P_DMVCMatlActyProcessCategory

DDL: P_DMVCMATLACTYPROCESSCATEGORY SQL: PDMVCMTATYPCCAT Type: view COMPOSITE

P_DMVCMatlActyProcessCategory is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ACDOCA) and exposes 22 fields with key fields CostEstimate, ProcessCategory.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
P_ACDOCA _acdoca left_outer

Parameters (4)

NameTypeDefault
P_DateFrom calendardate
P_DateTo calendardate
P_CurrencyType curtp
P_Ledger rldnr

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PDMVCMTATYPCCAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate _Activity CostEstimate
KEY ProcessCategory _Activity ProcessCategory
ObjectInternalID _Activity ObjectInternalID
Plant _Activity Plant
CompanyCode _Activity CompanyCode
ProfitCenter P_ACDOCA prctr
ProfitCenterMD _Activity ProfitCenter
ValuationArea _Activity ValuationArea
CostCenter _Activity CostCenter
CostCenterName _Activity CostCenterName
CostCtrActivityType _Activity CostCtrActivityType
ControllingArea _Activity ControllingArea
ValuationQuantityUnit _Activity ValuationQuantityUnit
Currency _Activity Currency
SourceLedger P_ACDOCA rldnr
SourceCompanyCode P_ACDOCA rbukrs
FiscalYear P_ACDOCA gjahr
AccountingDocument P_ACDOCA belnr
LedgerGLLineItem P_ACDOCA docln
Timestamp P_ACDOCA timestamp
CostCtrActivityTypeName
BusinessProcessName 
@AbapCatalog.sqlViewName: 'PDMVCMTATYPCCAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_DMVCMatlActyProcessCategory
  with parameters
    P_DateFrom     : calendardate,
    P_DateTo       : calendardate,
    P_CurrencyType : curtp,
    P_Ledger       : rldnr
  as select distinct from P_DMVCMatlActivityCostCenter( P_DateFrom     : :P_DateFrom,
                                                        P_DateTo       : :P_DateTo,
                                                        P_CurrencyType : :P_CurrencyType,
                                                        P_Ledger       : :P_Ledger) as _Activity

    left outer join       P_ACDOCA                                                                  as _acdoca on  _acdoca.objnr    = _Activity.ObjectInternalID
                                                                                                               and _acdoca.rldnr    = $parameters.P_Ledger
                                                                                                               and _acdoca.budat    >= $parameters.P_DateFrom
                                                                                                               and _acdoca.budat    <= $parameters.P_DateTo
                                                                                                               and _acdoca.co_belnr = _Activity.ReferenceDocument
                                                                                                               and _acdoca.co_buzei = _Activity.ReferenceDocumentItem


{
  key _Activity.CostEstimate,
  key _Activity.ProcessCategory,
      _Activity.ObjectInternalID,
      _Activity.Plant,
      _Activity.CompanyCode,
      _acdoca.prctr     as ProfitCenter,
      _Activity.ProfitCenter as ProfitCenterMD,
      _Activity.ValuationArea,
      _Activity.CostCenter,
      _Activity.CostCenterName,
      _Activity.CostCtrActivityType,
      _Activity.ControllingArea,
      _Activity.ValuationQuantityUnit,
      _Activity.Currency,
      
      _acdoca.rldnr     as SourceLedger,
      _acdoca.rbukrs    as SourceCompanyCode,
      _acdoca.gjahr     as FiscalYear,
      _acdoca.belnr     as AccountingDocument,
      _acdoca.docln     as LedgerGLLineItem,
      _acdoca.timestamp as Timestamp,
      _ActivityText[1: Language = $session.system_language].CostCtrActivityTypeName,
      _BusinessText[1: Language = $session.system_language].BusinessProcessName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPROCESSTEXT",
"I_COSTCENTERACTIVITYTYPETEXT",
"P_ACDOCA",
"P_DMVCMATLACTIVITYCOSTCENTER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More