SAP ABAP Table OICIL (Second level analysis header line data structure- item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIC (Package) MAP Marketing, Accounting and Pricing

Basic Data

Table Category	INTTAB	Structure
Structure	OICIL	Table Relationship Diagram
Short Description	Second level analysis header line data structure- item

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	.INCLUDE	☐				0	0	Communication Item for Pricing
2	KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
4	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
6	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	*
7	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
8	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
9	WAGRP	☐	WAGRP	CHAR9	CHAR	9	0	Material group
10	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	*
11	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	*
12	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	*
13	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
14	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
15	NRMNG	☐	NRMNG	MENG13	QUAN	13	3	Discount in kind: Inclusive bonus quantity of item
16	ANZPU	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
17	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	*
18	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
19	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
20	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
21	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
22	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
23	REFFP	☐	EFFPR	WERT11	CURR	11	2	Effective Price in Purchasing Info Record
24	VABME	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
25	NO017	☐	NO017	XFELD	CHAR	1	0	Read info record conditions without plant
26	TAXIM	☐	TAXIM1	TAXIM1	CHAR	1	0	Tax indicator for material (Purchasing)	*
27	TAXIK	☐	TAXIK1	TAXIK1	CHAR	1	0	Tax Indicator: Account Assignment (Purchasing)	*
28	TAXIW	☐	TAXIW1	TAXIW1	CHAR	1	0	Tax Indicator: Plant (Purchasing)	*
29	TAXIL	☐	TAXIL	TAXIL	CHAR	1	0	Tax indicator: Import
30	TAXIR	☐	TAXIR	TAXIR	CHAR	1	0	Tax indicator: Region (Intrastat)
31	TAXPS	☐	TAX_POSNR	NUM6	NUMC	6	0	Tax document item number
32	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	*
33	KOLBO	☐	KOLBO	EBONU	CHAR	2	0	Settlement group 1 of prior vendor
34	KOLB2	☐	KOLB1	EBONU	CHAR	2	0	Settlement group 2 of prior vendor
35	KOLB3	☐	KOLB2	EBONU	CHAR	2	0	Settlement group 3 of prior vendor
36	KOLTS	☐	KOLTS	CHAR6	CHAR	6	0	Vendor sub-range of prior vendor
37	KOLWG	☐	KOLWG	CHAR18	CHAR	18	0	Vendor material group of prior vendor
38	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	*
39	WGLIF	☐	WGLIF	CHAR18	CHAR	18	0	Vendor Material Group
40	EBONY	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
41	EBONU	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
42	EBON2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
43	EBON3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
44	WGRU1	☐	WGRU_HIE1	KLASSE	CHAR	18	0	Material group hierarchy 1
45	WGRU2	☐	WGRU_HIE2	KLASSE	CHAR	18	0	Material group hierarchy 2
46	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
47	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	*
48	VKGRU	☐	VKGRU	RMA_VORGA	CHAR	3	0	Repair processing: Classify items	*
49	VKAUS	☐	VKAUS	VKAUS	CHAR	3	0	Unused - Reserve Length 3
50	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
51	MGLME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
52	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
53	LGUMZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
54	LGUMN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
55	MGAME	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
56	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
57	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
58	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
59	BRGEW	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
60	NTGEW	☐	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
61	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
62	VOLUM	☐	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
63	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
64	BRTWR	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
65	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
66	EFFWR	☐	EFFWR	WERT7	CURR	13	2	Effective value of item
67	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
68	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
69	SKFBP	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
70	KZWI1	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
71	KZWI2	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
72	KZWI3	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
73	KZWI4	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
74	KZWI5	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
75	KZWI6	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
76	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
77	GRWRT	☐	GRWRT	GRWRT	CURR	13	2	Statistical value for foreign trade
78	PREVA	☐	PREVA	WERTV8	CURR	15	2	Preference value
79	CMPRE	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
80	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
81	KZINC	☐	KZINC	XFELD	CHAR	1	0	Initial amount incl.taxes
82	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
83	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
84	KZNEP	☐	KZNEP	KZNEP	CHAR	1	0	Condition exclusion indicator	*
85	EVRWR	☐	EVRWR	XFELD	CHAR	1	0	Determine cost
86	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
87	WAVWR_KW00	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
88	WAERS_KW00	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
89	WAVWR_PCVP	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
90	WAERS_PCVP	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
91	DLVEXT	☐	XFLAG	XFLAG	CHAR	1	0	New Input Values
92	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
93	ESOKZ	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
94	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
95	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
96	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
97	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
98	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
99	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
100	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
101	EVRTN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
102	EVRTP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
103	EVRTT	☐	EVRTT	BSTYP	CHAR	1	0	Purchasing document category
104	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
105	ELPAK	☐	EVRTN	EBELN	CHAR	10	0	Agreement Number	*
106	ELPAP	☐	EVRTP	EBELP	NUMC	5	0	Agreement Item	*
107	ELPAT	☐	EVRTT	BSTYP	CHAR	1	0	Purchasing document category
108	EKKOL	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
109	EKKOA	☐	EKKOG1	CHAR4	CHAR	4	0	Condition group in case of different vendor
110	GRMEN	☐	GRMEN	MEINS	UNIT	3	0	Scale unit	*
111	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
112	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
113	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
114	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
115	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
116	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
117	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
118	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
119	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
120	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
121	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
122	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
123	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
124	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
125	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item	*
126	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
127	KAEND_TYP	☐	KAEND_TYP	CHAR5	CHAR	5	0	Condition categories that cannot be changed
128	KONAU_TYP	☐	KONAU_TYP	CHAR5	CHAR	5	0	Condition - inadmissible condition categories
129	FXMSG	☐	MSGNR	MSGNR	CHAR	3	0	Message number	*
130	PRSOK	☐	PRSOK	XFELD	CHAR	1	0	Pricing is OK
131	KZBZG	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
132	KSTBS	☐	KSTBS	WERTV8	CURR	15	2	Scale base value of the condition
133	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
134	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
135	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
136	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
137	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
138	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
139	CEPOK	☐	CEPOK	CEPOK	CHAR	1	0	Status expected price
140	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	*
141	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
142	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
143	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
144	PLTYP_P	☐	PLTYP_P	PLTYP	CHAR	2	0	Price determination: Item-based price list type	*
145	ANZ_TAGE	☐	ANZ_TAGE	FLTP	FLTP	16	16	Number of days
146	ANZ_MONATE	☐	ANZ_MONATE	FLTP	FLTP	16	16	Number of months
147	ANZ_WOCHEN	☐	ANZ_WOCHEN	FLTP	FLTP	16	16	Number of weeks
148	ANZ_JAHRE	☐	ANZ_JAHRE	FLTP	FLTP	16	16	Number of years
149	STF_TAGE	☐	ANZ_TAGE	FLTP	FLTP	16	16	Number of days
150	STF_MONATE	☐	ANZ_MONATE	FLTP	FLTP	16	16	Number of months
151	STF_WOCHEN	☐	ANZ_WOCHEN	FLTP	FLTP	16	16	Number of weeks
152	STF_JAHRE	☐	ANZ_JAHRE	FLTP	FLTP	16	16	Number of years
153	VLAUFK	☐	VLAUK_VEDA	VLAUK_VEDA	CHAR	2	0	Validity period category of contract	*
154	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	*
155	.INCLUDE	☐				0	0	Fields for Loop within KOMP
156	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	*
157	VARCOND	☐	VARCOND	VARCON	CHAR	26	0	Variant condition	*
158	FACTOR	☐	ATFLV	FLTP	FLTP	16	16	Internal floating point from
159	ADDNR	☐	ADDI_MATNR	MATNR	CHAR	18	0	Material number for additional	*
160	ADDMG	☐	ADDI_ORDQU	MENG13	QUAN	13	3	Quantity of the additional used
161	ADDME	☐	ADDI_MEINS	MEINS	UNIT	3	0	Unit of measure for quantity of the additional used	*
162	MBWNR	☐	MBWNR	KUNNR	CHAR	10	0	Customer number of competitor	*
163	KNUMA_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	*
164	UPMAT	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item	*
165	UKONM	☐	UKONM	KONDM	CHAR	2	0	Material pricing group of main item	*
166	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
167	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
168	REP_MATNR	☐	REP_MATNR	MATNR	CHAR	18	0	Representative material for Profit Center Accounting	*
169	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
170	PRSGR	☐	PRSGR	XFELD	CHAR	1	0	Full pricing necessary
171	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
172	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
173	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
174	BERGL	☐	BERGL	BERGL	CHAR	1	0	Calculation Base
175	DISTZ	☐	DISTZ	MENG13	QUAN	13	3	Distance
176	MEDST	☐	MEDST	MEINS	UNIT	3	0	Unit of measure for distance	*
177	ANZVSE	☐	ANZVSE	MENG13	QUAN	13	3	Number of handling units
178	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering
179	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
180	GEAEND	☐	GEAEND	XFELD	CHAR	1	0	Conditions in pricing changed
181	J_1BTXSDC	☐	J_1BTXSDC_	J_1BTXSDC	CHAR	2	0	SD tax code	*
182	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
183	MBLNR	☐	VBELN_NACH	VBELN	CHAR	10	0	Subsequent sales and distribution document	*
184	MBLPS	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
185	MBLDT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
186	MBLBU	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
187	REFSITE	☐	WREFSITE	WERKS_W	CHAR	4	0	Reference Site For Purchasing
188	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
189	NRFAKTOR	☐	NRFAKTOR	FLTP	FLTP	16	16	Factor for free goods (inclusive)
190	KZFME	☐	KZFME	KZFME	CHAR	1	0	ID: Leading unit of measure for completing a transaction
191	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
192	USE_MULTIVAL_ATTR	☐	SD_COND_MULTIVAL_ATTR	XFELD	CHAR	1	0	Boolean Value: Use Multivalue Attributes?
193	EINDT	☐	EDATU	DATUM	DATS	8	0	Schedule line date
194	FORECAST_DATE	☐	CPET_FORECAST_DATE	DATE	DATS	8	0	Obsolete -> use CPET_USED_EVAL_KEYDATE
195	USE_PREREAD_COND	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
196	.INCLUDE	☐				0	0	Communication Fields from the Delivery Header (KOMP)
197	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
198	LSTEL	☐	LSTEL	LSTEL	CHAR	2	0	Loading Point	TVLA
199	.INCLUDE	☐				0	0	Communication Fields from the Delivery Item
200	LADGR	☐	LADGR	LADGR	CHAR	4	0	Loading Group	TLGR
201	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	TTGR
202	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
203	.INCLUDE	☐				0	0	Determine freight classes / freight codes
204	GARVZ	☐	GARVZ	GARVZ	CHAR	6	0	Freight code set	TGAV
205	GTART	☐	GTART	GTART	CHAR	12	0	Freight code	TGAR
206	GTKLS	☐	GTKLS	CHAR12	CHAR	12	0	Freight class
207	.INCLUDE	☐				0	0	Communication Fields from the Shipping Units (KOMG)
208	VHART	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
209	.INCLUDE	☐				0	0	Communication Fields from the Shipping Units
210	VEGR1	☐	VEGR1	VEGR1	CHAR	5	0	Handling Unit Group 1 (Freely Definable)	TVE1
211	VEGR2	☐	VEGR2	VEGR2	CHAR	5	0	Handling Unit Group 2 (Freely Definable)	TVE2
212	VEGR3	☐	VEGR3	VEGR3	CHAR	5	0	Handling Unit Group 3 (Freely Definable)	TVE3
213	VEGR4	☐	VEGR4	VEGR4	CHAR	5	0	Handling Unit Group 4 (Freely Definable)	TVE4
214	VEGR5	☐	VEGR5	VEGR5	CHAR	5	0	Handling Unit Group 5 (Freely Definable)	TVE5
215	VHILM	☐	VHILM	MATNR	CHAR	18	0	Packaging Materials	MARA
216	VELTP	☐	VELTP	VELTP	CHAR	1	0	Packaging Material Category
217	LANDT	☐	LANDT	LAND1	CHAR	3	0	Country providing means of transport	T005
218	.INCLUDE	☐				0	0	Communication Fields from the Shipping Units (KOMP)
219	LADLG	☐	LADLG	LADLG	QUAN	6	0	Lgth of loading platform in lgth of LdPlat measurement units
220	LADEH	☐	LADEH	MEINS	UNIT	3	0	Unit of Measure to Measure the Length of Loading Platform	T006
221	.INCLUDE	☐				0	0	Communication Fields: Determination via Pricing (KOMP)
222	BUGRP	☐	VH_BUGRP	VH_BUGRP	CHAR	6	0	Bulkiness Group	TVFBWG
223	MGKUM	☐	VH_MGKUM	VH_MGKUM	CHAR	1	0	Cumulate Minimum Weights
224	.INCLUDE	☐				0	0	Description of Product Hierarchy (T179)
225	.INCLUDE	☐				0	0	Structure of Product Hierarchy (T179)
226	PRODH1	☐	PRODH1	PRODH1	CHAR	5	0	Standard data element PRODH1
227	PRODH2	☐	PRODH2	PRODH2	CHAR	5	0	Standard data element PRODH2
228	PRODH3	☐	PRODH3	PRODH3	CHAR	8	0	Standard data element PRODH3
229	.INCLUDE	☐				0	0	Conditions Communication Structure: External Services
230	SRVPOS	☐	ASNUM	ASNUM	CHAR	18	0	Activity Number	ASMD
231	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
232	INTROW	☐	INTROW	NUMC10	NUMC	10	0	Internal line number for limits
233	EXTROW	☐	EXTROW	NUMC10	NUMC	10	0	Line Number
234	KONT_PACK	☐	KONT_PACK	PACKNO	NUMC	10	0	Package Number of Contract	*
235	KONT_ZEILE	☐	KONT_ZEILE	INTROW	NUMC	10	0	Line number of contract
236	LGART	☐	LGART	LGART	CHAR	4	0	Wage Type	*
237	STELL	☐	STELL	STELL	NUMC	8	0	Job	*
238	FINAL	☐	FINAL	CHAR01	CHAR	1	0	Indicator: Final Entry Sheet
239	ORIGIN	☐	ORIGIN	ORIGIN	CHAR	1	0	Transaction/event in External Services Management	*
240	STLVPOS	☐	STLVPOS	CHAR18	CHAR	18	0	Standard Service Catalog Item
241	AUSGB	☐	AUSGB	NUMC4	NUMC	4	0	Edition of Service Type
242	LBNUM	☐	LBNUM	CHAR3	CHAR	3	0	Short Description of Service Type
243	USERF1_NUM	☐	USERF1_NUM	NUMC10	NUMC	10	0	User-Defined Field
244	USERF1_TXT	☐	USERF1_TXT	TEXT40	CHAR	40	0	User-Defined Field
245	USERF2_NUM	☐	USERF2_NUM	MENGE	QUAN	13	3	User-Defined Field
246	USERF2_TXT	☐	USERF2_TXT	TEXT10	CHAR	10	0	User-Defined Field
247	PERSEXT	☐	PERSEXT	TEXT40	CHAR	40	0	External Personnel Number
248	SDATE	☐	SIDATE	DATUM	DATS	8	0	Date
249	BEGTIME	☐	BEGINUZ	UZEIT	TIMS	6	0	Start Time
250	ENDTIME	☐	ENDEUZ	UZEIT	TIMS	6	0	End Time
251	FORMELNR	☐	FORMELNR	CHAR10	CHAR	10	0	Formula Number
252	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
253	MOLGA	☐	MOLGA	MOLGA	CHAR	2	0	Country Grouping	*
254	EXTSRVNO	☐	EXTSRVNO	CHAR18	CHAR	18	0	Vendor's Service Number
255	.INCLUDE	☐				0	0	Price determination, communication-item: IS-R fields
256	ISR_NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
257	ISR_VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
258	ISR_BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
259	ISR_MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
260	.INCLUDE	☐				0	0	Pricing Communication Item: IS-H Fields
261	PDUMMY_IS	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
262	.INCLUDE	☐				0	0	Pricing communication item: RK-E fields
263	PDUMMY_KE	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
264	RKE_EFORM	☐	RKEG_EFORM	RKEG_EFORM	CHAR	5	0	Form of manufacture	*
265	RKE_GEBIE	☐	RKEG_GEBIE	RKEG_GEBIE	CHAR	4	0	Area	*
266	RKE_MAABC	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	*
267	.INCLUDE	☐				0	0	Pricing Communication Item: Bank Fields
268	PDUMMY_BA	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
269	.INCLUDE	☐				0	0	Pricing communication item: Customer modifications
270	PDUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
271	.INCLU--AP	☐				0	0	Append Structure CH -> CO PA
272	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
273	.INCLU--AP	☐				0	0	Commissions: Customer Fields Condition Technique
274	.INCLUDE	☐				0	0	Condition Attributes
275	.INCLU--AP	☐				0	0	Additional CRM Fields (Construction) From Sales Order Area
276	.INCLUDE	☐				0	0	Additional CRM Fields (Construction) From Sales Order Area
277	CATEGORY_ID	☐	CACS_COM_CATEGORY_ID	CACS_COM_CATEGORY_ID	CHAR	20	0	Category ID
278	INDUSTRY	☐	CACS_CRM_INDUSTRY	CACS_CRM_INDUSTRY	CHAR	4	0	Industry Sector
279	.INCLU--AP	☐				0	0	Customer Fields for Condition Technique of Insurances
280	SSPARTE	☐	CACSINS_SPARTE	DSPARTE	CHAR	20	0	Line of Business Package Insurance
281	TTARIF	☐	CACSINS_TARIF	DTARIF	CHAR	20	0	Tariff Package Insurance
282	NAME	☐	CACSINS_NAME	DNAME	CHAR	20	0	Surname of Policy Holder
283	VORNAME	☐	CACSINS_VORNAME	DVORNAME	CHAR	20	0	First Name of Policy Holder
284	VSNR	☐	CACSINS_VSNR	DVSNR	NUMC	20	0	Insurance Policy Number
285	LAUFZEIT	☐	CACSINS_LAUFZEIT	DLAUFZEIT	DEC	4	2	Coverage Periods
286	ANNUAL_PREMIUM	☐	CACSINS_ANNUALPREMIUM	CACSDOM_ANNPREM	CURR	10	2	Annual Contribution
287	.INCLU--AP	☐				0	0	Append for Condition Technique Fields from Commission System
288	.INCLUDE	☐				0	0	Comm.: All Condition Technique-Relevant Commission Fields
289	CTRTST_ID	☐	CACS_CTRTST_ID	ISIS_CONTRACT_ID	CHAR	20	0	Number of Standard Commission Contract
290	BUCAGR_ID	☐	CACS_CTRTBU_ID	ISIS_CONTRACT_ID	CHAR	20	0	Commission Contract Number
291	CTRTST	☐	CACS_CTRTST_ID	ISIS_CONTRACT_ID	CHAR	20	0	Number of Standard Commission Contract
292	REM_BUSCASE_TYP	☐	CACSREMBUSCASTYP	CACSBUSCASTYP	CHAR	3	0	Remunerating Business Transaction in Operational System	*
293	P_VERSION	☐	CACS_COND_VERSION	CACSTIMESTAMP	NUMC	14	0	Version Date as Timestamp
294	P_CTRT_XL	☐	CACS_COND_CTRTID_XL	CHAR21	CHAR	21	0	Agreement Number Including Contract Type Indicator
295	P_CACSAPPL	☐	CACSAPPL	CACSAPPL	CHAR	6	0	Commission Application (ICM)	*
296	P_STATE	☐	CACSCONDSTATE	CACSCONDSTATE	CHAR	1	0	Condition Record Status
297	.INCLUDE	☐				0	0	Pricing Communication Position: IS-P Fields
298	PDUMMY_J0	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
299	.INCLUDE	☐				0	0	IS-PAM: Pricing Communications Item: Fields
300	PDUMMY_J1	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
301	.INCLUDE	☐				0	0	Foreign Trade: Import Simulation - Ctrl Fields for Pricing
302	FT_KONT	☐	FT_KONT	FT_KONT	CHAR	1	0	Control field for quota check during pricing
303	FT_PHAR	☐	FT_PHAR	FT_PHAR	CHAR	1	0	Control field for pharmaceut. products check during pricing
304	FT_AUSS	☐	FT_AUSS	FT_AUSS	CHAR	1	0	Control field for customs exemption check during pricing
305	FT_PREF	☐	FT_PREF	FT_PREF	CHAR	1	0	Control field for preference check during pricing
306	FT_DRIT	☐	FT_DRIT	FT_DRIT	CHAR	1	0	Control field for third-country check during pricing
307	FT_ANTI	☐	FT_ANTI	FT_ANTI	CHAR	1	0	Control field for anti-dumping check during pricing
308	FT_PLAF	☐	FT_PLAF	FT_PLAF	CHAR	1	0	Control Field for Ceiling Determination in Price Determintn
309	.INCLUDE	☐				0	0	Foreign Trade: General Fields Item
310	HLAND	☐	HLAND	LAND1	CHAR	3	0	Delivering country	*
311	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
312	VERLD	☐	VERLD	LAND1	CHAR	3	0	Country of dispatch for Foreign Trade	*
313	COIMP	☐	COIMP	STAWN	CHAR	17	0	Code number for import processing in foreign trade	*
314	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	*
315	CASNR	☐	CASNR	CASNR	CHAR	15	0	CAS number for pharmaceutical products in foreign trade	*
316	EXPRF	☐	EXPRF	EXPRF	CHAR	8	0	Export/Import Procedure for Foreign Trade	*
317	COKON	☐	COKON	COKON	CHAR	6	0	Customs quota code for import processing in foreign trade	*
318	COPHA	☐	COPHA	COPHA	CHAR	6	0	Pharmaceutical products code (Foreign Trade)	*
319	COADI	☐	COADI	COADI	CHAR	6	0	Anti-dumping code for import processing in foreign trade	*
320	HERSE	☐	HERSE	LIFNR	CHAR	10	0	Manufacturer number for import processing in foreign trade	*
321	KTNUM	☐	KTPLN	KTPLN	CHAR	10	0	Quota or Ceiling Number for Import Processing	*
322	PLNUM	☐	KTPLN	KTPLN	CHAR	10	0	Quota or Ceiling Number for Import Processing	*
323	PREFA	☐	PREFA	PREFA	CHAR	10	0	Preference: Preference type for foreign trade	*
324	EILGR	☐	EILGR	EILGR	CHAR	10	0	Country Groups for Import Processing in Foreign Trade	*
325	MOGRU	☐	MOGRU	MOGRU	CHAR	6	0	Common Agricultural Policy: CAP products group-Foreign Trade	*
326	PWGGR	☐	PWGGR	PWGGR	CHAR	6	0	Grouping for cross-plant preference determination	*
327	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
328	.INCLUDE	☐				0	0	Pricing Communication Item: IS-OIL Specific
329	OIIDC	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
330	OIEBC	☐	KZWIS	WERTV8	CURR	15	2	Condition subtotal
331	.INCLUDE	☐				0	0	Price Determination Communication Item (Brazil)
332	TXREG_SF	☐	J_1BTXSHPF	J_1BTXREG	CHAR	3	0	Ship from location (tax region)	*
333	TXREG_ST	☐	J_1BTXSHPT	J_1BTXREG	CHAR	3	0	Ship to location (tax region)	*
334	MTUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
335	OWNPR	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
336	MTORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
337	LOC_PR	☐	J_1BTXJCD_PR	J_1BTXJCD	CHAR	15	0	Tax Jurisdiction Code for Location of Service Provider	*
338	LOC_SE	☐	J_1BTXJCD_SE	J_1BTXJCD	CHAR	15	0	Tax Jurisdiction Code of Location Where Service Is Provided	*
339	LOC_SR	☐	J_1BTXJCD_SR	J_1BTXJCD	CHAR	15	0	Tax Jurisdiction Code of Location of Service Recipient	*
340	IPICONTRIBUTOR	☐	J_1BIPICONTRIBUTOR	XFELD	CHAR	1	0	IPI contributor
341	MTUSE_MARC	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
342	NBS	☐	J_1BNBS	J_1BNBS	CHAR	20	0	Brazilian Nomenclature Services code	*
343	FISCAL_INCENTIVE	☐	J_1BFISCAL_INCENTIVE_CODE	J_1BFISCAL_INCENTIVE_CODE	CHAR	4	0	Tax Incentive Type	*
344	TAX_SUBJECT_ST	☐	J_1BTC_TAX_SUBJECT_ST	J_1BYES_NO	CHAR	1	0	Tax Subject to Substituição Tributária
345	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
346	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
347	MANUAL_TC_REASON	☐	J_1BMANUAL_TC_REASON	J_1BMANUAL_TC_REASON	CHAR	2	0	Manual Tax Code Reason	*
348	J_1BINDUST	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
349	.INCLUDE	☐				0	0	Pricing Communication Items for Student Accounting
350	.INCLUDE	☐				0	0	Bonus Buys: Include KOMP
351	BBYNR	☐	BBYNR	BBYNR	CHAR	12	0	Bonus buy	KONBBYH
352	BBYPRQTYPE	☐	PRQTYPE	PRQTYPE	CHAR	3	0	Prerequisite Type
353	BBYGRPGNR	☐	GRPGNR	GRPGNR	CHAR	12	0	Material grouping	KONMATGRP
354	BBYMATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
355	BBYMATQUAN	☐	MATQUAN	MENG10	QUAN	10	3	Material Quantity
356	BBYMATUNIT	☐	MATUNIT	MEINS	UNIT	3	0	Unit of material	MARM
357	BBYSUMFLAG	☐	SUMFLAG	XFELD	CHAR	1	0	Indicates number as total
358	BBYREQNR	☐	REQNR	BEDNG	NUMC	3	0	Requirement number
359	BBYPER	☐	BBYPER	DEC3_3	DEC	6	3	Bonus buy condition value (percentage)
360	BBYVAL	☐	BBYVAL	WERT8	CURR	15	2	Bonus buy condition value (fixed)
361	BBYCUR	☐	BBYCUR	WAERS	CUKY	5	0	Currency of bonus buy condition	TCURC
362	BBYRQMIN	☐	BBYRQMIN	WERT8	CURR	15	2	Bonus buy requirement: miminum value
363	BBYRQMAX	☐	BBYRQMAX	WERT8	CURR	15	2	Bonus buy requirement: maximum value
364	BBYCUSCARD	☐	BBYCUSCARD	CHAR25	CHAR	25	0	Bonus buy requirement: customer card
365	BBYSCALETYPE	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
366	.INCLUDE	☐				0	0	Item Pricing Communication: second base value India version
367	NEBTR	☐	NEBTR	WERT7	CURR	13	2	Net Payment Amount
368	J_1ISTCODE	☐	J_1ISTCODE	J_1ISTCODE	CHAR	3	0	LST CST applicability code	*
369	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
370	.INCLUDE	☐				0	0	KOMP Field Enhancements for Global Trade Management
371	COCO_NUM	☐	WCB_COCO_NUM	WCB_COCO_NUM	CHAR	10	0	Condition Contract Number
372	IX_VBAP	☐	KOIDX	KOIDX	INT4	10	0	Index number for internal tables
373	IX_KOMK	☐	KOIDX	KOIDX	INT4	10	0	Index number for internal tables
374	MSR_RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason	*
375	MSR_REFUND_CODE	☐	MSR_RETURNS_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code
376	CLAIMS_TAXATION	☐	CLAIMS_TAXATION	CLAIMS_TAXATION	CHAR	1	0	Claims Taxation
377	NRAB_VALUE	☐	KWERT	WERTV7	CURR	13	2	Condition Value
378	.INCLUDE	☐				0	0
379	PAYMNT	☐	PAYMNT	WERTV8	CURR	15	2	Payment Value in Document Currency
380	RR_COSTREC_FLAG	☐	RR_COSTREC_FLAG	XFELD	CHAR	1	0	Relevant for Cost Recognition
381	.INCLU--AP	☐				0	0	Additional Fields JV
382	OICRP	☐	JV_CRP	CURRV13	CURR	13	2	Current replacement price
383	OICONDCOD	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)	*
384	.INCLU--AP	☐				0	0	TPM Campaign Determination: APPEND to KOMP
385	CMPGN_ID	☐	CMPGN_ID_R3	CMPGN_ID_R3	CHAR	10	0	Campaign ID
386	.INCLU--AP	☐				0	0	Append for Pricing and Payment Events
387	.INCLUDE	☐				0	0	PPE Data in Pricing
388	GROUP_CODE	☐	PPE_GROUP	PPE_GROUP	CHAR	4	0	Group
389	.INCLU--AP	☐				0	0	GTM: Characteristic Quality
390	.INCLUDE	☐				0	0	Quality: Characteristic Name
391	ATNAM_TC	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
392	.INCLU--AP	☐				0	0	Advanced Price Reference Handling
393	ALLOW_PMAT_IGNO	☐	WPM_ALLOW_PMAT_IGNO_MAT	XFELD	CHAR	1	0	Variant Price Allowed (for Material Master)
394	.INCLU--AP	☐				0	0	Article Hierarchy
395	NODE1	☐	WRF_STRUC_NODE2	WRF_NODES	CHAR	18	0	Hierarchy Node
396	NODE2	☐	WRF_STRUC_NODE2	WRF_NODES	CHAR	18	0	Hierarchy Node
397	NODE3	☐	WRF_STRUC_NODE2	WRF_NODES	CHAR	18	0	Hierarchy Node
398	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
399	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
400	.INCLU--AP	☐				0	0	Pricing Warranty - Item
401	WTY_POSNR	☐	WTY_POSNR	WTY_POSNR	NUMC	6	0	Item Number	*
402	WTY_POSKT	☐	WTY_POSKT	WTY_POSKT	CHAR	4	0	Controlling Item Type
403	WTY_DEFCT	☐	WTY_DEFCT	CHAR40	CHAR	40	0	Defect Code Number
404	WTY_ITMNO	☐	WTY_ITMNO	CHAR40	CHAR	40	0	Key for Detailed Item Data
405	WTY_QUANT	☐	WTY_QUANT	MENG15	QUAN	15	3	Quantity Claimed
406	WTY_CONTR	☐	WTY_CONTR	WERT11	CURR	11	2	Contribution
407	WTY_CNTTY	☐	WTY_CNTTY	WTY_CNTTY	CHAR	4	0	Calculation Type for Amount and Contribution
408	WTY_RETPA	☐	WTY_RETPA	WTY_RETPA	CHAR	1	0	Status for Parts that Have to Be Returned from Claimant
409	WTY_CAUSP	☐	WTY_CAUSP	WTY_CAUSP	CHAR	1	0	Part that Causes Damage
410	WTY_CRNCY	☐	WTY_CRNCY	WAERS	CUKY	5	0	Version Currency	*
411	WTY_REJCD	☐	WTY_REJCD	CHAR8	CHAR	8	0	Decision Code
412	WTY_REFKT	☐	WTY_REFKT		CHAR	2	0	Reference Type
413	WTY_REFNR	☐	WTY_REFNR	WTY_REFNR	CHAR	35	0	Reference Number
414	WTY_SDPOSNR	☐	WTY_SDPOSNR	POSNR	NUMC	6	0	Contract Item Number	*
415	WTY_PVGUID	☐	BAPIGUID	SDOK_DOCID	CHAR	32	0	GUID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OICIL	BBYCUR	TCURC	WAERS
2	OICIL	BBYGRPGNR	KONMATGRP	GRPGNR
3	OICIL	BBYMATNR	MARA	MATNR
4	OICIL	BBYMATUNIT	MARM	MEINH
5	OICIL	BBYNR	KONBBYH	BBYNR
6	OICIL	BUGRP	TVFBWG	BUGRP
7	OICIL	EXTWG	TWEW	EXTWG	KEY
8	OICIL	GARVZ	TGAV	GARVZ
9	OICIL	GEWEI	T006	MSEHI
10	OICIL	GTART	TGAR	GTART
11	OICIL	LADEH	T006	MSEHI
12	OICIL	LADGR	TLGR	LADGR
13	OICIL	LAGME	T006	MSEHI
14	OICIL	LANDT	T005	LAND1
15	OICIL	LPRIO	TPRIO	LPRIO
16	OICIL	LSTEL	TVLA	LSTEL
17	OICIL	MATNR	MARA	MATNR
18	OICIL	MEINS	T006	MSEHI
19	OICIL	MFRGR	TMFG	MFRGR
20	OICIL	PRDHA	T179	PRODH	KEY
21	OICIL	SRVPOS	ASMD	ASNUM
22	OICIL	TRAGR	TTGR	TRAGR
23	OICIL	VEGR1	TVE1	VEGR1
24	OICIL	VEGR2	TVE2	VEGR2
25	OICIL	VEGR3	TVE3	VEGR3
26	OICIL	VEGR4	TVE4	VEGR4
27	OICIL	VEGR5	TVE5	VEGR5
28	OICIL	VHART	TVTY	TRATY
29	OICIL	VHILM	MARA	MATNR
30	OICIL	VOLEH	T006	MSEHI
31	OICIL	VRKME	T006	MSEHI

History

Last changed by/on	SAP	20140121
SAP Release Created in