VIYCCOST2POOL SAP (Determined Costs for Lease in CAM Recovery) Table details
Dictionary Type: Table
Description: Determined Costs for Lease in CAM Recovery
Description: Determined Costs for Lease in CAM Recovery
ABAP Code to SELECT data from VIYCCOST2POOL
Related tables to VIYCCOST2POOL
Access table VIYCCOST2POOL
Related tables to VIYCCOST2POOL
Access table VIYCCOST2POOL
Table field list including key, data, relationships and ABAP select examples
VIYCCOST2POOL is a standard SAP Table which is used to store Determined Costs for Lease in CAM Recovery data and is available within R/3 SAP systems depending on the version and release level.
The VIYCCOST2POOL table consists of various fields, each holding specific information or linking keys about Determined Costs for Lease in CAM Recovery data available in SAP. These include CAM_EXP_GUID (Cost of CAM Recovery), SETTL_GUID (Unique Key of Settlement), CNOBJNR (Object Number), RECNNR (Contract 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 VIYCCOST2POOL 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
CAM_EXP_GUID | Cost of CAM Recovery | REYCCOSTGUID | RAW | 16 | RECAGUID | ||||
SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | RAW | 16 | RECAGUID | ||||
CNOBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
RECNNR | Contract Number | RECNNUMBER | CHAR | 13 | ALPHA | RECNNUMBER | RECNNR | RECNCN | |
CAM_POOL_GUID | Expense Pool in CAM Recovery | REYCPOOLGUID | RAW | 16 | RECAGUID | ||||
POOLOBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
EXPPOOL | Expense Pool | REYCEXPPOOL | NUMC | 4 | REYCEXPPOOL | ||||
EXPTYPE | Expense Type | REYCEXPTYPE | CHAR | 4 | REYCEXPTYPE | ||||
SHORTFALLLINE | Shortfall Line Item | REYCSHORTFALLLINE | CHAR | 1 | RECABOOL | ||||
OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
RO_OBJNR | Object Number of Rental Object | RESCROOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
EXPLINEGUID | Expense Type of CAM Pool | REYCEXPGUID | RAW | 16 | RECAGUID | ||||
PGOBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
PGID | Participation Group | RESCPGID | CHAR | 10 | ALPHA | RESCPGID | RESCPGID | RESCPG | |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
REFSETTLGUID | Reference Settlement Guid | REYCREFSETTLGUID | RAW | 16 | RECAGUID | ||||
CAM_MS_GUID | Cost of CAM Recovery | REYCCOSTGUID | RAW | 16 | RECAGUID | ||||
TERMNO_PROV | Term Number | RETMTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNO_MARK | Term Number | RETMTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
TERMNO_CAP | Term Number | RETMTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
COST2OBJ_GUID | Cost of CAM Recovery | REYCCOSTGUID | RAW | 16 | RECAGUID | ||||
NETAMOUNTPRE | Net Amount in Object Currency | RECONETAMOUNT | CURR | 15(2) | RECACURR | ||||
SERVVALIDFROM | Start of Service Period | REYCSERVVALIDFROM | DATS | 8 | RECADATE | ||||
SERVVALIDTO | End of Service Period | REYCSERVVALIDTO | DATS | 8 | RECADATE | ||||
SEASONDAYLEASE | Seasonal Days Contract | REYCSEASONDAYLEASE | NUMC | 6 | INT6 | ||||
SEASONDAYSERV | Seasonal Days Service | REYCSEASONDAYSERV | NUMC | 6 | INT6 | ||||
APPORTIONMENT | Apportionment Seasonal Days for Contract and Service | REYCAPPORTIONMENT | DEC | 15(6) | REYC_SHARE_LONG | ||||
NETAMOUNT | Adjusted Net Original Costs | REYCADJNETAMOUNT | CURR | 15(2) | WERTV8 | ||||
COSTADJTEXT | CAMS COST ADJUSTMENT DESCRIPTION | REYCCOSTADJTXT | CHAR | 25 | TEXT25 | ||||
AMOUNTTYPE | Amount Type | REYCAMTTYPE | NUMC | 2 | REYCAMTTYPE | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
MARKUPPERCPRE | Markup Percentage Before Distribution | REYCMARKUPPERCPRE | DEC | 9(2) | REYCPERCENT | ||||
MARKUPAMNTPRE | Markup Amount Before Distribution | REYCMARKUPAMNTPRE | CURR | 15(2) | REYCBASEAMNT | ||||
ADMINFEEPRE | Administrative Fee | REYCADMINFEEPRE | CURR | 13(2) | WERT7 | ||||
ADJUSTMENT | Final Markup Amount | REYCFINALMARKUPAMT | CURR | 15(2) | WERTV8 | ||||
AMTAFTERMK | Amount After Markup | REYCAMTAFTERMK | CURR | 15(2) | WERTV8 | ||||
PLENGTHTOTAL | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
APPORTVALUE | Reference Factor for a Rental Unit | REYCAPPORTVALUE | DEC | 20(8) | REYCAPPORTVALUE | ||||
MEASVALUE | Measurement Amount | RESCROMEASVALUE | QUAN | 17(4) | REBDMEASVALUE | ||||
MEASUNIT | Measurement Unit | REBDMEASUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CAPPINGRATEPRE | Capping Rate Before Distribution | REYCCAPPINGRATEPRE | DEC | 9(2) | REYCPERCENT | ||||
CAPPINGAMNTPRE | Capping Amount Before Distribution | REYCCAPPINGAMNTPRE | CURR | 15(2) | REYCBASEAMNT | ||||
LESSAMNTRATEPRE | Lesser of Capping Amount and Capping Rate (Before) | REYCLESSAMNTRATEPRE | CHAR | 1 | RECABOOL | ||||
PRESETTLAMT | Pre-Settled Amount | REYCPRESETTLAMT | CURR | 15(2) | WERTV8 | ||||
FINALCAPAMT | Final Capping Amount | REYCFINALCAPAMT | CURR | 15(2) | WERTV8 | ||||
AMTAFTERCAP | Amount After Capping | REYCAMTAFTERCAP | CURR | 15(2) | WERTV8 | ||||
MTCFLAG | Major Tenant Contrubution Indicator for Contract | REYCMTCFLAG | CHAR | 1 | RECABOOL | ||||
PREAPPLIEDMTC | Major Tenant Contribution Total Pre-applied | REYCPREAPPLIEDMTC | CURR | 15(2) | WERTV8 | ||||
CURRENTMTC | Major Tenant Contribution Total Current | REYCCURRENTMTC | CURR | 15(2) | WERTV8 | ||||
MTCDEDUCTTOTAL | Major Tenant Contribution Total Deduction | REYCMTCDEDUCTTOTAL | CURR | 15(2) | WERTV8 | ||||
POOLDISTAMT | Amount for Distribution | REYCAMT4DISTRIBUTION | CURR | 15(2) | WERTV8 | ||||
AMT4DISTRIBUTION | Pool Distributable Amount | REYCPOOLDISTAMT | CURR | 15(2) | WERTV8 | ||||
PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | RECADATEBEG | ||||
PTO | Period End Date | RECAPERIODTO | DATS | 8 | REDAT | RECADATEEND | |||
SEASONALITYKEY | Seasonality | REYCSEASONKEY | CHAR | 4 | REYCSEASON | ||||
BYCUMMALATIVE | Base Year Provision - Cumulative Base Year | REYCBYCUMULATIVE | CHAR | 1 | RECABOOL | ||||
DELETIONFLAG | Deletion Flag - deleted in step 5, should show in step 3 | REYCDELETIONFLAG | CHAR | 1 | RECABOOL | ||||
INSERTIONFLAG | Insertion Flag - Inserted in Step 5, do not show in step 3 | REYCINSERTIONFLAG | CHAR | 1 | RECABOOL |
Key field | Non-key field |
How do I retrieve data from SAP table VIYCCOST2POOL using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIYCCOST2POOL to SELECT all data from the tableDATA: WA_VIYCCOST2POOL TYPE VIYCCOST2POOL.
SELECT SINGLE *
FROM VIYCCOST2POOL
INTO CORRESPONDING FIELDS OF WA_VIYCCOST2POOL
WHERE...
How to access SAP table VIYCCOST2POOL
Within an ECC or HANA version of SAP you can also view further information about VIYCCOST2POOL 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