P_DACRActualCostingPeriods

DDL: P_DACRACTUALCOSTINGPERIODS SQL: PDACRACTCSTPER Type: view COMPOSITE

DACR Actual Costing Periods

P_DACRActualCostingPeriods is a Composite CDS View that provides data about "DACR Actual Costing Periods" in SAP S/4HANA. It reads from 4 data sources (I_CompanyCode, P_DMVCMinMaxPeriod, P_DACRPlant, I_ValuationArea) and exposes 1 field with key field FiscalYearPeriod.

4 data source(s) 1 fields

Data Sources (4)

SourceAliasJoin Type
I_CompanyCode _CompanyCode inner
P_DMVCMinMaxPeriod _PerMinMax inner
P_DACRPlant _Plant inner
I_ValuationArea _ValuationArea inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PDACRACTCSTPER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label DACR Actual Costing Periods view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY FiscalYearPeriod 
@AbapCatalog.sqlViewName: 'PDACRACTCSTPER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'DACR Actual Costing Periods'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_DACRActualCostingPeriods
  as select distinct from I_FiscalPeriodForVariant as _FiscalPeriod
    inner join            I_CompanyCode            as _CompanyCode   on _FiscalPeriod.FiscalYearVariant = _CompanyCode.FiscalYearVariant
    inner join            I_ValuationArea          as _ValuationArea on _ValuationArea.CompanyCode = _CompanyCode.CompanyCode
    inner join            P_DACRPlant              as _Plant         on _ValuationArea.ValuationArea = _Plant.ValuationArea
    inner join            P_DMVCMinMaxPeriod       as _PerMinMax     on _FiscalPeriod.FiscalYearPeriod between _PerMinMax.MIN_JAHRPER and _PerMinMax.MAX_JAHRPER
{
  key cast ( _FiscalPeriod.FiscalYearPeriod as jahrper ) as FiscalYearPeriod
}
where
      _Plant.mgvupd                 = 'X'
  and _FiscalPeriod.IsSpecialPeriod = '';

Learn More