SAP ABAP Table SAPI_SIV_ITEM (Step API: Item Data For Sales Invoices)

Hierarchy

☛ EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   ⤷ LO-GT-TEW (Application Component) Trading Execution Workbench
     ⤷ WB2B_METHODS (Package) Methods Calls for BAPIs in Trading Execution Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	SAPI_SIV_ITEM	Table Relationship Diagram
Short Description	Step API: Item Data For Sales Invoices

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	DOC_KEY	☐	WB2_DOC_KEY		CHAR	20	0	Document Key
2	ITEM_KEY	☐	WB2_ITEM_KEY		CHAR	16	0	Item Key
3	VBRK	☐	WB2_VBRK		STRU	0	0
4	.INCLUDE	☐				0	0	Billing Document: Header Data
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
6	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document
7	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type
8	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
9	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
10	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency
11	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
12	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
13	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing
14	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
15	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions
16	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
17	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
18	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
19	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
20	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)
21	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group
22	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district
23	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type
24	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)
25	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
26	EXPKZ	☐	EXPKZ	EXPKZ	CHAR	1	0	Export indicator
27	RFBSK	☐	RFBSK	RFBSK	CHAR	1	0	Status for transfer to accounting
28	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
29	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
30	CPKUR	☐	CPKUR	CPKUR	CHAR	1	0	ID:Exchange rate setting (no new rate determ.in bill.doc.)
31	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
32	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
33	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
34	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method
35	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer
36	LAND1	☐	LLAND	LAND1	CHAR	3	0	Destination Country
37	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
38	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code
39	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code
40	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code
41	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer
42	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer
43	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer
44	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer
45	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer
46	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer
47	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer
48	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer
49	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer
50	NETWR	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
51	ZUKRI	☐	DZUKRI	CHAR40	CHAR	40	0	Combination criteria in the billing document
52	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
53	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
54	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
55	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
56	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer
57	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party
58	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area
59	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency
60	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents
61	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
62	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
63	SFAKN	☐	SFAKN	VBELN	CHAR	10	0	Cancelled billing document number
64	KNUMA	☐	KNUMA	KNUMA	CHAR	10	0	Agreement (various conditions grouped together)
65	FKART_RL	☐	FKART_RL	FKART	CHAR	4	0	Invoice list type
66	FKDAT_RL	☐	FKDAT_RL	DATUM	DATS	8	0	Billing date for the invoice list
67	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type
68	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key
69	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block
70	SPART	☐	SPART	SPART	CHAR	2	0	Division
71	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area
72	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference
73	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area
74	CMKUF	☐	CMKUF	KURRF	DEC	9	5	Credit data exchange rate at billing document rate
75	HITYP_PR	☐	HITYP_PR	HITYP	CHAR	1	0	Hierarchy type for pricing
76	BSTNK_VF	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
77	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner
78	FKART_AB	☐	FKART_AB	FKART	CHAR	4	0	Accrual billing type
79	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application
80	LANDTX	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country
81	STCEG_H	☐	STCEG_H	STCEG_H	CHAR	1	0	Origin of sales tax ID number
82	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number
83	XBLNR	☐	XBLNR_V1	XBLNR1	CHAR	16	0	Reference Document Number
84	ZUONR	☐	ORDNR_V	ZUONR	CHAR	18	0	Assignment Number
85	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
86	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system
87	FKSTO	☐	FKSTO	XFELD	CHAR	1	0	Billing document is cancelled
88	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
89	RPLNR	☐	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number
90	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number
91	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type
92	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
93	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade
94	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
95	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
96	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
97	NUMPG	☐	J_1ANOPG	J_1ANOPG	NUMC	3	0	Number of pages of invoice
98	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place
99	VKONT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
100	FKK_DOCSTAT	☐	DOCSTAT_KK	DOCSTAT_KK	CHAR	1	0	Additional Status Transfer to Fin. Accounting (Res. RFBSK)
101	NRZAS	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
102	SPE_BILLING_IND	☐	/SPE/DE_BILLING_IND	/SPE/DE_BILLING_IND	CHAR	1	0	EWM Billing Indicator
103	VTREF	☐	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
104	FK_SOURCE_SYS	☐	FK_SOURCE_SYS	LOGSYS	CHAR	10	0	Source System
105	FKTYP_CRM	☐	FKTYP_CRM	FKTYP	CHAR	1	0	Billing Category in CRM
106	STGRD	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal
107	VBTYP_EXT	☐	TDD_VBTYP_EXT	DOM_VBTYP_EXT	CHAR	4	0	Extension of SD Document Category
108	.INCLU--AP	☐				0	0	VBRK append for Down Payment Chain
109	DPC_REL	☐	/SAPPCE/DPC_REL	CHAR01	CHAR	1	0	Flag: DPC relevant
110	.INCLU--AP	☐				0	0	VBRK_SEPA
111	.INCLUDE	☐				0	0	SEPA SD Struktur
112	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
113	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
114	SEPON	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
115	MNDVG	☐	SD_SEPA_FLAG	SD_SEPA_FLAG	CHAR	1	0	SEPA-Relevance
116	.INCLU--AP	☐				0	0	Append Structure for Special Paymenents
117	SPPAYM	☐	SPPAYM	SPPAYM	CHAR	2	0	Payment Form for Special Payment Method
118	SPPORD	☐	SPPORD	VBELN	CHAR	10	0	Sales Order for Special Payment Method
119	.INCLU-_GT	☐				0	0	Customer Billing Document: Dynamic Header Data
120	FILTERED_OUT_GT	☐	WB2_FILTERED_OUT	WB2_FILTERED_OUT	CHAR	1	0	Filtered Out
121	EXTERNAL_NO_GT	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
122	SCENARIO_GT	☐	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario
123	VBRP	☐	WB2_VBRP		STRU	0	0
124	.INCLUDE	☐				0	0	Billing Document: Item Data
125	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
126	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document
127	POSNR	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item
128	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures
129	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
130	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit
131	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
132	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
133	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
134	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
135	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
136	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
137	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
138	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
139	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
140	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
141	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit
142	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area
143	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
144	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
145	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
146	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
147	VBELV	☐	VBELV	VBELN	CHAR	10	0	Originating document
148	POSNV	☐	POSNV	POSNR	NUMC	6	0	Originating item
149	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
150	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
151	VGTYP	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
152	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document
153	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
154	AUREF	☐	AUREF	XFELD	CHAR	1	0	Sales document was created from reference
155	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
156	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
157	PMATN	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material
158	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
159	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group
160	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category
161	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
162	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy
163	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
164	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
165	SPART	☐	SPART	SPART	CHAR	2	0	Division
166	POSPA	☐	POSPA	POSNR	NUMC	6	0	Item number in the partner segment
167	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
168	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)
169	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located
170	WKCOU	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
171	WKCTY	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
172	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material
173	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material
174	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material
175	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material
176	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material
177	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material
178	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material
179	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material
180	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material
181	KOWRR	☐	KOWRR	KOWRR	CHAR	1	0	Statistical values
182	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
183	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
184	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
185	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group
186	KTGRM	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material
187	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
188	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group
189	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group
190	EANNR	☐	EANNR	CHAR13	CHAR	13	0	European Article Number (EAN) - obsolete!!!!!
191	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group
192	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
193	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header
194	SHKZG	☐	SHKZG_VF	SHKZG_VF	CHAR	1	0	Returns item
195	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
196	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
197	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
198	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
199	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
200	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
201	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
202	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
203	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
204	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
205	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
206	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
207	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
208	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
209	UVPRS	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
210	UVALL	☐	UVALL	XFELD	CHAR	1	0	Generally incomplete
211	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
212	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
213	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1
214	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2
215	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3
216	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4
217	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5
218	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1
219	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2
220	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3
221	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4
222	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5
223	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered
224	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
225	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area
226	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
227	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
228	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
229	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction
230	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
231	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
232	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
233	CUOBJ_CH	☐	CUOBJ_CH	CUOBJ	NUMC	18	0	Internal object number of the batch classification
234	KOUPD	☐	KOUPD	XFELD	CHAR	1	0	Condition update
235	UECHA	☐	UECHA	POSNR	NUMC	6	0	Higher-Level Item of Batch Split Item
236	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
237	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator
238	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number
239	BZIRK_AUFT	☐	BZIRK_AUFT	BZIRK	CHAR	6	0	Sales district of sales order
240	KDGRP_AUFT	☐	KDGRP_AUFT	KDGRP	CHAR	2	0	Customer group of sales order
241	KONDA_AUFT	☐	KONDA_AUFT	KONDA	CHAR	2	0	Price group of sales order
242	LLAND_AUFT	☐	LLAND_AUFT	LAND1	CHAR	3	0	Country of destination of sales order
243	MPROK	☐	MPROK	MPROK	CHAR	1	0	Status manual price change
244	PLTYP_AUFT	☐	PLTYP_AUFT	PLTYP	CHAR	2	0	Price list type of sales order
245	REGIO_AUFT	☐	REGIO_AUFT	REGIO	CHAR	3	0	Region of sales order
246	VKORG_AUFT	☐	VKORG_AUFT	VKORG	CHAR	4	0	Sales organization of sales order
247	VTWEG_AUFT	☐	VTWEG_AUFT	VTWEG	CHAR	2	0	Distribution channel of sales order
248	ABRBG	☐	ABRBG	DATUM	DATS	8	0	Start of accounting settlement period
249	PROSA	☐	PROSA	PROSA	CHAR	1	0	ID for material selection - active
250	UEPVW	☐	UEPVW	UEPVW	CHAR	1	0	ID for higher-level item usage
251	AUTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
252	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
253	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number
254	FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards
255	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion
256	KNUMA_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion
257	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal
258	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
259	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
260	AUGRU_AUFT	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)
261	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
262	UPMAT	☐	UPMAT	MATNR	CHAR	18	0	Pricing reference material of main item
263	UKONM	☐	UKONM	KONDM	CHAR	2	0	Material pricing group of main item
264	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
265	ABFOR	☐	ABSFORM_CM	ABSFORM_CM	CHAR	2	0	Form of payment guarantee
266	ABGES	☐	ABGES_CM	FLTP	FLTP	16	16	Guaranteed (factor between 0 and 1)
267	J_1ARFZ	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT
268	J_1AREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
269	J_1AGICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax
270	J_1ADTYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax
271	J_1ATXREL	☐	J_1ATXREL_	J_1ATXREL	CHAR	10	0	Tax relevant classification
272	J_1BCFOP	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension
273	J_1BTAXLW1	☐	J_1BTAXLW1	J_1BTAXLW1	CHAR	3	0	Tax law: ICMS
274	J_1BTAXLW2	☐	J_1BTAXLW2	J_1BTAXLW2	CHAR	3	0	Tax law: IPI
275	J_1BTXSDC	☐	J_1BTXSDC_	J_1BTXSDC	CHAR	2	0	SD tax code
276	BRTWR	☐	BRTWR_FP	WERTV8	CURR	15	2	Gross value of the billing item in document currency
277	WKTNR	☐	WKTNR	VBELN	CHAR	10	0	Value contract no.
278	WKTPS	☐	WKTPS	POSNR	NUMC	6	0	Value contract item
279	RPLNR	☐	RPLNR_AU	FPLNR	CHAR	10	0	Payment card plan number of sales document
280	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
281	WGRU1	☐	WGRU_HIE1	KLASSE	CHAR	18	0	Material group hierarchy 1
282	WGRU2	☐	WGRU_HIE2	KLASSE	CHAR	18	0	Material group hierarchy 2
283	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1
284	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2
285	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3
286	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4
287	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5
288	VKAUS	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator
289	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index
290	J_1AIDATEP	☐	J_1AIDATES	J_1AUDATEP	DATS	8	0	Indexing base date
291	KZFME	☐	KZFME	KZFME	CHAR	1	0	ID: Leading unit of measure for completing a transaction
292	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code
293	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
294	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
295	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
296	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
297	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator
298	RRREL	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
299	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
300	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number
301	VGBEL_EX	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
302	VGPOS_EX	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
303	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system
304	VGTYP_EX	☐	VGTYP_EX	VORG_TYP	CHAR	3	0	Category of an external transaction or element
305	J_1BTAXLW3	☐	J_1BTAXLW3	J_1BTAXLW3	CHAR	3	0	Tax law: ISS
306	J_1BTAXLW4	☐	J_1BTAXLW4	J_1BTAXLW4	CHAR	3	0	COFINS Tax Law
307	J_1BTAXLW5	☐	J_1BTAXLW5	J_1BTAXLW5	CHAR	3	0	PIS Tax Law
308	MSR_ID	☐	MSR_PROCESS_ID	MSR_PROCESS_ID	CHAR	10	0	Process Identification Number
309	MSR_REFUND_CODE	☐	MSR_RETURNS_REFUND_CODE	MSR_RETURNS_REFUND_CODE	CHAR	3	0	Returns Refund Code
310	MSR_RET_REASON	☐	MSR_RETURNS_REASON	MSR_RETURNS_REASON	CHAR	3	0	Return Reason
311	NRAB_KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
312	NRAB_VALUE	☐	KWERT	WERTV7	CURR	13	2	Condition Value
313	DISPUTE_CASE	☐	DISPUTE_CASE	SDBIL_RAW16	RAW	16	0	Dispute Case
314	FUND_USAGE_ITEM	☐	FUND_USAGE_ITEM	SDBIL_RAW16	RAW	16	0	Fund Usage Item
315	CLAIMS_TAXATION	☐	CLAIMS_TAXATION	CLAIMS_TAXATION	CHAR	1	0	Claims Taxation
316	KURRF_DAT_ORIG	☐	WWERT_D	DATUM	DATS	8	0	Translation date
317	VGTYP_EXT	☐	TDD_VBTYP_EXT_V	DOM_VBTYP_EXT	CHAR	4	0	Extension of SD document category of preceding document
318	.INCLUDE	☐				0	0
319	.INCLU--AP	☐				0	0	OLC append to VBRP
320	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
321	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
322	.INCLU--AP	☐				0	0	VBRP Append for Down Payment Chain
323	DPCNR	☐	/SAPPCE/DPCNR	/SAPPCE/DPCNR	CHAR	10	0	Down Payment Chain Number
324	DCPNR	☐	/SAPPCE/DPCPNR	NUM03	NUMC	3	0	Transaction Number
325	DPNRB	☐	/SAPPCE/DPCPNRB	NUM03	NUMC	3	0	Sequence Number of Accounting Document in Transaction
326	.INCLU--AP	☐				0	0	Period of Performance
327	PEROP_BEG	☐	FM_PEROP_SD_LOW	DATUM	DATS	8	0	Period of Performance Start Date
328	PEROP_END	☐	FM_PEROP_SD_HIGH	DATUM	DATS	8	0	Period of Performance End Date
329	.INCLU--AP	☐				0	0	Grants Mgmt: Additional FM fields to VBRP
330	FONDS	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
331	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center
332	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area
333	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
334	.INCLU--AP	☐				0	0	Commercial Project Inception & Lean Staffing appending VBRP
335	PRS_WORK_PERIOD	☐	PRS_WORK_PERIOD	PRS_WORK_PERIOD	NUMC	7	0	Work Period (Internal Representation)
336	.INCLU--AP	☐				0	0	Enhancements for RRICB / DP93
337	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center
338	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area
339	.INCLU--AP	☐				0	0	VBRP Append for Operation level costing
340	AUFPL_OAA	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
341	APLZL_OAA	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
342	.INCLU--AP	☐				0	0	TPM Campaign Determination: APPEND to VBRP
343	CAMPAIGN	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
344	.INCLU--AP	☐				0	0	Complaint Management
345	COMPREAS	☐	CMP_COMPREAS_COPY	CMP_COMPREAS_COPY	CHAR	4	0	Abbreviation for Complaints Reason
346	.INCLU-_GT	☐				0	0	Billing Document: Dynamic Item Data
347	SCENARIO_GT	☐	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario
348	FILTERED_OUT_GT	☐	WB2_FILTERED_OUT	WB2_FILTERED_OUT	CHAR	1	0	Filtered Out
349	NOT_REF_QUAN_GT	☐	WB2_NOT_REF_QUAN	MENG15	QUAN	15	3	Open Quantity
350	NOT_REF_QUAN_UNIT_GT	☐	WB2_NOT_REF_QUAN_UNIT	MEINS	UNIT	3	0	Open Quantity Unit
351	EXTERNAL_NO_GT	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
352	VBRK_WAERK_GT	☐	WAERS	WAERS	CUKY	5	0	Currency Key
353	.INCLUDE	☐				0	0	Dynamic Part of Data for Subsequent Action
354	ASSOC_QUAN_B	☐	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
355	UNIT_OF_QUAN_B	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
356	ASSOC_QUAN_S	☐	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
357	UNIT_OF_QUAN_S	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
358	ASSOC_QUAN_P	☐	WB2_ASSOCIATED_QUAN	MENGV15	QUAN	15	3	Assoc. Mngt: Actually Associated Quantity of an Item
359	UNIT_OF_QUAN_P	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
360	PORTFOLIO	☐	WB2_PORTFOLIO	KNUMB	CHAR	10	0	Global Trade: (Internal) Portfolio Number
361	.INCLUDE	☐				0	0	Communication Fields for Billing Header Fields
362	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
363	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
364	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
365	DOC_TYPE	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
366	ORDBILLTYP	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	TVFK
367	BILL_DATE	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
368	SOLD_TO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
369	ITEM_CATEG	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
370	ACCTASGNMT	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
371	PRICE_DATE	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
372	COUNTRY	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	T005
373	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
374	BILL_TO	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	KNA1
375	PAYER	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
376	SHIP_TO	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
377	REF_DOC	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
378	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
379	REQ_QTY	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
380	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
381	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
382	TAXCL_1MAT	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
383	REF_ITEM	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
384	STAT_GROUP	☐	VERSG	VERSG	CHAR	1	0	Statistics group	TVSG
385	NO_MATMAST	☐	NO_MARA	XFELD	CHAR	1	0	Do not check material master
386	ADDR_NO	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
387	TITLE	☐	ANRED	TEXT15	CHAR	15	0	Title
388	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
389	NAME_2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
390	POSTL_CODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
391	CONSUMCTRY	☐	ELAND	LAND1	CHAR	3	0	Country key of the consumer	T005
392	CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
393	DISTRICT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
394	STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
395	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
396	PROD_HIER	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
397	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
398	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
399	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
400	PURCH_ORD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
401	DOC_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
402	ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
403	ORIGINDOC	☐	VBELV	VBELN	CHAR	10	0	Originating document	*
404	ITEM	☐	POSNV	POSNR	NUMC	6	0	Originating item	*
405	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
406	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
407	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
408	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
409	INCOTERMS1	☐	BAPIINCO1	CHAR3	CHAR	3	0	Incoterms (Part 1)
410	INCOTERMS2	☐	BAPIINCO2	TEXT28	CHAR	28	0	Incoterms (part 2)
411	EXCHANGE_RATE	☐	BAPIKURSK	BAPIKURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
412	PAYMENT_TERMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
413	HG_LV_ITEM	☐	BAPIUEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
414	.INCLU--AP	☐				0	0	Append Structure to BAPIVBRK for Foreign Key
415	REF_DOC_CA	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
416	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
417	PROFIT_SEGM_NO	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
418	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
419	WBS_ELEM	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
420	TAX_DEPART_CTY	☐	LANDTX	LAND1	CHAR	3	0	Tax Departure Country	*
421	TAX_DEST_CTY	☐	LAND1TX	LAND1	CHAR	3	0	Tax Destination Country	*
422	SERV_DATE	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
423	CONT_ACCT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
424	PARALLEL_QTY	☐	/CWM/MENGE	MENG13	QUAN	13	3	Quantity in Parallel Unit of Measure
425	PARALLEL_UOM	☐	/CWM/MEINS	MEINS	UNIT	3	0	Parallel Unit of Measure	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SAPI_SIV_ITEM	ACCTASGNMT	TVKM	KTGRM
2	SAPI_SIV_ITEM	BILL_TO	KNA1	KUNNR
3	SAPI_SIV_ITEM	CONSUMCTRY	T005	LAND1
4	SAPI_SIV_ITEM	COUNTRY	T005	LAND1
5	SAPI_SIV_ITEM	CURRENCY	TCURC	WAERS
6	SAPI_SIV_ITEM	DISTR_CHAN	TVTW	VTWEG
7	SAPI_SIV_ITEM	DIVISION	TSPA	SPART
8	SAPI_SIV_ITEM	DOC_TYPE	TVAK	AUART
9	SAPI_SIV_ITEM	ITEM_CATEG	TVPT	PSTYV
10	SAPI_SIV_ITEM	MATERIAL	MARA	MATNR
11	SAPI_SIV_ITEM	ORDBILLTYP	TVFK	FKART
12	SAPI_SIV_ITEM	PAYER	KNA1	KUNNR
13	SAPI_SIV_ITEM	PLANT	T001W	WERKS
14	SAPI_SIV_ITEM	PROD_HIER	T179	PRODH
15	SAPI_SIV_ITEM	REGION	T005S	BLAND
16	SAPI_SIV_ITEM	SALESORG	TVKO	VKORG
17	SAPI_SIV_ITEM	SALES_UNIT	T006	MSEHI
18	SAPI_SIV_ITEM	SHIP_TO	KNA1	KUNNR
19	SAPI_SIV_ITEM	SOLD_TO	KNA1	KUNNR
20	SAPI_SIV_ITEM	STAT_GROUP	TVSG	VERSG

History

Last changed by/on	SAP	20140121
SAP Release Created in	46C