SAP WB2_D_COMSUB Trading Contract: commodity sub items Table
Overview
WB2_D_COMSUB is a standard SAP S/4HANA table that stores Trading Contract: commodity sub items data. There are total 31 fields in the WB2_D_COMSUB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WB2_D_COMSUB belongs to Global Trade (LO-GT) module and is located in the package commodity items and pricing aspects (WB2_COMMODITY_ITEM).
In addition, following links provide an overview of foreign key relationships, if any, that link WB2_D_COMSUB to other SAP tables and standard CDS views available based on WB2_D_COMSUB table in S/4HANA 2020.
Techincal Settings of WB2_D_COMSUB
Below are technical details of the table WB2_D_COMSUB
- Buffering not allowed
- No buffering
- Storage type is Not Defined
List of WB2_D_COMSUB Fields
The following table gives you an overview of the fields available in WB2_D_COMSUB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| TKONN | Trading Contract | TKONN | CHAR | 10 | |
| TPOSN | Item Number of Trading Contract | TPOSN | * | NUMC | 6 |
| SIDE | Side | WLF_PR_SIDE | CHAR | 2 | |
| TPOSN_COM | Commodity Subitem Number | WLF_TPOSN_COM | NUMC | 6 | |
| QUANTITY | Commodity Item Quantity | WLF_ITEM_QUANTITY | D34R | 34 | |
| UNIT | Unit | WLF_UNIT | * | UNIT | 3 |
| DATE_FROM | Date From | WLF_DATE_FROM | DATS | 8 | |
| DATE_TO | Date To | WLF_DATE_TO | DATS | 8 | |
| FUTURE | Future | WLF_FUTURE | CHAR | 20 | |
| COM_GUID | commodity GUID | WLF_COM_GUID | RAW | 16 | |
| CR_NAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| CR_DATE | Date on which the record was created | ERDAT | DATS | 8 | |
| CR_TIME | Time at Which Record Was Added | WLF_ERZEIT | TIMS | 6 | |
| CH_NAME | Name of person who changed object | AENAM | CHAR | 12 | |
| CH_DATE | Date of Last Change | AEDAT | DATS | 8 | |
| CH_TIME | Time of Change | WLF_AEZEIT | TIMS | 6 | |
| IT_CLOSED | Item Closed | WLF_ITEM_CLOSED | CHAR | 1 | |
| COM_CAT | Commodity Item Category | WLF_COM_ITEM_CAT | CHAR | 4 | |
| NUMERATOR | Numerator Conversion Factor | WB2_UMZ | DEC | 5 | |
| DENOMINATOR | Denominator Conversion Factor | WB2_UMN | DEC | 5 | |
| ASSGMT_REL | Assignment Relevant | WLF_ASSGMT_REL | CHAR | 1 | |
| HKPSTP | Item Category | HKPSTP | TB2BJ | CHAR | 4 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| BASIS_MEINS | Base Unit of Measure | MEINS | * | UNIT | 3 |
| VENDOR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| CUSTOMER | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| BATCH | Batch Number | CHARG_D | * | CHAR | 10 |
| EXT_REF | External Identifier for Commodity Item | WLF_EXT_IDENTIFIER_COM | CHAR | 10 | |
| COM_ITEM_PROP | Special Commodity property | WB2_COM_ITEM_PROPERTY | RAW | 2 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WB2_D_COMSUB
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WB2_D_COMSUB | CLIENT | : | T000 |
| WB2_D_COMSUB | CUSTOMER | : | KNA1 |
| WB2_D_COMSUB | HKPSTP | 1: CN | TB2BJ |
| WB2_D_COMSUB | MATNR | : | MARA |
| WB2_D_COMSUB | TKONN | : | * |
| WB2_D_COMSUB | TPOSN | : | * |
| WB2_D_COMSUB | VENDOR | : | LFA1 |