SAP ABAP Table WINT_CARRH (Assortment header data/overall view (incl. data from plant))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ WSOR (Package) IS-R: Assortments

Basic Data

Table Category	INTTAB	Structure
Structure	WINT_CARRH	Table Relationship Diagram
Short Description	Assortment header data/overall view (incl. data from plant)

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	ASORT	☑	ASORT	ASORT	CHAR	10	0	Assortment	WRS1
3	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
4	VKORG_STD	☐	VKORG_STD	VKORG	CHAR	4	0	Sales organization for master data assignments	TVKO
5	VTWEG_STD	☐	VTWEG_STD	VTWEG	CHAR	2	0	Distribution channel for master data assignments	TVTW
6	EROED	☐	EROED	DATUM	DATS	8	0	Opening date
7	SCHLD	☐	SCHLD	DATUM	DATS	8	0	Closing date
8	SPDAB	☐	SPDAB	DATUM	DATS	8	0	Block from
9	SPDBI	☐	SPDBI	DATUM	DATS	8	0	Block to
10	AUTOB	☐	AUTOB	CHAR001	CHAR	1	0	Automatic purchase order
11	KOPRO	☐	POSKOPRO	POSKOPRO	CHAR	4	0	POS outbound profile	TWPFI
12	LAYVR	☐	LAYVAR	LAYVAR	CHAR	10	0	Layout	TWGV
13	FLVAR	☐	FLVAR	FLVAR	CHAR	4	0	Area schema	TWGF
14	STFAK	☐	STKAL	WFCID	CHAR	2	0	Calendar	TFACD
15	VERFL	☐	VERFL_WWS	VERFL_WWS	QUAN	6	0	Sales area (floor space)
16	VERFE	☐	VERFE_WWS	MEINS	UNIT	3	0	Sales area (floor space) unit	T006
17	SPGR1	☐	SPGR1	SPGR1	CHAR	2	0	Blocking reason	TWRF11
18	INPRO	☐	POSINTPROF	POSINTPROF	CHAR	4	0	POS inbound profile	TWPIS
19	EKOAR	☐	POSEKOAR	POSEKOAR	CHAR	4	0	POS outbound: condition type group	TWPPK
20	KZLIK	☐	KZLIK	XFELD	CHAR	1	0	Listing conditions should be created per assortment
21	BETRP	☐	BETRP	BETRP	CHAR	4	0	Plant profile	TWRF2
22	NLMATFB	☐	NLMATFB	NLMATFB	CHAR	1	0	ID: Carry out subsequent listing
23	BWWRK	☐	BWWRK	WERKS	CHAR	4	0	Plant for retail price determination	T001W
24	BWVKO	☐	BWVKO	VKORG	CHAR	4	0	Sales organization for retail price determination	TVKO
25	BWVTW	☐	BWVTW	VTWEG	CHAR	2	0	Distribution channel for retail price determination	TVTW
26	BBPRO	☐	BBPRO	BBPRO	CHAR	4	0	Assortment list profile	TWBP
27	VKBUR_WRK	☐	VKBUR_WRK	VKBUR	CHAR	4	0	Sales office	TVBUR
28	LSTFL	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV
29	LIGRD	☐	WLIGRD	WLIGRD	CHAR	1	0	Basic listing rule for assortments
30	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
31	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
32	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
33	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
34	VKORG	☐	VKOIV	VKORG	CHAR	4	0	Sales organization for intercompany billing	TVKO
35	CHAZV	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
36	FABKL	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	TFACD
37	KKOWK	☐	KKOWK	KKOWK	CHAR	1	0	Indicator: Conditions at plant level
38	KORDB	☐	KORDB	XFELD	CHAR	1	0	Indicator: Source list requirement
39	BEDPL	☐	BEDPL	XFELD	CHAR	1	0	Activating requirements planning
40	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
41	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
42	VTWEG	☐	VTWIV	VTWEG	CHAR	2	0	Distribution channel for intercompany billing	TVTW
43	SPART	☐	SPAIV	SPART	CHAR	2	0	Division for intercompany billing	TSPA
44	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
45	CHAZV_OLD	☐	CHAZV	XFELD	CHAR	1	0	Indicator: batch status management active
46	VLFKZ	☐	W_SOTYP	W_SOTYP	CHAR	1	0	Assortment Category
47	LIFNR	☐	LIFNR_WK	LIFNR	CHAR	10	0	Vendor number of plant	LFA1
48	BZQHL	☐	BZQHL	XFELD	CHAR	1	0	Take regular vendor into account
49	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
50	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
51	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
52	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
53	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
54	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
55	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
56	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
57	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
58	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
59	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
60	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
61	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
62	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
63	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
64	ETIKG	☐	ETIKG	ETIKG	CHAR	10	0	IS-R Labeling: customer/plant group	TWEK
65	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
66	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
67	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
68	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
69	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
70	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
71	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
72	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
73	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
74	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
75	LAYPR	☐	W_S_LAYPR	XFELD	CHAR	1	0	Listing check: only use layout defined for the assortment
76	SOTYP	☐	W_SOTYP	W_SOTYP	CHAR	1	0	Assortment Category
77	STATU	☐	W_S_STATUS	W_S_STATUS	CHAR	1	0	Status of assortment
78	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
79	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WINT_CARRH	ASORT	WRS1	ASORT		1	CN
2	WINT_CARRH	BBPRO	TWBP	BBPRO		1	CN
3	WINT_CARRH	BETRP	TWRF2	BETRP		1	CN
4	WINT_CARRH	BRSCH	T016	BRSCH		1	CN
5	WINT_CARRH	BWKEY	T001K	BWKEY		1	CN
6	WINT_CARRH	BWVKO	TVKO	VKORG		1	CN
7	WINT_CARRH	BWVTW	TVTW	VTWEG		1	CN
8	WINT_CARRH	BWWRK	T001W	WERKS		1	CN
9	WINT_CARRH	EKOAR	TWPPK	EKOAR		1	CN
10	WINT_CARRH	EKORG	T024E	EKORG		1	CN
11	WINT_CARRH	ETIKG	TWEK	KUNGR		1	CN
12	WINT_CARRH	FABKL	TFACD	IDENT		1	CN
13	WINT_CARRH	FLVAR	TWGF	FLVAR		1	CN
14	WINT_CARRH	INPRO	TWPIS	INPRO		1	CN
15	WINT_CARRH	KATR1	TVK1	KATR1		1	CN
16	WINT_CARRH	KATR10	TVK0	KATR10		1	CN
17	WINT_CARRH	KATR2	TVK2	KATR2		1	CN
18	WINT_CARRH	KATR3	TVK3	KATR3		1	CN
19	WINT_CARRH	KATR4	TVK4	KATR4		1	CN
20	WINT_CARRH	KATR5	TVK5	KATR5		1	CN
21	WINT_CARRH	KATR6	TVK6	KATR6		1	CN
22	WINT_CARRH	KATR7	TVK7	KATR7		1	CN
23	WINT_CARRH	KATR8	TVK8	KATR8		1	CN
24	WINT_CARRH	KATR9	TVK9	KATR9		1	CN
25	WINT_CARRH	KNAZK	TFACD	IDENT		1	CN
26	WINT_CARRH	KOPRO	TWPFI	KOPRO		1	CN
27	WINT_CARRH	KUKLA	TKUKL	KUKLA		1	CN
28	WINT_CARRH	KUNNR	KNA1	KUNNR		1	CN
29	WINT_CARRH	LAND1	T005	LAND1		1	CN
30	WINT_CARRH	LAYVR	TWGV	LAYVR		1	CN
31	WINT_CARRH	LIFNR	LFA1	LIFNR		1	CN
32	WINT_CARRH	LIFSD	TVLS	LIFSP		1	CN
33	WINT_CARRH	LSTFL	TWLV	LSTFL		1	CN
34	WINT_CARRH	LZONE	TZONE	ZONE1		1	CN
35	WINT_CARRH	MANDT	T000	MANDT		1	CN
36	WINT_CARRH	NIELS	TNLS	NIELS		1	CN
37	WINT_CARRH	REGIO	T005S	BLAND		1	CN
38	WINT_CARRH	SPART	TSPA	SPART		1	CN
39	WINT_CARRH	SPGR1	TWRF11	SPGR1		1	CN
40	WINT_CARRH	SPRAS	T002	SPRAS		1	CN
41	WINT_CARRH	STFAK	TFACD	IDENT		1	CN
42	WINT_CARRH	VERFE	T006	MSEHI		1	CN
43	WINT_CARRH	VKBUR_WRK	TVBUR	VKBUR		1	CN
44	WINT_CARRH	VKORG	TVKO	VKORG		1	CN
45	WINT_CARRH	VKORG_STD	TVKO	VKORG		1	CN
46	WINT_CARRH	VTWEG	TVTW	VTWEG		1	CN
47	WINT_CARRH	VTWEG_STD	TVTW	VTWEG		1	CN
48	WINT_CARRH	WERKS	T001W	WERKS		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in