SAP ABAP Table DB_WCOCOA (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | DB_WCOCOA |
|
| 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 | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
WCB_COCO_NUM | WCB_COCO_NUM | CHAR | 10 | 0 | Condition Contract Number | ||
| 3 | |
WCB_CONTRACT_TYPE | WCB_CONTRACT_TYPE | CHAR | 4 | 0 | Condition Contract Type | TWCBCONTRTYPE | |
| 4 | |
WCB_VEND_OWNER | LIFNR | CHAR | 10 | 0 | Condition Contract: Owner Vendor | LFA1 | |
| 5 | |
WCB_CUST_OWNER | KUNNR | CHAR | 10 | 0 | Condition Contract: Customer Owner | KNA1 | |
| 6 | |
WCB_REFERENCE | WCB_REFERENCE | CHAR | 16 | 0 | Condition Contract: Reference | ||
| 7 | |
WCB_ASSIGNMENT | WCB_ASSIGNMENT | CHAR | 16 | 0 | Condition Contract: Assignment | ||
| 8 | |
WCB_EXTERNAL_PARTNER | WCB_EXTERNAL_PARTNER | CHAR | 10 | 0 | Condition Contract: External Partner | ||
| 9 | |
WCB_CREATED_BY | USNAM | CHAR | 12 | 0 | Condition Contract: Name of Processor | ||
| 10 | |
WCB_CREATED_ON | DATUM | DATS | 8 | 0 | Condition Contract: Date on Which Record Was Added | ||
| 11 | |
WCB_REC_TIME | UZEIT | TIMS | 6 | 0 | Condition Contr.: Time at Which Record Was Added | ||
| 12 | |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
| 13 | |
EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
| 14 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 15 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
| 16 | |
SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
| 17 | |
DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
| 18 | |
DZBDET | ZBDXT | DEC | 3 | 0 | Cash (Prompt Payment) Discount Days | ||
| 19 | |
DZBD1P | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 | ||
| 20 | |
DZBD2T | ZBDXT | DEC | 3 | 0 | Cash discount days 2 | ||
| 21 | |
DZBD2P | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 | ||
| 22 | |
DZBD3T | ZBDXT | DEC | 3 | 0 | Net Payment Terms Period | ||
| 23 | |
DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | ||
| 24 | |
WCB_GUID | WCB_GUID | RAW | 16 | 0 | Condition Contract GUID | ||
| 25 | |
WCB_DEACTIVATED | WCB_DEACTIVATED | CHAR | 1 | 0 | Deactivated | ||
| 26 | |
WCB_DATE_FROM | WCB_DATE_FROM | DATS | 8 | 0 | Valid from | ||
| 27 | |
WCB_DATE_TO | WCB_DATE_TO | DATS | 8 | 0 | Valid to | ||
| 28 | |
SYSTZONLO | SYCHAR06 | CHAR | 6 | 0 | Time Zone | ||
| 29 | |
WCB_EXTERNAL_NUMBER | WCB_EXTERNAL_NUMBER | CHAR | 30 | 0 | External Number of Document | ||
| 30 | |
WCB_CC_CURR | WAERS | CUKY | 5 | 0 | Currency of Condition Contract | TCURC | |
| 31 | |
WCB_WKURS | KURSP | DEC | 9 | 5 | Exchange Rate | ||
| 32 | |
WCB_WWERT_D | DATUM | DATS | 8 | 0 | Conversion Date | ||
| 33 | |
KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
| 34 | |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
| 35 | |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVBUR | |
| 36 | |
WCB_ACCESS_TYPE | WCB_ACCESS_TYPE | CHAR | 1 | 0 | Access Type | ||
| 37 | |
WCB_ITEM_GUID | WCB_GUID | RAW | 16 | 0 | Condition Contract: Item GUID | ||
| 38 | |
WCB_ELIGIBLE_CUST | KUNNR | CHAR | 10 | 0 | Condition Contract: Eligible Partners for Customer | KNA1 | |
| 39 | |
WCB_ELIGIBLE_VENDOR | LIFNR | CHAR | 10 | 0 | Condition Contract: Eligible Partners for Vendor | LFA1 | |
| 40 | |
WCB_LIST_NUM | WCB_COCO_NUM | CHAR | 10 | 0 | Number of an Eligible Partner List | ||
| 41 | |
WCB_EXCLUSION | BVALD | CHAR | 1 | 0 | Filter Eligible Partner from Group | ||
| 42 | |
WCB_DATE_FROM_I | WCB_DATE_FROM | DATS | 8 | 0 | Valid from | ||
| 43 | |
WCB_DATE_TO_I | WCB_DATE_TO | DATS | 8 | 0 | Valid to | ||
| 44 | |
WCB_DEACTIVATED | WCB_DEACTIVATED | CHAR | 1 | 0 | Deactivated | ||
| 45 | |
WCB_GUID | WCB_GUID | RAW | 16 | 0 | Condition Contract GUID | ||
| 46 | |
WCB_REFERENCE | WCB_REFERENCE | CHAR | 16 | 0 | Condition Contract: Reference |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | DB_WCOCOA | CC_CURR | |
|
1 | CN | |
| 2 | DB_WCOCOA | CLIENT | |
|
KEY | 1 | CN |
| 3 | DB_WCOCOA | CONTRACT_TYPE | |
|
1 | CN | |
| 4 | DB_WCOCOA | CUST_OWNER | |
|
KEY | 1 | CN |
| 5 | DB_WCOCOA | EKGRP | |
|
|||
| 6 | DB_WCOCOA | EKORG | |
|
REF | 1 | CN |
| 7 | DB_WCOCOA | ELIGIBLE_CUST | |
|
KEY | 1 | CN |
| 8 | DB_WCOCOA | ELIGIBLE_VENDOR | |
|
KEY | 1 | CN |
| 9 | DB_WCOCOA | RATE_TYPE | |
|
1 | CN | |
| 10 | DB_WCOCOA | SPART | |
|
REF | 1 | CN |
| 11 | DB_WCOCOA | VEND_OWNER | |
|
REF | 1 | CN |
| 12 | DB_WCOCOA | VKBUR | |
|
1 | CN | |
| 13 | DB_WCOCOA | VKGRP | |
|
1 | CN | |
| 14 | DB_WCOCOA | VKORG | |
|
REF | 1 | CN |
| 15 | DB_WCOCOA | VTWEG | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |