SAP table T041A (Clearing Transactions)

SAP table T041A has 2 primary key fields being MANDT,AUGLV.

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
AUGLV Clearing Transaction CHAR 8 0 AUGLV
BSKSO Posting Key for Debit Postings to Vendor Account CHAR 2 0 TBSL BSKSO
BSKHA Posting Key for Credit Postings to Vendor Account CHAR 2 0 TBSL BSKHA
BSKSS Posting Key for Debit Special G/L Trans.to Vendor Account CHAR 2 0 TBSL BSKSS
BSKHS Posting Key for Credit Special G/L Trans.to Vendor Account CHAR 2 0 TBSL BSKHS
BSDSO Posting Key for Debit Postings to Customer Account CHAR 2 0 TBSL BSDSO
BSDHA Posting Key for Credit Postings to Customer Account CHAR 2 0 TBSL BSDHA
BSDSS Posting Key for Debit Special G/L Trans.to Customer Account CHAR 2 0 TBSL BSDSS
BSDHS Posting Key for Credit Special G/L Trans.to Customer Account CHAR 2 0 TBSL BSDHS
BSSSO Posting Key for Debit Postings to G/L Account CHAR 2 0 TBSL BSSSO
BSSHA Posting Key for Credit Postings to G/L Account CHAR 2 0 TBSL BSSHA
RPKSO Posting Key for Vendor Residual Items/Debit CHAR 2 0 TBSL RPKSO
RPKHA Posting Key for Vendor Residual Items/Credit CHAR 2 0 TBSL RPKHA
RPDSO Posting Key for Customer Residual Items/Debit CHAR 2 0 TBSL RPDSO
RPDHA Posting Key Customer Residual Items/Credit CHAR 2 0 TBSL RPDHA
BLARD Document Type for A/R Transfer Posting CHAR 2 0 T003 BLARD
BLARK Document Type for A/P Transfer Posting CHAR 2 0 T003 BLARK
BLARS Document Type for G/L Transfer Postings CHAR 2 0 T003 BLARS

T041A foreign key relationships

Table Field Check Table Check Field
0 T041A BLARD T003 Document Types MANDT
1 T041A BLARK T003 Document Types MANDT
0 T041A BLARS T003 Document Types MANDT
1 T041A BSDHA TBSL Posting Key MANDT
1 T041A BSDHA TBSL Posting Key BSCHL
0 T041A BSDHS TBSL Posting Key MANDT
0 T041A BSDHS TBSL Posting Key BSCHL
1 T041A BSDSO TBSL Posting Key MANDT
1 T041A BSDSO TBSL Posting Key BSCHL
0 T041A BSDSS TBSL Posting Key MANDT
0 T041A BSDSS TBSL Posting Key BSCHL
1 T041A BSKHA TBSL Posting Key MANDT
1 T041A BSKHA TBSL Posting Key BSCHL
0 T041A BSKHS TBSL Posting Key MANDT
0 T041A BSKHS TBSL Posting Key BSCHL
1 T041A BSKSO TBSL Posting Key MANDT
1 T041A BSKSO TBSL Posting Key BSCHL
0 T041A BSKSS TBSL Posting Key MANDT
0 T041A BSKSS TBSL Posting Key BSCHL
1 T041A BSSHA TBSL Posting Key MANDT
1 T041A BSSHA TBSL Posting Key BSCHL
0 T041A BSSSO TBSL Posting Key MANDT
0 T041A BSSSO TBSL Posting Key BSCHL
1 T041A MANDT T000 Clients MANDT
0 T041A RPDHA TBSL Posting Key MANDT
0 T041A RPDHA TBSL Posting Key BSCHL
1 T041A RPDSO TBSL Posting Key MANDT
1 T041A RPDSO TBSL Posting Key BSCHL
0 T041A RPKHA TBSL Posting Key MANDT
0 T041A RPKHA TBSL Posting Key BSCHL
1 T041A RPKSO TBSL Posting Key MANDT
1 T041A RPKSO TBSL Posting Key BSCHL