SAP ABAP Table ENT6800 (Generated Table for View)

Basic Data

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

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	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	KUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
43	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
44	LIFNR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
45	EROED	☐	EROED	DATUM	DATS	8	0	Opening date
46	SCHLD	☐	SCHLD	DATUM	DATS	8	0	Closing date
47	SPDAB	☐	SPDAB	DATUM	DATS	8	0	Block from
48	SPDBI	☐	SPDBI	DATUM	DATS	8	0	Block to
49	AUTOB	☐	AUTOB	CHAR001	CHAR	1	0	Automatic purchase order
50	KOPRO	☐	POSKOPRO	POSKOPRO	CHAR	4	0	POS outbound profile	TWPFI
51	LAYVR	☐	LAYVAR	LAYVAR	CHAR	10	0	Layout	TWGV
52	FLVAR	☐	FLVAR	FLVAR	CHAR	4	0	Area schema	TWGF
53	WANID	☐	WANID	WANID	CHAR	3	0	Goods receiving hours ID (default value)	TVWA
54	MOAB1	☐	WAMOAB1	UHRZT	TIMS	6	0	Goods receipt times: Monday morning from ...
55	MOBI1	☐	WAMOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Monday morning until ...
56	MOAB2	☐	WAMOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Monday afternoon from ...
57	MOBI2	☐	WAMOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Monday afternoon until ...
58	DIAB1	☐	WADIAB1	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday morning from...
59	DIBI1	☐	WADIBI1	UHRZT	TIMS	6	0	Goods receipt times: Tuesday morning until ...
60	DIAB2	☐	WADIAB2	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday afternoon from ...
61	DIBI2	☐	WADIBI2	UHRZT	TIMS	6	0	Goods receiving hours: Tuesday afternoon until ...
62	MIAB1	☐	WAMIAB1	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday morning from ...
63	MIBI1	☐	WAMIBI1	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday morning until ...
64	MIAB2	☐	WAMIAB2	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday afternoon from ...
65	MIBI2	☐	WAMIBI2	UHRZT	TIMS	6	0	Goods receiving hours: Wednesday afternoon until ...
66	DOAB1	☐	WADOAB1	UHRZT	TIMS	6	0	Goods receiving hours: Thursday morning from ...
67	DOBI1	☐	WADOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Thursday morning until ...
68	DOAB2	☐	WADOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Thursday afternoon from ...
69	DOBI2	☐	WADOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Thursday afternoon until...
70	FRAB1	☐	WAFRAB1	UHRZT	TIMS	6	0	Goods receiving hours: Friday morning from ...
71	FRBI1	☐	WAFRBI1	UHRZT	TIMS	6	0	Goods receiving hours: Friday morning until ...
72	FRAB2	☐	WAFRAB2	UHRZT	TIMS	6	0	Goods receiving hours: Friday afternoon from ...
73	FRBI2	☐	WAFRBI2	UHRZT	TIMS	6	0	Goods receiving hours: Friday afternoon until ...
74	SAAB1	☐	WASAAB1	UHRZT	TIMS	6	0	Goods receiving hours: Saturday morning from ...
75	SABI1	☐	WASABI1	UHRZT	TIMS	6	0	Goods receiving hours: Saturday morning from ...
76	SAAB2	☐	WASAAB2	UHRZT	TIMS	6	0	Goods receiving hours: Saturday afternoon from ...
77	SABI2	☐	WASABI2	UHRZT	TIMS	6	0	Goods receiving hours: Saturday afternoon until ...
78	SOAB1	☐	WASOAB1	UHRZT	TIMS	6	0	Goods receiving hours: Sunday morning from ...
79	SOBI1	☐	WASOBI1	UHRZT	TIMS	6	0	Goods receiving hours: Sunday morning until ...
80	SOAB2	☐	WASOAB2	UHRZT	TIMS	6	0	Goods receiving hours: Sunday afternoon from ...
81	SOBI2	☐	WASOBI2	UHRZT	TIMS	6	0	Goods receiving hours: Sunday afternoon until ...
82	VERFL	☐	VERFL_WWS	VERFL_WWS	QUAN	6	0	Sales area (floor space)
83	VERFE	☐	VERFE_WWS	MEINS	UNIT	3	0	Sales area (floor space) unit	T006
84	SPGR1	☐	SPGR1	SPGR1	CHAR	2	0	Blocking reason	TWRF11
85	INPRO	☐	POSINTPROF	POSINTPROF	CHAR	4	0	POS inbound profile	TWPIS
86	EKOAR	☐	POSEKOAR	POSEKOAR	CHAR	4	0	POS outbound: condition type group	TWPPK
87	KZLIK	☐	KZLIK	XFELD	CHAR	1	0	Listing conditions should be created per assortment
88	SPART	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing	TSPA
89	STFAK	☐	STKAL	WFCID	CHAR	2	0	Calendar	TFACD
90	BETRP	☐	BETRP	BETRP	CHAR	4	0	Plant profile	TWRF2
91	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
92	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
93	NLMATFB	☐	NLMATFB	NLMATFB	CHAR	1	0	ID: Carry out subsequent listing
94	BWWRK	☐	BWWRK	WERKS	CHAR	4	0	Plant for retail price determination	T001W
95	BWVKO	☐	BWVKO	VKORG	CHAR	4	0	Sales organization for retail price determination	TVKO
96	BWVTW	☐	BWVTW	VTWEG	CHAR	2	0	Distribution channel for retail price determination	TVTW
97	BBPRO	☐	BBPRO	BBPRO	CHAR	4	0	Assortment list profile	TWBP
98	VKBUR_WRK	☐	VKBUR_WRK	VKBUR	CHAR	4	0	Sales office
99	VLFKZ2	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
100	LSTFL	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV
101	LIGRD	☐	WLIGRD	WLIGRD	CHAR	1	0	Basic listing rule for assortments
102	VKORG2	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
103	VTWEG2	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
104	DESROI	☐	DESROI	DEC3_2	DEC	5	2	ROI required
105	TIMINC	☐	TIMINC	DEC5	DEC	5	0	Time increment for investement buying algorithm
106	POSWS	☐	POSWS	WAERS	CUKY	5	0	Currency of POS systems	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT6800	AWSLS	TKV01	AWSLS	REF	C	CN
2	ENT6800	BBPRO	TWBP	BBPRO
3	ENT6800	BETRP	TWRF2	BETRP
4	ENT6800	BWKEY	T001K	BWKEY	REF	1	CN
5	ENT6800	BWVKO	TVKO	VKORG	KEY	1	CN
6	ENT6800	BWVTW	TVTW	VTWEG	KEY	1	CN
7	ENT6800	BWWRK	T001W	WERKS	KEY	1	CN
8	ENT6800	BZIRK	T171	BZIRK	KEY	1	CN
9	ENT6800	CITYC	T005G	CITYC	REF	C	CN
10	ENT6800	COUNC	T005E	COUNC	REF	C	CN
11	ENT6800	EKOAR	TWPPK	EKOAR	KEY	1	CN
12	ENT6800	FABKL	TFACD	IDENT	KEY	1	CN
13	ENT6800	FLVAR	TWGF	FLVAR	REF	C	CN
14	ENT6800	FPRFW	TWFPF	FPRFW	REF	1	CN
15	ENT6800	INPRO	TWPIS	INPRO	KEY	1	CN
16	ENT6800	J_1BBRANCH	J_1BBRANCH	BRANCH	KEY	1	CN
17	ENT6800	KOPRO	TWPFI	KOPRO	KEY	1	CN
18	ENT6800	KUNNR	KNA1	KUNNR	REF	C	CN
19	ENT6800	LAND1	T005	LAND1	REF	1	CN
20	ENT6800	LAYVR	TWGV	LAYVR	KEY	1	CN
21	ENT6800	LIFNR	LFA1	LIFNR	KEY	1	CN
22	ENT6800	LSTFL	TWLV	LSTFL
23	ENT6800	MANDT	T000	MANDT	KEY	1	CN
24	ENT6800	NODETYPE	MDRP_NODT	NODETYPE		1	CN
25	ENT6800	POSWS	TCURC	WAERS	REF	1	CN
26	ENT6800	REGIO	T005S	BLAND	REF	C	CN
27	ENT6800	SPART	TSPA	SPART	REF	C	CN
28	ENT6800	SPGR1	TWRF11	SPGR1	KEY	1	CN
29	ENT6800	SPRAS	T002	SPRAS	REF	C	CN
30	ENT6800	STFAK	TFACD	IDENT	KEY	1	CN
31	ENT6800	TAXIW	TMKW1	TAXIW	KEY	1	CN
32	ENT6800	TXJCD	TTXJ	TXJCD	REF	1	CN
33	ENT6800	VERFE	T006	MSEHI	KEY	1	CN
34	ENT6800	VKORG	TVKO	VKORG	REF	1	CN
35	ENT6800	VKORG2	TVKO	VKORG	REF	1	CN
36	ENT6800	VTWEG	TVTW	VTWEG	REF	C	CN
37	ENT6800	VTWEG2	TVTW	VTWEG	REF	C	CN
38	ENT6800	WANID	TVWA	WANID	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in