SAP WB2_D_STRING Logistical string,circle and washout Table
Overview
WB2_D_STRING is a standard SAP S/4HANA table that stores Logistical string,circle and washout data. There are total 24 fields in the WB2_D_STRING table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WB2_D_STRING belongs to Trading Contract (LO-GT-TC) module and is located in the package Strings and Circles (WB2_STRING_CIRCLE).
In addition, following links provide an overview of foreign key relationships, if any, that link WB2_D_STRING to other SAP tables and standard CDS views available based on WB2_D_STRING table in S/4HANA 2020.
Techincal Settings of WB2_D_STRING
Below are technical details of the table WB2_D_STRING
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WB2_D_STRING Fields
The following table gives you an overview of the fields available in WB2_D_STRING
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| TKONN | Trading Contract | TKONN | WBHK | CHAR | 10 |
| GUID | GUID | WB2_GUID | RAW | 16 | |
| STRING_ORDER | Order of items in string or circle | WB2_STRING_ORDER | NUMC | 6 | |
| FLAG_FIRST | Start of a Logistical String | WB2_STRING_START | CHAR | 1 | |
| VENDOR | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| CUSTOMER | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| NETPR | Price | WB2_NETPR | CURR | 11 | |
| CURR | Currency | WB2_STR_WAERS | TCURC | CUKY | 5 |
| PRICING_UNIT | Price pricing unit | WB2_PEINH | DEC | 5 | |
| COND_UNIT | Condition unit | WB2_KMEIN | T006 | UNIT | 3 |
| TRADER_ROLE | Trader's Role | WB2_TRADER_ROLE | CHAR | 1 | |
| TKONN_MM | Referenced purchase sided TC | WB2_TKONN_MM | WBHK | CHAR | 10 |
| TPOSN_MM | Item number of referenced purchase sided TC item | WB2_TPOSN_MM | WBHI | NUMC | 6 |
| TKONN_SD | Referenced sales sided TC | WB2_TKONN_SD | WBHK | CHAR | 10 |
| TPOSN_SD | Item number of referenced sales sided TC item | WB2_TPOSN_SD | WBHI | NUMC | 6 |
| QUANTITY | Open Quantity | WB2_NOT_REF_QUAN | QUAN | 15 | |
| QUANTITY_UNIT | Open Quantity Unit | WB2_NOT_REF_QUAN_UNIT | UNIT | 3 | |
| WASHED_QUAN | Washed out quantity in a string or circle | WB2_WASHED_QUAN | QUAN | 15 | |
| WASHED_QUAN_UNIT | Unit of Measure for Washout Quantity | WB2_WASHED_QUAN_UNIT | UNIT | 3 | |
| FROZEN | Element is frozen | WB2_FROZEN | CHAR | 1 | |
| ASSIG_CUST | Customer that is assigned to a supplier | WB2_ASSIGNED_CUST | CHAR | 10 | |
| ASSIG_VEND | Supplier that is assigend to a customer | WB2_ASSIGNED_VEND | CHAR | 10 | |
| _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_STRING
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WB2_D_STRING | CLIENT | 1: CN | T000 |
| WB2_D_STRING | COND_UNIT | 1: CN | T006 |
| WB2_D_STRING | CURR | 1: CN | TCURC |
| WB2_D_STRING | CUSTOMER | 1: CN | KNA1 |
| WB2_D_STRING | TKONN | 1: CN | WBHK |
| WB2_D_STRING | TKONN_MM | 1: CN | WBHK |
| WB2_D_STRING | TKONN_SD | 1: CN | WBHK |
| WB2_D_STRING | TPOSN_MM | 1: CN | WBHI |
| WB2_D_STRING | TPOSN_SD | 1: CN | WBHI |
| WB2_D_STRING | VENDOR | 1: CN | LFA1 |