SAP WBRL Item in Document List Table
Overview
WBRL is a standard SAP S/4HANA table that stores Item in Document List data. There are total 31 fields in the WBRL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBRL belongs to Settlement Management (LO-AB) module and is located in the package Settlement Management (Main Package) (WZRE).
In addition, following links provide an overview of foreign key relationships, if any, that link WBRL to other SAP tables and standard CDS views available based on WBRL table in S/4HANA 2020.
Techincal Settings of WBRL
Below are technical details of the table WBRL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WBRL Fields
The following table gives you an overview of the fields available in WBRL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| WBELN | Document Number of Settlement Document List | WBELN_RL | WBRK | CHAR | 10 |
| POSNR | Item in List | WPOSNR_RL | NUMC | 6 | |
| WBELN_LF | Document Number | WBELN_LF | WBRK | CHAR | 10 |
| NETWR | New Value of the Item in a List | NETWR_RL | CURR | 15 | |
| MWSBP | Tax Amount in Document Currency (Supplier-Side) | MWSBPK | CURR | 13 | |
| NAVNW | Non-deductible input tax | NAVNW | CURR | 13 | |
| KWERT_RL | Value of the Settlement Document List Conditions | WKWERT_RL | CURR | 13 | |
| MWSBP_RL | Tax of Settlement Document List Conditions | WMWSBP_RL | CURR | 13 | |
| LIFRE | Different Invoicing Party | LIFRE | LFA1 | CHAR | 10 |
| LNRZB | Payee | W_LIFZE | LFA1 | CHAR | 10 |
| KUNRE | Bill-to party | KUNRE | KNA1 | CHAR | 10 |
| KUNRG | Payer | KUNRG | KNA1 | CHAR | 10 |
| LFTYP | Settlement Document Category | WFTYP | CHAR | 2 | |
| LOGSYS | Logical system | LOGSYS | CHAR | 10 | |
| WDTYP_L | Category of List Document | DOCTYPE_L | CHAR | 1 | |
| WDTYP_LI | Category of List Document Item | DOCTYPE_LI | CHAR | 1 | |
| TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| EXT_DOC_NR | External Document for Settlement Management | WLF_FOREIGN_DOC_NUMBER | CHAR | 10 | |
| EXT_DOC_YEAR | Year of External Document for Settlement Management | WLF_FOREIGN_DOC_YEAR | NUMC | 4 | |
| EXT_DOC_BUKRS | Company Code of External Document for Settlement Management | WLF_FOREIGN_DOC_BUKRS | CHAR | 4 | |
| EXT_DOC_ITEM | Item in External Document for Settlement Management | WLF_FOREIGN_DOC_ITEM_NUMBER | NUMC | 10 | |
| FBUDA_LI | Date on which services are rendered | FBUDA | DATS | 8 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| BUPLA | Business Place | BUPLA | J_1BBRANCH | CHAR | 4 |
| TAX_COUNTRY | Tax Reporting Country | FOT_TAX_COUNTRY | T005 | CHAR | 3 |
| DUMMY_WBRL_INCL_EEW_PS | Dummy Data Elmnt for Settlmt Mgmt Doc List Itm Extensibility | WBRL_INCL_EEW | CHAR | 1 | |
| FKSTO_LI | List Item is Reversed | WLF_FKSTO_LIST_ITEM | CHAR | 1 | |
| WUVPRS | Indicator that Pricing Determination for Item is Incomplete | WUVPRS | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WBRL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBRL | BUPLA | : | J_1BBRANCH |
| WBRL | KUNRE | C: CN | KNA1 |
| WBRL | KUNRG | C: CN | KNA1 |
| WBRL | LIFRE | 1: CN | LFA1 |
| WBRL | LNRZB | C: CN | LFA1 |
| WBRL | MANDT | : | T000 |
| WBRL | TAX_COUNTRY | : | T005 |
| WBRL | TXJCD | : | TTXJ |
| WBRL | WBELN | 1: CN | WBRK |
| WBRL | WBELN_LF | 1: CN | WBRK |