How many fields does P_EBPC_COGM_CCGroup have?

P_EBPC_COGM_CCGroup has 82 fields. Key fields: Ledger, CompanyCode, OrderID.

P_EBPC_COGM_CCGroup

Q: Which tables does P_EBPC_COGM_CCGroup use?

P_EBPC_COGM_CCGroup reads from 3 data source(s): I_LedgerCompanyCodeCrcyRolesVH, P_CoEvtBsdOrderKeyStatus, P_EBPC_COGM_CCGroup5.

DDL: P_EBPC_COGM_CCGROUP SQL: PEBPRCOGMCCG Type: view COMPOSITE

P_EBPC_COGM_CCGroup is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_LedgerCompanyCodeCrcyRolesVH, P_CoEvtBsdOrderKeyStatus, P_EBPC_COGM_CCGroup5) and exposes 82 fields with key fields Ledger, CompanyCode, OrderID. It has 1 association to related views.

Data Sources (3)

Source	Alias	Join Type
I_LedgerCompanyCodeCrcyRolesVH	_LdgrCompCodeCrcy	inner
P_CoEvtBsdOrderKeyStatus	_OrderKeyStatus	inner
P_EBPC_COGM_CCGroup5	P_EBPC_COGM_CCGroup5	from

Parameters (5)

Name	Type	Default
P_Ledger	fins_ledger
P_FromFiscalYearPeriod	fins_fyearperiod
P_ToFiscalYearPeriod	fins_fyearperiod
P_CurrencyRole	fis_curtp
P_CostComponentStructure	ck_elesmhk

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_ProductCostCtrlgOrderItem	_RepresentativeOrderItem	`_Costs.OrderID = _RepresentativeOrderItem.OrderID and _RepresentativeOrderItem.OrderItem = '0001'`

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	PEBPRCOGMCCG	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view

Fields (82)

Key	Field	Source Table	Source Field
KEY	Ledger	I_LedgerCompanyCodeCrcyRolesVH	Ledger
KEY	CompanyCode	_Costs	CompanyCode
KEY	OrderID	_Costs	OrderID
	OrderDescription		OrderDescription
	ObjectInternalID		ObjectInternalID
	Material
	Plant		Plant
	ControllingArea		ControllingArea
	ControllingObjectStatus
	OrderKeyStatus
	OrderCategory		OrderCategory
	OrderType		OrderType
	ProfitCenter		ProfitCenter
	BusinessArea		BusinessArea
	ResponsibleCostCenter		ResponsibleCostCenter
	ActualCostsCostingVariant		ActualCostsCostingVariant
	PlannedCostsCostingVariant		PlannedCostsCostingVariant
	ExternalOrder		ExternalOrder
	ActualOutputQuantity
	BaseUnit
	ScheduledBasicEndDate		ScheduledBasicEndDate
	ScheduledReleaseDate		ScheduledReleaseDate
	ActualStartDate		ActualStartDate
	ConfirmedEndDate		ConfirmedEndDate
	ActualDeliveryDate		ActualDeliveryDate
	ActualReleasedDate		ActualReleasedDate
	TechnicalCompletionDate		TechnicalCompletionDate
	MRPPlant
	StorageLocation
	ProductionVersion	_RepresentativeOrderItem	ProductionVersion
	SalesOrder	_RepresentativeOrderItem	SalesOrder
	SalesOrderItem	_RepresentativeOrderItem	SalesOrderItem
	WBSElementInternalID
	ValuationType	_RepresentativeOrderItem	ValuationType
	CreatedByUser		CreatedByUser
	CreationDate		CreationDate
	LastChangedByUser		LastChangedByUser
	LastChangeDate		LastChangeDate
	DisplayCurrency	I_LedgerCompanyCodeCrcyRolesVH	Currency
	TotalAmountInDisplayCrcy
	MfgOrderHasMultipleItems		MfgOrderHasMultipleItems
	CostCompGrp1AmountInDC		CostCompGrp1AmountInDC
	CostCompGrp2AmountInDC		CostCompGrp2AmountInDC
	CostCompGrp3AmountInDC		CostCompGrp3AmountInDC
	CostCompGrp4AmountInDC		CostCompGrp4AmountInDC
	CostCompGrp5AmountInDC		CostCompGrp5AmountInDC
	CostCompGrp6AmountInDC		CostCompGrp6AmountInDC
	CostCompGrp7AmountInDC		CostCompGrp7AmountInDC
	CostCompGrp8AmountInDC		CostCompGrp8AmountInDC
	CostCompGrp9AmountInDC		CostCompGrp9AmountInDC
	CostCompGrp10AmountInDC		CostCompGrp10AmountInDC
	CostCompGrp11AmountInDC		CostCompGrp11AmountInDC
	CostCompGrp12AmountInDC		CostCompGrp12AmountInDC
	CostCompGrp13AmountInDC		CostCompGrp13AmountInDC
	CostCompGrp14AmountInDC		CostCompGrp14AmountInDC
	CostCompGrp15AmountInDC		CostCompGrp15AmountInDC
	CostCompGrp16AmountInDC		CostCompGrp16AmountInDC
	CostCompGrp17AmountInDC		CostCompGrp17AmountInDC
	CostCompGrp18AmountInDC		CostCompGrp18AmountInDC
	CostCompGrp19AmountInDC		CostCompGrp19AmountInDC
	CostCompGrp20AmountInDC		CostCompGrp20AmountInDC
	CostCompGrp21AmountInDC		CostCompGrp21AmountInDC
	CostCompGrp22AmountInDC		CostCompGrp22AmountInDC
	CostCompGrp23AmountInDC		CostCompGrp23AmountInDC
	CostCompGrp24AmountInDC		CostCompGrp24AmountInDC
	CostCompGrp25AmountInDC		CostCompGrp25AmountInDC
	CostCompGrp26AmountInDC		CostCompGrp26AmountInDC
	CostCompGrp27AmountInDC		CostCompGrp27AmountInDC
	CostCompGrp28AmountInDC		CostCompGrp28AmountInDC
	CostCompGrp29AmountInDC		CostCompGrp29AmountInDC
	CostCompGrp30AmountInDC		CostCompGrp30AmountInDC
	CostCompGrp31AmountInDC		CostCompGrp31AmountInDC
	CostCompGrp32AmountInDC		CostCompGrp32AmountInDC
	CostCompGrp33AmountInDC		CostCompGrp33AmountInDC
	CostCompGrp34AmountInDC		CostCompGrp34AmountInDC
	CostCompGrp35AmountInDC		CostCompGrp35AmountInDC
	CostCompGrp36AmountInDC		CostCompGrp36AmountInDC
	CostCompGrp37AmountInDC		CostCompGrp37AmountInDC
	CostCompGrp38AmountInDC		CostCompGrp38AmountInDC
	CostCompGrp39AmountInDC		CostCompGrp39AmountInDC
	CostCompGrp40AmountInDC		CostCompGrp40AmountInDC
	_RepresentativeOrderItem		_RepresentativeOrderItem

@AbapCatalog.sqlViewName: 'PEBPRCOGMCCG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

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

define view P_EBPC_COGM_CCGroup
  with parameters
    P_Ledger                 : fins_ledger,
    P_FromFiscalYearPeriod   : fins_fyearperiod,
    P_ToFiscalYearPeriod     : fins_fyearperiod,
    P_CurrencyRole           : fis_curtp,
    P_CostComponentStructure : ck_elesmhk

  as select from           P_EBPC_COGM_CCGroup5( P_Ledger                : :P_Ledger,
                                                 P_FromFiscalYearPeriod  : :P_FromFiscalYearPeriod,
                                                 P_ToFiscalYearPeriod    : :P_ToFiscalYearPeriod,
                                                 P_CurrencyRole          : :P_CurrencyRole,
                                                 P_CostComponentStructure: :P_CostComponentStructure )     as _Costs

  //Order Key Statuses - REL, PREL, CNF, DLV, CLSD, TECO, DLFL

    inner join             P_CoEvtBsdOrderKeyStatus                                                        as _OrderKeyStatus   on _Costs.ObjectInternalID = _OrderKeyStatus.ControllingObject
    inner join             I_LedgerCompanyCodeCrcyRolesVH                                                  as _LdgrCompCodeCrcy on  _LdgrCompCodeCrcy.Ledger       = :P_Ledger
                                                                                                                                and _LdgrCompCodeCrcy.CompanyCode  = _Costs.CompanyCode
                                                                                                                                and _LdgrCompCodeCrcy.CurrencyRole = :P_CurrencyRole

  // Order Quantities

    left outer to one join P_EBPC_MfgActualOutputQuantity( P_Ledger              : :P_Ledger, 
                                                           P_FromFiscalYearPeriod: :P_FromFiscalYearPeriod,
                                                           P_ToFiscalYearPeriod  : :P_ToFiscalYearPeriod ) as _ActualOutpQty    on  _ActualOutpQty.ControllingObject = _Costs.ObjectInternalID
                                                                                                                                and _ActualOutpQty.CompanyCode       = _Costs.CompanyCode
  //    left outer to one join P_EBPC_MfgOutputQuantity( P_FromFiscalYearPeriod: :P_FromFiscalYearPeriod,

  //                                                     P_ToFiscalYearPeriod  : :P_ToFiscalYearPeriod )   as _OrderOutpQty     on _OrderOutpQty.ControllingObject = _Costs.ObjectInternalID


  association [0..1] to I_ProductCostCtrlgOrderItem as _RepresentativeOrderItem on  _Costs.OrderID                     = _RepresentativeOrderItem.OrderID
                                                                                and _RepresentativeOrderItem.OrderItem = '0001'
{
  key _LdgrCompCodeCrcy.Ledger,
  key _Costs.CompanyCode,
  key _Costs.OrderID,

      OrderDescription,
      ObjectInternalID,
      cast(_RepresentativeOrderItem.Material as fco_rtwip_product preserving type)                        as Material,
      Plant,
      ControllingArea,

      // Order Status /////////////////////////////////////////////////

      cast(_OrderKeyStatus.ControllingObjectStatus as fco_current_order_status)                           as ControllingObjectStatus,

      // Order Key Status /////////////////////////////////////////////////

      cast(_OrderKeyStatus.StatusCode as fco_current_order_key_status)                                    as OrderKeyStatus,

      OrderCategory,
      OrderType,
      ProfitCenter,
      BusinessArea,
      ResponsibleCostCenter,

      ActualCostsCostingVariant,
      PlannedCostsCostingVariant,

      ExternalOrder,
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      cast(_ActualOutpQty.ActualOutputQuantity as fis_actual_output_quantity)                             as ActualOutputQuantity,
      @Semantics.unitOfMeasure: true
      cast(_RepresentativeOrderItem.BaseUnit as fis_meinh)                                                as BaseUnit,

      ScheduledBasicEndDate,
      ScheduledReleaseDate,
      ActualStartDate,
      ConfirmedEndDate,
      ActualDeliveryDate,
      ActualReleasedDate,
      TechnicalCompletionDate,

      cast(_RepresentativeOrderItem.MRPPlant as fis_co_pwerk)                                             as MRPPlant,
      cast(_RepresentativeOrderItem.StorageLocation as fis_lgort_d)                                       as StorageLocation,
      _RepresentativeOrderItem.ProductionVersion,
      _RepresentativeOrderItem.SalesOrder,
      _RepresentativeOrderItem.SalesOrderItem,
      cast(_RepresentativeOrderItem.WBSElementInternalID as fco_ebpr_wbs_element_int_id preserving type ) as WBSElementInternalID,
      _RepresentativeOrderItem.ValuationType,

      CreatedByUser,
      CreationDate,
      LastChangedByUser,
      LastChangeDate,

      @Semantics.currencyCode: true
      _LdgrCompCodeCrcy.Currency                                                                          as DisplayCurrency,

      @Semantics.amount.currencyCode: 'DisplayCurrency'
      cast (_Costs.TotalAmountInDisplayCrcy as fis_actlcost_in_dspcrcy)                                   as TotalAmountInDisplayCrcy,

      MfgOrderHasMultipleItems,

      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp1AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp2AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp3AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp4AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp5AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp6AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp7AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp8AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp9AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp10AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp11AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp12AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp13AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp14AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp15AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp16AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp17AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp18AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp19AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp20AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp21AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp22AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp23AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp24AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp25AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp26AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp27AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp28AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp29AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp30AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp31AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp32AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp33AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp34AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp35AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp36AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp37AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp38AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp39AmountInDC,
      @Semantics.amount.currencyCode: 'DisplayCurrency'
      CostCompGrp40AmountInDC,

      _RepresentativeOrderItem
}

Depth:

P_EBPC_COGM_CCGroup view

P_EBPC_COGM_CCGroup5 view
I_LedgerCompanyCodeCrcyRolesVH view_entity
P_CoEvtBsdOrderKeyStatus view

C_RealTimeProdnCostCompGroup view