SAP ABAP Table U_16990 (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	T001W
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	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant
3	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
4	NAME2	☐	NAME2	TEXT30	CHAR	30	0	Name 2
5	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
6	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
7	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
8	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
9	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
10	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
11	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
12	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	KKOWK	☐	KKOWK	KKOWK	CHAR	1	0	Indicator: Conditions at plant level
14	KORDB	☐	KORDB	XFELD	CHAR	1	0	Indicator: Source list requirement
15	BEDPL	☐	BEDPL	XFELD	CHAR	1	0	Activating requirements planning
16	CHAZV	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
17	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
18	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
19	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
20	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
21	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
22	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
23	WKSOP	☐	WKSOP	XFELD	CHAR	1	0	SOP plant
24	AWSLS	☐	AWSLS	AWSLS	CHAR	6	0	Variance Key	TKV01
25	CHAZV_OLD	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
26	TAXIW	☐	TAXIW1	TAXIW1	CHAR	1	0	Tax Indicator: Plant (Purchasing)	TMKW1
27	BZQHL	☐	BZQHL	XFELD	CHAR	1	0	Take regular vendor into account
28	LET01	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
29	LET02	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
30	LET03	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
31	TXNAM_MA1	☐	TXNAM_MA1	TXNAM16	CHAR	16	0	Text name of 1st dunning of vendor declarations
32	TXNAM_MA2	☐	TXNAM_MA2	TXNAM16	CHAR	16	0	Text name of the 2nd dunning of vendor declarations
33	TXNAM_MA3	☐	TXNAM_MA3	TXNAM16	CHAR	16	0	Text name of 3rd dunning of vendor declarations
34	BETOL	☐	BETOL	NUMC3	NUMC	3	0	Number of days for PO tolerance - Compress info records - SU
35	J_1BBRANCH	☐	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	J_1BBRANCH
36	FPRFW	☐	FPRFW	FEPRF	CHAR	3	0	Distribution profile at plant level	TWFPF
37	ACHVM	☐	ACHVM_X	XFELD	CHAR	1	0	Central archiving marker for master record
38	DVSART	☐	DVSART	DVSART	CHAR	1	0	Batch Record: Type of DMS Used
39	NODETYPE	☐	NODETYPE	NODETYPE	CHAR	3	0	Node type: supply chain network	MDRP_NODT
40	VKORG	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
41	VTWEG	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
42	SPART	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing	TSPA
43	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
44	LIFNR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
45	VTBFI	☐	VTBFI	VTBFI	CHAR	2	0	Rule for determining the sales area for stock transfers

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_16990	AWSLS	TKV01	AWSLS	REF	C	CN
2	U_16990	BWKEY	T001K	BWKEY	REF	1	CN
3	U_16990	BZIRK	T171	BZIRK	KEY	1	CN
4	U_16990	CITYC	T005G	CITYC	REF	C	CN
5	U_16990	COUNC	T005E	COUNC	REF	C	CN
6	U_16990	FABKL	TFACD	IDENT	KEY	1	CN
7	U_16990	FPRFW	TWFPF	FPRFW	REF	1	CN
8	U_16990	J_1BBRANCH	J_1BBRANCH	BRANCH	KEY	1	CN
9	U_16990	LAND1	T005	LAND1	REF	1	CN
10	U_16990	LIFNR	LFA1	LIFNR	KEY	1	CN
11	U_16990	MANDT	T000	MANDT	KEY	1	CN
12	U_16990	NODETYPE	MDRP_NODT	NODETYPE		1	CN
13	U_16990	REGIO	T005S	BLAND	REF	C	CN
14	U_16990	SPART	TSPA	SPART	REF	C	CN
15	U_16990	SPRAS	T002	SPRAS	REF	C	CN
16	U_16990	TAXIW	TMKW1	TAXIW	KEY	1	CN
17	U_16990	TXJCD	TTXJ	TXJCD	REF	1	CN
18	U_16990	VKORG	TVKO	VKORG	REF	1	CN
19	U_16990	VTWEG	TVTW	VTWEG	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in