SAP ABAP Table S430 (SIS: (OIL-TSW) Sales document statistics by TSW object)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S430	Table Relationship Diagram
Short Description	SIS: (OIL-TSW) Sales document statistics by TSW object

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	P44V
4	TSYST	☑	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
5	LOCID	☑	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
6	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
7	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
8	ETENR	☑	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
9	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
10	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
11	BASME	☐	BASME	MEINS	UNIT	3	0	Base Unit of Measure for BOM	T006
12	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
14	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
15	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
16	AENETWR	☐	MC_AENETWR	WERTV10	CURR	19	2	Net value of incoming orders
17	AEMENGE	☐	MC_AEMENGE	MENGV15_3	QUAN	15	3	Incoming orders quantity
18	RENETWR	☐	MC_RENETWR	WERTV10	CURR	19	2	Net value of incoming returns
19	REMENGE	☐	MC_REMENGE	MENGV15_3	QUAN	15	3	Returns Quantity
20	OAUWE	☐	MC_OAUWE	WERTV10	CURR	19	2	Open net value of orders
21	OAUME	☐	MC_OAUME	MENGV15_3	QUAN	15	3	Open orders quantity in base unit of measure
22	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
23	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
24	WADAT	☐	WADAK	DATUM	DATS	8	0	Planned goods movement date
25	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
26	VKTRA	☐	VKTRA	VKTRA	CHAR	2	0	Mode of transport	TVTR
27	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
28	OIJMTI	☐	OIJ_TSWMTI	OIJ_TSWMTI	CHAR	1	0	OIL-TSW: TSW mode of transport indicator
29	CHARG	☐	OIJ_CHARG	CHARG	CHAR	10	0	Batch / Valuation type	*
30	VBTYP	☐	OIJ_EL_VBTYP	OIJ_EL_VBTYP	CHAR	1	0	TSW Details document type
31	.INCLUDE	☐				0	0	Additional fields for data transfer from TSW details to whif
32	NMSHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	*
33	NMCARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	*
34	UNLIMITED	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
35	ITBOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
36	ITBUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
37	PLANLOC	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*
38	PARTNR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
39	CONPAT	☐	OIJ_CONPAT	OIJ_PARTNR	CHAR	10	0	Contract Partner
40	FROMDATE	☐	OIJ_FROMDATE	DATUM	DATS	8	0	OIL-TSW: Deal validity From date
41	TODATE	☐	OIJ_TODATE	DATUM	DATS	8	0	OIL-TSW: Deal validity To date
42	SOLDTO	☐	OIJ_SOLDTO	OIJ_SOLDTO	CHAR	10	0	Customer Sold-to or Vendor

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S430	BASME	T006	MSEHI	REF	1	CN
2	S430	ETENR	VBEP	ETENR	KEY	1	CN
3	S430	KUNAG	KNA1	KUNNR	REF	1	CN
4	S430	KUNWE	KNA1	KUNNR	REF	1	CN
5	S430	LGORT	T001L	LGORT	REF	1	CN
6	S430	LOCID	OIJLOC	LOCID	KEY	1	CN
7	S430	MANDT	T000	MANDT	KEY	1	CN
8	S430	MATNR	MARA	MATNR	REF	1	CN
9	S430	POSNR	VBUP	POSNR	KEY	1	CN
10	S430	STWAE	TCURC	WAERS	REF	1	CN
11	S430	TSYST	OIJTS	TSYST	KEY	1	CN
12	S430	VBELN	VBUK	VBELN	KEY	1	CN
13	S430	VKTRA	TVTR	VKTRA	REF	1	CN
14	S430	VRSIO	P44V	VRSIO	KEY	1	CN
15	S430	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in