SAP table H_WRLBC (Generated Table for View)
SAP table H_WRLBC has 2 primary key fields being MANDT,WBELN.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
T000
MANDT
WBELN
Document Number
CHAR
10
0
WBELN_AG
LFART
Settlement Document Type
CHAR
4
0
TMFK
WFART
WFDAT
Posting Date
DATS
8
0
WFDAT
KUNRE
Bill-to Party
CHAR
10
0
KNA1
KUNRE
KUNRG
Payer
CHAR
10
0
KNA1
KUNRG
VKORG
Sales Organization
CHAR
4
0
TVKO
VKORG
VTWEG
Distribution Channel
CHAR
2
0
TVTW
VTWEG
SPART
Division
CHAR
2
0
TSPA
SPART
BUKRS
Company Code
CHAR
4
0
T001
BUKRS
ERDAT
Date on which the record was created
DATS
8
0
ERDAT
ERNAM
Name of Person Responsible for Creating the Object
CHAR
12
0
ERNAM
WRART
Settlement Process Type
CHAR
4
0
TMZR
WRART
WRLPAR
Recipient of a Settlement Document List
CHAR
1
0
WRLPAR
Possible values
H_WRLBC foreign key relationships
Table
Field
Check Table
Check Field
0 H_WRLBC
BUKRS
T001
Company Codes
BUKRS
1 H_WRLBC
KUNRE
KNA1
General Data in Customer Master
MANDT
1 H_WRLBC
KUNRE
KNA1
General Data in Customer Master
KUNNR
0 H_WRLBC
KUNRG
KNA1
General Data in Customer Master
MANDT
0 H_WRLBC
KUNRG
KNA1
General Data in Customer Master
KUNNR
1 H_WRLBC
LFART
TMFK
Settlement Document Types
LFART
0 H_WRLBC
MANDT
T000
Clients
MANDT
1 H_WRLBC
SPART
TSPA
Organizational Unit: Sales Divisions
MANDT
1 H_WRLBC
SPART
TSPA
Organizational Unit: Sales Divisions
SPART
0 H_WRLBC
VKORG
TVKO
Organizational Unit: Sales Organizations
MANDT
0 H_WRLBC
VKORG
TVKO
Organizational Unit: Sales Organizations
VKORG
1 H_WRLBC
VTWEG
TVTW
Organizational Unit: Distribution Channels
MANDT
1 H_WRLBC
VTWEG
TVTW
Organizational Unit: Distribution Channels
VTWEG
0 H_WRLBC
WRART
TMZR
Settlement Process Types
MANDT