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 |