SAP ABAP Table S260BIWS (S260BIWS * SD - Sales order)
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 | INTTAB | Structure |
Structure | S260BIWS | Table Relationship Diagram |
Short Description | S260BIWS * SD - Sales order |
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 | STORNO | STORNO | CHAR1_X | CHAR | 1 | 0 | Indicator: Data to Be Canceled | ||
2 | WRTTP | RSVTYPE | RSVTYPE | NUMC | 3 | 0 | Value type for Reporting | * | |
3 | VRSIO | VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
4 | SPMON | RSCALMONTH | RSCALMONTH | NUMC | 6 | 0 | Calendar year / month | ||
5 | SPTAG | RSCALDAY | DATUM | DATS | 8 | 0 | Calendar day | ||
6 | SPWOC | RSCALWEEK | RSCALWEEK | NUMC | 6 | 0 | Calendar year / week | ||
7 | SPBUP | RSFISCPER | RSFISCPER | NUMC | 7 | 0 | Fiscal year / period | ||
8 | VBELN | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
9 | POSNR | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | * | |
10 | ETENR | ETENR | ETENR | NUMC | 4 | 0 | Schedule line | * | |
11 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
12 | .INCLUDE | 0 | 0 | SIS Characteristics: Sales Order - Header | |||||
13 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | * | |
14 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
15 | STWAE | STWAE | WAERS | CUKY | 5 | 0 | Statistics currency | * | |
16 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
17 | AUART | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | * | |
18 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
19 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
20 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
21 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
22 | KVGR1 | KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
23 | KVGR2 | KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
24 | KVGR3 | KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
25 | KVGR4 | KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
26 | KVGR5 | KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
27 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
28 | KUNNR | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | * | |
29 | SPARA | SPART_AK | SPART | CHAR | 2 | 0 | Division for order header | * | |
30 | AUGRU | AUGRU | AUGRU | CHAR | 3 | 0 | Order reason (reason for the business transaction) | * | |
31 | FAKSK | FAKSK | FAKSP | CHAR | 2 | 0 | Billing block in SD document | * | |
32 | LIFSK | LIFSK | LIFSP | CHAR | 2 | 0 | Delivery block (document header) | * | |
33 | .INCLU--AP | 0 | 0 | Sales Info System Characteristics: Sales Order Header Append | |||||
34 | VGTYP_AK | MC_VBTYPAK | VBTYP | CHAR | 1 | 0 | Sales Document Category of Reference Doc. in Order Header | ||
35 | .INCLUDE | 0 | 0 | SIS Characteristics: Sales Order - Item | |||||
36 | PSTYV | PSTYV | PSTYV | CHAR | 4 | 0 | Sales document item category | * | |
37 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
38 | PRODH | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
39 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
40 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
41 | FAKSP | FAKSP_AP | FAKSP | CHAR | 2 | 0 | Billing block for item | * | |
42 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
43 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
44 | VSTEL | VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | * | |
45 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | * | |
46 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
47 | PKUNWE | KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | * | |
48 | PKUNRE | KUNRE | KUNNR | CHAR | 10 | 0 | Bill-to party | * | |
49 | PKUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | * | |
50 | PSPDNR | SPDNR | LIFNR | CHAR | 10 | 0 | Carrier | * | |
51 | PVRTNR | VRTNR | PERNR | NUMC | 8 | 0 | Sales employee | ||
52 | PABLA | PABLA | TEXT25 | CHAR | 25 | 0 | Unloading point of the ship-to party | ||
53 | MVGR1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | * | |
54 | MVGR2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | * | |
55 | MVGR3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | * | |
56 | MVGR4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | * | |
57 | MVGR5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | * | |
58 | ABGRU | ABGRU_VA | ABGRU_VA | CHAR | 2 | 0 | Reason for rejection of quotations and sales orders | * | |
59 | ABSTA | ABSTA_VB | STATV | CHAR | 1 | 0 | Rejection status for SD item | ||
60 | UVALL | UVALL_UP | STATV | CHAR | 1 | 0 | General Incompletion Status of the Item | ||
61 | UVVLK | UVVLK_UP | STATV | CHAR | 1 | 0 | Incompletion Status of the Item with Regard to Delivery | ||
62 | UVFAK | UVFAK_UP | STATV | CHAR | 1 | 0 | Item incompletion status with respect to billing | ||
63 | UVPRS | UVPRS_UP | STATV | CHAR | 1 | 0 | Item is incomplete with respect to pricing | ||
64 | KDGRP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | * | |
65 | BZIRK | BZIRK | BZIRK | CHAR | 6 | 0 | Sales district | * | |
66 | INCO1 | INCO1 | INCO1 | CHAR | 3 | 0 | Incoterms (part 1) | * | |
67 | INCO2 | INCO2 | INCO2 | CHAR | 28 | 0 | Incoterms (part 2) | ||
68 | KTGRD | KTGRD | KTGRD | CHAR | 2 | 0 | Account assignment group for this customer | * | |
69 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
70 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
71 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
72 | FKDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
73 | FBUDA | FBUDA | DATUM | DATS | 8 | 0 | Date When Services Rendered | ||
74 | STADAT | STADAT | DATUM | DATS | 8 | 0 | Statistics date | ||
75 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
76 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
77 | ZIEME | DZIEME | MEINS | UNIT | 3 | 0 | Target quantity UoM | * | |
78 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
79 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
80 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
81 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
82 | UMZIZ | UMZIZ | UMBSZ | DEC | 5 | 0 | Factor for converting sales units to base units (target qty) | ||
83 | UMZIN | UMZIN | UMBSN | DEC | 5 | 0 | Factor for converting sales units to base units (target qty) | ||
84 | CMKUA | CMKUA | KURRF | DEC | 9 | 5 | Credit data exchange rate for requested delivery date | ||
85 | KURSK | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
86 | STCUR | STCUR | KURRF | DEC | 9 | 5 | Exchange rate for statistics | ||
87 | NETPR | NETPR | WERTV6 | CURR | 11 | 2 | Net price | ||
88 | .INCLU--AP | 0 | 0 | SIS Characteristics: Sales Order Item Append | |||||
89 | VGTYP | VBTYP_V | VBTYP | CHAR | 1 | 0 | Document category of preceding SD document | ||
90 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
91 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
92 | PS_POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
93 | .INCLUDE | 0 | 0 | SIS Key Figures: Sales Order - Item | |||||
94 | NETWR | NETWR_AP | WERTV8 | CURR | 15 | 2 | Net value of the order item in document currency | ||
95 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
96 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
97 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
98 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
99 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
100 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
101 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
102 | ZWERT | DZWERT | WERT7 | CURR | 13 | 2 | Target value for outline agreement in document currency | ||
103 | ZMENG | DZMENG | MENG13 | QUAN | 13 | 3 | Target quantity in sales units | ||
104 | KWMENG | KWMENG | MENG15 | QUAN | 15 | 3 | Cumulative order quantity in sales units | ||
105 | LSMENG | LSMENG | MENG15 | QUAN | 15 | 3 | Cumulative Target Delivery Qty (all dlv-relev.sched.lines) | ||
106 | KBMENG | KBMENG | MENG15 | QUAN | 15 | 3 | Cumulative confirmed quantity in sales unit | ||
107 | KLMENG | KLMENG | MENG15 | QUAN | 15 | 3 | Cumulative Confirmed Quantity in Base Unit of Measure | ||
108 | LFMNG | MINLF | MENG13 | QUAN | 13 | 3 | Minimum delivery quantity in delivery note processing | ||
109 | BRGEW | BRGEW_AP | MENG15 | QUAN | 15 | 3 | Gross weight of item | ||
110 | NTGEW | NTGEW_AP | MENG15 | QUAN | 15 | 3 | Net weight of item | ||
111 | VOLUM | VOLUM_AP | MENG15 | QUAN | 15 | 3 | Volume of the item | ||
112 | .INCLU--AP | 0 | 0 | SIS Key Figures: Sales Order Item Append | |||||
113 | ANZAU | MC_ANZAU | MCZAEHLER | DEC | 9 | 0 | Number of orders | ||
114 | ANZAUPOS | MC_ANZAUPO | MCZAEHLER | DEC | 9 | 0 | Number of order items | ||
115 | .INCLUDE | 0 | 0 | SIS Characteristics: Sales Order - Schedule Line | |||||
116 | ETTYP | ETTYP | ETTYP | CHAR | 2 | 0 | Item Cat. in Schedule Line | * | |
117 | LIFSP | LIFSP_EP | LIFSP | CHAR | 2 | 0 | Schedule line blocked for delivery | * | |
118 | LDDAT | LDDAT | DATUM | DATS | 8 | 0 | Loading Date | ||
119 | TDDAT | TDDAT_D | DATUM | DATS | 8 | 0 | Transportation Planning Date | ||
120 | EDATU | EDATU | DATUM | DATS | 8 | 0 | Schedule line date | ||
121 | WADAT | WADAT | DATUM | DATS | 8 | 0 | Goods Issue Date | ||
122 | MBDAT | MBDAT | DATUM | DATS | 8 | 0 | Material Staging/Availability Date | ||
123 | WLDATBE | WLDATBE | DATUM | DATS | 8 | 0 | Desired del. date in confirmed schedule lines | ||
124 | .INCLUDE | 0 | 0 | SIS Key Figures: Sales Order - Schedule Line | |||||
125 | WMENG | WMENG | MENG13 | QUAN | 13 | 3 | Order quantity in sales units | ||
126 | LMENG | LMENG | MENG13 | QUAN | 13 | 3 | Required quantity for mat.management in stockkeeping units | ||
127 | BMENG | BMENG | MENG13 | QUAN | 13 | 3 | Confirmed quantity | ||
128 | CMENG | CMENG | MENG13 | QUAN | 13 | 3 | Corrected quantity in sales unit |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |