VIYCCOST2DC SAP (Application of Distribution / Denominator Method) Table details
Dictionary Type: Table
Description: Application of Distribution / Denominator Method
Description: Application of Distribution / Denominator Method
Table field list including key, data, relationships and ABAP select examples
VIYCCOST2DC is a standard SAP Table which is used to store Application of Distribution / Denominator Method data and is available within R/3 SAP systems depending on the version and release level.
The VIYCCOST2DC table consists of various fields, each holding specific information or linking keys about Application of Distribution / Denominator Method data available in SAP. These include CAM_DC_GUID (Unique Key of Distribution / Denominator Method), SETTL_GUID (Unique Key of Settlement), CAM_EXP_GUID (Cost of 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: Cannot Be Enhanced
SAP VIYCCOST2DC 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_DC_GUID | Unique Key of Distribution / Denominator Method | REYCCOSTDCGUID | RAW | 16 | RECAGUID | ||||
SETTL_GUID | Unique Key of Settlement | RECASETTLGUID | RAW | 16 | RECAGUID | ||||
CAM_EXP_GUID | Cost of CAM Recovery | REYCCOSTGUID | 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 | ||||
EXPLINEGUID | Expense Type of CAM Pool | REYCEXPGUID | RAW | 16 | RECAGUID | ||||
PGID | Participation Group | RESCPGID | CHAR | 10 | ALPHA | RESCPGID | RESCPGID | RESCPG | |
EXPTYPE | Expense Type | REYCEXPTYPE | CHAR | 4 | REYCEXPTYPE | ||||
OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
KSTAR | Cost Element | KSTAR | CHAR | 10 | Assigned to domain | ALPHA | KSTAR | KAT | |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RO_OBJNR | Object Number of Rental Object | RESCROOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
AMOUNTTYPE | Amount Type | REYCAMTTYPE | NUMC | 2 | REYCAMTTYPE | ||||
TERMNO_PROV | Term Number | RETMTERMNO | CHAR | 4 | ALPHA | RETMTERMNO | |||
PROVISIONMETHOD | CAM Provision Type Selection | REYCPROVISIONMETHOD | CHAR | 2 | REYCPROVTYPE | ||||
GROSSUPMETHOD | Gross-Up Method | REYCGROSSUPMETHOD | CHAR | 2 | REYCGROSSMETHOD | ||||
BASEMETHOD | Method | REYCBASEMETHOD | CHAR | 2 | REYCBASEMETHOD | ||||
DENMETHOD | Denominator Method in CAM | REYCDENMETHOD | CHAR | 4 | REYCDENMETHOD | ||||
DENMETHODINT | Internal Denominator Method in CAM | REYCDENMETHODINT | CHAR | 4 | REYCDENMETHODINT | ||||
OCCUPIEDMEAS | Determination Based on Occupied Measurement Share | REYCOCCUPIEDMEAS | CHAR | 1 | RECABOOL | ||||
DENMEAS | Denominator Measurement Type | REYCDENMEAS | CHAR | 4 | Assigned to domain | ALPHA | REBDMEAS | REBDMEAS | REBDMEAS |
MVAPPORTAVERAGE | Measurement Rental Unit | REYCMVAPPORTAVERAGE | QUAN | 17(4) | REBDMEASVALUE | ||||
MVOCCAVERAGE | Measurement Total Occupancy | REYCMVOCCAVERAGE | QUAN | 17(4) | REBDMEASVALUE | ||||
MVTOTALAVERAGE | Measurement Total | REYCMVTOTALAVERAGE | QUAN | 17(4) | REBDMEASVALUE | ||||
MEASUNIT | Measurement Unit | REBDMEASUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PLENGTHTOTAL | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
APPORTVALUE | Reference Factor for a Rental Unit | REYCAPPORTVALUE | DEC | 20(8) | REYCAPPORTVALUE | ||||
OCCAPPORTTOTAL | Reference Factors Total Occupancy | REYCOCCAPPORTVALUETOTAL | DEC | 20(8) | REYCAPPORTVALUE | ||||
APPORTVALUETOTAL | Reference Factors Total | REYCAPPORTVALUETOTAL | DEC | 20(8) | REYCAPPORTVALUE | ||||
MTAPPORTVALUE | Reference Factor Major Tenant | REYCMTAPPORTVALUE | DEC | 20(8) | REYCAPPORTVALUE | ||||
DENOMINATOR | Fixed Denominator | REYCDENOMINATOR | DEC | 15(2) | REYC_FIXED_DENOM | ||||
BASEYEARAMT | Base Year Amount | REYCBASEYEARAMT | CURR | 15(2) | REYCBASEYEARAMNT | ||||
BASEYEARRATE | Base Year Rate | REYCBASEYEARRATE | CURR | 15(2) | REYC_D_BASERATE | ||||
CURRYEARAMT | Current Year Amount | REYCCURRYEARAMT | CURR | 15(2) | REYCBASEYEARAMNT | ||||
CURRYEARRATE | Current Year Rate | REYCCURRYEARRATE | CURR | 15(2) | REYC_D_CURRRATE | ||||
CURRBYAMT | Current Base Year Amount | REYCCURRBYAMT | CURR | 15(2) | REYCBASEYEARAMNT | ||||
GROSSUPBYAMT | Gross-Up Base Year Amount | REYCGROSSUPBYAMT | CURR | 15(2) | REYCBASEYEARAMNT | ||||
STOPYEARAMT | Stop Amount | REYCSTOPYEARAMT | CURR | 15(2) | REYCBASEYEARAMNT | ||||
STOPYEARRATE | Stop Year Rate | REYCSTOPYEARRATE | CURR | 15(2) | REYC_D_STOPRATE | ||||
CURRENTSTOPAMT | Current Stop Amount | REYCCURRENTSTOPAMT | CURR | 15(2) | REYCBASEYEARAMNT | ||||
ACTUALOCCRATE | Occupancy Rate Percentage | REYCOCCRATE | DEC | 9(2) | REYCPERCENT | ||||
OCCRATE | Occupancy Rate Percentage | REYCOCCRATE | DEC | 9(2) | REYCPERCENT | ||||
GROSSRATE | Gross-Up Rate | REYCGROSSRATE | CURR | 15(2) | REYC_D_GROSSRATE | ||||
GROSSAMNT | Gross-Up Amount | REYCGROSSAMNT | CURR | 15(2) | REYCGROSSAMNT | ||||
THRESHOLD | Threshold | REYCDENOMTHRESHOLD | DEC | 9(2) | REYCPERCENT | ||||
ACTOCCRATE | Actual Occupancy Rate | REYCACTUALOCCRATE | DEC | 9(2) | REYCPERCENT | ||||
ADJDENOMINATOR | Adjusted Denominator | REYCADJDENOMINATOR | DEC | 20(8) | REYCAPPORTVALUE | ||||
FIXEDSHARE | Fixed Share | REYCFIXEDSHARE | DEC | 15(2) | REYC_SHARE_FIXED | ||||
NETAMOUNT | Net Amount in Object Currency | RECONETAMOUNT | CURR | 15(2) | RECACURR | ||||
AMT4DISTRIBUTION | Amount for Distribution | REYCAMT4DISTRIBUTION | CURR | 15(2) | WERTV8 | ||||
EXPTYPESHARE | Share at Expense Type Level | REYCEXPTYPESHARE | DEC | 15(6) | REYC_SHARE_LONG | ||||
EXPENSE2SHARE | Expenses to Share | REYCEXP2SHARE | CURR | 15(2) | WERTV8 | ||||
GROSSUP_ACTEXP | Grossed-Up Actual Expense | REYCGROSSUP_ACTEXP | CURR | 15(2) | WERTV8 | ||||
TENANTSHARE | Tenant's Share of Expenses | REYCTENANTSHARE | DEC | 15(6) | REYC_SHARE_LONG | ||||
PRESETTLAMT | Pre-Settled Amount | REYCPRESETTLAMT | CURR | 15(2) | WERTV8 | ||||
AMT_DC | Distributed Value in Transaction Currency | REYCAMT_DC | CURR | 15(2) | WERTV8 | ||||
MTCFLAG | Major Tenant Contrubution Indicator for Contract | REYCMTCFLAG | CHAR | 1 | RECABOOL | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
PFROM | Period Start Date | RECAPERIODFROM | DATS | 8 | RECADATEBEG | ||||
PTO | Period End Date | RECAPERIODTO | DATS | 8 | REDAT | RECADATEEND | |||
CYISBY | Base Year Provision - Current Year is Base Year | REYCCYISBY | CHAR | 1 | RECABOOL | ||||
BYCUMMALATIVE | Base Year Provision - Cumulative Base Year | REYCBYCUMULATIVE | CHAR | 1 | RECABOOL | ||||
CUMULATIVEEXP | Cumulative Expense | REYCCUMULATIVEEXP | CURR | 15(2) | RECACURR | ||||
CUMUNETDIFF | Cumulative Expense Net Difference | REYCCUMUNETDIFF | CURR | 15(2) | RECACURR |
Key field | Non-key field |
How do I retrieve data from SAP table VIYCCOST2DC using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIYCCOST2DC to SELECT all data from the tableDATA: WA_VIYCCOST2DC TYPE VIYCCOST2DC.
SELECT SINGLE *
FROM VIYCCOST2DC
INTO CORRESPONDING FIELDS OF WA_VIYCCOST2DC
WHERE...
How to access SAP table VIYCCOST2DC
Within an ECC or HANA version of SAP you can also view further information about VIYCCOST2DC 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