WBRP
Settlement Management Document Item
WBRP is an SAP database table in S/4HANA. Settlement Management Document Item. It contains 233 fields. 12 CDS views read from this table.
CDS Views using this table (12)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_AgbuItemQty | view | from | Settlement Management Item Quantity | |
| E_SettlmtMgmtDocItem | view_entity | from | EXTENSION | Settlmt Mgmt Doc Item Extension |
| I_CmmdtyExpnSuplrBillgDocument | view_entity | inner | BASIC | Commodity Supplier Billing Document |
| I_SettlmtMgmtDocItem | view | from | BASIC | Settlement Management Document Item |
| P_SettlDocItemAddInfo1 | view | from | BASIC | |
| P_SettlmtMgmtDocItem | view | from | BASIC | |
| P_WBRP_ValueHelp | view | from | BASIC | |
| V_WB2_WBRK_WBRP_0_1 | view | inner | Business Volume Settlement Doc Supplier | |
| V_WB2_WBRK_WBRP_0_2 | view | inner | Business Volume Settlement Doc Customer | |
| view_ab_items_p | view | from | Item Related Data of Settlement Management Document | |
| view_ab_lts | view | from | Supplier Subrange of an Settlement Management Item | |
| WB2_WBRP_PRCD_ELM_PART_SETTK | view | from | Settlmt Items with KSCHL in WB2_C_PART_SETTK |
Fields (233)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | wbeln | WBELN_AG | Document Number | |||
| KEY | posnr | WPOSNR_LF | Item | |||
| matnr | MATNR | Material | ||||
| matkl | MATKL | Material Group | ||||
| werks | WERKS_D | Plant | ||||
| mwskz | MWSKZ_LF | Input Tax Code | ||||
| mwsk2 | MWSKZ_RB | Output Tax Code | ||||
| prsdt | PRSDT | Pricing Date | ||||
| menge | WFIMG | SettlmtQuantity | ||||
| netpr | WNETPR | Net Price | ||||
| peinh | WEINH | Price Unit | ||||
| wfkme | WFKME | Settlement Unit | ||||
| umrez | UMWFZ | Corresponds to | ||||
| umren | UMWFN | Denominator | ||||
| fprme | WFPRME | SettlmtPrcUnit | ||||
| fpumz | WPUMZ | Qty Conversion | ||||
| fpumn | WPUMN | Qty Conversion | ||||
| meins | MEINS | Base Unit | ||||
| ntgew | WLF_NTGEW_15 | Net Weight | ||||
| brgew | WLF_BRGEW_15 | Gross Weight | ||||
| gewei | GEWEI | Unit of Weight | ||||
| volum | WLF_VOLUM_15 | Volume | ||||
| voleh | VOLEH | Volume Unit | ||||
| stafo | STAFO | Update Group | ||||
| mtart | MTART | Material Type | ||||
| netwr | NETWR_LFP | Net Amount | ||||
| brtwr | BRTWR_LFP | Gross Amount | ||||
| kzwi1 | KZWI1 | Subtotal 1 | ||||
| kzwi2 | KZWI2 | Subtotal 2 | ||||
| kzwi3 | KZWI3 | Subtotal 3 | ||||
| kzwi4 | KZWI4 | Subtotal 4 | ||||
| kzwi5 | KZWI5 | Subtotal 5 | ||||
| kzwi6 | KZWI6 | Subtotal 6 | ||||
| bonba | BONBA | Rebate Basis | ||||
| effwr | WLF_EFFWR | Effective Amnt | ||||
| ernam | ERNAM | Created By | ||||
| erdat | ERDAT | Created On | ||||
| erzet | ERZET | Time | ||||
| kowrr | WKOWRR | Item Control | ||||
| sktof | SKTOF | Cash Discount | ||||
| skfbp | SKFBP | Csh.Disc.Bas | ||||
| netwrd | NETWRD_LFP | Net Amount | ||||
| brtwrd | BRTWRD_LFP | Gross Amount | ||||
| kzwi1d | KZWI1 | Subtotal 1 | ||||
| kzwi2d | KZWI2 | Subtotal 2 | ||||
| kzwi3d | KZWI3 | Subtotal 3 | ||||
| kzwi4d | KZWI4 | Subtotal 4 | ||||
| kzwi5d | KZWI5 | Subtotal 5 | ||||
| kzwi6d | KZWI6 | Subtotal 6 | ||||
| bonbad | BONBA | Rebate Basis | ||||
| skfbpd | SKFBPD | Cash Disc. Base | ||||
| effwrd | EFFWRD | Effective Value | ||||
| mwsbpd | MWSBPD | Tax Amount | ||||
| wbelnv | WBELNV | Source Doc. | ||||
| posnrv | WPOSNRV | SourceDocItem | ||||
| lftypv | WFTYPV | SourceDocCat | ||||
| gjahrv | GJAHR | Fiscal Year | ||||
| aktnr | WAKTION | Promotion | ||||
| lfgru | WFGRU | Activity Reason | ||||
| arktx | TXZ01 | Short Text | ||||
| infnr | INFNR | Info Record | ||||
| idnlf | IDNLF | Supp. Mat. No. | ||||
| mwsbp | MWSBP | Tax Amount | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| ebonf | EBONY | Settlement | ||||
| bonus | EBONU | Sett. Group 1 | ||||
| ebon2 | EBON2 | Sett. Group 2 | ||||
| ebon3 | EBON3 | Sett. Group 3 | ||||
| ltsnr | LTSNR | Suppl. Subrange | ||||
| ekkol | EKKOG | Condition Group | ||||
| punei | PUNEI | Points Unit | ||||
| anzpu | ANZPU | Points | ||||
| kolif | KOLIF | Prior Supplier | ||||
| navnw | NAVNW | Non-deductible | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| bwtty | BWTTY_D | Valuation Cat. | ||||
| gsber | GSBER | Business Area | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| kostl | KOSTL | Cost Center | ||||
| prctr | PRCTR | Profit Center | ||||
| kokrs | KOKRS | CO Area | ||||
| charg | CHARG_D | Batch | ||||
| wuvprs | WUVPRS | Incomp. Pricing | ||||
| wbeln_v | WBELN_V | Pre. Document | ||||
| posnr_v | POSNR_V | Preceding Item | ||||
| ftypv_v | WFTYP_V | PreDocCat | ||||
| itemcat | WSHKZG | Item Category | ||||
| matbf | MATBF | Stock Mat. | ||||
| mwert_im | WLF_MWERT_IM | Inventory Value | ||||
| mwert_pr | WLF_MWERT_PR | Price Difference Value | ||||
| mwert_um | WLF_MWERT_UM | Revaluation Value | ||||
| contract | WCONTRACT | Contract | ||||
| contract_type | WCONTRACT_TYPE | Contract Cat. | ||||
| contract_item | WCONTRACT_ITEM | Item | ||||
| idnlf_type | WLF_IDNLF_TYPE | ID ObjType Mat. | ||||
| item_status | WLF_ITEM_STATUS | Status | ||||
| item_canceled | WLF_ITEM_CANCELED | Item Canceled | ||||
| guid_ref | WLF_GUID_REFERENCE | Reference GUID | ||||
| bemot | BEMOT | AcctIndicator | ||||
| aufnr | AUFNR | Order | ||||
| settl_status_i_v | WLF_SETTLEMENT_STATUS_ITEM_V | Sttlmnt Sts Itm Sup. | ||||
| settl_status_i_c | WLF_SETTLEMENT_STATUS_ITEM_C | Settlmt StatusItemCu | ||||
| settl_block_i_v | WLF_SETTLEMENT_BLOCK_ITEM_V | Supplier Settlement Item Blocking Reason | ||||
| settl_block_i_c | WLF_SETTLEMENT_BLOCK_ITEM_C | Customer Settlement Item Blocking Reason | ||||
| settl_item_rel | WLF_SETTLEMENT_ITEM_RELEVANCE | Itm Sttlm Relevance | ||||
| cuobj | CUOBJ_VA | Configuration | ||||
| fbuda | WLF_FBUDA | Services Rendered Date | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| entity_tag_item | WLF_ENTITY_TAG_ITEM | Item Entity Tag | ||||
| dummy_wbrp_incl_eew_ps | WBRP_INCL_EEW | Dummy | ||||
| j_1bnbm | J_1BNBMCO1 | NCM Code | ||||
| j_1bmatuse | J_1BMATUSE | Material Usage | ||||
| j_1bmatorg | J_1BMATORG | Material Origin | ||||
| j_1bownpro | J_1BOWNPRO | Prod. in-house | ||||
| j_1bindust | J_1BINDUS3 | Mat. category | ||||
| j_1bcfop | J_1BCFOP | CFOP | ||||
| j_1btxsdc | J_1BTXSDC_ | Tax Code | ||||
| j_1btaxlw1 | J_1BTAXLW1 | ICMS Law | ||||
| j_1btaxlw2 | J_1BTAXLW2 | IPI Law | ||||
| j_1btaxlw3 | J_1BTAXLW3 | ISS Law | ||||
| j_1btaxlw4 | J_1BTAXLW4 | COFINS Law | ||||
| j_1btaxlw5 | J_1BTAXLW5 | PIS Law | ||||
| sakto | SAKNR | G/L Account | ||||
| saknr_inp | WLF_SAKNR_INP | G/L Acc. Supplier | ||||
| saknrd_inp | WLF_SAKNRD_INP | G/L Acc. Customer | ||||
| servconf_item | FSL_SERVCONF_ITEM | Conf. Item | ||||
| status | FSL_STATUS | Status | ||||
| iv_check_type_i | WLF_IV_CHECK_TYPE_ITEM | Check Type (Pos.) | ||||
| refsite | WREFSITE | Purchasing Ref. Site | ||||
| gjahr | WB2_CCS_GJAHR | Fiscal Year Settlmnt | ||||
| mwskz_bv | WB2_MWSKZ_BV | Tax Code BusVol | ||||
| settl_date_i | WB2_SETTLEMENT_DATE | Settlement Date | ||||
| settl_date_seq_id_i | WB2_SETTLEMENT_DATE_SEQ_ID | Settlement Date ID | ||||
| waers_bv | WB2_WAERS_BV | Currency BusVol. | ||||
| txdat_from_bv | WB2_TXDAT_FROM_BV | Tax Rate Valid-From | ||||
| contr_type_i | WCB_CONTRACT_TYPE | Contract Type | ||||
| process_variant_i | WCB_PROCESS_VARIANT | Process Variant | ||||
| ref_settl_date_i | WB2_REF_SETTLEMENT_DATE | Reference Date | ||||
| settl_date_type_i | WB2_SETTLEMENT_DATE_TYPE | Settlement Date Type | ||||
| act_settl_date_i | WB2_ACTUAL_SETTLEMENT_DATE | Actual Settl. Date | ||||
| settl_start_date_i | WB2_SETTLEMENT_START_DATE | Start Date of Period | ||||
| kschl_settlement | WB2_KSCHL_SETTLEMENT | Settlement Cond.Type | ||||
| settl_variant_i | WB2_SETTLEMENT_VARIANT | Settlement Variant | ||||
| settl_doc_item_type | WB2_SETTL_DOC_ITEM_TYPE | Item Type | ||||
| posnr_main | WLF_POSNR_MAIN | Main Item | ||||
| posnr_sub_exist | WLF_POSNR_SUB_EXIST | Subitems | ||||
| distrib_status | WLF_DISTRIBUTION_STATUS | Distributn Status | ||||
| no_text_i | WLF_NO_TEXT | No Texts Exist | ||||
| cwm_menge | WLF_CWM_MENGE | Qty in PUoM | ||||
| cwm_meins | WLF_CWM_MEINS | Parallel UoM | ||||
| cwm_uom_type | WLF_CWM_UOM_TYPE | PUoM Type | ||||
| ref_doc_nr_1 | WLF_REF_DOC_NUMBER | Settlmt. Ref. Doc. | ||||
| ref_doc_year_1 | WLF_REF_DOC_YEAR | SM Ref Doc Year | ||||
| ref_log_sys_1 | WLF_REF_LOG_SYS | SM Ref Log Sys | ||||
| ref_item_number | WLF_REF_ITEM_NUMBER | SettlmtRefDocItem | ||||
| ref_type | WLF_REF_TYPE | SettlmtRefDocCat | ||||
| ref_company_code_1 | WLF_REF_COMPANY_CODE | Ref. Company Code | ||||
| ref_doc_type_1 | WLF_REF_DOC_TYPE | Settlement Reference Document Type | ||||
| item_intra_rel | WLF_ITEM_INTRASTAT_RELEVANT | Intrastat Relev | ||||
| grwrt | GRWRT | Statist. Value | ||||
| grwrtd | GRWRTD | Stat.Value Cust | ||||
| posting_rule_k_i | WLF_POSTING_RULE_K_ITEM | Creditor Postg Rule | ||||
| posting_rule_d_i | WLF_POSTING_RULE_D_ITEM | Debtor Posting Rule | ||||
| weight_volume | WLF_WEIGHT_VOLUME_LEVEL | Weight/Volume | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| t2ccode_crcy_conv_factor_k | WLF_T2CCODE_CRCY_CONV_FACTOR | Exchange Factor for Tax in LC (Supplier) | ||||
| t2cntry_crcy_conv_factor_k | WLF_T2CNTRY_CRCY_CONV_FACTOR | Exchange Factor for Tax in RC (Supplier) | ||||
| t2ccode_crcy_conv_factor_d | WLF_T2CCODE_CRCY_CONV_FACTOR_D | Exchange Factor for Tax in LC (Customer) | ||||
| t2cntry_crcy_conv_factor_d | WLF_T2CNTRY_CRCY_CONV_FACTOR_D | Exchange Factor for Tax in RC (Customer) | ||||
| inco1_p | INCO1 | Incoterms | ||||
| inco2_p | INCO2 | Incoterms 2 | ||||
| incov_p | INCOV | Inco. Version | ||||
| inco2_l_p | INCO2_L | Inco. Location1 | ||||
| inco3_l_p | INCO3_L | Inco. Location2 | ||||
| kokrsd | WLF_KOKRS_CUSTOMER | Customer Ctrl Area | ||||
| prctrd | WLF_PRCTR_CUSTOMER | Cust. Profit Center | ||||
| kostld | WLF_KOSTL_CUSTOMER | Cust Cost Ctr | ||||
| paobjnrd | WLF_PAOBJNR_CUSTOMER | Profit. Segment | ||||
| aufnrd | WLF_AUFNR_CUSTOMER | Customer Order | ||||
| ps_psp_pnrd | WLF_PS_PSP_PNR_CUSTOMER | Customer WBS Element | ||||
| gsberd | WLF_GSBER_CUSTOMER | Cust. Business Area | ||||
| coll_status_i | WLF_COLLECTION_STATUS_ITEM | Collective Settlement Status Item | ||||
| coll_block_i | WLF_COLLECTION_BLOCK_ITEM | Collective Settlement Item Block Reason | ||||
| coll_rel | WLF_COLLECTION_RELEVANCE | Collective Settlement Relevance | ||||
| customer | WLF_CUSTOMER | Customer | ||||
| mvgr1 | MVGR1 | MaterialGroup 1 | ||||
| mvgr2 | MVGR2 | MaterialGroup 2 | ||||
| mvgr3 | MVGR3 | MaterialGroup 3 | ||||
| mvgr4 | MVGR4 | MaterialGroup 4 | ||||
| mvgr5 | MVGR5 | MaterialGroup 5 | ||||
| prodh | PRODH_D | Prod. Hierarchy | ||||
| dispute_case | WLF_DISPUTE_CASE_GUID | Dispute Case GUID | ||||
| txdat_from_k | WLF_FOT_TXDAT_FROM_K | Supplier Tax Rate Valid-From | ||||
| txdat_from_d | WLF_FOT_TXDAT_FROM_D | Customer Tax Rate Valid-From | ||||
| vkorg_i | WLF_VKORG_ITEM | Sales Org. | ||||
| vtweg_i | WLF_VTWEG_ITEM | Distr. Channel | ||||
| spart_i | WLF_SPART_ITEM | Division | ||||
| provg | PROVG | Commission Grp | ||||
| kondm | KONDM | Mat. Price Grp | ||||
| rebate_grp | WLF_REBATE_GRP_SLS | Volume Rebate Group | ||||
| bupla | BUPLA | Business place | ||||
| bupla_ic | WLF_BUPLA_IC | Business Place Intercompany | ||||
| tax_country | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| tax_country_ic | WLF_FOT_TAX_COUNTRY | Tax Ctry/Reg. Intercompany | ||||
| txjcd_ic | WLF_TXJCD_IC | Tax Jur Intercompany | ||||
| ref_menge | WLF_REFERENCE_QUANTITY | Reference Quantity | ||||
| ref_wfkme | WLF_REFERENCE_QUANTITY_UNIT | Ref. Quantity Unit | ||||
| landtx_i | WLF_D_LANDTX | Tx Dep Ctry/Reg | ||||
| land1tx_i | WLF_D_LAND1TX | Tx Des Ctry/Reg | ||||
| stceg_i | WLF_SUPLR_STCEG | Supp.VATReg.No. | ||||
| stcegd_i | WLF_CUST_STCEG | Cust.VATReg.No. | ||||
| bukrs_i | WLF_BUKRS_ITEM | Company Code | ||||
| spart_product | WLF_PRODUCT_SPART | Product Division | ||||
| prodh_univ_sales_parnt_nodid | PRODUCTHIERARCHYNODEID | Product Hierarchy Node ID | ||||
| prodh_univ_sales_det_origin | SD_PRODH_DET_ORIGIN | Rlvt Date for Det. | ||||
| dep_country_intra | WLF_DEP_COUNTRY_INTRASTAT | Departure Country | ||||
| dest_country_intra | WLF_DEST_COUNTRY_INTRASTAT | Destination Country | ||||
| invc_item_id | WLF_BTD_ITEM_ID | Ext. Inv. Item | ||||
| reference_id | WLF_REF_ID | Item Ref. Doc. | ||||
| ref_item_id | WLF_REF_ITEM_ID | Item RefItemID | ||||
| scheme_id | WLF_SCHEME_ID | Scheme | ||||
| scheme_a_id | WLF_SCHEME_A_ID | Scheme ID | ||||
| agency_id_code | WLF_AGENCY_ID_CODE | Agency ID | ||||
| j_1tpbupl | BCODE | Branch Code | ||||
| j_1tpbupl_d | WLF_BCODE | Branch Code (Customer) | ||||
| ref_doc_nr_2 | WLF_REF_DOC_NUMBER_2 | SettlmtAddlRefDoc | ||||
| ref_doc_year_2 | WLF_REF_DOC_YEAR_2 | Add. Ref. Doc. Year | ||||
| ref_log_sys_2 | WLF_REF_LOG_SYS_2 | SM Addl Ref Log Sys | ||||
| ref_item_num_2 | WLF_REF_ITEM_NUMBER_2 | SettlmtAddlRefDocItm | ||||
| ref_type_2 | WLF_REF_TYPE_2 | SettlmtAddlRefDocCat | ||||
| ref_doc_type_2 | WLF_REF_DOC_TYPE_2 | Additional Reference Doc Type in Settlmt | ||||
| ref_company_code_2 | WLF_REF_COMPANY_CODE_2 | Company Code of Add. Reference Document |
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.
-- Settlement Management Document Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WBRP (
MANDT, -- Client [MANDT]
WBELN, -- Document Number [WBELN_AG]
POSNR, -- Item [WPOSNR_LF]
MATNR, -- Material [MATNR]
MATKL, -- Material Group [MATKL]
WERKS, -- Plant [WERKS_D]
MWSKZ, -- Input Tax Code [MWSKZ_LF]
MWSK2, -- Output Tax Code [MWSKZ_RB]
PRSDT, -- Pricing Date [PRSDT]
MENGE, -- SettlmtQuantity [WFIMG]
NETPR, -- Net Price [WNETPR]
PEINH, -- Price Unit [WEINH]
WFKME, -- Settlement Unit [WFKME]
UMREZ, -- Corresponds to [UMWFZ]
UMREN, -- Denominator [UMWFN]
FPRME, -- SettlmtPrcUnit [WFPRME]
FPUMZ, -- Qty Conversion [WPUMZ]
FPUMN, -- Qty Conversion [WPUMN]
MEINS, -- Base Unit [MEINS]
NTGEW, -- Net Weight [WLF_NTGEW_15]
BRGEW, -- Gross Weight [WLF_BRGEW_15]
GEWEI, -- Unit of Weight [GEWEI]
VOLUM, -- Volume [WLF_VOLUM_15]
VOLEH, -- Volume Unit [VOLEH]
STAFO, -- Update Group [STAFO]
MTART, -- Material Type [MTART]
NETWR, -- Net Amount [NETWR_LFP]
BRTWR, -- Gross Amount [BRTWR_LFP]
KZWI1, -- Subtotal 1 [KZWI1]
KZWI2, -- Subtotal 2 [KZWI2]
KZWI3, -- Subtotal 3 [KZWI3]
KZWI4, -- Subtotal 4 [KZWI4]
KZWI5, -- Subtotal 5 [KZWI5]
KZWI6, -- Subtotal 6 [KZWI6]
BONBA, -- Rebate Basis [BONBA]
EFFWR, -- Effective Amnt [WLF_EFFWR]
ERNAM, -- Created By [ERNAM]
ERDAT, -- Created On [ERDAT]
ERZET, -- Time [ERZET]
KOWRR, -- Item Control [WKOWRR]
SKTOF, -- Cash Discount [SKTOF]
SKFBP, -- Csh.Disc.Bas [SKFBP]
NETWRD, -- Net Amount [NETWRD_LFP]
BRTWRD, -- Gross Amount [BRTWRD_LFP]
KZWI1D, -- Subtotal 1 [KZWI1]
KZWI2D, -- Subtotal 2 [KZWI2]
KZWI3D, -- Subtotal 3 [KZWI3]
KZWI4D, -- Subtotal 4 [KZWI4]
KZWI5D, -- Subtotal 5 [KZWI5]
KZWI6D, -- Subtotal 6 [KZWI6]
BONBAD, -- Rebate Basis [BONBA]
SKFBPD, -- Cash Disc. Base [SKFBPD]
EFFWRD, -- Effective Value [EFFWRD]
MWSBPD, -- Tax Amount [MWSBPD]
WBELNV, -- Source Doc. [WBELNV]
POSNRV, -- SourceDocItem [WPOSNRV]
LFTYPV, -- SourceDocCat [WFTYPV]
GJAHRV, -- Fiscal Year [GJAHR]
AKTNR, -- Promotion [WAKTION]
LFGRU, -- Activity Reason [WFGRU]
ARKTX, -- Short Text [TXZ01]
INFNR, -- Info Record [INFNR]
IDNLF, -- Supp. Mat. No. [IDNLF]
MWSBP, -- Tax Amount [MWSBP]
TXJCD, -- Tax Jur. [TXJCD]
EBONF, -- Settlement [EBONY]
BONUS, -- Sett. Group 1 [EBONU]
EBON2, -- Sett. Group 2 [EBON2]
EBON3, -- Sett. Group 3 [EBON3]
LTSNR, -- Suppl. Subrange [LTSNR]
EKKOL, -- Condition Group [EKKOG]
PUNEI, -- Points Unit [PUNEI]
ANZPU, -- Points [ANZPU]
KOLIF, -- Prior Supplier [KOLIF]
NAVNW, -- Non-deductible [NAVNW]
BWTAR, -- Valuation Type [BWTAR_D]
BWTTY, -- Valuation Cat. [BWTTY_D]
GSBER, -- Business Area [GSBER]
PAOBJNR, -- Profit. segment [RKEOBJNR]
KOSTL, -- Cost Center [KOSTL]
PRCTR, -- Profit Center [PRCTR]
KOKRS, -- CO Area [KOKRS]
CHARG, -- Batch [CHARG_D]
WUVPRS, -- Incomp. Pricing [WUVPRS]
WBELN_V, -- Pre. Document [WBELN_V]
POSNR_V, -- Preceding Item [POSNR_V]
FTYPV_V, -- PreDocCat [WFTYP_V]
ITEMCAT, -- Item Category [WSHKZG]
MATBF, -- Stock Mat. [MATBF]
MWERT_IM, -- Inventory Value [WLF_MWERT_IM]
MWERT_PR, -- Price Difference Value [WLF_MWERT_PR]
MWERT_UM, -- Revaluation Value [WLF_MWERT_UM]
CONTRACT, -- Contract [WCONTRACT]
CONTRACT_TYPE, -- Contract Cat. [WCONTRACT_TYPE]
CONTRACT_ITEM, -- Item [WCONTRACT_ITEM]
IDNLF_TYPE, -- ID ObjType Mat. [WLF_IDNLF_TYPE]
ITEM_STATUS, -- Status [WLF_ITEM_STATUS]
ITEM_CANCELED, -- Item Canceled [WLF_ITEM_CANCELED]
GUID_REF, -- Reference GUID [WLF_GUID_REFERENCE]
BEMOT, -- AcctIndicator [BEMOT]
AUFNR, -- Order [AUFNR]
SETTL_STATUS_I_V, -- Sttlmnt Sts Itm Sup. [WLF_SETTLEMENT_STATUS_ITEM_V]
SETTL_STATUS_I_C, -- Settlmt StatusItemCu [WLF_SETTLEMENT_STATUS_ITEM_C]
SETTL_BLOCK_I_V, -- Supplier Settlement Item Blocking Reason [WLF_SETTLEMENT_BLOCK_ITEM_V]
SETTL_BLOCK_I_C, -- Customer Settlement Item Blocking Reason [WLF_SETTLEMENT_BLOCK_ITEM_C]
SETTL_ITEM_REL, -- Itm Sttlm Relevance [WLF_SETTLEMENT_ITEM_RELEVANCE]
CUOBJ, -- Configuration [CUOBJ_VA]
FBUDA, -- Services Rendered Date [WLF_FBUDA]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
ENTITY_TAG_ITEM, -- Item Entity Tag [WLF_ENTITY_TAG_ITEM]
DUMMY_WBRP_INCL_EEW_PS, -- Dummy [WBRP_INCL_EEW]
J_1BNBM, -- NCM Code [J_1BNBMCO1]
J_1BMATUSE, -- Material Usage [J_1BMATUSE]
J_1BMATORG, -- Material Origin [J_1BMATORG]
J_1BOWNPRO, -- Prod. in-house [J_1BOWNPRO]
J_1BINDUST, -- Mat. category [J_1BINDUS3]
J_1BCFOP, -- CFOP [J_1BCFOP]
J_1BTXSDC, -- Tax Code [J_1BTXSDC_]
J_1BTAXLW1, -- ICMS Law [J_1BTAXLW1]
J_1BTAXLW2, -- IPI Law [J_1BTAXLW2]
J_1BTAXLW3, -- ISS Law [J_1BTAXLW3]
J_1BTAXLW4, -- COFINS Law [J_1BTAXLW4]
J_1BTAXLW5, -- PIS Law [J_1BTAXLW5]
SAKTO, -- G/L Account [SAKNR]
SAKNR_INP, -- G/L Acc. Supplier [WLF_SAKNR_INP]
SAKNRD_INP, -- G/L Acc. Customer [WLF_SAKNRD_INP]
SERVCONF_ITEM, -- Conf. Item [FSL_SERVCONF_ITEM]
STATUS, -- Status [FSL_STATUS]
IV_CHECK_TYPE_I, -- Check Type (Pos.) [WLF_IV_CHECK_TYPE_ITEM]
REFSITE, -- Purchasing Ref. Site [WREFSITE]
GJAHR, -- Fiscal Year Settlmnt [WB2_CCS_GJAHR]
MWSKZ_BV, -- Tax Code BusVol [WB2_MWSKZ_BV]
SETTL_DATE_I, -- Settlement Date [WB2_SETTLEMENT_DATE]
SETTL_DATE_SEQ_ID_I, -- Settlement Date ID [WB2_SETTLEMENT_DATE_SEQ_ID]
WAERS_BV, -- Currency BusVol. [WB2_WAERS_BV]
TXDAT_FROM_BV, -- Tax Rate Valid-From [WB2_TXDAT_FROM_BV]
CONTR_TYPE_I, -- Contract Type [WCB_CONTRACT_TYPE]
PROCESS_VARIANT_I, -- Process Variant [WCB_PROCESS_VARIANT]
REF_SETTL_DATE_I, -- Reference Date [WB2_REF_SETTLEMENT_DATE]
SETTL_DATE_TYPE_I, -- Settlement Date Type [WB2_SETTLEMENT_DATE_TYPE]
ACT_SETTL_DATE_I, -- Actual Settl. Date [WB2_ACTUAL_SETTLEMENT_DATE]
SETTL_START_DATE_I, -- Start Date of Period [WB2_SETTLEMENT_START_DATE]
KSCHL_SETTLEMENT, -- Settlement Cond.Type [WB2_KSCHL_SETTLEMENT]
SETTL_VARIANT_I, -- Settlement Variant [WB2_SETTLEMENT_VARIANT]
SETTL_DOC_ITEM_TYPE, -- Item Type [WB2_SETTL_DOC_ITEM_TYPE]
POSNR_MAIN, -- Main Item [WLF_POSNR_MAIN]
POSNR_SUB_EXIST, -- Subitems [WLF_POSNR_SUB_EXIST]
DISTRIB_STATUS, -- Distributn Status [WLF_DISTRIBUTION_STATUS]
NO_TEXT_I, -- No Texts Exist [WLF_NO_TEXT]
CWM_MENGE, -- Qty in PUoM [WLF_CWM_MENGE]
CWM_MEINS, -- Parallel UoM [WLF_CWM_MEINS]
CWM_UOM_TYPE, -- PUoM Type [WLF_CWM_UOM_TYPE]
REF_DOC_NR_1, -- Settlmt. Ref. Doc. [WLF_REF_DOC_NUMBER]
REF_DOC_YEAR_1, -- SM Ref Doc Year [WLF_REF_DOC_YEAR]
REF_LOG_SYS_1, -- SM Ref Log Sys [WLF_REF_LOG_SYS]
REF_ITEM_NUMBER, -- SettlmtRefDocItem [WLF_REF_ITEM_NUMBER]
REF_TYPE, -- SettlmtRefDocCat [WLF_REF_TYPE]
REF_COMPANY_CODE_1, -- Ref. Company Code [WLF_REF_COMPANY_CODE]
REF_DOC_TYPE_1, -- Settlement Reference Document Type [WLF_REF_DOC_TYPE]
ITEM_INTRA_REL, -- Intrastat Relev [WLF_ITEM_INTRASTAT_RELEVANT]
GRWRT, -- Statist. Value [GRWRT]
GRWRTD, -- Stat.Value Cust [GRWRTD]
POSTING_RULE_K_I, -- Creditor Postg Rule [WLF_POSTING_RULE_K_ITEM]
POSTING_RULE_D_I, -- Debtor Posting Rule [WLF_POSTING_RULE_D_ITEM]
WEIGHT_VOLUME, -- Weight/Volume [WLF_WEIGHT_VOLUME_LEVEL]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
T2CCODE_CRCY_CONV_FACTOR_K, -- Exchange Factor for Tax in LC (Supplier) [WLF_T2CCODE_CRCY_CONV_FACTOR]
T2CNTRY_CRCY_CONV_FACTOR_K, -- Exchange Factor for Tax in RC (Supplier) [WLF_T2CNTRY_CRCY_CONV_FACTOR]
T2CCODE_CRCY_CONV_FACTOR_D, -- Exchange Factor for Tax in LC (Customer) [WLF_T2CCODE_CRCY_CONV_FACTOR_D]
T2CNTRY_CRCY_CONV_FACTOR_D, -- Exchange Factor for Tax in RC (Customer) [WLF_T2CNTRY_CRCY_CONV_FACTOR_D]
INCO1_P, -- Incoterms [INCO1]
INCO2_P, -- Incoterms 2 [INCO2]
INCOV_P, -- Inco. Version [INCOV]
INCO2_L_P, -- Inco. Location1 [INCO2_L]
INCO3_L_P, -- Inco. Location2 [INCO3_L]
KOKRSD, -- Customer Ctrl Area [WLF_KOKRS_CUSTOMER]
PRCTRD, -- Cust. Profit Center [WLF_PRCTR_CUSTOMER]
KOSTLD, -- Cust Cost Ctr [WLF_KOSTL_CUSTOMER]
PAOBJNRD, -- Profit. Segment [WLF_PAOBJNR_CUSTOMER]
AUFNRD, -- Customer Order [WLF_AUFNR_CUSTOMER]
PS_PSP_PNRD, -- Customer WBS Element [WLF_PS_PSP_PNR_CUSTOMER]
GSBERD, -- Cust. Business Area [WLF_GSBER_CUSTOMER]
COLL_STATUS_I, -- Collective Settlement Status Item [WLF_COLLECTION_STATUS_ITEM]
COLL_BLOCK_I, -- Collective Settlement Item Block Reason [WLF_COLLECTION_BLOCK_ITEM]
COLL_REL, -- Collective Settlement Relevance [WLF_COLLECTION_RELEVANCE]
CUSTOMER, -- Customer [WLF_CUSTOMER]
MVGR1, -- MaterialGroup 1 [MVGR1]
MVGR2, -- MaterialGroup 2 [MVGR2]
MVGR3, -- MaterialGroup 3 [MVGR3]
MVGR4, -- MaterialGroup 4 [MVGR4]
MVGR5, -- MaterialGroup 5 [MVGR5]
PRODH, -- Prod. Hierarchy [PRODH_D]
DISPUTE_CASE, -- Dispute Case GUID [WLF_DISPUTE_CASE_GUID]
TXDAT_FROM_K, -- Supplier Tax Rate Valid-From [WLF_FOT_TXDAT_FROM_K]
TXDAT_FROM_D, -- Customer Tax Rate Valid-From [WLF_FOT_TXDAT_FROM_D]
VKORG_I, -- Sales Org. [WLF_VKORG_ITEM]
VTWEG_I, -- Distr. Channel [WLF_VTWEG_ITEM]
SPART_I, -- Division [WLF_SPART_ITEM]
PROVG, -- Commission Grp [PROVG]
KONDM, -- Mat. Price Grp [KONDM]
REBATE_GRP, -- Volume Rebate Group [WLF_REBATE_GRP_SLS]
BUPLA, -- Business place [BUPLA]
BUPLA_IC, -- Business Place Intercompany [WLF_BUPLA_IC]
TAX_COUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
TAX_COUNTRY_IC, -- Tax Ctry/Reg. Intercompany [WLF_FOT_TAX_COUNTRY]
TXJCD_IC, -- Tax Jur Intercompany [WLF_TXJCD_IC]
REF_MENGE, -- Reference Quantity [WLF_REFERENCE_QUANTITY]
REF_WFKME, -- Ref. Quantity Unit [WLF_REFERENCE_QUANTITY_UNIT]
LANDTX_I, -- Tx Dep Ctry/Reg [WLF_D_LANDTX]
LAND1TX_I, -- Tx Des Ctry/Reg [WLF_D_LAND1TX]
STCEG_I, -- Supp.VATReg.No. [WLF_SUPLR_STCEG]
STCEGD_I, -- Cust.VATReg.No. [WLF_CUST_STCEG]
BUKRS_I, -- Company Code [WLF_BUKRS_ITEM]
SPART_PRODUCT, -- Product Division [WLF_PRODUCT_SPART]
PRODH_UNIV_SALES_PARNT_NODID, -- Product Hierarchy Node ID [PRODUCTHIERARCHYNODEID]
PRODH_UNIV_SALES_DET_ORIGIN, -- Rlvt Date for Det. [SD_PRODH_DET_ORIGIN]
DEP_COUNTRY_INTRA, -- Departure Country [WLF_DEP_COUNTRY_INTRASTAT]
DEST_COUNTRY_INTRA, -- Destination Country [WLF_DEST_COUNTRY_INTRASTAT]
INVC_ITEM_ID, -- Ext. Inv. Item [WLF_BTD_ITEM_ID]
REFERENCE_ID, -- Item Ref. Doc. [WLF_REF_ID]
REF_ITEM_ID, -- Item RefItemID [WLF_REF_ITEM_ID]
SCHEME_ID, -- Scheme [WLF_SCHEME_ID]
SCHEME_A_ID, -- Scheme ID [WLF_SCHEME_A_ID]
AGENCY_ID_CODE, -- Agency ID [WLF_AGENCY_ID_CODE]
J_1TPBUPL, -- Branch Code [BCODE]
J_1TPBUPL_D, -- Branch Code (Customer) [WLF_BCODE]
REF_DOC_NR_2, -- SettlmtAddlRefDoc [WLF_REF_DOC_NUMBER_2]
REF_DOC_YEAR_2, -- Add. Ref. Doc. Year [WLF_REF_DOC_YEAR_2]
REF_LOG_SYS_2, -- SM Addl Ref Log Sys [WLF_REF_LOG_SYS_2]
REF_ITEM_NUM_2, -- SettlmtAddlRefDocItm [WLF_REF_ITEM_NUMBER_2]
REF_TYPE_2, -- SettlmtAddlRefDocCat [WLF_REF_TYPE_2]
REF_DOC_TYPE_2, -- Additional Reference Doc Type in Settlmt [WLF_REF_DOC_TYPE_2]
REF_COMPANY_CODE_2, -- Company Code of Add. Reference Document [WLF_REF_COMPANY_CODE_2]
PRIMARY KEY (MANDT, WBELN, POSNR)
);
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