SAP table T012C (Terms for bank transactions)

SAP table T012C has 5 primary key fields being MANDT,BUKRS,HBKID,HKTID,VORGA.

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
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
VORGA Transaction type for determining bank terms CHAR 8 0 VORGA_012C
BZDAT Reference date for determining the value date CHAR 1 0 BZDAT_012C
1 Document date
2 Posting date
3 Due Date
CALI1 Factory calendar ID for calculating the value date CHAR 2 0 TFACD CALI1_012C
VORZE +/- sign for the difference in days CHAR 1 0 VORZE_012C
+ Add deviation
- Subtract deviation
ABWEI Deviation from reference date in days NUMC 3 0 ABWEI_012C
CALI2 Factory calendar ID for the value date ruling on days off CHAR 2 0 TFACD CALI2_012C
ENDAT Rule for setting the value date for weekends and public hols CHAR 1 0 ENDAT_012C
Day determined should be used
+ Next week day should be used
- Last week day should be used

T012C foreign key relationships

Table Field Check Table Check Field
0 T012C BUKRS T001 Company Codes BUKRS
1 T012C HBKID T012 House Banks BUKRS
0 T012C HKTID T012K House Bank Accounts MANDT
0 T012C HKTID T012K House Bank Accounts BUKRS
0 T012C HKTID T012K House Bank Accounts HBKID
0 T012C HKTID T012K House Bank Accounts HKTID
1 T012C MANDT T000 Clients MANDT