S005 is a standard Data Collection Transparent Table in SAP Logistics application, which stores SIS: Shipping Point/Route/Forwarding Agent/Receiving Country data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for S005. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

S005 — Meta Data

Description: SIS: Shipping Point/Route/Forwarding Agent/Receiving Country
Main Category: Logistics
Sub Category: Data Collection
Table type: Transparent Table (TRANSP)

S005 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 SSOUR Statistic(s) origin X CHAR 4
    3 VRSIO Version X CHAR 3 *
    4 SPMON Calendar year / month X NUMC 6
    5 SPTAG Calendar day X DATS 8
    6 SPWOC Calendar year / week X NUMC 6
    7 SPBUP Fiscal year / period X NUMC 6
    8 VSTEL Shipping Point X CHAR 4 TVST
    9 ROUTE Route X CHAR 6 TVRO
    10 SPDNR Updated information in related user data field X CHAR 10 LFA1
    11 LLAND Country Key X CHAR 3 T005
    12 PERIV Fi.Year Variant CHAR 2 T009
    13 VWDAT Character Field Length = 10 NUMC 10
    14 GEWEI Weight unit UNIT 3 T006
    15 VOLEH Volume unit UNIT 3 T006
    16 NTGEW Net Weight QUAN 15
    17 BRGEW Gross Weight QUAN 15
    18 VOLUM Volume QUAN 15
    19 ARBLA Labor Required for Deliveries on Hand DEC 5
    20 RLNTGEW Net weight of returns deliveries QUAN 15
    21 RLBRGEW Gross weight of returns deliveries QUAN 15
    22 RLVOLUM Volume of returns delivery QUAN 15
    23 RLARBLA Labor required for returns deliveries on hand DEC 5

SAP Help, Wiki Resources, and Forum Discussions on S005


Related Tables

TABLE Description Functional Area
S004 SIS: Product/Sales Organization/Distribution Channel Logistics - Data Collection
TBTCP Background Job Step Overview Basis - Background Processing
SOLISTI1 SAPoffice: Single List with Column Length 255 30A - Communication Services: Mail
SODOCCHGI1 Data of an object which can be changed 30A - Communication Services: Mail
SOMLRECI1 SAPoffice: Structure of the API Recipient List 30A - Communication Services: Mail
SOEXTRECI1 SAPoffice: Structure of the External Recipient List 30A - Communication Services: Mail
REC_TYPE Structure with Instantiated Recipient Types 30A - Communication Services: Mail

Transaction Codes for SAP Table S005

TCODE Description Functional Area
SCOT SAPconnect - Administration Basis - Communication Services: Mail, Fax, SMS, Telephony
SE38 ABAP Editor Basis - ABAP Editor
S001 Basis - Session Manager
S002 Menu Administration Basis - Session Manager
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SP01 Output Controller Basis - Print and Output Management
SOST SAPconnect Send Requests Basis - Use Subcomponents

FMs for SAP Table S005

FM Description Functional Area
CONVERT_ABAPSPOOLJOB_2_PDF Basis - SAPscript
GET_JOB_RUNTIME_INFO Reading Background Job Runtime Data Basis - Background Processing
POPUP_TO_CONFIRM Standard Dialog Popup Basis - Standard Dialogs
CONVERT_OTF Basis - SAPscript
SO_NEW_DOCUMENT_ATT_SEND_API1 SAPoffice: Send new document with attachments using RFC Basis - Use Subcomponents
SO_DOCUMENT_SEND_API1 SAPoffice: Send new document with attachments using RFC Basis - Use Subcomponents
BAPI_COMPANYCODE_GET_PERIOD For Company Code: Posting Date -> Period, Fiscal Year FI - Financial Accounting
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface

ABAP Reports for SAP Table S005

ABAP REPORT Description Functional Area
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
RSTXPDFT4 Converting SAPscript (OTF) or ABAP List Spool Job to PDF Basis - SAPscript
MAILDATA WFMC: Data Definitions for Mail SD - Output Determination
SPRSL TEXT 630 - Workbench Tools: Editors
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMF02K Vendor Master Data FI - Basic Functions
BCALV_TEST_GRID_EVENTS Program BCALV_TEST_GRID_EVENTS Basis - SAP List Viewer
DEMO_DYNPRO_TABLE_CONTROL_1 Table Control with LOOP Statement Basis - Syntax, Compiler, Runtime

BW Datasources for SAP Table S005

BW DATASOURCE Description Functional Area
2LIS_11_VAHDR Sales Document Header Data SD - Sales and Distribution
2LIS_01_S001 Customer SD - Sales and Distribution
2LIS_12_VCSCL Sales-Shipping Schedule Line Delivery SD - Sales and Distribution
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
2LIS_01_S005 Shipping point SD - Sales and Distribution
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
0ABCINDIC_TEXT ABC indicator for technical object PM - Plant Maintenance
0TCTPRCSVAR_TEXT BW Meta Data: Process Variant - Text -

Authorization Objects for SAP Table S005

AUTHORIZATION OBJECT Description Functional Area
S_CARRID Authorization Object for Airlines
C_VKORG Transfer of Sales Organization Data
S_RS_IOBJ Data Warehousing Workbench - InfoObject
E_GRID Authorization Object for Grid
P_PERNR HR: Master Data - Personnel Number Check
F_LFA1_GRP Vendor: Account Group Authorization
L_TCODE Transaction Codes in the Warehouse Management System