SAP ABAP Table E3CLIPS (SIS - delivery item, first part)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ IDOCLOGISTICS (Package) IDoc Interface (logistics segment definitions)
⤷ CRM-MD-PCT (Application Component) Product Catalog
⤷ IDOCLOGISTICS (Package) IDoc Interface (logistics segment definitions)
Basic Data
Table Category | INTTAB | Structure |
Structure | E3CLIPS | Table Relationship Diagram |
Short Description | SIS - delivery item, first part |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
2 | VBELN | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
3 | POSNR | POSNR_VL | POSNR | NUMC | 6 | 0 | Delivery Item | * | |
4 | PSTYV | PSTYV_VL | PSTYV | CHAR | 4 | 0 | Delivery item category | * | |
5 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
6 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
7 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
8 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
9 | MATWA | MATWA | MATNR | CHAR | 18 | 0 | Material entered | * | |
10 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
11 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
12 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
13 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
14 | KDMAT | KDMAT | IDNEX | CHAR | 35 | 0 | Material belonging to the customer | ||
15 | PRODH | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | * | |
16 | LFIMG | LFIMG | MENG13 | QUAN | 13 | 3 | Actual quantity delivered (in sales units) | ||
17 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
18 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | * | |
19 | UMVKZ | UMVKZ | UMBSZ | DEC | 5 | 0 | Numerator (factor) for conversion of sales quantity into SKU | ||
20 | UMVKN | UMVKN | UMBSN | DEC | 5 | 0 | Denominator (divisor) for conversion of sales qty. into SKU | ||
21 | NTGEW | NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net weight | ||
22 | BRGEW | BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross weight | ||
23 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
24 | VOLUM | VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
25 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
26 | KZTLF | KZTLF | KZTLF | CHAR | 1 | 0 | Partial delivery at item level | ||
27 | UEBTK | UEBTK | XFELD | CHAR | 1 | 0 | Indicator: Unlimited Overdelivery Allowed | ||
28 | UEBTO | UEBTO | PRZ21 | DEC | 3 | 1 | Overdelivery Tolerance Limit | ||
29 | UNTTO | UNTTO | PRZ21 | DEC | 3 | 1 | Underdelivery Tolerance Limit | ||
30 | CHSPL | CHSPL | XFELD | CHAR | 1 | 0 | Batch split allowed | ||
31 | FAKSP | FAKSP | FAKSP | CHAR | 2 | 0 | Lock | * | |
32 | MBDAT | MBDAT | DATUM | DATS | 8 | 0 | Material Staging/Availability Date | ||
33 | LGMNG | LGMNG | MENG13 | QUAN | 13 | 3 | Actual quantity delivered in stockkeeping units | ||
34 | ARKTX | ARKTX | TEXT40 | CHAR | 40 | 0 | Short text for sales order item | ||
35 | LGPBE | LGPBE | CHAR10 | CHAR | 10 | 0 | Storage Bin | ||
36 | VBELV | VBELV | VBELN | CHAR | 10 | 0 | Originating document | * | |
37 | POSNV | POSNV | POSNR | NUMC | 6 | 0 | Originating item | * | |
38 | VGBEL | VGBEL | VBELN | CHAR | 10 | 0 | Document number of the reference document | * | |
39 | VGPOS | VGPOS | POSNR | NUMC | 6 | 0 | Item number of the reference item | * | |
40 | UPFLU | UPFLU | XFELD | CHAR | 1 | 0 | Update indicator for flow table | ||
41 | UEPOS | UEPOS | POSNR | NUMC | 6 | 0 | Higher-level item in bill of material structures | * | |
42 | FKREL | FKREL | FKREL | CHAR | 1 | 0 | Relevant for Billing | ||
43 | LADGR | LADGR | LADGR | CHAR | 4 | 0 | Loading Group | * | |
44 | TRAGR | TRAGR | TRAGR | CHAR | 4 | 0 | Transportation Group | * | |
45 | KOMKZ | KOMKZ | KOMKZ | CHAR | 1 | 0 | Indicator for picking control | ||
46 | LGNUM | LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | * | |
47 | LGTYP | LGTYP | LGTYP | CHAR | 3 | 0 | Storage Type | * | |
48 | LGPLA | LGPLA | LGPLA | CHAR | 10 | 0 | Storage Bin | * | |
49 | BWTEX | BWTEX | XFELD | CHAR | 1 | 0 | Indicator: Separate valuation | ||
50 | BWART | BWART | BWART | CHAR | 3 | 0 | Movement type (inventory management) | * | |
51 | BWLVS | BWLVS | BWLVS | NUMC | 3 | 0 | Movement Type for Warehouse Management | * | |
52 | KZDLG | LVS_KZDLG | XFELD | CHAR | 1 | 0 | Indicator: dynamic storage bin in warehouse management | ||
53 | BDART | BDART | BDART | CHAR | 2 | 0 | Requirement type | ||
54 | PLART | PLART | PLART | CHAR | 1 | 0 | Planning type | * | |
55 | MTART | MTART | MTART | CHAR | 4 | 0 | Material type | * | |
56 | XCHPF | XCHPF | XFELD | CHAR | 1 | 0 | Batch management requirement indicator | ||
57 | XCHAR | XCHAR | XFELD | CHAR | 1 | 0 | Batch management indicator (internal) | ||
58 | VGREF | VGREF | XFELD | CHAR | 1 | 0 | Preceding document has resulted from reference | ||
59 | POSAR | POSAR | POSAR | CHAR | 1 | 0 | Item type | ||
60 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
61 | SUMBD | SUMBD | SUMBD | CHAR | 1 | 0 | Summing up of requirements | ||
62 | MTVFP | MTVFP | MTVFP | CHAR | 2 | 0 | Checking Group for Availability Check | * | |
63 | EANNR | EANNR | CHAR13 | CHAR | 13 | 0 | European Article Number (EAN) - obsolete!!!!! | ||
64 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
65 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
66 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
67 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
68 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
69 | GRKOR | GRKOR | GRKOR | NUMC | 3 | 0 | Delivery group (items are delivered together) | ||
70 | FMENG | FMENG | XFELD | CHAR | 1 | 0 | Quantity is fixed | ||
71 | ANTLF | ANTLF | ANTLF | DEC | 1 | 0 | Maximum number of partial deliveries allowed per item | ||
72 | VBEAF | VBEAF | DEC3_2 | DEC | 5 | 2 | Fixed shipping processing time in days (= setup time) | ||
73 | VBEAV | VBEAV | DEC3_2 | DEC | 5 | 2 | Variable shipping processing time in days | ||
74 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
75 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
76 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
77 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
78 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
79 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
80 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
81 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
82 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | * | |
83 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
84 | EAN11 | EAN11 | EAN11 | CHAR | 18 | 0 | International Article Number (EAN/UPC) | ||
85 | KVGR1 | KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | * | |
86 | KVGR2 | KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | * | |
87 | KVGR3 | KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | * | |
88 | KVGR4 | KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | * | |
89 | KVGR5 | KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | * | |
90 | MVGR1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | * | |
91 | MVGR2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | * | |
92 | MVGR3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | * | |
93 | MVGR4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | * | |
94 | MVGR5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | * | |
95 | VPZUO | VPZUO | ZUVKZ | CHAR | 1 | 0 | Allocation Indicator | ||
96 | VGTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
97 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
98 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
99 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
100 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
101 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | * | |
102 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
103 | VPMAT | VPMAT | MATNR | CHAR | 18 | 0 | Planning material | * | |
104 | VPWRK | VPWRK | WERKS | CHAR | 4 | 0 | Planning plant | * | |
105 | PRBME | PRBME | MEINS | UNIT | 3 | 0 | Base unit of measure for product group | * | |
106 | UMREF | UMREFF | FLTP | FLTP | 16 | 16 | Conversion factor: quantities | ||
107 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | * | |
108 | KZVBR | KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
109 | PCKPF | PCKPF | PCKPF | CHAR | 1 | 0 | Packing control | ||
110 | BEDAR_LF | BEDAR | BEDAR | CHAR | 3 | 0 | Requirements class | * | |
111 | CMPNT | CMPNT | XFELD | CHAR | 1 | 0 | ID: Item with active credit function / relevant for credit | ||
112 | KCMENG | KCMENG | MENG15 | QUAN | 15 | 3 | Cumulative batch quantity of all split items (in StckUnit) | ||
113 | KCBRGEW | KCBRGEW | MENG15 | QUAN | 15 | 3 | Cumulative gross weight of all batch split items | ||
114 | KCNTGEW | KCNTGEW | MENG15 | QUAN | 15 | 3 | Cumulative net weight of all batch split items | ||
115 | KCVOLUM | KCVOLUM | MENG15 | QUAN | 15 | 3 | Cumulative volume of all batch split items | ||
116 | UECHA | UECHA | POSNR | NUMC | 6 | 0 | Higher-Level Item of Batch Split Item | * | |
117 | CUOBJ | CUOBJ_VA | CUOBJ | NUMC | 18 | 0 | Configuration | ||
118 | CUOBJ_CH | CUOBJ_CH | CUOBJ | NUMC | 18 | 0 | Internal object number of the batch classification | ||
119 | ANZSN | ANZSN | INT4 | INT4 | 10 | 0 | Number of serial numbers | ||
120 | SERAIL | SERAIL | SERAIL | CHAR | 4 | 0 | Serial Number Profile | * | |
121 | KCGEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
122 | KCVOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
123 | SERNR | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | * | |
124 | ABRLI | ABRLI | ABRLI | NUMC | 4 | 0 | Internal delivery schedule number | * | |
125 | ABART | ABART | ABART | CHAR | 1 | 0 | Release type | ||
126 | ABRVW | ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | * | |
127 | QPLOS | QPLOS | QPLOS | NUMC | 12 | 0 | Inspection Lot Number | * | |
128 | QTLOS | QTLOS | QTLOS | NUMC | 6 | 0 | Partial lot number | * | |
129 | NACHL | NACHL | XFELD | CHAR | 1 | 0 | Customer has not posted goods receipt | ||
130 | MAGRV | MAGRV | MAGRV | CHAR | 4 | 0 | Material Group: Packaging Materials | * | |
131 | OBJKO | OBJKO | J_OBJNR | CHAR | 22 | 0 | Object number at header level | * | |
132 | OBJPO | OBJPO | J_OBJNR | CHAR | 22 | 0 | Object number at item level | * |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |