SAP Table

FINSC_CUSTBTTYPE Business Transaction Type

SAP table FINSC_CUSTBTTYPE has 2 primary key fields being MANDT,CBTTYPE.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

FINSC_CUSTBTTYPE columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyCBTTYPE Business Transaction Type CHAR 4 0 FINS_CUSTBTTYPE
BTTYPE Business Transaction Category CHAR 4 0 FINSC_BTTYPE FINS_BTTYPE
XPERIODCONTROL Indicator: Business Transaction Relevant for Period Control CHAR 1 0 FINS_XPERIODCONTROL
XREPRESENTATIVE Indicator: Representative Business Transaction Type CHAR 1 0 FINS_XREPRESENTATIVE_BTTYPE
CLOSINGSTEP Closing step NUMC 3 0 FINSC_CLSNGSTEP FINS_CLOSINGSTEP
BLART Document Type CHAR 2 0 T003 BLART
XPERIODBYLEDGER Indicator : Period Control by Ledger CHAR 1 0 FINS_XPERIODBYLEDGER
/ Relationships

FINSC_CUSTBTTYPE foreign keys.

Table Field Check Table Description Check Field
FINSC_CUSTBTTYPE BLART T003 Document Types MANDT
FINSC_CUSTBTTYPE MANDT T000 Clients MANDT