SAP table FINSC_BTTYPE (Business Transaction Category)
SAP table FINSC_BTTYPE has 2 primary key fields being MANDT,BTTYPE.
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
BTTYPE
Business Transaction Category
CHAR
4
0
FINS_BTTYPE
XPERIODCONTROL
Indicator: Business Transaction Relevant for Period Control
CHAR
1
0
FINS_XPERIODCONTROL
Possible values
Not relevant
X
Relevant for Period Control
XMULTIPLECUSTOMER
Indicator: Multiple Customer BTTYPEs is possible
CHAR
1
0
FINS_XMULTIPLECUSTOMER
Possible values
Multiple Customer BTTYPEs is NOT possbile
X
Multiple Customer BTTYPEs is possible
XSETDOCUMENTTYPE
Indicator: Document Type could be set in Customer BTTYPE
CHAR
1
0
FINS_XSETDOCUMENTTYPE
Possible values
Document Type could NOT be set in Customer BTTYPE
X
Document Type could be set in Customer BTTYPE
XPERIODBYLEDGER
Indicator : Period Control by Ledger
CHAR
1
0
FINS_XPERIODBYLEDGER
Possible values
Ledger independent period control
X
Period Control by Ledger
XPERIODBYLEADINGLEDGER
Indicator: Check Period by Leading/Given Ledger
CHAR
1
0
FINS_XPERIODBYLEADINGLEDGER
Possible values
Check Period by Given Ledger
X
Check Period by Leading Ledger
FINSC_BTTYPE foreign key relationships
Table
Field
Check Table
Check Field
0 FINSC_BTTYPE
MANDT
T000
Clients
MANDT