P_DMVCOrderDetail

DDL: P_DMVCORDERDETAIL SQL: PDMVCORDDET Type: view BASIC Package: ODATA_ML_MATLVCA_DISP

Order Details for DMVC

P_DMVCOrderDetail is a Basic CDS View that provides data about "Order Details for DMVC" in SAP S/4HANA. It reads from 1 data source (P_ACDOCA) and exposes 12 fields with key fields SourceCompanyCode, AccountingDocument, LedgerGLLineItem, TransactionKey. Part of development package ODATA_ML_MATLVCA_DISP.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
P_ACDOCA _acdoca from

Parameters (3)

NameTypeDefault
P_DateFrom calendardate
P_DateTo calendardate
P_Ledger rldnr

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PDMVCORDDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SourceCompanyCode P_ACDOCA rbukrs
KEY AccountingDocument P_ACDOCA belnr
KEY LedgerGLLineItem P_ACDOCA docln
KEY TransactionKey P_ACDOCA ktosl
PurchasingDocument P_ACDOCA ebeln
PurchasingDocumentItem P_ACDOCA ebelp
ProductionOrder P_ACDOCA aufnr
ProductionProcess P_ACDOCA qsprocess
SalesOrder P_ACDOCA kdauf
SalesOrderItem P_ACDOCA kdpos
ProcessCategory P_ACDOCA mlptyp
CostEstimate P_ACDOCA kalnr 
@AbapCatalog.sqlViewName: 'PDMVCORDDET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #XXL,
    dataClass: #MIXED
}

@VDM.viewType: #BASIC
@VDM.private:true
define view P_DMVCOrderDetail
  with parameters
    P_DateFrom        : calendardate,
    P_DateTo          : calendardate,
    //P_TransactionKey  : fac_ktosl,

    //P_ProcessCategory : ml_ptyp_org,

    P_Ledger          : rldnr
  as select from P_ACDOCA as _acdoca
{
  key _acdoca.rbukrs    as SourceCompanyCode,
  key _acdoca.belnr     as AccountingDocument,
  key _acdoca.docln     as LedgerGLLineItem,
  key _acdoca.ktosl     as TransactionKey,

      _acdoca.ebeln     as PurchasingDocument,
      _acdoca.ebelp     as PurchasingDocumentItem,

      _acdoca.aufnr     as ProductionOrder,

      _acdoca.qsprocess as ProductionProcess,

      _acdoca.kdauf     as SalesOrder,
      _acdoca.kdpos     as SalesOrderItem,

      _acdoca.mlptyp    as ProcessCategory,

      _acdoca.kalnr     as CostEstimate
}
where
      _acdoca.budat  >= $parameters.P_DateFrom
  and _acdoca.budat  <= $parameters.P_DateTo
//  and _acdoca.ktosl  = $parameters.P_TransactionKey

//  and _acdoca.mlptyp = $parameters.P_ProcessCategory

  and _acdoca.rldnr  = $parameters.P_Ledger

Learn More