SAP ABAP Table S431 (PURCHIS: (OIL-TSW) Purchasing document stats 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	S431	Table Relationship Diagram
Short Description	PURCHIS: (OIL-TSW) Purchasing document stats 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	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
7	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
8	ETENR	☑	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter	EKET
9	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
10	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
11	BASME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
12	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
13	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
14	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
15	LIFN2	☐	LIFN2	LIFNR	CHAR	10	0	Reference to other vendor	LFA1
16	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
17	MENGE	☐	MC_MENGE	MENGV15_3	QUAN	15	3	Purchase order quantity
18	WEMNG	☐	MC_WEMNG	MENGV15_3	QUAN	15	3	Quantity of goods received
19	WEMGM	☐	MC_WEMGMAX	MENGV15_3	QUAN	15	3	Goods receipt qty in base unit (calculate wtd.delivery time)
20	REMNG	☐	MC_REMNG	MENGV15_3	QUAN	15	3	Invoice receipt quantity
21	LSMNG	☐	MC_LSMNG	MENGV15_3	QUAN	15	3	Target delivery quantity in base unit of measure
22	NETWR	☐	MC_EFFWR	WERTV8	CURR	15	2	Effective order value
23	REWRT	☐	MC_REWRT	WERTV8	CURR	15	2	Invoice Amount
24	ABSTE	☐	MC_ABSTE	MCZAEHLER	DEC	9	0	Number of purchase order item schedule lines
25	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
26	VKTRA	☐	VKTRA	VKTRA	CHAR	2	0	Mode of transport	TVTR
27	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
28	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
29	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
30	OIJMTI	☐	OIJ_TSWMTI	OIJ_TSWMTI	CHAR	1	0	OIL-TSW: TSW mode of transport indicator
31	CHARG	☐	OIJ_CHARG	CHARG	CHAR	10	0	Batch / Valuation type	*
32	VBTYP	☐	OIJ_EL_VBTYP	OIJ_EL_VBTYP	CHAR	1	0	TSW Details document type
33	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
34	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
35	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type
36	.INCLUDE	☐				0	0	Additional fields for data transfer from TSW details to whif
37	NMSHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	*
38	NMCARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	*
39	UNLIMITED	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
40	ITBOTOL	☐	OIJ_BOTOL	DEC3_1	DEC	4	1	Quantity tolerance over (percentage)
41	ITBUTOL	☐	OIJ_BUTOL	DEC3_1	DEC	4	1	Quantity tolerance under (%)
42	PLANLOC	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*
43	PARTNR	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
44	CONPAT	☐	OIJ_CONPAT	OIJ_PARTNR	CHAR	10	0	Contract Partner
45	FROMDATE	☐	OIJ_FROMDATE	DATUM	DATS	8	0	OIL-TSW: Deal validity From date
46	TODATE	☐	OIJ_TODATE	DATUM	DATS	8	0	OIL-TSW: Deal validity To date
47	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	S431	BASME	T006	MSEHI	REF	1	CN
2	S431	EBELN	EKKO	EBELN	KEY	1	CN
3	S431	EBELP	EKPO	EBELP	KEY	1	CN
4	S431	ETENR	EKET	ETENR	KEY	1	CN
5	S431	HWAER	TCURC	WAERS	REF	1	CN
6	S431	LGORT	T001L	LGORT	REF	1	CN
7	S431	LIFN2	LFA1	LIFNR	REF	1	CN
8	S431	LIFNR	LFA1	LIFNR	REF	1	CN
9	S431	LOCID	OIJLOC	LOCID	KEY	1	CN
10	S431	MANDT	T000	MANDT	KEY	1	CN
11	S431	MATNR	MARA	MATNR	REF	1	CN
12	S431	TSYST	OIJTS	TSYST	KEY	1	CN
13	S431	VKTRA	TVTR	VKTRA	REF	1	CN
14	S431	VRSIO	P44V	VRSIO	KEY	1	CN
15	S431	WERKS	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in