SAP ABAP Table WINT_SORTR (Assortments - complete access data)
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
⤷ 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_SORTR | Table Relationship Diagram |
Short Description | Assortments - complete access data |
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 | * | |
2 | LOCNR | ASORT | ASORT | CHAR | 10 | 0 | Assortment | * | |
3 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
4 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
5 | KATR1 | KATR1 | ATTR1 | CHAR | 2 | 0 | Attribute 1 | * | |
6 | KATR2 | KATR2 | ATTR2 | CHAR | 2 | 0 | Attribute 2 | * | |
7 | KATR3 | KATR3 | ATTR3 | CHAR | 2 | 0 | Attribute 3 | * | |
8 | KATR4 | KATR4 | ATTR4 | CHAR | 2 | 0 | Attribute 4 | * | |
9 | KATR5 | KATR5 | ATTR5 | CHAR | 2 | 0 | Attribute 5 | * | |
10 | KATR6 | KATR6 | ATTR6 | CHAR | 3 | 0 | Attribute 6 | * | |
11 | KATR7 | KATR7 | ATTR7 | CHAR | 3 | 0 | Attribute 7 | * | |
12 | KATR8 | KATR8 | ATTR8 | CHAR | 3 | 0 | Attribute 8 | * | |
13 | KATR9 | KATR9 | ATTR9 | CHAR | 3 | 0 | Attribute 9 | * | |
14 | KATR10 | KATR10 | ATTR10 | CHAR | 3 | 0 | Attribute 10 | * | |
15 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
16 | KNAZK | KNAZK | WFCID | CHAR | 2 | 0 | Working Time Calendar | * | |
17 | BEGRU | BRGRU | BRGRU | CHAR | 4 | 0 | Authorization Group | * | |
18 | BRSCH | BRSCH | BRSCH | CHAR | 4 | 0 | Industry key | * | |
19 | EXABL | EXABL | XFELD | CHAR | 1 | 0 | Indicator: Unloading points exist | ||
20 | KUKLA | KUKLA | KUKLA | CHAR | 2 | 0 | Customer classification | * | |
21 | LAND1 | LAND1_GP | LAND1 | CHAR | 3 | 0 | Country Key | * | |
22 | LIFSD | LIFSD_X | LIFSP | CHAR | 2 | 0 | Central delivery block for the customer | * | |
23 | LOEVM | LOEVM_X | XFELD | CHAR | 1 | 0 | Central Deletion Flag for Master Record | ||
24 | NIELS | NIELS | NIELS | CHAR | 2 | 0 | Nielsen ID | * | |
25 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
26 | STKZA | STKZA | STKZA | CHAR | 1 | 0 | Indicator: Business Partner Subject to Equalization Tax? | ||
27 | STKZU | STKZU | XFELD | CHAR | 1 | 0 | Liable for VAT | ||
28 | LZONE | LZONE | ZONE | CHAR | 10 | 0 | Transportation zone to or from which the goods are delivered | * | |
29 | XCPDK | XCPDK | XFELD | CHAR | 1 | 0 | Indicator: Is the account a one-time account? | ||
30 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
31 | HZUOR | HZUOR | HZUOR | NUMC | 2 | 0 | Assignment to Hierarchy | ||
32 | SPERZ | SPERZ | XFELD | CHAR | 1 | 0 | Payment Block | ||
33 | ETIKG | ETIKG | ETIKG | CHAR | 10 | 0 | IS-R Labeling: customer/plant group | * | |
34 | EROED | EROED | DATUM | DATS | 8 | 0 | Opening date | ||
35 | SCHLD | SCHLD | DATUM | DATS | 8 | 0 | Closing date | ||
36 | SPDAB | SPDAB | DATUM | DATS | 8 | 0 | Block from | ||
37 | SPDBI | SPDBI | DATUM | DATS | 8 | 0 | Block to | ||
38 | KOPRO | POSKOPRO | POSKOPRO | CHAR | 4 | 0 | POS outbound profile | * | |
39 | AUTOB | AUTOB | CHAR001 | CHAR | 1 | 0 | Automatic purchase order | ||
40 | LAYVR | LAYVAR | LAYVAR | CHAR | 10 | 0 | Layout | * | |
41 | FLVAR | FLVAR | FLVAR | CHAR | 4 | 0 | Area schema | * | |
42 | STFAK | STKAL | WFCID | CHAR | 2 | 0 | Calendar | * | |
43 | VERFL | VERFL_WWS | VERFL_WWS | QUAN | 6 | 0 | Sales area (floor space) | ||
44 | VERFE | VERFE_WWS | MEINS | UNIT | 3 | 0 | Sales area (floor space) unit | * | |
45 | SPGR1 | SPGR1 | SPGR1 | CHAR | 2 | 0 | Blocking reason | * | |
46 | INPRO | POSINTPROF | POSINTPROF | CHAR | 4 | 0 | POS inbound profile | * | |
47 | EKOAR | POSEKOAR | POSEKOAR | CHAR | 4 | 0 | POS outbound: condition type group | * | |
48 | KZLIK | KZLIK | XFELD | CHAR | 1 | 0 | Listing conditions should be created per assortment | ||
49 | BETRP | BETRP | BETRP | CHAR | 4 | 0 | Plant profile | * | |
50 | NLMATFB | NLMATFB | NLMATFB | CHAR | 1 | 0 | ID: Carry out subsequent listing | ||
51 | BWWRK | BWWRK | WERKS | CHAR | 4 | 0 | Plant for retail price determination | * | |
52 | BWVKO | BWVKO | VKORG | CHAR | 4 | 0 | Sales organization for retail price determination | * | |
53 | BWVTW | BWVTW | VTWEG | CHAR | 2 | 0 | Distribution channel for retail price determination | * | |
54 | BBPRO | BBPRO | BBPRO | CHAR | 4 | 0 | Assortment list profile | * | |
55 | VKBUR_WRK | VKBUR_WRK | VKBUR | CHAR | 4 | 0 | Sales office | * | |
56 | VLFKZ | W_SOTYP | W_SOTYP | CHAR | 1 | 0 | Assortment Category | ||
57 | LSTFL | LSTFL | LSTFL | CHAR | 2 | 0 | Listing procedure for store or other assortment categories | * | |
58 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
59 | BWKEY | BWKEY | BWKEY | CHAR | 4 | 0 | Valuation area | * | |
60 | VKORG | VKOIV | VKORG | CHAR | 4 | 0 | Sales organization for intercompany billing | * | |
61 | CHAZV | CHAZV | XFELD | CHAR | 1 | 0 | Indicator: batch status management active | ||
62 | FABKL | FABKL | WFCID | CHAR | 2 | 0 | Factory calendar key | * | |
63 | KORDB | KORDB | XFELD | CHAR | 1 | 0 | Indicator: Source list requirement | ||
64 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
65 | VTWEG | VTWIV | VTWEG | CHAR | 2 | 0 | Distribution channel for intercompany billing | * | |
66 | SPART | SPAIV | SPART | CHAR | 2 | 0 | Division for intercompany billing | * | |
67 | CHAZV_OLD | CHAZV | XFELD | CHAR | 1 | 0 | Indicator: batch status management active | ||
68 | VLFKZ_WK | VLFKZ | VLFKZ | CHAR | 1 | 0 | Plant category | ||
69 | LIFNR_WK | LIFNR_WK | LIFNR | CHAR | 10 | 0 | Vendor number of plant | * | |
70 | BZQHL | BZQHL | XFELD | CHAR | 1 | 0 | Take regular vendor into account |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |