SAP VISCCRSPLIT Split Receivable Table
Overview
VISCCRSPLIT is a standard SAP S/4HANA table that stores Split Receivable data. There are total 39 fields in the VISCCRSPLIT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCCRSPLIT belongs to Service Charge Settlement (RE-FX-SC) module and is located in the package SCS: Credit/Receivables (RE_SC_CR).
In addition, following links provide an overview of foreign key relationships, if any, that link VISCCRSPLIT to other SAP tables and standard CDS views available based on VISCCRSPLIT table in S/4HANA 2020.
Techincal Settings of VISCCRSPLIT
Below are technical details of the table VISCCRSPLIT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCCRSPLIT Fields
The following table gives you an overview of the fields available in VISCCRSPLIT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| CRSPLITGUID | Unique Key for Split Receivable | RESCCRSPLITGUID | RAW | 16 | |
| RECEIVABLEGUID | Unique Key for Receivable | RESCRECEIVABLEGUID | VISCRECEIVABLE | RAW | 16 |
| CDSPLITNO | Number of Condition Split | RETMCDSPLITNO | NUMC | 4 | |
| SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | RAW | 16 | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| CURRENCY | Currency of condition item | RECDCONDCURR | * | CUKY | 5 |
| TAXTYPE | Tax Type | RERATAXTYPE | * | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | * | CHAR | 20 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| TAXDATE | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| NETAMOUNT | Net Amount in Transaction Currency | RERANETAMOUNT | CURR | 15 | |
| TAXAMOUNT | Tax Amount in Transaction Currency | RERATAXAMOUNT | CURR | 15 | |
| GROSSAMOUNT | Gross Amount in Transaction Currency | RERAGROSSAMOUNT | CURR | 15 | |
| CHRGNETAMOUNT | Net Surcharge Amount | RESCCHRGNETAMOUNT | CURR | 15 | |
| CHRGTAXAMOUNT | Taxes on Management Costs Surcharge | RESCCHRGTAXAMOUNT | CURR | 15 | |
| CHRGFLOWTYPE | Flow Type | RECDFLOWTYPE | * | CHAR | 4 |
| CHRGTAXTYPE | Tax Type | RERATAXTYPE | * | CHAR | 4 |
| CHRGTAXGROUP | Tax Group | RERATAXGROUP | * | CHAR | 20 |
| CHRGTXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| CHRGTAXDATE | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| CTFCGROSSAMOUNT | Gross Amount in Foreign Currency | RECACTFCGROSSAMOUNT | CURR | 15 | |
| CTFCNETAMOUNT | Net Amount in Foreign Currency | RECACTFCNETAMOUNT | CURR | 15 | |
| CTFCTAXAMOUNT | Tax Amount in Foreign Currency | RECACTFCTAXAMOUNT | CURR | 15 | |
| CTFCCHRGNETAMT | Net Surcharge Amount | RESCCHRGNETAMOUNT | CURR | 15 | |
| CTFCCHRGTAXAMT | Taxes on Management Costs Surcharge | RESCCHRGTAXAMOUNT | CURR | 15 | |
| CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | * | CUKY | 5 |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTRATETYPE | Exchange Rate Type | RECACTRATETYPE | * | CHAR | 4 |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| CTFCPOST | Post in Foreign Currency | RECACTFCPOST | CHAR | 1 | |
| AMOUNT | Unit Price | RECDUNITPRICE | DEC | 19 | |
| AMOUNT_ROUNDED | Unit Price | RECDUNITPRICE | DEC | 19 | |
| CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15 | |
| CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15 | |
| ROUNDTYPE | Rounding Category of Unit Price | RECDROUNDTYPE | NUMC | 1 | |
| ROUNDUNIT | Unit to be rounded up to | RECDROUNDUNIT | NUMC | 4 | |
| CTRATE_BADI | Exchange Rate | RECACTRATE | DEC | 9 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VISCCRSPLIT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCCRSPLIT | RECEIVABLEGUID | : | VISCRECEIVABLE |