SAP ABAP Table U_15970 (Generated Table for View U_15970)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_15970	Table Relationship Diagram
Short Description	Generated Table for View U_15970

Delivery and Maintenance

Pool/cluster	AUPO
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	ABELN	☑	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
3	ABELP	☑	ABELP	ABELP	NUMC	5	0	Item number of allocation table
4	APSTP	☐	APSTP	APSTP	CHAR	4	0	Item category of allocation table	T621
5	ASTAP	☐	ASTAP	ASTAK	CHAR	1	0	Activity status of allocation table item
6	PSTAP	☐	PSTAP	PSTAK	CHAR	1	0	Maintenance status of alloc. table item
7	SPERR	☐	SPPOS	SPERR_A	CHAR	1	0	Blocking flag: item	T629
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	RFKTN	☐	RFKTN	EBELN	CHAR	10	0	Reference outline agreement	EKKO
13	RFKTP	☐	RFKTP	EBELP	NUMC	5	0	Reference outline agreement item	EKPO
14	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements
15	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
16	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
17	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
18	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
19	AKTPO	☐	W_MEPOS	NUMC2	NUMC	2	0	Sub-item for units of measure
20	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
21	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
22	BWART	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
23	VZWRK	☐	VZWRK	WERKS	CHAR	4	0	Distribution center as plant	T001W
24	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
25	SBELN	☐	SBELN	SBELN	CHAR	10	0	No. of allocation rule
26	FIKLI	☐	FCLIN	CLINT	NUMC	10	0	Internal class number, plant	KLAH
27	FILKL	☐	FILKL	KLASSE	CHAR	18	0	Plant group (technical plant class)
28	PMNGE	☐	PMNGE	MENG13	QUAN	13	3	Planned Quantity of Item
29	IMNGE	☐	IMNGE	MENG13	QUAN	13	3	Confirmed qty of item
30	MMNGE	☐	MMNGE	MENG13	QUAN	13	3	Minimum Quantity Per Plant
31	AUFME	☐	AUFME	MEINS	UNIT	3	0	Allocation Unit	T006
32	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
33	UZAEH	☐	UZAEH	UMBSZ	DEC	5	0	Numerator for conversion to base units of measure
34	UNENN	☐	UNENN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
35	LISTG	☐	LISTG	LISTG	CHAR	1	0	Listing Indicator
36	MANUE	☐	MANUE	CHAR1	CHAR	1	0	Flag: allocation table manually changed
37	RUNDG	☐	RUNDG	RUNDG	CHAR	1	0	Rounding off in allocation table
38	RESTV	☐	RESTV	RESTV	CHAR	1	0	Split remainder
39	ASTRA	☐	ASTRA	ASTRA	CHAR	4	0	Allocation Strategy	T627
40	LIEFW	☐	LIEFW	CHAR1	CHAR	1	0	Flag: delivery phase exists
41	VKSDT	☐	VKIDT	DATUM	DATS	8	0	Date of start of sales at plant
42	VKSTP	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
43	AAVIT	☐	AAVIT	AAVIT	CHAR	4	0	Notification Category Allocation: Info Exchance HQ - Plant	T626
44	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
45	VZENT	☐	VZENT	KUNNR	CHAR	10	0	Distribution center (as customer)	KNA1
46	VZLFR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
47	BSART	☐	BSART_LIEF	BSART	CHAR	4	0	Order type in allocation table (for external vendor)	T161
48	UMART	☐	BSART_LAGER	BSART	CHAR	4	0	Order type in allocation table (for warehouse/DC)	T161
49	LFART	☐	LFART_AUFT	LFART	CHAR	4	0	Delivery type of allocation table	TVLK
50	ABFDT	☐	AFIDT	DATUM	DATS	8	0	Confirmation request date
51	ABFTP	☐	PRGRS	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
52	SVFIX	☐	SVFIX	SVFIX	CHAR	1	0	Plants fixed in AR
53	SIMAM	☐	SIMAM	SIMAM	CHAR	1	0	Alloc tbl qty simulation
54	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_15970	AAVIT	T626	AAVIT
2	U_15970	ABELN	AUKO	ABELN	KEY	1	N
3	U_15970	AKTNR	WAKH	AKTNR
4	U_15970	APSTP	T621	APSTP
5	U_15970	ASTRA	T627	ASTRA
6	U_15970	AUFME	T006	MSEHI	KEY	1	N
7	U_15970	BSART	T161	BSART	REF	1	CN
8	U_15970	BWART	T149D	BWTAR
9	U_15970	EBELN	EKKO	EBELN	KEY	1	CN
10	U_15970	EBELP	EKPO	EBELP	KEY	1	CN
11	U_15970	FIKLI	KLAH	CLINT
12	U_15970	LFART	TVLK	LFART	REF	1	CN
13	U_15970	LGORT	T001L	LGORT	REF	1	CN
14	U_15970	LIFNR	LFA1	LIFNR	REF	C	CN
15	U_15970	MANDT	T000	MANDT	KEY	1	N
16	U_15970	MATKL	T023	MATKL	REF	1	CN
17	U_15970	MATNR	MARA	MATNR	REF	1	N
18	U_15970	MEINS	T006	MSEHI	REF	1	N
19	U_15970	RFKTN	EKKO	EBELN	REF	1	N
20	U_15970	RFKTP	EKPO	EBELP	REF	1	N
21	U_15970	SPERR	T629	SPERR	REF	1	CN
22	U_15970	UMART	T161	BSART	REF	1	CN
23	U_15970	VZENT	KNA1	KUNNR	REF	1	CN
24	U_15970	VZLFR	LFA1	LIFNR	REF	1	CN
25	U_15970	VZWRK	T001W	WERKS	REF	1	CN

History

Last changed by/on	SAP	20040719
SAP Release Created in