AVIYCADVPAY SAP (Change Document Structure Advance Payments in CAM (VIYCADVPA) Structure details

Dictionary Type: Structure
Description: Change Document Structure Advance Payments in CAM (VIYCADVPA




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




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

AVIYCADVPAY is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change Document Structure Advance Payments in CAM (VIYCADVPA" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_AVIYCADVPAY TYPE AVIYCADVPAY.

The AVIYCADVPAY table consists of various fields, each holding specific information or linking keys about Change Document Structure Advance Payments in CAM (VIYCADVPA data available in SAP. These include MANDT (Client), CAM_ADVPAY_GUID (Advance Payment in CAM Recovery), SETTL_GUID (Unique Key of Settlement), CAM_POOL_GUID (Expense Pool in CAM Recovery).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP AVIYCADVPAY structure 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_ADVPAY_GUIDAdvance Payment in CAM Recovery REYCADVPAYGUIDRAW16RECAGUID
SETTL_GUIDUnique Key of Settlement RECASETTLGUIDRAW16VISCSETTLRECAGUID
CAM_POOL_GUIDExpense Pool in CAM Recovery REYCPOOLGUIDRAW16RECAGUID
CNOBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
CFPAYGUIDGUID (RAW16) for Payment-Related Cash Flow RECDCFPAYGUIDRAW16RECAGUID
CONDGUIDGUID (RAW16) for Conditions RECDCONDGUIDRAW16RECAGUID
CONDVALIDFROMDate from when condition is valid RECDVALIDFROMDATS8RECADATE
REFGUIDGUID (RAW16) for Document References in Cash Flow RECDREFGUIDRAW16RECAGUID
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
BBWHRAmount which changes position TFM_BBWHRCURR23(2) TFM_WRTV12
BNWHRNominal amount TFM_BNWHRCURR23(2) TFM_WRTV12
DBERVONStart of Calculation Period DBERVONDATS8DATUM
SEXCLVONExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVONMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
DBERBISEnd of Calculation Period DBERBISDATS8DATUM
SINCLBISInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBISMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
DVALUTCalculation Date DVALUTDATS8DATUM
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SVINCLInclusive indicator for value date VVSVINCLNUMC1VVSINCL
SVULTMonth-End Indicator for Value Date VVSVULTCHAR1VVSULT
DFAELLDue date DFAELLDATS8DATUM
SFINCLInclusive Indicator for Due Date VVSFINCLNUMC1VVSINCL
SFULTMonth-End Indicator for Due Date SFULTCHAR1VVSULT
DDISPOPayment Date DDISPODATS8DATUM
SINCLVERRInclusive Indicator for Clearing Date VVSINCLVERNUMC1VVSINCLVER
SULTVERRMonth-End Indicator for Clearing Date VVSULTVERRCHAR1VVSULT
ATAGENumber of Days TFMATAGEINT410INT4
ABASTAGEAmount in floating point format for recursive determination BITERFLTP16(16) BFLTP
APERTAGENo. of days of a (calculation) period in cash flow VVAPERTAGENUMC6INT6
STGMETHDaily Method VVSTGMETHNUMC1VVSTGMETH
STGBASISBase Days Method VVSTGBASISNUMC1VVSTGBASIS
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
DBPERIODPeriod start VVDBPERIODDATS8DATUM
SPAEXCLExclusive Indicator for Start Date of a Period TFMSPAEXCLNUMC1TFMSPAEXCL
SPAULTMonth-End Indicator for Start Date of a Period TFMSPAULTCHAR1VVSULT
DEPERIODPeriod End VVDEPERIODDATS8DATUM
SPEINCLInclusive Indicator for End Date of a Period TFMSPEINCLNUMC1TFMSPEINCL
SPEULTMonth-End Indicator for End of a Period TFMSPEULTCHAR1VVSULT
SWHRKONDCurrency of Condition Item TFMWHRKONDCUKY5Assigned to domainTFM_WAERS
BKONDCondition item currency amount TFM_BKONDCURR17(2) TFM_WRTV9
SSTAFFType of Scaled Calculation TFMSSTAFFNUMC1TFMSSTAFF
SBASISCalculation Base Reference TFM_SBASISCHAR4TFM_SBASIS
JSOFVERRIndicator for Immediate Settlement (Financial Mathematics) TFMSOFVERRCHAR1TFMSOFVERR
AMMRHYFrequency in months AMMRHYNUMC3NUMC03
ATTRHYFrequency in Days ATTRHYNUMC3NUMC03
SSORTZITSort indicator for financial mathematic calculations TFM_SORTNUMC2NUMC2
SZEITANTIndicator for Pro Rata Temporis Calculations VVSZEITANTNUMC1VVSZEITANT
SSALBASIndicator for debit position/incoming pmnt (internal FiMa) TFMSSALBASCHAR1TFMSSALBAS
SKONDGRPCondition group in cash flow calculator SKONDGRPNUMC4SKONDGRP
LCNETAMOUNTNet Amount of Cash Flow Item in Local Currency RECDCFLCVALUENETCURR15(2) RECACURR
LCGROSSAMOUNTGross Amount of Cash Flow Item in Local Currency RECDCFLCVALUEGROSSCURR15(2) RECACURR
LCTAXAMOUNTSales/Purch. Tax Amount of Cash Flow Item in Local Currency RECDCFLCTAXVALUECURR15(2) RECACURR
LOCALCURRLocal Currency of Cash Flow Item RECDCFLCCURRCUKY5Assigned to domainWAERS
CCNETAMOUNTNet Amount of Cash Flow Item in Condition Currency RECDCFVALUENETCURR15(2) RECACURR
CCGROSSAMOUNTGross Amount of Cash Flow Item in Condition Currency RECDCFVALUEGROSSCURR15(2) RECACURR
CCTAXAMOUNTTax on Sales/Purch. of Cash Flow Item in Condition Currency RECDCFTAXVALUECURR15(2) RECACURR
CONDCURRCondition Currency of Cash Flow Item RECDCFCURRCUKY5Assigned to domainWAERS
TAXTYPETax Type RERATAXTYPECHAR4TIVRATAXTYPERERATAXTYPE
TAXGROUPTax Group RERATAXGROUPCHAR20TIVRATAXGROUPRERATAXGROUP
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
ISGROSSCondition Amount Is Gross Amount RECDISGROSSCHAR1RECABOOL
WHEREFROMFlow Origin RECDWHEREFROMCHAR1RECDWHEREFROM
FLOWTYPEFlow Type RECDFLOWTYPECHAR4Assigned to domainALPHARECDFLOWTYPE
ORIGFLOWTYPEOriginal Flow Type RECDORIGFLOWTYPECHAR4Assigned to domainALPHARECDFLOWTYPE
REFFLOWRELType of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWRELCHAR3Assigned to domainALPHARECDREFFLOWREL
CFSTATUSIndicates Status of Flow RECDCFSTATUSCHAR1RECDCFSTATUS
FDLEVPlanning level FDLEVCHAR2Assigned to domainFDLEVFFE
FDUPDFlag as to whether record enters cash management + forecast FDUPDCHAR1KENZX
FDELETEDeletion Indicator for Archiving RECAARDELETEINDCHAR1RECABOOL
ORIGDUEDATEOriginal Due Date RECDORIGDUEDATEDATS8DATUM
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PARTNEROBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
CONDTYPECondition Type RECDCONDTYPECHAR4Assigned to domainALPHARECDCONDTYPE
TERMNOPYNumber of Posting Term RECDTERMNOPYCHAR4ALPHARETMTERMNO
TERMNORHNumber of Frequency Term RECDTERMNORHCHAR4ALPHARETMTERMNO
TERMNOAJNumber of Adjustment Term RECDTERMNOAJCHAR4ALPHARETMTERMNO
TERMNOOANumber of Organizational Assignment Term RECDTERMNOOACHAR4ALPHARETMTERMNO
TERMNOSRNumber of Sales Term RECDTERMNOSRCHAR4ALPHARETMTERMNO
TERMNOMRNumber of Peak Sales Term RECDTERMNOMRCHAR4ALPHARETMTERMNO
TERMNOWTNumber of Withholding Tax Term RECDTERMNOWTCHAR4ALPHARETMTERMNO
ORIGEXDUEDATEOriginal Due Date RECDORIGDUEDATEDATS8DATUM
SEAPSTATUSStatus of Advance Payment Relevant to SCS RERASEAPSTATUSCHAR1RERASEAPSTATUS
POSTINGDATEPosting Date RECDPOSTINGDATEDATS8RECADATE
DOCUMENTDATEDocument Date RECDDOCUMENTDATEDATS8RECADATE
VALUATIONDATEDate for Translation of Contract Currency to Local Currency RECDVALUATIONDATEDATS8RECADATE
REVERSAL_FORGUID (RAW16) for 'Reversal for' References RECDREVERSALFORGUIDRAW16RECAGUID
REVERSAL_BYGUID (RAW16) for 'Reversed by' References RECDREVERSALBYGUIDRAW16RECAGUID
FOLLOWUP_FORGUID (RAW16) for 'Follow-Up Posting for' References RECDFOLLOWUPFORGUIDRAW16RECAGUID
BOOK_FLOWTYPEFlow Type RECDFLOWTYPECHAR4Assigned to domainALPHARECDFLOWTYPE
BOOK_REFFLOWRELType of Relationship Between Flow Type and Refer.Flow Type RECDREFFLOWRELCHAR3Assigned to domainALPHARECDREFFLOWREL
TAXDATEDate of Calculation of Sales/Purchase Tax RECDTAXDATEDATS8RECADATE
MODDUEDATEModified Due Date RECDMODDUEDATEDATS8DATUM
CALCDUEDATECalculated Due Date RECDCALCDUEDATEDATS8DATUM
CFSPLITFORGUIDGUID (RAW16) of Cash Flow Record That Was Split RECDCFSPLITFORGUIDRAW16RECAGUID
CFSPLITBASISCash Flow Record Was Basis for Split RECDCFSPLITBASISCHAR1RECABOOL
CDSPLITNONumber of Condition Split RETMCDSPLITNONUMC4NUMC4
COMPANYCODECompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
CMCFGROUPPlanning Group FDGRPCHAR10Assigned to domainALPHAFDGRPFFG
CTRULECurrency Translation Rule RECACTRULECHAR20Assigned to domainRECACTRULE
CTLCNETAMOUNTNet Amount in Local Currency RECACTLCNETAMOUNTCURR15(2) RECACURR
CTLCGROSSAMOUNTGross Amount in Local Currency RECACTLCGROSSAMOUNTCURR15(2) RECACURR
CTLCTAXAMOUNTTax Amount in Local Currency RECACTLCTAXAMOUNTCURR15(2) RECACURR
CTRATEExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
CTRATEORIGExchange Rate RECACTRATEDEC9(5) EXCRTKURSF
CTPOSTCDCURRPost in Condition Currency RECACTPOSTCDCURRCHAR1RECABOOL
CTDATEREQPlanned Translation Date RECACTDATEREQDATS8DATS
CTDATEACTActual Translation Date RECACTDATEACTDATS8DATS
CTDATEACTORIGActual Translation Date RECACTDATEACTDATS8DATS
CTDATEFROMCFPOSUse Translation Date from Cash Flow RECDCTDATEFROMCFPOSCHAR1RECABOOL
CTFCCURRKEYForeign Currency RECACTFCCURRKEYCUKY5Assigned to domainWAERS
IS_ITAX_OPTINGOpts RESCISITAXOPTINGCHAR1RECABOOL
ISCDSPLITCondition Split RETMISCDSPLITCHAR1RECABOOL
CTFCPOSTPost in Foreign Currency RECACTFCPOSTCHAR1RECABOOL
POSTCDCURRPost in Condition Currency RECACTPOSTCDCURRCHAR1RECABOOL
KZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND

Key field Non-key field



How do I retrieve data from SAP structure AVIYCADVPAY using ABAP code?

As AVIYCADVPAY is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on AVIYCADVPAY as there is no data to select.

How to access SAP table AVIYCADVPAY

Within an ECC or HANA version of SAP you can also view further information about AVIYCADVPAY 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!