SAP table T045P (Bill of Exchange Portfolios)

SAP table T045P has 3 primary key fields being MANDT,BUKRS,PORTFO.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
PORTFO Bill of Exchange Portfolio CHAR 10 0 PORTFO
WEKON Special G/L Account for Bills of Exchange Receivable CHAR 10 0 SKB1 WEKON_FBWE
FLAGCB Bill of Exchange Type CHAR 1 0 FLAGCB
0 Bills of exchange
2 Checks
HKONT G/L Account for Transferring Bills Between Portfolios CHAR 10 0 SKB1 HKONT_045P
VKONT Interim Account for Bills of Exchange Presented to Vendors CHAR 10 0 SKB1 VKONT_045P

T045P foreign key relationships

Table Field Check Table Check Field
0 T045P BUKRS T001 Company Codes BUKRS
1 T045P HKONT SKB1 G/L account master (company code) MANDT
1 T045P HKONT SKB1 G/L account master (company code) BUKRS
0 T045P MANDT T000 Clients MANDT
1 T045P VKONT SKB1 G/L account master (company code) MANDT
1 T045P VKONT SKB1 G/L account master (company code) BUKRS
0 T045P WEKON SKB1 G/L account master (company code) MANDT
0 T045P WEKON SKB1 G/L account master (company code) BUKRS