SAP WB2_D_ASSGMT Assignments Table
Overview
WB2_D_ASSGMT is a standard SAP S/4HANA table that stores Assignments data. There are total 25 fields in the WB2_D_ASSGMT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WB2_D_ASSGMT belongs to Global Trade (LO-GT) module and is located in the package Assignment management (WB2_ASSGMT).
In addition, following links provide an overview of foreign key relationships, if any, that link WB2_D_ASSGMT to other SAP tables and standard CDS views available based on WB2_D_ASSGMT table in S/4HANA 2020.
Techincal Settings of WB2_D_ASSGMT
Below are technical details of the table WB2_D_ASSGMT
- Buffering not allowed
- No buffering
- Storage type is Not Defined
List of WB2_D_ASSGMT Fields
The following table gives you an overview of the fields available in WB2_D_ASSGMT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | |
| TYPE_FROM | Document Category | WLF_SHADOW_DOC_TYPE | CHAR | 2 | |
| DOCUMENT_FROM | Document Number | WLF_GENERIC_DOC_NUM | CHAR | 32 | |
| ITEM_FROM | item number | WLF_GENERIC_ITEM_NUM | NUMC | 10 | |
| SIDE_FROM | Side of the Document with an Assignment | WLF_PR_SIDE_FROM | CHAR | 2 | |
| SUB_ITEM_FROM | Subitem Number | WLF_GENERIC_SUB_ITEM_NUM | NUMC | 6 | |
| TKONN | Trading Contract | TKONN | CHAR | 10 | |
| TPOSN | Item Number of Trading Contract | TPOSN | NUMC | 6 | |
| SIDE_TO | Side of the document which is assigned to | WLF_PR_SIDE_TO | CHAR | 2 | |
| TPOSN_COM | Commodity Subitem Number | WLF_TPOSN_COM | NUMC | 6 | |
| ASSGD_QUAN | Assigned Quantity | WLF_ASSGD_QUANTITY_IND | D34R | 34 | |
| ASSGD_QUAN_ORIG | Original Assigned Quantity | WLF_ASSGD_QUANTITY_ORIG | D34R | 34 | |
| ASSGD_UOM | UoM of the Assigned Quantity | WLF_ASSGD_UOM | T006 | UNIT | 3 |
| A_GUID | GUID of an assignment | WLF_ASSGMT_GUID | RAW | 16 | |
| PRED_A_GUID | GUID of a preceding assignment | WLF_PRED_ASSGMT_GUID | RAW | 16 | |
| PRED_QUAN | Quantity Transferred from a Preceding Assignment | WLF_PRED_ASSGD_QUANTITY | D34R | 34 | |
| FROZEN | Assignment is frozen | WLF_ASSGMT_FROZEN | CHAR | 1 | |
| 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 | AEZEIT | TIMS | 6 | |
| CANCEL_FLAG | Cancel | WLF_CANCEL | CHAR | 1 | |
| _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_ASSGMT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WB2_D_ASSGMT | ASSGD_UOM | : | T006 |