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 from BASIC Settlement Management Document List Item
P_SettlDocListItemAddInfo1 view from BASIC
P_SettlmtMgmtDocListItem view from BASIC
P_WBRL_ValueHelp view from BASIC

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 MWSBPK Tax Amount
navnw NAVNW Non-deductible
kwert_rl WKWERT_RL SDoc List Value
mwsbp_rl WMWSBP_RL SDListCond Tax
lifre LIFRE Invoicing Party
lnrzb W_LIFZE Payee
kunre KUNRE Bill-to Party
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
dummy_wbrl_incl_eew_ps WBRL_INCL_EEW Dummy
fksto_li WLF_FKSTO_LIST_ITEM Reversed
wuvprs WUVPRS Incomp. Pricing

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,                   -- Tax Amount [MWSBPK]
    NAVNW,                   -- Non-deductible [NAVNW]
    KWERT_RL,                -- SDoc List Value [WKWERT_RL]
    MWSBP_RL,                -- SDListCond Tax [WMWSBP_RL]
    LIFRE,                   -- Invoicing Party [LIFRE]
    LNRZB,                   -- Payee [W_LIFZE]
    KUNRE,                   -- Bill-to Party [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]
    DUMMY_WBRL_INCL_EEW_PS,  -- Dummy [WBRL_INCL_EEW]
    FKSTO_LI,                -- Reversed [WLF_FKSTO_LIST_ITEM]
    WUVPRS,                  -- Incomp. Pricing [WUVPRS]
    PRIMARY KEY (MANDT, WBELN, POSNR)
);

Learn More