P_EBPAO_ORDERCONTEXTFORHDRONLY

CDS View

P_EBPAO_ORDERCONTEXTFORHDRONLY is a CDS View in S/4HANA. It contains 11 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 11 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
P_EBPAO_ActualCostDebit view inner COMPOSITE
P_EBPAO_ActualCostDebitKPI1 view inner COMPOSITE
P_EBPAO_ActualPlanQty view inner COMPOSITE
P_EBPAO_OrderPlanCost view inner COMPOSITE
P_EBPAO_TR_ActlPlnOutQtyDiff view inner COMPOSITE
P_EBPAO_TR_PlanCostDebit1 view inner COMPOSITE
P_EBPAO_TR_TotalVariance3 view from COMPOSITE
P_EBPAO_TR_VarianceByType3 view from COMPOSITE

Fields (11)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 8
KEY ControllingArea ControllingArea 7
KEY OrderCategory OrderCategory 8
KEY OrderID OrderID 8
KEY OrderType OrderType 8
KEY Plant Plant 8
KEY Product Product 8
KEY ProductGroup ProductGroup 8
KEY ProfitCenter ProfitCenter 8
KEY StorageLocation StorageLocation 7
BaseUnit BaseUnit 2 
@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_OrderContextForHdrOnly
  as select from           I_ProductCostCtrlgOrderItem as OrderItem
    inner join             I_ProductCostCtrlgOrder     as OrderHeader on  OrderHeader.OrderID                  = OrderItem.OrderID
                                                                      and OrderItem.OrderItem                  = '0001'
                                                                      and (
                                                                         OrderHeader.OrderCategory             = '10'
                                                                         or OrderHeader.OrderCategory          = '40'
                                                                       )
                                                                      and OrderHeader.OrderIsEventBasedPosting = 'X'
                                                                      and OrderHeader.ActualReleasedDate != '00000000'
    left outer to one join I_Product                   as Product     on Product.Product = OrderItem.Material
{

  key OrderHeader.OrderID,
  key OrderHeader.ObjectInternalID,
  key case
    when OrderHeader.MfgOrderHasMultipleItems = ''
      then OrderHeader.ObjectInternalID
    else OrderItem.ObjectInternalID
  end as ObjectInternalID4Qty,

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

Learn More