SAP VISCRECEIVABLE Receivables from Settlement Table
Overview
VISCRECEIVABLE is a standard SAP S/4HANA table that stores Receivables from Settlement data. There are total 60 fields in the VISCRECEIVABLE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VISCRECEIVABLE 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 VISCRECEIVABLE to other SAP tables and standard CDS views available based on VISCRECEIVABLE table in S/4HANA 2020.
Techincal Settings of VISCRECEIVABLE
Below are technical details of the table VISCRECEIVABLE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VISCRECEIVABLE Fields
The following table gives you an overview of the fields available in VISCRECEIVABLE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| RECEIVABLEGUID | Unique Key for Receivable | RESCRECEIVABLEGUID | RAW | 16 | |
| SCS_PERIOD_GUID | Rental Periods | RESCPERIODGUID | RAW | 16 | |
| CONDTYPE | Condition Type | RECDCONDTYPE | TIVCDCONDTYPE | CHAR | 4 |
| VALIDTO | Assignment Is Valid to This Date | RESCVALIDTO_UNI | DATS | 8 | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| PARTNEROBJNR | Object Number for Internal Use | RETMPARTNEROBJNR | * | CHAR | 22 |
| VALIDFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | |
| SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | RAW | 16 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
| FLOWTYPE | Flow Type | RECDFLOWTYPE | TIVCDFLOWTYPE | CHAR | 4 |
| IS_ITAX_OPTING | Opts | RESCISITAXOPTING | CHAR | 1 | |
| TAXTYPE | Tax Type | RERATAXTYPE | TIVRATAXTYPE | CHAR | 4 |
| TAXGROUP | Tax Group | RERATAXGROUP | TIVRATAXGROUP | CHAR | 20 |
| TXJCD | Tax Jurisdiction | TXJCD | * | CHAR | 15 |
| TAXDATE | Date for Determining Tax Rates | TXDAT | DATS | 8 | |
| GROSSAMOUNT | Gross Amount in Transaction Currency | RERAGROSSAMOUNT | CURR | 15 | |
| NET_AMOUNT | Net Amount in Transaction Currency | RERANETAMOUNT | CURR | 15 | |
| NETAMTOPTING | Net Amount of the Opting Share | RESCNETAMTOPTING | CURR | 15 | |
| TAX_AMOUNT | Tax Amount in Transaction Currency | RERATAXAMOUNT | CURR | 15 | |
| NETAMTNONDEDTAX | Net Amount of the Non-Opting Share | RESCNETAMTNONDEDTAX | CURR | 15 | |
| DEDUCT_TAX | Deductible Tax Amount | RERADEDTAXAMT | CURR | 15 | |
| NONDEDUCT_TAX | Non-Deductible Tax Amount | RERANONDEDTAXAMT | CURR | 15 | |
| NET_BALANCE | Net Balance | RESCNBALANCE | CURR | 15 | |
| TAX_BALANCE | Tax Amount Balance | RESCTBALANCE | CURR | 15 | |
| ADVPAYNETAMOUNT | Net Amount of Advanced Payment | RERAADVPAYNET | CURR | 15 | |
| ADVPAYTAXAMOUNT | Tax Amount of Advance Payment | RERAADVPAYTAX | 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 | |
| CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | |
| TERMNOPY | Number of Posting Term | RECDTERMNOPY | CHAR | 4 | |
| ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | |
| ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | |
| 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 | |
| CTFCNETBALANCE | Net Amount in Foreign Currency | RECACTFCNETAMOUNT | CURR | 15 | |
| CTFCTAXBALANCE | Tax Amount in Foreign Currency | RECACTFCTAXAMOUNT | CURR | 15 | |
| CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | * | CUKY | 5 |
| CTRULE | Currency Translation Rule | RECACTRULE | * | CHAR | 20 |
| CTRATE | Exchange Rate | RECACTRATE | DEC | 9 | |
| CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | |
| CTFCPOST | Post in Foreign Currency | RECACTFCPOST | CHAR | 1 | |
| POSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | |
| AMOUNT | Unit Price | RECDUNITPRICE | DEC | 19 | |
| AMOUNT_ROUNDED | Unit Price | RECDUNITPRICE | DEC | 19 | |
| GROSSAMT_ROUNDED | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | |
| 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 | |
| ENTRYTYPE | Entry Type | RESCCRENTRYTYPE | CHAR | 2 | |
| 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 VISCRECEIVABLE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VISCRECEIVABLE | CONDTYPE | : | TIVCDCONDTYPE |
| VISCRECEIVABLE | FLOWTYPE | : | TIVCDFLOWTYPE |
| VISCRECEIVABLE | TAXGROUP | : | TIVRATAXGROUP |
| VISCRECEIVABLE | TAXTYPE | : | TIVRATAXTYPE |