WBRP

Transparent Table Application Table
113 Fields 11 CDS Views

Settlement Management Document Item

WBRP is an SAP database table in S/4HANA. Settlement Management Document Item. It contains 113 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_AgbuItemQty view_entity from Settlement Management Item Quantity
E_SettlmtMgmtDocItem view_entity from EXTENSION Settlmt Mgmt Doc Item Extension
I_SettlmtMgmtDocItem view from BASIC Settlement Management Document Item
P_SettlDocItemAddInfo1 view_entity from BASIC Additional Information of a Settlmt Doc Item (Table WBRP)
P_SettlmtMgmtDocItem view from BASIC Settlement Management Document Item Basic
P_WBRP_ValueHelp view from BASIC Value Help for Settlement Management Docs Items
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 (113)

KeyField Data ElementDescription DomainTypeLength
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 wskfbp_i
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 wskfbpd_i
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 wmwsbp_i
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 wnavnw_i
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 wlf_cuobj
fbuda wlf_fbuda Services Rendered Date
sont_abbrv_i wlf_bo_node_type_abbrv SAP Object Node Type Abbreviation
semantic_type_i wlf_semantic_type Semantic Type
semantic_type_sub_cat_i wlf_semantic_type_sub_cat
_dataaging data_temperature Data Aging
entity_tag_item wlf_entity_tag_item Item Entity Tag

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,                    -- wskfbp_i
    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,                   -- wskfbpd_i
    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,                    -- wmwsbp_i
    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,                    -- wnavnw_i
    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,                    -- wlf_cuobj
    FBUDA,                    -- Services Rendered Date [wlf_fbuda]
    SONT_ABBRV_I,             -- SAP Object Node Type Abbreviation [wlf_bo_node_type_abbrv]
    SEMANTIC_TYPE_I,          -- Semantic Type [wlf_semantic_type]
    SEMANTIC_TYPE_SUB_CAT_I,  -- wlf_semantic_type_sub_cat
    _DATAAGING,               -- Data Aging [data_temperature]
    ENTITY_TAG_ITEM,          -- Item Entity Tag [wlf_entity_tag_item]
    PRIMARY KEY (MANDT, WBELN, POSNR)
);

Learn More