SAP ABAP Table S261BIW1 (SD - Delivery note)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | S261BIW1 | Table Relationship Diagram |
Short Description | SD - Delivery note |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | SPTAG | SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
3 | VBELN | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | VBUK | |
4 | POSNR | POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | VBUP | |
5 | ETENR | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | VBEP | |
6 | VRSIO | VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
7 | SPMON | SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
8 | SPWOC | SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
9 | SPBUP | SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
10 | SSOUR | SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
11 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
12 | VWDAT | VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
13 | .INCLUDE | 0 | 0 | SIS Characteristics: Delivery Note - Header | |||||
14 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
15 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | TVST | |
16 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | * | |
17 | PSPDNR | SPDNR | LIFNR | CHAR | 10 | 0 | Carrier | * | |
18 | PKUNRE | KUNRE | KUNNR | CHAR | 10 | 0 | Bill-to party | * | |
19 | PKUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
20 | PVRTNR | VRTNR | PERNR | NUMC | 8 | 0 | Sales employee | ||
21 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
22 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
23 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
24 | SPARA | SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
25 | LFART | LFART | LFART | CHAR | 4 | 0 | Delivery Type | * | |
26 | FAKSK | FAKSK | FAKSP | CHAR | 2 | 0 | Billing block in SD document | * | |
27 | LIFSK | LIFSK | LIFSP | CHAR | 2 | 0 | Delivery block (document header) | * | |
28 | ABLAD | ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
29 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
30 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
31 | KUNNR | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
32 | KUNAG | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
33 | LSTEL | LSTEL | LSTEL | CHAR | 2 | 0 | Loading Point | * | |
34 | WADAT_IST | WADAT_IST | DATUM | DATS | 8 | 0 | Actual Goods Movement Date | ||
35 | .INCLU--AP | 0 | 0 | SIS Characteristics: Delivery Header Append | |||||
36 | LFDAT | LFDAT_V | DATUM | DATS | 8 | 0 | Delivery Date | ||
37 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
38 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
39 | .INCLUDE | 0 | 0 | SIS Characteristics: Delivery Note - Item | |||||
40 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
41 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
42 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
43 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
44 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
45 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
46 | STADAT | STADAT | DATUM | DATS | 8 | 0 | Statistics date | ||
47 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
48 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
49 | PSTYV | PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | * | |
50 | VGTYP | VGTYP | VORG_TYP | CHAR | 3 | 0 | Activity or element category | ||
51 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
52 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
53 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
54 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
55 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
56 | PRODH | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
57 | FAKSP | FAKSP | FAKSP | CHAR | 2 | 0 | Lock | * | |
58 | VGBEL | VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | * | |
59 | VGPOS | VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | * | |
60 | KOMKZ | KOMKZ | KOMKZ | CHAR | 1 | 0 | Indicator for picking control | ||
61 | LGNUM | LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | * | |
62 | LGTYP | LGTYP | LGTYP | CHAR | 3 | 0 | Storage Type | * | |
63 | LGPLA | LGPLA | LGPLA | CHAR | 10 | 0 | Storage Bin | * | |
64 | POSAR | POSAR | POSAR | CHAR | 1 | 0 | Item type | ||
65 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
66 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
67 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
68 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
69 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
70 | KVGR1 | KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
71 | KVGR2 | KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
72 | KVGR3 | KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
73 | KVGR4 | KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
74 | KVGR5 | KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
75 | MVGR1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | * | |
76 | MVGR2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | * | |
77 | MVGR3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | * | |
78 | MVGR4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | * | |
79 | MVGR5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | * | |
80 | WBSTA | WBSTA | STATV | CHAR | 1 | 0 | Goods movement status | ||
81 | KOSTA | KOSTA | STATV | CHAR | 1 | 0 | Picking Status/Putaway Status | ||
82 | KOQUA | KOQUA | STATV | CHAR | 1 | 0 | Confirmation status of picking/putaway | ||
83 | .INCLU--AP | 0 | 0 | SIS Characteristics: Delivery Item Append | |||||
84 | APERDAT | MC_APERDAT | DATUM | DATS | 8 | 0 | Creation Date of Order Item | ||
85 | KZVBR | KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
86 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
87 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
88 | PS_POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
89 | .INCLUDE | 0 | 0 | SIS Key Figures: Delivery Note - Header | |||||
90 | LFIMG | LFIMG | MENG13 | QUAN | 13 | 3 | Actual quantity delivered (in sales units) | ||
91 | NTGEW | NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
92 | BRGEW | BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross weight | ||
93 | VOLUM | VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
94 | LGMNG | LGMNG | MENG13 | QUAN | 13 | 3 | Actual quantity delivered in stockkeeping units | ||
95 | .INCLU--AP | 0 | 0 | SIS Key Figures: Delivery Item Append | |||||
96 | ANZLI | MC_ANZLI | MCZAEHLER | DEC | 9 | 0 | No. of deliveries | ||
97 | ANZLIPOS | MC_ANZLIPO | MCZAEHLER | DEC | 9 | 0 | Number of delivery items | ||
98 | .INCLUDE | 0 | 0 | SIS Characteristics: Delivery Note - Schedule Line | |||||
99 | ETTYP | ETTYP | ETTYP | CHAR | 2 | 0 | Item Cat. in Schedule Line | * | |
100 | LIFSP | LIFSP_EP | LIFSP | CHAR | 2 | 0 | Schedule line blocked for delivery | * | |
101 | LDDAT | LDDAT | DATUM | DATS | 8 | 0 | Loading Date | ||
102 | TDDAT | TDDAT_D | DATUM | DATS | 8 | 0 | Transportation Planning Date | ||
103 | EDATU | EDATU | DATUM | DATS | 8 | 0 | Schedule line date | ||
104 | WADAT | WADAT | DATUM | DATS | 8 | 0 | Goods Issue Date | ||
105 | MBDAT | MBDAT | DATUM | DATS | 8 | 0 | Material Staging/Availability Date | ||
106 | WLDATBE | WLDATBE | DATUM | DATS | 8 | 0 | Desired del. date in confirmed schedule lines | ||
107 | .INCLUDE | 0 | 0 | SIS key Figures: Delivery Note - Schedule Line | |||||
108 | VSMNG_L | MC_VSMNG_L | MENGV15_3 | QUAN | 15 | 3 | Delivered quantity per schedule line and delivery item |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | S261BIW1 | ETENR | VBEP | ETENR | |||
2 | S261BIW1 | MANDT | T000 | MANDT | |||
3 | S261BIW1 | POSNR | VBUP | POSNR | |||
4 | S261BIW1 | VBELN | VBUK | VBELN | |||
5 | S261BIW1 | VRKME | T006 | MSEHI | |||
6 | S261BIW1 | VSTEL | TVST | VSTEL |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |