SAP ABAP Table WOSE_ITEMS_SHOW (SRS Display Material Document Item)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-SRS (Application Component) SAP Retail Store
     ⤷ WOST (Package) SAP Retail Store: Internet Application Components

Basic Data

Table Category	INTTAB	Structure
Structure	WOSE_ITEMS_SHOW	Table Relationship Diagram
Short Description	SRS Display Material Document 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	BAPI Communication Structure: Display Mat. Document Item
2	MAT_DOC	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
3	DOC_YEAR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
4	MATDOC_ITM	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
5	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
8	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
9	MOVE_TYPE	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
10	STCK_TYPE	☐	MB_INSMK	MB_INSMK	CHAR	1	0	Stock Type
11	SPEC_STOCK	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
12	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
13	CUSTOMER	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	KNA1
14	SALES_ORD	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
15	S_ORD_ITEM	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
16	SCHED_LINE	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
17	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
18	ENTRY_QNT	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
19	ENTRY_UOM	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
20	ENTRY_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
21	PO_PR_QNT	☐	BPMNG	MENG13	QUAN	13	3	Quantity in order price quantity unit
22	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
23	ORDERPR_UN_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
24	PO_NUMBER	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
25	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
26	SHIPPING	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
27	COMP_SHIP	☐	EVERE	EVERE	CHAR	2	0	Compliance with Shipping Instructions	T027C
28	NO_MORE_GR	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
29	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
30	GR_RCPT	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
31	UNLOAD_PT	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
32	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
33	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
34	ORDER_ITNO	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
35	CALC_MOTIVE	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
36	ASSET_NO	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
37	SUB_NUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
38	RESERV_NO	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	RESB
39	RES_ITEM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
40	RES_TYPE	☐	RSART	RSART	CHAR	1	0	Record type
41	WITHDRAWN	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
42	MOVE_MAT	☐	UMMAT	MATNR	CHAR	18	0	Receiving/issuing material	MARA
43	MOVE_PLANT	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
44	MOVE_STLOC	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	T001L
45	MOVE_BATCH	☐	UMCHA	CHARG	CHAR	10	0	Receiving/issuing batch	MCHA
46	MOVE_VAL_TYPE	☐	UMBAR	BWTAR	CHAR	10	0	Valuation type of transfer batch	T149D
47	MVT_IND	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
48	MOVE_REAS	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	T157D
49	RL_EST_KEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
50	REF_DATE	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
51	COST_OBJ	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	CKPH
52	PROFIT_SEGM_NO	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
53	PROFIT_CTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
54	WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
55	NETWORK	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	AUFK
56	ACTIVITY	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
57	PART_ACCT	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
58	AMOUNT_LC	☐	BAPI_EXBWR	BAPICURR	DEC	23	4	Externally entered posting amount in local currency (BAPI)
59	AMOUNT_SV	☐	BAPI_EXVKW	BAPICURR	DEC	23	4	Externally entered sales value in local currency (for Bapi)
60	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
61	CURRENCY_ISO	☐	ISOCD	ISOCD	CHAR	3	0	ISO currency code
62	REF_DOC_YR	☐	LFBJA	GJAHR	NUMC	4	0	Fiscal Year of a Reference Document
63	REF_DOC	☐	LFBNR	BELNR	CHAR	10	0	Document number of a reference document
64	REF_DOC_IT	☐	LFPOS	MBLPO	NUMC	4	0	Item of a reference document
65	EXPIRYDATE	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
66	PROD_DATE	☐	HSDAT	DATUM	DATS	8	0	Date of Manufacture
67	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	FMFINCODE
68	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	FMFCTR
69	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
70	VAL_SALES_ORD	☐	MAT_KDAUF	VBELN	CHAR	10	0	Sales order number of valuated sales order stock	VBUK
71	VAL_S_ORD_ITEM	☐	MAT_KDPOS	NUM06	NUMC	6	0	Sales Order Item of Valuated Sales Order Stock
72	VAL_WBS_ELEM	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
73	CO_BUSPROC	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
74	ACTTYPE	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
75	SUPPL_VEND	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	*
76	X_AUTO_CRE	☐	MB_XAUTO	MB_XAUTO	CHAR	1	0	Item automatically created
77	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
78	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
79	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
80	MOVE_MAT_EXTERNAL	☐	MGV_MOVE_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MOVE_MAT Field
81	MOVE_MAT_GUID	☐	MGV_MOVE_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MOVE_MAT Field
82	MOVE_MAT_VERSION	☐	MGV_MOVE_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MOVE_MAT Field
83	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
84	CMMT_ITEM_LONG	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
85	FUNC_AREA_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
86	LINE_ID	☐	MB_LINE_ID	MB_LINE_ID	NUMC	6	0	Unique identification of document line
87	PARENT_ID	☐	MB_PARENT_ID	MB_LINE_ID	NUMC	6	0	Identifier of immediately superior line
88	LINE_DEPTH	☐	MB_LINE_DEPTH	MB_LINE_DEPTH	NUMC	2	0	Hierarchy level of line in document
89	BUDGET_PERIOD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
90	EARMARKED_NUMBER	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
91	EARMARKED_ITEM	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
92	MATXT	☐	MATXT	TEXT40	CHAR	40	0	Short text for task
93	WEMENGE	☐	W_ERFMG	CHAR14	CHAR	14	0	Quantity in unit of entry
94	AUSW_KZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
95	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
96	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
97	MLGUT	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
98	REFPOS	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
99	ERROR_MESSAGE	☐	BAPI_MSG	TEXT220	CHAR	220	0	Message Text
100	SORT_KZ	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
101	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
102	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
103	ARTNR	☐	WSRS_MAT_KEY	WSRS_MAT_KEY	CHAR	40	0	Long material number for SAP Retail Store

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WOSE_ITEMS_SHOW	ASSET_NO	ANLH	ANLN1
2	WOSE_ITEMS_SHOW	BATCH	MCHA	CHARG
3	WOSE_ITEMS_SHOW	CALC_MOTIVE	TBMOT	BEMOT
4	WOSE_ITEMS_SHOW	CMMT_ITEM	FMFPO	FIPOS
5	WOSE_ITEMS_SHOW	COMP_SHIP	T027C	EVERE
6	WOSE_ITEMS_SHOW	COSTCENTER	CSKS	KOSTL
7	WOSE_ITEMS_SHOW	COST_OBJ	CKPH	KSTRG
8	WOSE_ITEMS_SHOW	CURRENCY	TCURC	WAERS
9	WOSE_ITEMS_SHOW	CUSTOMER	KNA1	KUNNR
10	WOSE_ITEMS_SHOW	ENTRY_UOM	T006	MSEHI
11	WOSE_ITEMS_SHOW	ENTRY_UOM_ISO	T006I	ISOCODE
12	WOSE_ITEMS_SHOW	FUND	FMFINCODE	FINCODE
13	WOSE_ITEMS_SHOW	FUNDS_CTR	FMFCTR	FICTR
14	WOSE_ITEMS_SHOW	MATERIAL	MARA	MATNR
15	WOSE_ITEMS_SHOW	MOVE_BATCH	MCHA	CHARG
16	WOSE_ITEMS_SHOW	MOVE_MAT	MARA	MATNR
17	WOSE_ITEMS_SHOW	MOVE_PLANT	T001W	WERKS
18	WOSE_ITEMS_SHOW	MOVE_REAS	T157D	GRUND
19	WOSE_ITEMS_SHOW	MOVE_STLOC	T001L	LGORT
20	WOSE_ITEMS_SHOW	MOVE_TYPE	T156	BWART
21	WOSE_ITEMS_SHOW	MOVE_VAL_TYPE	T149D	BWTAR
22	WOSE_ITEMS_SHOW	NETWORK	AUFK	AUFNR
23	WOSE_ITEMS_SHOW	ORDERID	AUFK	AUFNR
24	WOSE_ITEMS_SHOW	ORDERPR_UN	T006	MSEHI
25	WOSE_ITEMS_SHOW	ORDERPR_UN_ISO	T006I	ISOCODE
26	WOSE_ITEMS_SHOW	PART_ACCT	KNA1	KUNNR
27	WOSE_ITEMS_SHOW	PLANT	T001W	WERKS
28	WOSE_ITEMS_SHOW	PO_ITEM	EKPO	EBELP
29	WOSE_ITEMS_SHOW	PO_NUMBER	EKKO	EBELN
30	WOSE_ITEMS_SHOW	PROFIT_CTR	CEPC	PRCTR
31	WOSE_ITEMS_SHOW	RESERV_NO	RESB	RSNUM
32	WOSE_ITEMS_SHOW	SALES_ORD	VBUK	VBELN
33	WOSE_ITEMS_SHOW	SHIPPING	T027A	EVERS
34	WOSE_ITEMS_SHOW	SPEC_STOCK	T148	SOBKZ
35	WOSE_ITEMS_SHOW	STGE_LOC	T001L	LGORT
36	WOSE_ITEMS_SHOW	SUB_NUMBER	ANLA	ANLN2
37	WOSE_ITEMS_SHOW	VAL_SALES_ORD	VBUK	VBELN
38	WOSE_ITEMS_SHOW	VAL_TYPE	T149D	BWTAR
39	WOSE_ITEMS_SHOW	VENDOR	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	200