AVIYCADVPAY SAP (Change Document Structure Advance Payments in CAM (VIYCADVPA) Structure details
Description: Change Document Structure Advance Payments in CAM (VIYCADVPA
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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
CAM_ADVPAY_GUID | Advance Payment in CAM Recovery | REYCADVPAYGUID | RAW | 16 | RECAGUID | ||||
SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | RAW | 16 | VISCSETTL | RECAGUID | |||
CAM_POOL_GUID | Expense Pool in CAM Recovery | REYCPOOLGUID | RAW | 16 | RECAGUID | ||||
CNOBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
CFPAYGUID | GUID (RAW16) for Payment-Related Cash Flow | RECDCFPAYGUID | RAW | 16 | RECAGUID | ||||
CONDGUID | GUID (RAW16) for Conditions | RECDCONDGUID | RAW | 16 | RECAGUID | ||||
CONDVALIDFROM | Date from when condition is valid | RECDVALIDFROM | DATS | 8 | RECADATE | ||||
REFGUID | GUID (RAW16) for Document References in Cash Flow | RECDREFGUID | RAW | 16 | RECAGUID | ||||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
BBWHR | Amount which changes position | TFM_BBWHR | CURR | 23(2) | TFM_WRTV12 | ||||
BNWHR | Nominal amount | TFM_BNWHR | CURR | 23(2) | TFM_WRTV12 | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | VVSEXCLVON | ||||
SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | VVSULT | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | VVSINCLBIS | ||||
SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | VVSULT | ||||
DVALUT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
SVINCL | Inclusive indicator for value date | VVSVINCL | NUMC | 1 | VVSINCL | ||||
SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | VVSULT | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
SFINCL | Inclusive Indicator for Due Date | VVSFINCL | NUMC | 1 | VVSINCL | ||||
SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | VVSULT | ||||
DDISPO | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | VVSINCLVER | ||||
SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | VVSULT | ||||
ATAGE | Number of Days | TFMATAGE | INT4 | 10 | INT4 | ||||
ABASTAGE | Amount in floating point format for recursive determination | BITER | FLTP | 16(16) | BFLTP | ||||
APERTAGE | No. of days of a (calculation) period in cash flow | VVAPERTAGE | NUMC | 6 | INT6 | ||||
STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | VVSTGMETH | ||||
STGBASIS | Base Days Method | VVSTGBASIS | NUMC | 1 | VVSTGBASIS | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | DATUM | ||||
SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | TFMSPAEXCL | ||||
SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | VVSULT | ||||
DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | DATUM | ||||
SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | TFMSPEINCL | ||||
SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | VVSULT | ||||
SWHRKOND | Currency of Condition Item | TFMWHRKOND | CUKY | 5 | Assigned to domain | TFM_WAERS | |||
BKOND | Condition item currency amount | TFM_BKOND | CURR | 17(2) | TFM_WRTV9 | ||||
SSTAFF | Type of Scaled Calculation | TFMSSTAFF | NUMC | 1 | TFMSSTAFF | ||||
SBASIS | Calculation Base Reference | TFM_SBASIS | CHAR | 4 | TFM_SBASIS | ||||
JSOFVERR | Indicator for Immediate Settlement (Financial Mathematics) | TFMSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | NUMC03 | ||||
SSORTZIT | Sort indicator for financial mathematic calculations | TFM_SORT | NUMC | 2 | NUMC2 | ||||
SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | VVSZEITANT | ||||
SSALBAS | Indicator for debit position/incoming pmnt (internal FiMa) | TFMSSALBAS | CHAR | 1 | TFMSSALBAS | ||||
SKONDGRP | Condition group in cash flow calculator | SKONDGRP | NUMC | 4 | SKONDGRP | ||||
LCNETAMOUNT | Net Amount of Cash Flow Item in Local Currency | RECDCFLCVALUENET | CURR | 15(2) | RECACURR | ||||
LCGROSSAMOUNT | Gross Amount of Cash Flow Item in Local Currency | RECDCFLCVALUEGROSS | CURR | 15(2) | RECACURR | ||||
LCTAXAMOUNT | Sales/Purch. Tax Amount of Cash Flow Item in Local Currency | RECDCFLCTAXVALUE | CURR | 15(2) | RECACURR | ||||
LOCALCURR | Local Currency of Cash Flow Item | RECDCFLCCURR | CUKY | 5 | Assigned to domain | WAERS | |||
CCNETAMOUNT | Net Amount of Cash Flow Item in Condition Currency | RECDCFVALUENET | CURR | 15(2) | RECACURR | ||||
CCGROSSAMOUNT | Gross Amount of Cash Flow Item in Condition Currency | RECDCFVALUEGROSS | CURR | 15(2) | RECACURR | ||||
CCTAXAMOUNT | Tax on Sales/Purch. of Cash Flow Item in Condition Currency | RECDCFTAXVALUE | CURR | 15(2) | RECACURR | ||||
CONDCURR | Condition Currency of Cash Flow Item | RECDCFCURR | CUKY | 5 | Assigned to domain | WAERS | |||
TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | TIVRATAXTYPE | RERATAXTYPE | |||
TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | TIVRATAXGROUP | RERATAXGROUP | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
ISGROSS | Condition Amount Is Gross Amount | RECDISGROSS | CHAR | 1 | RECABOOL | ||||
WHEREFROM | Flow Origin | RECDWHEREFROM | CHAR | 1 | RECDWHEREFROM | ||||
FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDFLOWTYPE | ||
ORIGFLOWTYPE | Original Flow Type | RECDORIGFLOWTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDFLOWTYPE | ||
REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | CHAR | 3 | Assigned to domain | ALPHA | RECDREFFLOWREL | ||
CFSTATUS | Indicates Status of Flow | RECDCFSTATUS | CHAR | 1 | RECDCFSTATUS | ||||
FDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
FDUPD | Flag as to whether record enters cash management + forecast | FDUPD | CHAR | 1 | KENZX | ||||
FDELETE | Deletion Indicator for Archiving | RECAARDELETEIND | CHAR | 1 | RECABOOL | ||||
ORIGDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | DATUM | ||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PARTNEROBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDTYPE | ||
TERMNOPY | Number of Posting Term | RECDTERMNOPY | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNORH | Number of Frequency Term | RECDTERMNORH | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOAJ | Number of Adjustment Term | RECDTERMNOAJ | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOOA | Number of Organizational Assignment Term | RECDTERMNOOA | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOSR | Number of Sales Term | RECDTERMNOSR | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOMR | Number of Peak Sales Term | RECDTERMNOMR | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNOWT | Number of Withholding Tax Term | RECDTERMNOWT | CHAR | 4 | ALPHA | RETMTERMNO | |||
ORIGEXDUEDATE | Original Due Date | RECDORIGDUEDATE | DATS | 8 | DATUM | ||||
SEAPSTATUS | Status of Advance Payment Relevant to SCS | RERASEAPSTATUS | CHAR | 1 | RERASEAPSTATUS | ||||
POSTINGDATE | Posting Date | RECDPOSTINGDATE | DATS | 8 | RECADATE | ||||
DOCUMENTDATE | Document Date | RECDDOCUMENTDATE | DATS | 8 | RECADATE | ||||
VALUATIONDATE | Date for Translation of Contract Currency to Local Currency | RECDVALUATIONDATE | DATS | 8 | RECADATE | ||||
REVERSAL_FOR | GUID (RAW16) for 'Reversal for' References | RECDREVERSALFORGUID | RAW | 16 | RECAGUID | ||||
REVERSAL_BY | GUID (RAW16) for 'Reversed by' References | RECDREVERSALBYGUID | RAW | 16 | RECAGUID | ||||
FOLLOWUP_FOR | GUID (RAW16) for 'Follow-Up Posting for' References | RECDFOLLOWUPFORGUID | RAW | 16 | RECAGUID | ||||
BOOK_FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDFLOWTYPE | ||
BOOK_REFFLOWREL | Type of Relationship Between Flow Type and Refer.Flow Type | RECDREFFLOWREL | CHAR | 3 | Assigned to domain | ALPHA | RECDREFFLOWREL | ||
TAXDATE | Date of Calculation of Sales/Purchase Tax | RECDTAXDATE | DATS | 8 | RECADATE | ||||
MODDUEDATE | Modified Due Date | RECDMODDUEDATE | DATS | 8 | DATUM | ||||
CALCDUEDATE | Calculated Due Date | RECDCALCDUEDATE | DATS | 8 | DATUM | ||||
CFSPLITFORGUID | GUID (RAW16) of Cash Flow Record That Was Split | RECDCFSPLITFORGUID | RAW | 16 | RECAGUID | ||||
CFSPLITBASIS | Cash Flow Record Was Basis for Split | RECDCFSPLITBASIS | CHAR | 1 | RECABOOL | ||||
CDSPLITNO | Number of Condition Split | RETMCDSPLITNO | NUMC | 4 | NUMC4 | ||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
CMCFGROUP | Planning Group | FDGRP | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
CTRULE | Currency Translation Rule | RECACTRULE | CHAR | 20 | Assigned to domain | RECACTRULE | |||
CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15(2) | RECACURR | ||||
CTRATE | Exchange Rate | RECACTRATE | DEC | 9(5) | EXCRT | KURSF | |||
CTRATEORIG | Exchange Rate | RECACTRATE | DEC | 9(5) | EXCRT | KURSF | |||
CTPOSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | RECABOOL | ||||
CTDATEREQ | Planned Translation Date | RECACTDATEREQ | DATS | 8 | DATS | ||||
CTDATEACT | Actual Translation Date | RECACTDATEACT | DATS | 8 | DATS | ||||
CTDATEACTORIG | Actual Translation Date | RECACTDATEACT | DATS | 8 | DATS | ||||
CTDATEFROMCFPOS | Use Translation Date from Cash Flow | RECDCTDATEFROMCFPOS | CHAR | 1 | RECABOOL | ||||
CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | CUKY | 5 | Assigned to domain | WAERS | |||
IS_ITAX_OPTING | Opts | RESCISITAXOPTING | CHAR | 1 | RECABOOL | ||||
ISCDSPLIT | Condition Split | RETMISCDSPLIT | CHAR | 1 | RECABOOL | ||||
CTFCPOST | Post in Foreign Currency | RECACTFCPOST | CHAR | 1 | RECABOOL | ||||
POSTCDCURR | Post in Condition Currency | RECACTPOSTCDCURR | CHAR | 1 | RECABOOL | ||||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects