P_EBPAO_AdjustedOrder4Quantity

DDL: P_EBPAO_ADJUSTEDORDER4QUANTITY Type: view_entity COMPOSITE

P_EBPAO_AdjustedOrder4Quantity is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ProductCostCtrlgOrder, I_ProductCostCtrlgOrderItem, I_Product) and exposes 11 fields with key field ObjectInternalIDendasObjectInternalID.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_ProductCostCtrlgOrder OrderHeader inner
I_ProductCostCtrlgOrderItem OrderItem from
I_Product Product inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ObjectInternalIDendasObjectInternalID
OrderID I_ProductCostCtrlgOrder OrderID
CompanyCode I_ProductCostCtrlgOrder CompanyCode
Plant I_ProductCostCtrlgOrder Plant
ProfitCenter I_ProductCostCtrlgOrder ProfitCenter
OrderCategory I_ProductCostCtrlgOrder OrderCategory
OrderType I_ProductCostCtrlgOrder OrderType
ControllingArea I_ProductCostCtrlgOrder ControllingArea
StorageLocation I_ProductCostCtrlgOrderItem StorageLocation
Product I_Product Product
ProductGroup I_Product ProductGroup 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #D,
    sizeCategory: #L,
    dataClass: #MIXED
}

@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_EBPAO_AdjustedOrder4Quantity
  as select from I_ProductCostCtrlgOrderItem as OrderItem
    inner join   I_ProductCostCtrlgOrder     as OrderHeader on  OrderHeader.OrderID                  = OrderItem.OrderID
                                                            and (
                                                               OrderHeader.OrderCategory             = '10'
                                                               or OrderHeader.OrderCategory          = '40'
                                                             )
                                                            and OrderHeader.OrderIsEventBasedPosting = 'X'
                                                            and OrderHeader.ActualReleasedDate != '00000000'
    inner join   I_Product                   as Product     on Product.Product = OrderItem.Material
{
  key case
    when OrderHeader.MfgOrderHasMultipleItems = ''
      then OrderHeader.ObjectInternalID
    else OrderItem.ObjectInternalID
  end as ObjectInternalID,

      OrderHeader.OrderID,
      OrderHeader.CompanyCode,
      OrderHeader.Plant,
      OrderHeader.ProfitCenter,
      OrderHeader.OrderCategory,
      OrderHeader.OrderType,
      OrderHeader.ControllingArea,
      OrderItem.StorageLocation,
      Product.Product,
      Product.ProductGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT",
"I_PRODUCTCOSTCTRLGORDER",
"I_PRODUCTCOSTCTRLGORDERITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More