SAP ABAP View U_16957 (Store)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	U_16957
Short Description	Store
Root table	T001W	Plants/Branches

Entity Type	DM02L
Short text	Store

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T001W	T001W
2	KNA1
3	WRF1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ		0		0	0
2	T001W	MANDT	JR	EQ		0	AND	0	0
3	KNA1	KUNNR	JL	EQ		0		0	0
4	T001W	KUNNR	JR	EQ		0	AND	0	0
5	KNA1	MANDT	JL	EQ		0		0	0
6	WRF1	MANDT	JR	EQ		0	AND	0	0
7	KNA1	KUNNR	JL	EQ		0		0	0
8	WRF1	LOCNR	JR	EQ		0	AND	0	0
9	KNA1	MANDT	JL	EQ		0		0	0
10	T001W	MANDT	JR	EQ		0	AND	0	0
11	KNA1	KUNNR	JL	EQ		0		0	0
12	T001W	KUNNR	JR	EQ		0	AND	0	0
13	KNA1	MANDT	JL	EQ		0		0	0
14	WRF1	MANDT	JR	EQ		0	AND	0	0
15	KNA1	KUNNR	JL	EQ		0		0	0
16	WRF1	LOCNR	JR	EQ		0	AND	0	0
17	T001W	VLFKZ		NE	' '	1	AND	0	0
18	T001W	VLFKZ		EQ	'A'	0		0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T001W	MANDT		☐	MANDT	☐	Client
2	WERKS	T001W	WERKS		☐	WERKS_D	☐	Plant
3	NAME1	T001W	NAME1		☐	NAME1	☐	Name
4	NAME2	T001W	NAME2		☐	NAME2	☐	Name 2
5	STRAS	T001W	STRAS		☐	STRAS	☐	House number and street
6	PFACH	T001W	PFACH		☐	PFACH	☐	PO Box
7	PSTLZ	T001W	PSTLZ		☐	PSTLZ	☐	Postal Code
8	ORT01	T001W	ORT01		☐	ORT01	☐	City
9	ADRNR	T001W	ADRNR		☐	ADRNR	☐	Address
10	BWKEY	T001W	BWKEY		☐	BWKEY	☐	Valuation area
11	FABKL	T001W	FABKL		☐	FABKL	☐	Factory calendar key
12	LAND1	T001W	LAND1		☐	LAND1	☐	Country Key
13	KKOWK	T001W	KKOWK		☐	KKOWK	☐	Indicator: Conditions at plant level
14	KORDB	T001W	KORDB		☐	KORDB	☐	Indicator: Source list requirement
15	BEDPL	T001W	BEDPL		☐	BEDPL	☐	Activating requirements planning
16	CHAZV	T001W	CHAZV		☐	CHAZV	☐	Indicator: batch status management active
17	SPRAS	T001W	SPRAS		☐	SPRAS	☐	Language Key
18	VLFKZ	T001W	VLFKZ		☐	VLFKZ	☐	Plant category
19	REGIO	T001W	REGIO		☐	REGIO	☐	Region (State, Province, County)
20	COUNC	T001W	COUNC		☐	COUNC	☐	County Code
21	CITYC	T001W	CITYC		☐	CITYC	☐	City Code
22	TXJCD	T001W	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
23	WKSOP	T001W	WKSOP		☐	WKSOP	☐	SOP plant
24	AWSLS	T001W	AWSLS		☐	AWSLS	☐	Variance Key
25	CHAZV_OLD	T001W	CHAZV_OLD		☐	CHAZV	☐	Indicator: batch status management active
26	TAXIW	T001W	TAXIW		☐	TAXIW1	☐	Tax Indicator: Plant (Purchasing)
27	BZQHL	T001W	BZQHL		☐	BZQHL	☐	Take regular vendor into account
28	LET01	T001W	LET01		☐	MAHN1	☐	Number of Days for First Reminder/Expediter
29	LET02	T001W	LET02		☐	MAHN2	☐	Number of Days for Second Reminder/Expediter
30	LET03	T001W	LET03		☐	MAHN3	☐	Number of Days for Third Reminder/Expediter
31	TXNAM_MA1	T001W	TXNAM_MA1		☐	TXNAM_MA1	☐	Text name of 1st dunning of vendor declarations
32	TXNAM_MA2	T001W	TXNAM_MA2		☐	TXNAM_MA2	☐	Text name of the 2nd dunning of vendor declarations
33	TXNAM_MA3	T001W	TXNAM_MA3		☐	TXNAM_MA3	☐	Text name of 3rd dunning of vendor declarations
34	BETOL	T001W	BETOL		☐	BETOL	☐	Number of days for PO tolerance - Compress info records - SU
35	J_1BBRANCH	T001W	J_1BBRANCH		☐	J_1BBRANC_	☐	Business Place
36	FPRFW	T001W	FPRFW		☐	FPRFW	☐	Distribution profile at plant level
37	ACHVM	T001W	ACHVM		☐	ACHVM_X	☐	Central archiving marker for master record
38	DVSART	T001W	DVSART		☐	DVSART	☐	Batch Record: Type of DMS Used
39	NODETYPE	T001W	NODETYPE		☐	NODETYPE	☐	Node type: supply chain network
40	VKORG	T001W	VKORG		☐	VKOIV	☐	Sales organization for intercompany billing
41	VTWEG	T001W	VTWEG		☐	VTWIV	☐	Distribution channel for intercompany billing
42	KUNNR	T001W	KUNNR		☐	KUNNR_WK	☐	Customer number of plant
43	BZIRK	T001W	BZIRK		☐	BZIRK	☐	Sales district
44	LIFNR	T001W	LIFNR		☐	LIFNR_WK	☐	Vendor number of plant
45	EROED	WRF1	EROED		☐	EROED	☐	Opening date
46	SCHLD	WRF1	SCHLD		☐	SCHLD	☐	Closing date
47	SPDAB	WRF1	SPDAB		☐	SPDAB	☐	Block from
48	SPDBI	WRF1	SPDBI		☐	SPDBI	☐	Block to
49	AUTOB	WRF1	AUTOB		☐	AUTOB	☐	Automatic purchase order
50	KOPRO	WRF1	KOPRO		☐	POSKOPRO	☐	POS outbound profile
51	LAYVR	WRF1	LAYVR		☐	LAYVAR	☐	Layout
52	FLVAR	WRF1	FLVAR		☐	FLVAR	☐	Area schema
53	WANID	WRF1	WANID		☐	WANID	☐	Goods receiving hours ID (default value)
54	MOAB1	WRF1	MOAB1		☐	WAMOAB1	☐	Goods receipt times: Monday morning from ...
55	MOBI1	WRF1	MOBI1		☐	WAMOBI1	☐	Goods receiving hours: Monday morning until ...
56	MOAB2	WRF1	MOAB2		☐	WAMOAB2	☐	Goods receiving hours: Monday afternoon from ...
57	MOBI2	WRF1	MOBI2		☐	WAMOBI2	☐	Goods receiving hours: Monday afternoon until ...
58	DIAB1	WRF1	DIAB1		☐	WADIAB1	☐	Goods receiving hours: Tuesday morning from...
59	DIBI1	WRF1	DIBI1		☐	WADIBI1	☐	Goods receipt times: Tuesday morning until ...
60	DIAB2	WRF1	DIAB2		☐	WADIAB2	☐	Goods receiving hours: Tuesday afternoon from ...
61	DIBI2	WRF1	DIBI2		☐	WADIBI2	☐	Goods receiving hours: Tuesday afternoon until ...
62	MIAB1	WRF1	MIAB1		☐	WAMIAB1	☐	Goods receiving hours: Wednesday morning from ...
63	MIBI1	WRF1	MIBI1		☐	WAMIBI1	☐	Goods receiving hours: Wednesday morning until ...
64	MIAB2	WRF1	MIAB2		☐	WAMIAB2	☐	Goods receiving hours: Wednesday afternoon from ...
65	MIBI2	WRF1	MIBI2		☐	WAMIBI2	☐	Goods receiving hours: Wednesday afternoon until ...
66	DOAB1	WRF1	DOAB1		☐	WADOAB1	☐	Goods receiving hours: Thursday morning from ...
67	DOBI1	WRF1	DOBI1		☐	WADOBI1	☐	Goods receiving hours: Thursday morning until ...
68	DOAB2	WRF1	DOAB2		☐	WADOAB2	☐	Goods receiving hours: Thursday afternoon from ...
69	DOBI2	WRF1	DOBI2		☐	WADOBI2	☐	Goods receiving hours: Thursday afternoon until...
70	FRAB1	WRF1	FRAB1		☐	WAFRAB1	☐	Goods receiving hours: Friday morning from ...
71	FRBI1	WRF1	FRBI1		☐	WAFRBI1	☐	Goods receiving hours: Friday morning until ...
72	FRAB2	WRF1	FRAB2		☐	WAFRAB2	☐	Goods receiving hours: Friday afternoon from ...
73	FRBI2	WRF1	FRBI2		☐	WAFRBI2	☐	Goods receiving hours: Friday afternoon until ...
74	SAAB1	WRF1	SAAB1		☐	WASAAB1	☐	Goods receiving hours: Saturday morning from ...
75	SABI1	WRF1	SABI1		☐	WASABI1	☐	Goods receiving hours: Saturday morning from ...
76	SAAB2	WRF1	SAAB2		☐	WASAAB2	☐	Goods receiving hours: Saturday afternoon from ...
77	SABI2	WRF1	SABI2		☐	WASABI2	☐	Goods receiving hours: Saturday afternoon until ...
78	SOAB1	WRF1	SOAB1		☐	WASOAB1	☐	Goods receiving hours: Sunday morning from ...
79	SOBI1	WRF1	SOBI1		☐	WASOBI1	☐	Goods receiving hours: Sunday morning until ...
80	SOAB2	WRF1	SOAB2		☐	WASOAB2	☐	Goods receiving hours: Sunday afternoon from ...
81	SOBI2	WRF1	SOBI2		☐	WASOBI2	☐	Goods receiving hours: Sunday afternoon until ...
82	VERFL	WRF1	VERFL		☐	VERFL_WWS	☐	Sales area (floor space)
83	VERFE	WRF1	VERFE		☐	VERFE_WWS	☐	Sales area (floor space) unit
84	SPGR1	WRF1	SPGR1		☐	SPGR1	☐	Blocking reason
85	INPRO	WRF1	INPRO		☐	POSINTPROF	☐	POS inbound profile
86	EKOAR	WRF1	EKOAR		☐	POSEKOAR	☐	POS outbound: condition type group
87	KZLIK	WRF1	KZLIK		☐	KZLIK	☐	Listing conditions should be created per assortment
88	SPART	T001W	SPART		☐	SPAIV	☐	Division for intercompany billing
89	STFAK	WRF1	STFAK		☐	STKAL	☐	Calendar
90	BETRP	WRF1	BETRP		☐	BETRP	☐	Plant profile
91	ERDAT	WRF1	ERDAT		☐	ERDAT	☐	Date on which the record was created
92	ERNAM	WRF1	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
93	NLMATFB	WRF1	NLMATFB		☐	NLMATFB	☐	ID: Carry out subsequent listing
94	BWWRK	WRF1	BWWRK		☐	BWWRK	☐	Plant for retail price determination
95	BWVKO	WRF1	BWVKO		☐	BWVKO	☐	Sales organization for retail price determination
96	BWVTW	WRF1	BWVTW		☐	BWVTW	☐	Distribution channel for retail price determination
97	BBPRO	WRF1	BBPRO		☐	BBPRO	☐	Assortment list profile
98	VKBUR_WRK	WRF1	VKBUR_WRK		☐	VKBUR_WRK	☐	Sales office
99	VLFKZ2	WRF1	VLFKZ		☐	VLFKZ	☐	Plant category
100	LSTFL	WRF1	LSTFL		☐	LSTFL	☐	Listing procedure for store or other assortment categories
101	LIGRD	WRF1	LIGRD		☐	WLIGRD	☐	Basic listing rule for assortments
102	VKORG2	WRF1	VKORG		☐	VKOIV	☐	Sales organization for intercompany billing
103	VTWEG2	WRF1	VTWEG		☐	VTWIV	☐	Distribution channel for intercompany billing
104	DESROI	WRF1	DESROI		☐	DESROI	☐	ROI required
105	TIMINC	WRF1	TIMINC		☐	TIMINC	☐	Time increment for investement buying algorithm
106	POSWS	WRF1	POSWS		☐	POSWS	☐	Currency of POS systems

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in