- Home
- Resources
- SAP Tables
- WBRL - Agency business: Item in document list
SAP Table WBRL
Agency business: Item in document list
WBRL (Agency business: Item in document list) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WBRL to other SAP tables.
Source: WBRL (Agency business: Item in document list)
WBRL table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
WBELN |
Agency Business: Document Number of Remuneration List |
WBELN_RL |
WBRK
|
CHAR |
|
10 |
0 |
|
POSNR |
Agency business: Item in list |
WPOSNR_RL |
|
NUMC |
|
6 |
0 |
|
WBELN_LF |
Agency Business: Document Number |
WBELN_LF |
WBRK
|
CHAR |
|
10 |
0 |
|
NETWR |
Agency business: New value of item in a list |
NETWR_RL |
|
CURR |
|
15 |
2 |
|
MWSBP |
Tax amount in document currency |
MWSBPK |
|
CURR |
|
13 |
2 |
|
NAVNW |
Non-deductible input tax |
NAVNW |
|
CURR |
|
13 |
2 |
|
KWERT_RL |
Value of the Remuneration List Condition of a Document |
WKWERT_RL |
|
CURR |
|
13 |
2 |
|
MWSBP_RL |
Tax of Remuneration List Conditions |
WMWSBP_RL |
|
CURR |
|
13 |
2 |
|
LIFRE |
Different Invoicing Party |
LIFRE |
LFA1
|
CHAR |
|
10 |
0 |
|
LNRZB |
Agency business: Payee |
W_LIFZE |
LFA1
|
CHAR |
|
10 |
0 |
|
KUNRE |
Bill-to party |
KUNRE |
KNA1
|
CHAR |
|
10 |
0 |
|
KUNRG |
Payer |
KUNRG |
KNA1
|
CHAR |
|
10 |
0 |
|
LFTYP |
Agency business: Billing category |
WFTYP |
|
CHAR |
|
2 |
0 |
Possible values
01 |
Invoice |
02 |
Invoice Reversal |
03 |
Credit Memo |
04 |
Credit Memo Reversal |
05 |
Invoice List |
06 |
Credit Memo List |
|
LOGSYS |
Logical system |
LOGSYS |
|
CHAR |
|
10 |
0 |
|
WDTYP_L |
Agency Business: Category of List Document |
DOCTYPE_L |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not Assigned |
A |
Vendor Billing Document |
B |
Single Settlement Request |
C |
Posting List |
D |
Settlement Request List |
E |
Remuneration List from Vendor Billing Documents |
F |
Remuneration List from Payment Documents |
G |
Customer Settlement |
H |
Expenses Settlement |
I |
Remuneration List from Customer Settlements |
J |
Remuneration List from Expenses Settlements |
K |
Remuneration List from Remuneration Lists |
* |
Generically for All Document Categories |
X |
Undefined Document Category |
0 |
Remuneration List From External Documents |
L |
Vendor Settlement |
M |
Remuneration List from Vendor Settlements |
N |
Any Remuneration List |
|
WDTYP_LI |
Agency Business: Category of List Item |
DOCTYPE_LI |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not Assigned |
A |
Vendor Billing Document |
B |
Single Settlement Request |
C |
Posting List |
D |
Settlement Request List |
E |
Remuneration List from Vendor Billing Documents |
F |
Remuneration List from Payment Documents |
G |
Customer Settlement |
H |
Expenses Settlement |
I |
Remuneration List from Customer Settlements |
J |
Remuneration List from Expenses Settlements |
K |
Remuneration List from Remuneration Lists |
L |
Vendor Settlement |
M |
Remuneration List from Vendor Settlements |
* |
Generically for All Document Categories |
X |
Undefined Document Category |
0 |
Remuneration List From External Documents |
1 |
Accounting Document |
2 |
Customer Billing Document |
|
TXJCD |
Tax Jurisdiction |
TXJCD |
TTXJ
|
CHAR |
|
15 |
0 |
|
PAOBJNR |
Profitability Segment Number (CO-PA) |
RKEOBJNR |
|
NUMC |
|
10 |
0 |
|
GJAHR |
Fiscal Year |
GJAHR |
|
NUMC |
|
4 |
0 |
|
OBJECT_ID |
AB: External Document: Object Key |
WLF_FOREIGN_OBJECT_ID |
|
CHAR |
|
30 |
0 |
|
FKSTO_LI |
List Item Cancelled |
WLF_FKSTO_LIST_ITEM |
|
CHAR |
|
1 |
0 |
Possible values
|
WUVPRS |
Agency business: Item incomplete re. price determination |
WUVPRS |
|
CHAR |
|
1 |
0 |
Possible values
|
WBRL foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
WBRL |
KUNRE |
WBRL |
MANDT |
KNA1 |
General Data in Customer Master |
MANDT |
WBRL |
KUNRE |
WBRL |
KUNRE |
KNA1 |
General Data in Customer Master |
KUNNR |
WBRL |
KUNRG |
WBRL |
MANDT |
KNA1 |
General Data in Customer Master |
MANDT |
WBRL |
KUNRG |
WBRL |
KUNRG |
KNA1 |
General Data in Customer Master |
KUNNR |
WBRL |
LIFRE |
WBRL |
MANDT |
LFA1 |
Vendor Master (General Section) |
MANDT |
WBRL |
LIFRE |
WBRL |
LIFRE |
LFA1 |
Vendor Master (General Section) |
LIFNR |
WBRL |
LNRZB |
WBRL |
MANDT |
LFA1 |
Vendor Master (General Section) |
MANDT |
WBRL |
LNRZB |
WBRL |
LNRZB |
LFA1 |
Vendor Master (General Section) |
LIFNR |
WBRL |
MANDT |
WBRL |
MANDT |
T000 |
Clients |
MANDT |
WBRL |
TXJCD |
WBRL |
MANDT |
TTXJ |
Check Table for Tax Jurisdiction |
MANDT |
WBRL |
TXJCD |
T005 |
KALSM |
TTXJ |
Check Table for Tax Jurisdiction |
KALSM |
WBRL |
TXJCD |
WBRL |
TXJCD |
TTXJ |
Check Table for Tax Jurisdiction |
TXJCD |
WBRL |
WBELN |
WBRL |
MANDT |
WBRK |
Agency business: Header |
MANDT |
WBRL |
WBELN |
WBRL |
WBELN |
WBRK |
Agency business: Header |
WBELN |
WBRL |
WBELN_LF |
WBRL |
MANDT |
WBRK |
Agency business: Header |
MANDT |
WBRL |
WBELN_LF |
WBRL |
WBELN_LF |
WBRK |
Agency business: Header |
WBELN |