SAP table TIVXCFCSCKEYPROP (Service Charge Key: Properties for Fuel Management)

SAP table TIVXCFCSCKEYPROP has 3 primary key fields being MANDT,SNKSL,BUKRS.

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 MANDT
SNKSL Service Charge Key CHAR 4 0 TIVSCSCKEY RESCSCKEY
BUKRS Company Code CHAR 4 0 BUKRS
BALANCEACC Flow Type CHAR 4 0 TIVCDFLOWTYPE RECDFLOWTYPE
FLOWTYPEIN Flow Type CHAR 4 0 TIVCDFLOWTYPE RECDFLOWTYPE
FLOWTYPEOUT Flow Type CHAR 4 0 TIVCDFLOWTYPE RECDFLOWTYPE
TAXTYPE Tax Type CHAR 4 0 TIVRATAXTYPE RERATAXTYPE
TAXGROUP Tax Group CHAR 20 0 TIVRATAXGROUP RERATAXGROUP
BLART Document Type CHAR 2 0 T003 BLART
BKEYDEBIT Posting key for debit posting CHAR 2 0 TBSL BSCHL_S
BKEYCREDIT Posting key for credit posting CHAR 2 0 TBSL BSCHL_H
ROUNDACTIVE Rounding to Five Centimes CHAR 1 0 REXCFCROUNDACTIVE
UNIT Unit of Measurement UNIT 3 0 T006 MSEHI
STGRD Reason for Reversal or Inverse Posting CHAR 2 0 T041C STGRD
MANCONTNO Fuel Management: Sequence Number (Manual) CHAR 1 0 REXCFCMANCONTNO

TIVXCFCSCKEYPROP foreign key relationships

Table Field Check Table Check Field
0 TIVXCFCSCKEYPROP BALANCEACC TIVCDFLOWTYPE Flow Type MANDT
1 TIVXCFCSCKEYPROP BKEYCREDIT TBSL Posting Key MANDT
1 TIVXCFCSCKEYPROP BKEYCREDIT TBSL Posting Key BSCHL
0 TIVXCFCSCKEYPROP BKEYDEBIT TBSL Posting Key MANDT
0 TIVXCFCSCKEYPROP BKEYDEBIT TBSL Posting Key BSCHL
1 TIVXCFCSCKEYPROP BLART T003 Document Types MANDT
0 TIVXCFCSCKEYPROP FLOWTYPEIN TIVCDFLOWTYPE Flow Type MANDT
1 TIVXCFCSCKEYPROP FLOWTYPEOUT TIVCDFLOWTYPE Flow Type MANDT
0 TIVXCFCSCKEYPROP SNKSL TIVSCSCKEY Service Charge Keys SNKSL
1 TIVXCFCSCKEYPROP STGRD T041C Reasons for Reverse Posting MANDT
1 TIVXCFCSCKEYPROP STGRD T041C Reasons for Reverse Posting STGRD
0 TIVXCFCSCKEYPROP TAXGROUP TIVRATAXGROUP Tax Group TAXGROUP
1 TIVXCFCSCKEYPROP TAXTYPE TIVRATAXTYPE Tax Types COUNTRY
1 TIVXCFCSCKEYPROP TAXTYPE TIVRATAXTYPE Tax Types TAXTYPE
0 TIVXCFCSCKEYPROP UNIT T006 Units of Measurement MANDT
0 TIVXCFCSCKEYPROP UNIT T006 Units of Measurement MSEHI