WBRL

Transparent Table Application Table
33 Fields 5 CDS Views

Item in Document List

WBRL is an SAP database table in S/4HANA. Item in Document List. It contains 33 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
E_SettlmtMgmtDocListItem view from EXTENSION Settlmt Mgmt Doc List Item Extension
I_SettlmtMgmtDocListItem view_entity from BASIC Settlement Management Document List Item
P_SettlDocListItemAddInfo1 view_entity from BASIC Additional Info of a Settlmt Doc List Item (Table WBRL)
P_SettlmtMgmtDocListItem view from BASIC Settlement Management Document List Item Basic
P_WBRL_ValueHelp view from BASIC Value Help for Settlement Management Document List Items

Fields (33)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wbeln wbeln_rl Sett. Doc. List
KEY posnr wposnr_rl Item
wbeln_lf wbeln_lf Document
netwr netwr_rl Net Value
mwsbp wmwsbp_i
navnw wnavnw_i
kwert_rl wkwert_rl SDoc List Value
mwsbp_rl wmwsbp_rl SDListCond Tax
lifre wlf_lifre
lnrzb w_lifze Payee
kunre wlf_kunre
kunrg kunrg Payer
lftyp wftyp Sett. Doc. Cat.
logsys logsys Logical system
wdtyp_l doctype_l List Doc. Cat.
wdtyp_li doctype_li Doc. Cat of List Itm
txjcd txjcd Tax Jur.
paobjnr rkeobjnr Profit. segment
gjahr gjahr Fiscal Year
ext_doc_nr wlf_foreign_doc_number External Doc ID
ext_doc_year wlf_foreign_doc_year External Doc Year
ext_doc_bukrs wlf_foreign_doc_bukrs External Doc CoCode
ext_doc_item wlf_foreign_doc_item_number External Doc. Item
fbuda_li fbuda Serv. Rend. Dte
_dataaging data_temperature Data Aging
bupla bupla Business place
tax_country fot_tax_country Tax Ctry/Reg.
kowrr wkowrr Item Control
lfgru_li wfgru Activity Reason
sont_abbrv_l wlf_bo_node_type_abbrv SAP Object Node Type Abbreviation
semantic_type_l wlf_semantic_type Semantic Type
semantic_type_sub_cat_l wlf_semantic_type_sub_cat

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.

-- Item in Document List
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WBRL (
    MANDT,                    -- Client [mandt]
    WBELN,                    -- Sett. Doc. List [wbeln_rl]
    POSNR,                    -- Item [wposnr_rl]
    WBELN_LF,                 -- Document [wbeln_lf]
    NETWR,                    -- Net Value [netwr_rl]
    MWSBP,                    -- wmwsbp_i
    NAVNW,                    -- wnavnw_i
    KWERT_RL,                 -- SDoc List Value [wkwert_rl]
    MWSBP_RL,                 -- SDListCond Tax [wmwsbp_rl]
    LIFRE,                    -- wlf_lifre
    LNRZB,                    -- Payee [w_lifze]
    KUNRE,                    -- wlf_kunre
    KUNRG,                    -- Payer [kunrg]
    LFTYP,                    -- Sett. Doc. Cat. [wftyp]
    LOGSYS,                   -- Logical system [logsys]
    WDTYP_L,                  -- List Doc. Cat. [doctype_l]
    WDTYP_LI,                 -- Doc. Cat of List Itm [doctype_li]
    TXJCD,                    -- Tax Jur. [txjcd]
    PAOBJNR,                  -- Profit. segment [rkeobjnr]
    GJAHR,                    -- Fiscal Year [gjahr]
    EXT_DOC_NR,               -- External Doc ID [wlf_foreign_doc_number]
    EXT_DOC_YEAR,             -- External Doc Year [wlf_foreign_doc_year]
    EXT_DOC_BUKRS,            -- External Doc CoCode [wlf_foreign_doc_bukrs]
    EXT_DOC_ITEM,             -- External Doc. Item [wlf_foreign_doc_item_number]
    FBUDA_LI,                 -- Serv. Rend. Dte [fbuda]
    _DATAAGING,               -- Data Aging [data_temperature]
    BUPLA,                    -- Business place [bupla]
    TAX_COUNTRY,              -- Tax Ctry/Reg. [fot_tax_country]
    KOWRR,                    -- Item Control [wkowrr]
    LFGRU_LI,                 -- Activity Reason [wfgru]
    SONT_ABBRV_L,             -- SAP Object Node Type Abbreviation [wlf_bo_node_type_abbrv]
    SEMANTIC_TYPE_L,          -- Semantic Type [wlf_semantic_type]
    SEMANTIC_TYPE_SUB_CAT_L,  -- wlf_semantic_type_sub_cat
    PRIMARY KEY (MANDT, WBELN, POSNR)
);

Learn More