SAP WBASSOC Global Trade: Association Table Table
Overview
WBASSOC is a standard SAP S/4HANA table that stores Global Trade: Association Table data. There are total 49 fields in the WBASSOC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBASSOC belongs to Position Management (LO-GT-PM) module and is located in the package Trading Contract: Positiion Management (WB2BPOSTYPMNGT).
In addition, following links provide an overview of foreign key relationships, if any, that link WBASSOC to other SAP tables and standard CDS views available based on WBASSOC table in S/4HANA 2020.
Techincal Settings of WBASSOC
Below are technical details of the table WBASSOC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WBASSOC Fields
The following table gives you an overview of the fields available in WBASSOC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RUUID | Unique Document Relationship Identification in GTM | WB2_DOC_REL_UUID | RAW | 16 | |
| TEW_TYPE | Trading Execution Workbench Type | WB2_TEW_TYPE | TEWTYPE | CHAR | 4 |
| ASSOC_STEP_FROM | Process Step That Contains An Association | WB2_ASSOC_STEP_FROM | TEWSTEP | CHAR | 4 |
| RDOC_NR | Number of Document to Which Doc. is Assigned | WB2_RECEIVING_DOC_NR | CHAR | 10 | |
| RDOC_YEAR | Year of Receiving Document in Global Trade Management | WB2_RECEIVING_DOC_YEAR | NUMC | 4 | |
| RDOC_BUKRS | Company Code of Receiving Document in GTM | WB2_RECEIVING_DOC_BUKRS | CHAR | 4 | |
| RPOSNR | Item No. of Document to Which Doc.is Assigned | WB2_RECEIVING_POSNR | NUMC | 10 | |
| RPOSNR_SUB | Sub-Item No. of Doc. to Which Doc. is Assigned | WB2_RECEIVING_POSNR_SUB | NUMC | 6 | |
| ASSOC_STEP_TO | Process Step That is Associated | WB2_ASSOC_STEP_TO | TEWSTEP | CHAR | 4 |
| ADOC_NR | Number of a Document that is Assigned | WB2_ASSOCIATED_DOC_NR | CHAR | 10 | |
| ADOC_YEAR | Year of Assigned Document in Global Trade Management | WB2_ASSOCIATED_DOC_YEAR | NUMC | 4 | |
| ADOC_BUKRS | Company Code of Assigned Document in Global Trade Management | WB2_ASSOCIATED_DOC_BUKRS | CHAR | 4 | |
| APOSNR | Item No. of a Doc. that is Assigned to a Doc. | WB2_ASSOCIATED_POSNR | NUMC | 10 | |
| APOSNR_SUB | Sub-Item No. of Doc. That is Assigned to Doc. | WB2_ASSOCIATED_POSNR_SUB | NUMC | 6 | |
| REC_BASE | Basis for Receiving Document | WB2_RECEIVING_BASE | CHAR | 2 | |
| BAS_DOCTYPE_REC | Document Type | WB2_DOC_TYPE | CHAR | 2 | |
| BAS_DOCNR_REC | Base Document Receiving Associations | WB2_BASE_DOCUMENT_RECEIVING | CHAR | 10 | |
| BAS_ITEM_REC | Item Number in Base Document | WB2_BASE_ITEM | NUMC | 6 | |
| BAS_S_ITEM_REC | Sub-Item Number in Base Document | WB2_BASE_SUB_ITEM | NUMC | 6 | |
| PORTFOLIO_REC | Portfolio Number(Internal) | WB2_PORTFOLIO | KONHM | CHAR | 10 |
| RMATNR | Material Number | MATNR | MARA | CHAR | 40 |
| BAS_DOCTYPE_ASSO | Document Type | WB2_DOC_TYPE | CHAR | 2 | |
| BAS_DOCNR_ASSO | Base Document That is Associated | WB2_BASE_DOCUMENT_ASSOCIATED | CHAR | 10 | |
| BAS_ITEM_ASSO | Item Number in Base Document | WB2_BASE_ITEM | NUMC | 6 | |
| BAS_S_ITEM_ASSO | Sub-Item Number in Base Document | WB2_BASE_SUB_ITEM | NUMC | 6 | |
| PORTFOLIO_ASSOC | Portfolio Number(Internal) | WB2_PORTFOLIO | KONHM | CHAR | 10 |
| AMATNR | Material Number | MATNR | MARA | CHAR | 40 |
| UNIT_OF_QUAN | Association Unit of Measure | WB2_ASSO_UNIT | T006 | UNIT | 3 |
| ASSOC_QUAN_ORIG | Originally Associated Quantity of an Item | WB2_ASSOC_QUAN_ORIG | QUAN | 15 | |
| ASSOC_QUAN | Actually Associated Quantity of an Item | WB2_ASSOCIATED_QUAN | QUAN | 15 | |
| LOCKED_QUAN | Locked Quantity | WB2_LOCKED_QUAN | QUAN | 15 | |
| LOCK_FLAG | Flag for Locked Quantity | WB2_LOCK_FLAG | CHAR | 1 | |
| LOCK_REASON | Lock Reason | WB2_ASS_LOCK_REASON | CHAR | 4 | |
| COMPLETED | Indicates Whether Asc.Qty is Transferred inFull | WB2_ASSOC_TRANSFER_COMPLETED | CHAR | 1 | |
| DOC_TYPE_FROM | Document Category Receiving Association | WB2_ASSOC_DOC_TYPE_FROM | CHAR | 2 | |
| DOC_TYPE_TO | Document Category That Is Associated | WB2_ASSOC_DOC_TYPE_TO | CHAR | 2 | |
| STATUS | Association Status Only Needed Internally | WB2_ASSO_STATUS | CHAR | 1 | |
| CHARG_ASSO | Batch Number of Associated Item | WB2_ASSO_CHARG | CHAR | 10 | |
| CHARG_REC | Batch Number of Item Receiving Association | WB2_REC_CHARG | CHAR | 10 | |
| PRED_STEP_FROM | Process Step That Contains An Association | WB2_ASSOC_STEP_FROM | CHAR | 4 | |
| PRED_STEP_TO | Process Step That is Associated | WB2_ASSOC_STEP_TO | CHAR | 4 | |
| PRED_QUAN_FROM | Quantity Transferred from Preceding Association | WB2_TRANSFERRED_QUANTITY | QUAN | 15 | |
| PRED_QUAN_TO | Quantity Transferred from Preceding Association | WB2_TRANSFERRED_QUANTITY | QUAN | 15 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| IGNORE_ASSO | Ignore Active Association Quantity? | WB2_IGNORE_ACTIVE_ASSOC_QUAN | CHAR | 1 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| DUMMY_WBASSOC_INCL_EEW_PS | Dummy Data Element for Association Table Extensibility | WBASSOC_INCL_EEW | CHAR | 1 |
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 WBASSOC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBASSOC | AMATNR | 1: CN | MARA |
| WBASSOC | ASSOC_STEP_FROM | 1: CN | TEWSTEP |
| WBASSOC | ASSOC_STEP_TO | 1: CN | TEWSTEP |
| WBASSOC | MANDT | 1: CN | T000 |
| WBASSOC | PORTFOLIO_ASSOC | 1: CN | KONHM |
| WBASSOC | PORTFOLIO_REC | 1: CN | KONHM |
| WBASSOC | RMATNR | 1: CN | MARA |
| WBASSOC | TEW_TYPE | 1: CN | TEWTYPE |
| WBASSOC | UNIT_OF_QUAN | 1: CN | T006 |