P_PLANDATA_RT_06

CDS View

P_PLANDATA_RT_06 is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PLANDATA_RT_07 view from COMPOSITE 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PPLANDATA_06'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
//@AccessControl.authorizationCheck: #NOT_ALLOWED

@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view P_PlanData_RT_06
  with parameters
    P_CreationDateTimeRgFr :timestamp,
    P_CreationDateTimeRgTo :timestamp

  as select from P_PlanData_RT_05
                 (P_CreationDateTimeRgFr : :P_CreationDateTimeRgFr,
                            P_CreationDateTimeRgTo : :P_CreationDateTimeRgTo) as Source
{


  // begin of bbr n2850362: synchronize subitem and sender fields

  cast(
    case CnsldtnSubitemSource
        when '01' then left(SubItem,3)
        else FinancialTransactionType end
  as rmvct)      as FinancialTransactionType,
  cast(
    case CnsldtnSubitemSource
        when '02' then left(SubItem,16)
        else FunctionalArea end
  as fkber)      as FunctionalArea,
  cast(
    case CnsldtnSubitemSource
        when '03' then left(SubItem,4)
        else BusinessArea end
  as gsber)      as BusinessArea,
  cast(
    case CnsldtnSubitemSource
        when '05' then left(SubItem,10)
        else CostCenter end
  as kostl)      as CostCenter,
  cast(
    case CnsldtnSubitemSource
        when '06' then left(SubItem,10)
        else GLAccount end
  as racct)      as GLAccount,
  cast(
    case CnsldtnSubitemSource
        when '07' then left(SubItem,10)
        else ProfitCenter end
  as prctr)      as ProfitCenter,
  cast(
    case CnsldtnSubitemSource
        when '08' then left(SubItem,10)
        else Segment end
  as fb_segment) as Segment,
  // end of bbr n2850362


  // case

  Source.SubItemCategory,
  Source.SubItem,
  Source.PartnerConsolidationUnit,
  Source.BaseUnit,
  Source.QuantityInBaseUnit,

  // I_CnsldtnFinStmntItem

  Source.BreakdownCategory,

  // I_FSItemMappingAssgmtWithVers

  Source.FinancialStatementItem,
  Source.ConsolidationChartOfAccounts,

  // P_ConsolidationUnitCurrency

  Source.CnsldtnUnitLocalCrcySource,

  // tfin010

  Source.ConsolidationDimension,
  Source.ConsolidationUnit,

  // I_CnsldtnVersion

  Source.ConsolidationVersion,

  // t881

  Source.ConsolidationLedger,

  // I_FiscalCalendarDate / Or other source

  Source.FiscalPeriod,
  Source.FiscalYear,

  // specific fileds for this cds view

  Source.FinancialPlanningReqTransSqnc,
  Source.FinancialPlanningDataPacket,
  Source.FinancialPlanningEntryItem,

  // Currencies and currency amounts

  Source.BalanceTransactionCurrency,
  Source.AmountInTransactionCurrency,
  
  Source.ConsolidationUnitLocalCurrency,
  Source.AmountInCompanyCodeCurrency as AmountInLocalCurrency,
  
  Source.GroupCurrency,
  Source.AmountInGlobalCurrency as AmountInGroupCurrency

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PLANDATA_RT_05"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More