VIYCRECEIVABLE SAP (Receivables from Settlement) Table details

Dictionary Type: Table
Description: Receivables from Settlement




ABAP Code to SELECT data from VIYCRECEIVABLE
Related tables to VIYCRECEIVABLE
Access table VIYCRECEIVABLE




Table field list including key, data, relationships and ABAP select examples

VIYCRECEIVABLE is a standard SAP Table which is used to store Receivables from Settlement data and is available within R/3 SAP systems depending on the version and release level.

The VIYCRECEIVABLE table consists of various fields, each holding specific information or linking keys about Receivables from Settlement data available in SAP. These include CAM_RECEIVA_GUID (Unique Key for Receivable), SETTL_GUID (Unique Key of Settlement), CAM_POOL_GUID (Expense Pool in CAM Recovery), CNOBJNR (Object Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIYCRECEIVABLE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
CAM_RECEIVA_GUIDUnique Key for Receivable REYCRECEIVABLEGUIDRAW16RECAGUID
SETTL_GUIDUnique Key of Settlement RECASETTLGUIDRAW16RECAGUID
CAM_POOL_GUIDExpense Pool in CAM Recovery REYCPOOLGUIDRAW16RECAGUID
CNOBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
POOLOBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
CONDTYPECondition Type RECDCONDTYPECHAR4Assigned to domainALPHARECDCONDTYPE
CONDGUIDGUID (RAW16) for Conditions RECDCONDGUIDRAW16RECAGUID
ORIG_SETTL_GUIDUnique Key of Settlement RECASETTLGUIDRAW16RECAGUID
ISSUECREDITIssue Credit REYCISSUECREDITCHAR1REYCISSUECREDIT
CURRENCYCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
TAXTYPETax Type RERATAXTYPECHAR4TIVRATAXTYPERERATAXTYPE
TAXGROUPTax Group RERATAXGROUPCHAR20TIVRATAXGROUPRERATAXGROUP
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
TAXDATEDate for defining tax rates TXDATDATS8DATUM
AMTADJUSTEDNet Distribution Amount REYCAMTADJUSTEDCURR15(2) WERTV8
GROSSAMOUNTGross Amount in Transaction Currency RERAGROSSAMOUNTCURR15(2) RECACURR
NETAMOUNTNet Amount in Transaction Currency RERANETAMOUNTCURR15(2) RECACURR
ADNETAMOUNTAdjusted Net Amount REYCADNETAMOUNTCURR15(2) RECACURR
COSTADJTEXTCAMS COST ADJUSTMENT DESCRIPTION REYCCOSTADJTXTCHAR25TEXT25
TAXAMOUNTTax Amount in Transaction Currency RERATAXAMOUNTCURR15(2) RECACURR
ADVPAYNETAMOUNTNet Amount of Advanced Payment RERAADVPAYNETCURR15(2) RECACURR
ADVPAYTAXAMOUNTTax Amount of Advance Payment RERAADVPAYTAXCURR15(2) RECACURR
FINALADJAMOUNTFinal Adjustment Amount REYCFINALADJUSTMENTCURR15(2) RECACURR
TERMNOPYNumber of Posting Term RECDTERMNOPYCHAR4ALPHARETMTERMNO
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNEROBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
FLOWTYPEFlow Type RECDFLOWTYPECHAR4Assigned to domainALPHARECDFLOWTYPE
IS_ITAX_OPTINGOpts RESCISITAXOPTINGCHAR1RECABOOL
ISCDSPLITCondition Split RETMISCDSPLITCHAR1RECABOOL
ISGROSSCondition Amount Is Gross Amount RECDISGROSSCHAR1RECABOOL
CTFCNETAMOUNTNet Amount in Foreign Currency RECACTFCNETAMOUNTCURR15(2) RECACURR
CTFCTAXAMOUNTTax Amount in Foreign Currency RECACTFCTAXAMOUNTCURR15(2) RECACURR
CTFCNETBALANCENet Amount in Foreign Currency RECACTFCNETAMOUNTCURR15(2) RECACURR
CTFCTAXBALANCETax Amount in Foreign Currency RECACTFCTAXAMOUNTCURR15(2) RECACURR
CTFCCURRKEYForeign Currency RECACTFCCURRKEYCUKY5Assigned to domainWAERS
CTRULECurrency Translation Rule RECACTRULECHAR20Assigned to domainRECACTRULE
CTRATEExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
AMOUNT_ROUNDEDUnit Price RECDUNITPRICEDEC19(6) RECDUNITPRICE
GROSSAMT_ROUNDEDCondition Amount Is Gross Amount RECDISGROSSCHAR1RECABOOL
VALIDFROMPeriod Start Date RECAPERIODFROMDATS8RECADATEBEG
VALIDTOAssignment Is Valid to This Date RESCVALIDTO_UNIDATS8REDATRECADATEEND
CTDATEACTActual Translation Date RECACTDATEACTDATS8DATS
CTFCPOSTPost in Foreign Currency RECACTFCPOSTCHAR1RECABOOL
POSTCDCURRPost in Condition Currency RECACTPOSTCDCURRCHAR1RECABOOL
CTLCNETAMOUNTNet Amount in Local Currency RECACTLCNETAMOUNTCURR15(2) RECACURR
CTLCTAXAMOUNTTax Amount in Local Currency RECACTLCTAXAMOUNTCURR15(2) RECACURR
AMOUNTUnit Price RECDUNITPRICEDEC19(6) RECDUNITPRICE
NET_BALANCENet Balance RESCNBALANCECURR15(2) RECACURR
TAX_BALANCETax Amount Balance RESCTBALANCECURR15(2) RECACURR
ROUNDTYPERounding Category of Unit Price RECDROUNDTYPENUMC1RECDROUNDTYPE
ROUNDDECIMALNo. of decimal places to which rounding should be performed RECDROUNDDECIMALINT25
ROUNDUNITUnit to be rounded up to RECDROUNDUNITNUMC4NUM04

Key field Non-key field



How do I retrieve data from SAP table VIYCRECEIVABLE using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIYCRECEIVABLE to SELECT all data from the table
DATA: WA_VIYCRECEIVABLE TYPE VIYCRECEIVABLE.

SELECT SINGLE *
FROM VIYCRECEIVABLE
INTO CORRESPONDING FIELDS OF WA_VIYCRECEIVABLE
WHERE...

How to access SAP table VIYCRECEIVABLE

Within an ECC or HANA version of SAP you can also view further information about VIYCRECEIVABLE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!