SAP ABAP Table WB2_ALV_IV_ITEM (ALV Display Invoice Verification: Item Data)

Hierarchy

☛ EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   ⤷ LO-GT-TEW (Application Component) Trading Execution Workbench
     ⤷ WB2B_TEW (Package) Trading Execution Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	WB2_ALV_IV_ITEM	Table Relationship Diagram
Short Description	ALV Display Invoice Verification: Item Data

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	Invoice Verification: Item Data
2	.INCLUDE	☐				0	0	Document Item: Incoming Invoice
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
5	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	BUZEI	☐	RBLGP	NUMC6	NUMC	6	0	Document Item in Invoice Document
7	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
8	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
9	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
12	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
13	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
16	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
17	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
18	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
19	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
20	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
21	BPMNG	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
22	BPRME	☐	BPRME	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
23	LBKUM	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
24	VRKUM	☐	VRKUM	MENG13V	QUAN	13	3	Total valuated stock in the previous posting period
25	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
26	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
27	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
28	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
29	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
30	EXKBE	☐	XEKBE	XFELD	CHAR	1	0	Indicator: update purchase order history
31	XEKBZ	☐	XEKBZ	XFELD	CHAR	1	0	Indicator: Update Purchase Order Delivery Costs
32	TBTKZ	☐	TBTKZ	TBTKZ	CHAR	1	0	Indicator: Subsequent Debit/Credit
33	SPGRP	☐	SPGRP	XFELD	CHAR	1	0	Blocking Reason: Price
34	SPGRM	☐	SPGRM	XFELD	CHAR	1	0	Blocking Reason: Quantity
35	SPGRT	☐	SPGRT	XFELD	CHAR	1	0	Blocking Reason: Date
36	SPGRG	☐	SPGRG	XFELD	CHAR	1	0	Blocking Reason: Order Price Quantity
37	SPGRV	☐	SPGRV	XFELD	CHAR	1	0	Blocking Reason: Project Budget
38	SPGRQ	☐	SPGRQ	XFELD	CHAR	1	0	Manual Blocking Reason
39	SPGRS	☐	SPGRS	XFELD	CHAR	1	0	Blocking Reason: Item Amount
40	SPGRC	☐	SPGRC	XFELD	CHAR	1	0	Blocking Reason: Quality
41	SPGREXT	☐	SPGREXT	XFELD	CHAR	1	0	Blocking Reason Enhancement Fields
42	BUSTW	☐	BUSTW	BUSTW	CHAR	4	0	Posting string for values
43	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
44	XRUEB	☐	XRUEB	XFELD	CHAR	1	0	Indicator: Document is posted to a previous period
45	BNKAN	☐	BNK_ANTEIL	WERT7	CURR	13	2	Delivery costs' share of item value
46	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
47	SALK3	☐	SALK3	WERT13N	CURR	13	2	Value of Total Valuated Stock
48	VMSAL	☐	VMSAL	WERT13N	CURR	13	2	Value of total valuated stock in previous period
49	XLIFO	☐	XLIFO	LIFO_FIFO	CHAR	1	0	LIFO/FIFO-relevant
50	LFBNR	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
51	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
52	LFPOS	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
53	MATBF	☐	MATBF	MATNR	CHAR	18	0	Material in Respect of Which Stock is Managed	*
54	RBMNG	☐	RBMNG	MENG13V	QUAN	13	3	Qty invoiced in vendor invoice in PO order units
55	BPRBM	☐	BPRBM	MENG13V	QUAN	13	3	Qty invoiced in vendor invoice in PO price units
56	RBWWR	☐	RBWWR	WERT7	CURR	13	2	Invoice amount in document currency of vendor invoice
57	LFEHL	☐	LFEHL	LFEHL	CHAR	1	0	Type of vendor error
58	GRICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
59	GRIRG	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
60	GITYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
61	PACKNO	☐	PACKNO_EKBE	PACKNO	NUMC	10	0	Package Number of Service	*
62	INTROW	☐	INTROW_EKBE	INTROW	NUMC	10	0	Line Number of Service
63	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
64	XSKRL	☐	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
65	KZMEK	☐	KZMEKORR	KZMEKORR	CHAR	1	0	Correction indicator
66	MRMOK	☐	MRMOK	XFELD	CHAR	1	0	Indicator: invoice item processed
67	STUNR	☐	STUNR	STUNR	NUMC	3	0	Level Number	*
68	ZAEHK	☐	DZAEHK	ZAEHK	NUMC	2	0	Condition counter
69	STOCK_POSTING	☐	STOCK_POSTING	WRTV7	CURR	13	2	Stock Posting of Line from an Incoming Invoice
70	STOCK_POSTING_PP	☐	STOCK_POSTING_PP	WRTV7	CURR	13	2	Stock Posting of Line from an Incoming Invoice, Prev. Period
71	STOCK_POSTING_PY	☐	STOCK_POSTING_PY	WRTV7	CURR	13	2	Stock Posting of Line from an Incoming Invoice, Prev. Year
72	WEREC	☐	MMWEREC	XFELD	CHAR	1	0	Clearing Indicator for GR/IR Posting for External Services
73	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
74	FRBNR	☐	FRBNR1	XBLNR1	CHAR	16	0	Number of Bill of Lading at Time of Goods Receipt
75	XHISTMA	☐	XHISTMA	CHAR1	CHAR	1	0	Update Multiple Account Assignment EKBE_MA, EKBZ_MA
76	COMPLAINT_REASON	☐	COMPLAINT_REASON	COMPLAINT_REASON	CHAR	2	0	Complaints Reason in an Invoice	*
77	RETAMT_FC	☐	RET_AMT_FC	WERT7	CURR	13	2	Retention Amount in Document Currency
78	RETPC	☐	RETPZ	PRZ32	DEC	5	2	Retention in Percent
79	RETDUEDT	☐	RET_DUE_DATE	DATUM	DATS	8	0	Due Date for Retention
80	XRETTAXNET	☐	RET_TAXNET	XFELD	CHAR	1	0	Tax Reduction for Retention
81	RE_ACCOUNT	☐	FAGL_RE_ACCOUNT	SAKNR	CHAR	10	0	Cash Ledger: Expense or Revenue Account	*
82	ERP_CONTRACT_ID	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
83	ERP_CONTRACT_ITM	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
84	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
85	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
86	CONT_PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
87	SRVMAPKEY	☐	SRVMAPKEY		NUMC	10	0	Item Key for eSOA Messages
88	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
89	INV_ITM_ORIGIN	☐	INV_ITM_ORIGIN	INV_ITM_ORIGIN	CHAR	1	0	Origin of an Invoice Item
90	INVREL	☐	INVREL	NUMC6	NUMC	6	0	Grouping Characteristic for Invoice Verification
91	XDINV	☐	XDINV	CHAR1	CHAR	1	0	Indicator for Differential Invoicing
92	DIFF_AMOUNT	☐	DIFFERENCE_AMOUNT	ANLKWERT	CURR	13	2	Difference Amount (in Document Currency)
93	XCPRF	☐	XCPRF	CHAR1	CHAR	1	0	Checkbox for Commodity Repricing in Invoice Verification
94	.INCLU--AP	☐				0	0	License details to Invoice
95	LICNO	☐	J_1ILICNO	J_1ILICNO	NUMC	10	0	Internal License Number
96	ZEILE	☐	J_1IZEILE	J_1IZEILE	NUMC	4	0	Item Number
97	.INCLU-_GT	☐				0	0	Invoice Verification: Dynamic Item Data
98	SCENARIO_GT	☐	WB2_BUSINESS_SCENARIO	WB2_BUSINESS_SCENARIO	CHAR	2	0	Business Scenario
99	FILTERED_OUT_GT	☐	WB2_FILTERED_OUT	WB2_FILTERED_OUT	CHAR	1	0	Filtered Out
100	NOT_REF_QUAN_GT	☐	WB2_NOT_REF_QUAN	MENG15	QUAN	15	3	Open Quantity
101	NOT_REF_QUAN_UNIT_GT	☐	WB2_NOT_REF_QUAN_UNIT	MEINS	UNIT	3	0	Open Quantity Unit	*
102	EXTERNAL_NO_GT	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
103	RBKP_WAERS_GT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
104	T001_WAERS_GT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
105	MARA_MEINS_GT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
106	LINECOLOR_GT	☐	WB2_LINECOLOR		CHAR	4	0	Color of a Row in ALV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WB2_ALV_IV_ITEM	BKLAS	T025	BKLAS
2	WB2_ALV_IV_ITEM	BPRME	T006	MSEHI
3	WB2_ALV_IV_ITEM	BSTME	T006	MSEHI
4	WB2_ALV_IV_ITEM	BUKRS	T001	BUKRS
5	WB2_ALV_IV_ITEM	BWKEY	T001K	BWKEY
6	WB2_ALV_IV_ITEM	BWTAR	T149D	BWTAR
7	WB2_ALV_IV_ITEM	EBELN	EKKO	EBELN
8	WB2_ALV_IV_ITEM	EBELP	EKPO	EBELP
9	WB2_ALV_IV_ITEM	GITYP	J_1ADTYP	J_1ADTYP	KEY	1	CN
10	WB2_ALV_IV_ITEM	GRICD	J_1AGICD	J_1AGICD	KEY	1	CN
11	WB2_ALV_IV_ITEM	GRIRG	T005S	BLAND	KEY	1	CN
12	WB2_ALV_IV_ITEM	KNTTP	T163K	KNTTP
13	WB2_ALV_IV_ITEM	MANDT	T000	MANDT
14	WB2_ALV_IV_ITEM	MATNR	MARA	MATNR
15	WB2_ALV_IV_ITEM	MEINS	T006	MSEHI
16	WB2_ALV_IV_ITEM	MWSKZ	T007A	MWSKZ
17	WB2_ALV_IV_ITEM	PSTYP	T163	PSTYP
18	WB2_ALV_IV_ITEM	TXJCD	TTXJ	TXJCD
19	WB2_ALV_IV_ITEM	WERKS	T001W	WERKS

History

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