VISCRECEIVABLE SAP table for – Receivables from Settlement

Here we would like to draw your attention to VISCRECEIVABLE table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VISCRECEIVABLE is a SAP standard transp table used for storing Receivables from Settlement related data in SAP. It comes under the package RE_SC_CR.

SAP VISCRECEIVABLE table

Table VISCRECEIVABLE technical data

TableVISCRECEIVABLE
Data storingReceivables from Settlement
ModuleRE
Sub ModuleRE-FX-SC
SAP PackageRE_SC_CR
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VISCRECEIVABLE Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VISCRECEIVABLE table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECEIVABLEGUID : Unique Key for Receivable
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • .INCLUDE : Key Fields of Table VISCRECEIVABLE
  • SCS_PERIOD_GUID : Rental Periods
    Its data type is RAW (Byte string) with field length 16
  • CONDTYPE : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • VALIDTO : Assignment Is Valid to This Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PARTNER : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • PARTNEROBJNR : Object Number for Internal Use
    Its data type is CHAR (Character String) with field length 22
  • .INCLUDE : Non-Key Fields of Table VISCRECEIVABLE
  • VALIDFROM : Period Start Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SETTL_GUID : Unique Key of Settlement
    Its data type is RAW (Byte string) with field length 16
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • IS_ITAX_OPTING : Opts
    Its data type is CHAR (Character String) with field length 1
  • TAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • TAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • TAXDATE : Date for defining tax rates
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GROSSAMOUNT : Gross Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • NET_AMOUNT : Net Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • NETAMTOPTING : Net Amount of the Opting Share
    Its data type is CURR (Currency Field) with field length 15
  • TAX_AMOUNT : Tax Amount in Transaction Currency
    Its data type is CURR (Currency Field) with field length 15
  • NETAMTNONDEDTAX : Net Amount of the Non-Opting Share
    Its data type is CURR (Currency Field) with field length 15
  • DEDUCT_TAX : Deductible Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • NONDEDUCT_TAX : Non-Deductible Tax Amount
    Its data type is CURR (Currency Field) with field length 15
  • NET_BALANCE : Net Balance
    Its data type is CURR (Currency Field) with field length 15
  • TAX_BALANCE : Tax Amount Balance
    Its data type is CURR (Currency Field) with field length 15
  • ADVPAYNETAMOUNT : Net Amount of Advanced Payment
    Its data type is CURR (Currency Field) with field length 15
  • ADVPAYTAXAMOUNT : Tax Amount of Advance Payment
    Its data type is CURR (Currency Field) with field length 15
  • CHRGNETAMOUNT : Net Surcharge Amount
    Its data type is CURR (Currency Field) with field length 15
  • CHRGTAXAMOUNT : Taxes on Management Costs Surcharge
    Its data type is CURR (Currency Field) with field length 15
  • CHRGFLOWTYPE : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • CHRGTAXTYPE : Tax Type
    Its data type is CHAR (Character String) with field length 4
  • CHRGTAXGROUP : Tax Group
    Its data type is CHAR (Character String) with field length 20
  • CHRGTXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • CHRGTAXDATE : Date for defining tax rates
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CONDGUID : GUID (RAW16) for Conditions
    Its data type is RAW (Byte string) with field length 16
  • TERMNOPY : Number of Posting Term
    Its data type is CHAR (Character String) with field length 4
  • ISCDSPLIT : Condition Split
    Its data type is CHAR (Character String) with field length 1
  • ISGROSS : Condition Amount Is Gross Amount
    Its data type is CHAR (Character String) with field length 1
  • CTFCGROSSAMOUNT : Gross Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCNETAMOUNT : Net Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCTAXAMOUNT : Tax Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCCHRGNETAMT : Net Surcharge Amount
    Its data type is CURR (Currency Field) with field length 15
  • CTFCCHRGTAXAMT : Taxes on Management Costs Surcharge
    Its data type is CURR (Currency Field) with field length 15
  • CTFCNETBALANCE : Net Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCTAXBALANCE : Tax Amount in Foreign Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTFCCURRKEY : Foreign Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CTRULE : Currency Translation Rule
    Its data type is CHAR (Character String) with field length 20
  • CTRATE : Exchange Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • CTDATEACT : Actual Translation Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CTFCPOST : Post in Foreign Currency
    Its data type is CHAR (Character String) with field length 1
  • POSTCDCURR : Post in Condition Currency
    Its data type is CHAR (Character String) with field length 1
  • AMOUNT : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • AMOUNT_ROUNDED : Unit Price
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 19
  • GROSSAMT_ROUNDED : Condition Amount Is Gross Amount
    Its data type is CHAR (Character String) with field length 1
  • CTLCNETAMOUNT : Net Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • CTLCTAXAMOUNT : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • ROUNDTYPE : Rounding Category of Unit Price
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ROUNDDECIMAL : No. of decimal places to which rounding should be performed
  • ROUNDUNIT : Unit to be rounded up to
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ENTRYTYPE : Entry Type
    Its data type is CHAR (Character String) with field length 2