SAP ABAP Table BS01SDORDERS (View: Order Items for Material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-EC-BOS (Application Component) Customer Bill of Services
     ⤷ AD_BOS_01 (Package) Customer Bills of Services (IBU A&D/E&C)

Basic Data

Table Category	INTTAB	Structure
Structure	BS01SDORDERS	Table Relationship Diagram
Short Description	View: Order Items for Material

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	View: Order Items for Material
2	SD_DOC	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
3	ITM_NUMBER	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
4	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
6	DOC_TYPE	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
7	DOC_DATE	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
8	REQ_QTY	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
9	REQ_DATE	☐	WLDAT	DATUM	DATS	8	0	Requested delivery date
10	PURCH_NO	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
11	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
12	VALID_FROM	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
13	VALID_TO	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
14	BILL_BLOCK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
15	DLV_BLOCK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
16	SOLD_TO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
17	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
18	EXCHG_RATE	☐	KURSK_P	PKURS	DEC	9	5	Directly Quoted Exchange Rate for Pricing and Statistics
19	DLV_QTY	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
20	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
21	NET_PRICE	☐	NETPR	WERTV6	CURR	11	2	Net price
22	COND_P_UNT	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
23	COND_UNIT	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
24	NET_VAL_HD	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
25	NET_VALUE	☐	NETWR	WERTV8	CURR	15	2	Net Value in Document Currency
26	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
27	DOC_STATUS	☐	STATS	TEXT20	CHAR	20	0	Document status
28	SALES_GRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
29	SALES_OFF	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
30	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
31	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
32	SHIP_POINT	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
33	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
34	GI_DATE	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
35	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
36	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
37	STORE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
38	ORD_REASON	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
39	REASON_REJ	☐	ABGRU	ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
40	B_UOM_ISO	☐	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	T006I
41	CD_UNT_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
42	S_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
43	CURR_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
44	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
45	EXCHG_RATE_V	☐	KURSK_V	PKURS	DEC	9	5	Indirectly Quoted Exchange Rate for Pricing and Statistics
46	MAT_EXT	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
47	MAT_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
48	MAT_VERS	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
49	CREATION_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
50	CREATION_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time
51	STATUS_DOC	☐	STATUS_VB	STATV	CHAR	1	0	Status of the document
52	PCKG_NO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BS01SDORDERS	BASE_UOM	T006	MSEHI
2	BS01SDORDERS	BATCH	MCHA	CHARG
3	BS01SDORDERS	BILL_BLOCK	TVFS	FAKSP
4	BS01SDORDERS	B_UOM_ISO	T006I	ISOCODE
5	BS01SDORDERS	CD_UNT_ISO	T006I	ISOCODE
6	BS01SDORDERS	COND_UNIT	T006	MSEHI
7	BS01SDORDERS	CURRENCY	TCURC	WAERS
8	BS01SDORDERS	DISTR_CHAN	TVTW	VTWEG
9	BS01SDORDERS	DIVISION	TSPA	SPART
10	BS01SDORDERS	DLV_BLOCK	TVLS	LIFSP
11	BS01SDORDERS	DOC_TYPE	TVAK	AUART
12	BS01SDORDERS	ITM_NUMBER	VBUP	POSNR
13	BS01SDORDERS	MATERIAL	MARA	MATNR
14	BS01SDORDERS	ORD_REASON	TVAU	AUGRU
15	BS01SDORDERS	PLANT	T001W	WERKS
16	BS01SDORDERS	SALES_GRP	TVKGR	VKGRP
17	BS01SDORDERS	SALES_OFF	TVBUR	VKBUR
18	BS01SDORDERS	SALES_ORG	TVKO	VKORG
19	BS01SDORDERS	SALES_UNIT	T006	MSEHI
20	BS01SDORDERS	SD_DOC	VBUK	VBELN
21	BS01SDORDERS	SHIP_POINT	TVST	VSTEL
22	BS01SDORDERS	SOLD_TO	KNA1	KUNNR
23	BS01SDORDERS	STORE_LOC	T001L	LGORT
24	BS01SDORDERS	S_UNIT_ISO	T006I	ISOCODE

History

Last changed by/on	SAP	20110901
SAP Release Created in