SAP table IDCFM_BST_CUSTIT (Customizing for Balance Sheet Transfer for Brazil)

SAP table IDCFM_BST_CUSTIT has 9 primary key fields being MANDT,BUKRS,GSART,RANTYP,TRAN_CAT,PARTNER,RREFKONT,POST_TYPE,DIRECTION.

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 IDCFM_BST_CUST BUKRS
GSART Product Type CHAR 3 0 IDCFM_BST_CUST VVSART
RANTYP Contract Type CHAR 1 0 IDCFM_BST_CUST RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
TRAN_CAT Indicator: Asset/Liability Transaction CHAR 1 0 IDCFM_BST_CUST VVSAKTPAS
0 Asset Transaction
1 Liabilities Transaction
PARTNER Business Partner Number CHAR 10 0 BP_PARTNR_NEW
RREFKONT Account Assignment Reference in Financial Assets Management CHAR 8 0 RREFKONT
POST_TYPE Posting identification CHAR 2 0 IDPST_TYP
1 Interest Accrual
1V Currency Valuation for Interest Accrual
2 Installment repayment
2V Currency valuation for Installment Repayment
3 Final Repayment
3V Currency valuation for Final Repayment
S1 Net amount
S2 SWAP IRRF
S3 Net amount accrual
S4 SWAP IRRF accrual
DIRECTION Direction of Flow CHAR 1 0 TB_SSIGN
TOLONG Flow Type CHAR 4 0 TZB0A SBEWART
TOMEDIUM Flow Type CHAR 4 0 TZB0A SBEWART
TOSHORT Flow Type CHAR 4 0 TZB0A SBEWART
L2S Flow Type CHAR 4 0 TZB0A SBEWART
M2S Flow Type CHAR 4 0 TZB0A SBEWART
L2M Flow Type CHAR 4 0 TZB0A SBEWART
S2M Flow Type CHAR 4 0 TZB0A SBEWART
M2L Flow Type CHAR 4 0 TZB0A SBEWART
S2L Flow Type CHAR 4 0 TZB0A SBEWART

IDCFM_BST_CUSTIT foreign key relationships

Table Field Check Table Check Field
0 IDCFM_BST_CUSTIT BUKRS IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil MANDT
0 IDCFM_BST_CUSTIT BUKRS IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil BUKRS
0 IDCFM_BST_CUSTIT BUKRS IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil GSART
1 IDCFM_BST_CUSTIT GSART IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil MANDT
1 IDCFM_BST_CUSTIT GSART IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil BUKRS
1 IDCFM_BST_CUSTIT GSART IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil GSART
0 IDCFM_BST_CUSTIT L2M TZB0A Definition of flow types MANDT
0 IDCFM_BST_CUSTIT L2M TZB0A Definition of flow types SBEWART
1 IDCFM_BST_CUSTIT L2S TZB0A Definition of flow types MANDT
1 IDCFM_BST_CUSTIT L2S TZB0A Definition of flow types SBEWART
0 IDCFM_BST_CUSTIT M2L TZB0A Definition of flow types MANDT
0 IDCFM_BST_CUSTIT M2L TZB0A Definition of flow types SBEWART
1 IDCFM_BST_CUSTIT M2S TZB0A Definition of flow types MANDT
1 IDCFM_BST_CUSTIT M2S TZB0A Definition of flow types SBEWART
0 IDCFM_BST_CUSTIT MANDT T000 Clients MANDT
1 IDCFM_BST_CUSTIT RANTYP IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil MANDT
1 IDCFM_BST_CUSTIT RANTYP IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil BUKRS
1 IDCFM_BST_CUSTIT RANTYP IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil GSART
0 IDCFM_BST_CUSTIT S2L TZB0A Definition of flow types MANDT
0 IDCFM_BST_CUSTIT S2L TZB0A Definition of flow types SBEWART
1 IDCFM_BST_CUSTIT S2M TZB0A Definition of flow types MANDT
1 IDCFM_BST_CUSTIT S2M TZB0A Definition of flow types SBEWART
0 IDCFM_BST_CUSTIT TOLONG TZB0A Definition of flow types MANDT
0 IDCFM_BST_CUSTIT TOLONG TZB0A Definition of flow types SBEWART
1 IDCFM_BST_CUSTIT TOMEDIUM TZB0A Definition of flow types MANDT
1 IDCFM_BST_CUSTIT TOMEDIUM TZB0A Definition of flow types SBEWART
0 IDCFM_BST_CUSTIT TOSHORT TZB0A Definition of flow types MANDT
0 IDCFM_BST_CUSTIT TOSHORT TZB0A Definition of flow types SBEWART
1 IDCFM_BST_CUSTIT TRAN_CAT IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil MANDT
1 IDCFM_BST_CUSTIT TRAN_CAT IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil BUKRS
1 IDCFM_BST_CUSTIT TRAN_CAT IDCFM_BST_CUST Customizing for Balance Sheet Transfer for Brazil GSART