WBIT
Association Item at Step Level
WBIT is an SAP database table in S/4HANA. Association Item at Step Level. It contains 47 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_TrdgDocReltdAssocdItmBasic | view_entity | from | BASIC | Associated Item for Trading Document |
Fields (47)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | ruuid | WB2_DOC_REL_UUID | GTM Doc Rel UUID | |||
| doc_type | WB2_DOC_TYPE | Document Type | ||||
| doc_nr | WB2_DOCUMENT_NUMBER | Document | ||||
| doc_year | WB2_DOCUMENT_YEAR | General Doc Year | ||||
| doc_bukrs | WB2_DOCUMENT_BUKRS | General Doc CoCode | ||||
| item | WB2_N2M_ITEM | Item Number | ||||
| sub_item | WB2_N2M_SUB_ITEM | Subitem | ||||
| tew_type | WB2_TEW_TYPE | TEW Type | ||||
| bus_step | WB2_STEP | Step | ||||
| open_quan_flag | WB2_OPEN_QUAN_FLAG | Open Quantity? | ||||
| tkonn | TKONN | Trading Contract | ||||
| tposn | TPOSN | Item Number | ||||
| tposn_sub | TPOSN_SUB | Subitem | ||||
| portfolio | WB2_PORTFOLIO | Portfolio | ||||
| unit_of_quan | WB2_ASSO_UNIT | Association UoM | ||||
| base_side | WB2_SIDE | Side | ||||
| side | WB2_SIDE | Side | ||||
| matnr | MATNR | Material | ||||
| matkl | MATKL | Material Group | ||||
| own_quan | WB2_QUANTITY_DOC | Qty Curr. Doc. | ||||
| unit_doc | WB2_UNIT_DOC | Current Doc UoM | ||||
| progressed_quan | WB2_PROGRESSED_QUAN | Transferred Qty | ||||
| act_asso_quan | WB2_ASSOCIATED_QUAN | Assoc.Quantity | ||||
| completed_quan | WB2_COMPLETED_QUANTITY | Closed Quantity | ||||
| pos_quan_flag | WB2_POS_QUAN_FLAG | Item Quantity? | ||||
| pred_doc_type | WB2_DOC_TYPE | Document Type | ||||
| pred_doc_nr | WB2_DOC_NUMBER_FROM | Pred. Gen. Doc. | ||||
| pred_doc_year | WB2_DOC_YEAR_FROM | Pred. Gen. Doc. Year | ||||
| pred_doc_bukrs | WB2_DOC_BUKRS_FROM | Pred.Gen.Doc.CoCode | ||||
| pred_item | WB2_N2M_ITEM | Item Number | ||||
| pred_sub_item | WB2_N2M_SUB_ITEM | Subitem | ||||
| werks | WERKS_D | Plant | ||||
| lgort | LGORT_D | Location | ||||
| charg | CHARG_D | Batch | ||||
| complete | WB2_DOCUMENT_COMPLETE_2 | Item Closed | ||||
| send_compl | WB2_SEND_COMPLETION | Send Completion | ||||
| del_flag | WB2_DELETION_FLAG | Deletion ind. | ||||
| tkonn_ex | TKONN_EX | Ext. Identifier | ||||
| scenario | WB2_BUSINESS_SCENARIO | Scenario | ||||
| erdat | ERDAT | Created On | ||||
| erzet | ERZET | Time | ||||
| umz | WB2_UMZ | Qty Conv. | ||||
| umn | WB2_UMN | Qty Conv. Denomin. | ||||
| corrected_quan | WB2_CORRECTED_QUANTITY | Correction Qty | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| dummy_wbit_incl_eew_ps | WBIT_INCL_EEW | Dummy |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Association Item at Step Level
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WBIT (
MANDT, -- Client [MANDT]
RUUID, -- GTM Doc Rel UUID [WB2_DOC_REL_UUID]
DOC_TYPE, -- Document Type [WB2_DOC_TYPE]
DOC_NR, -- Document [WB2_DOCUMENT_NUMBER]
DOC_YEAR, -- General Doc Year [WB2_DOCUMENT_YEAR]
DOC_BUKRS, -- General Doc CoCode [WB2_DOCUMENT_BUKRS]
ITEM, -- Item Number [WB2_N2M_ITEM]
SUB_ITEM, -- Subitem [WB2_N2M_SUB_ITEM]
TEW_TYPE, -- TEW Type [WB2_TEW_TYPE]
BUS_STEP, -- Step [WB2_STEP]
OPEN_QUAN_FLAG, -- Open Quantity? [WB2_OPEN_QUAN_FLAG]
TKONN, -- Trading Contract [TKONN]
TPOSN, -- Item Number [TPOSN]
TPOSN_SUB, -- Subitem [TPOSN_SUB]
PORTFOLIO, -- Portfolio [WB2_PORTFOLIO]
UNIT_OF_QUAN, -- Association UoM [WB2_ASSO_UNIT]
BASE_SIDE, -- Side [WB2_SIDE]
SIDE, -- Side [WB2_SIDE]
MATNR, -- Material [MATNR]
MATKL, -- Material Group [MATKL]
OWN_QUAN, -- Qty Curr. Doc. [WB2_QUANTITY_DOC]
UNIT_DOC, -- Current Doc UoM [WB2_UNIT_DOC]
PROGRESSED_QUAN, -- Transferred Qty [WB2_PROGRESSED_QUAN]
ACT_ASSO_QUAN, -- Assoc.Quantity [WB2_ASSOCIATED_QUAN]
COMPLETED_QUAN, -- Closed Quantity [WB2_COMPLETED_QUANTITY]
POS_QUAN_FLAG, -- Item Quantity? [WB2_POS_QUAN_FLAG]
PRED_DOC_TYPE, -- Document Type [WB2_DOC_TYPE]
PRED_DOC_NR, -- Pred. Gen. Doc. [WB2_DOC_NUMBER_FROM]
PRED_DOC_YEAR, -- Pred. Gen. Doc. Year [WB2_DOC_YEAR_FROM]
PRED_DOC_BUKRS, -- Pred.Gen.Doc.CoCode [WB2_DOC_BUKRS_FROM]
PRED_ITEM, -- Item Number [WB2_N2M_ITEM]
PRED_SUB_ITEM, -- Subitem [WB2_N2M_SUB_ITEM]
WERKS, -- Plant [WERKS_D]
LGORT, -- Location [LGORT_D]
CHARG, -- Batch [CHARG_D]
COMPLETE, -- Item Closed [WB2_DOCUMENT_COMPLETE_2]
SEND_COMPL, -- Send Completion [WB2_SEND_COMPLETION]
DEL_FLAG, -- Deletion ind. [WB2_DELETION_FLAG]
TKONN_EX, -- Ext. Identifier [TKONN_EX]
SCENARIO, -- Scenario [WB2_BUSINESS_SCENARIO]
ERDAT, -- Created On [ERDAT]
ERZET, -- Time [ERZET]
UMZ, -- Qty Conv. [WB2_UMZ]
UMN, -- Qty Conv. Denomin. [WB2_UMN]
CORRECTED_QUAN, -- Correction Qty [WB2_CORRECTED_QUANTITY]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
DUMMY_WBIT_INCL_EEW_PS, -- Dummy [WBIT_INCL_EEW]
PRIMARY KEY (MANDT, RUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA