P_DMVCOrderDetail

DDL: P_DMVCORDERDETAIL SQL: PDMVCORDDET Type: view BASIC

P_DMVCOrderDetail is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (P_ACDOCA) and exposes 12 fields with key fields SourceCompanyCode, AccountingDocument, LedgerGLLineItem, TransactionKey.

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 (7)

NameValueLevelField
AbapCatalog.sqlViewName PDMVCORDDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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

@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More