I_COCostCompGrpAmountByOrder

DDL: I_COCOSTCOMPGRPAMOUNTBYORDER SQL: IFICCGAMTBYORD Type: view COMPOSITE Package: ODATA_PRODUCTION_COST_ANALYSIS
38 Fields 1 Data Sources 2 Associations

Cost Component Group Amount By Order

I_COCostCompGrpAmountByOrder is a Composite CDS View that provides data about "Cost Component Group Amount By Order" in SAP S/4HANA. It reads from 1 data source (P_COCostCompGrpAmountByOrder) and exposes 38 fields with key field ControllingObject. It has 2 associations to related views. Part of development package ODATA_PRODUCTION_COST_ANALYSIS.

Data Sources (1)

SourceAliasJoin Type
P_COCostCompGrpAmountByOrder P_COCostCompGrpAmountByOrder from

Parameters (3)

NameTypeDefault
P_FromFiscalYearPeriod fis_jahrper
P_ToFiscalYearPeriod fis_jahrper
P_CostComponentGroup char100

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFICCGAMTBYORD view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cost Component Group Amount By Order view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.buffering.type #NONE view
AbapCatalog.buffering.numberOfKeyFields 0 view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject Object number
OrderID
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
ControllingAreaCurrency _ControllingArea ControllingAreaCurrency
CompanyCodeCurrency _CompanyCode Currency Valuation Crcy
ControllingAreaCrcyP01Amt ControllingAreaCrcyP01Amt
ControllingAreaCrcyP02Amt ControllingAreaCrcyP02Amt
ControllingAreaCrcyP03Amt ControllingAreaCrcyP03Amt
ControllingAreaCrcyP04Amt ControllingAreaCrcyP04Amt
ControllingAreaCrcyP05Amt ControllingAreaCrcyP05Amt
ControllingAreaCrcyP06Amt ControllingAreaCrcyP06Amt
ControllingAreaCrcyP07Amt ControllingAreaCrcyP07Amt
ControllingAreaCrcyP08Amt ControllingAreaCrcyP08Amt
ControllingAreaCrcyP09Amt ControllingAreaCrcyP09Amt
ControllingAreaCrcyP10Amt ControllingAreaCrcyP10Amt
ControllingAreaCrcyP11Amt ControllingAreaCrcyP11Amt
ControllingAreaCrcyP12Amt ControllingAreaCrcyP12Amt
ControllingAreaCrcyP13Amt ControllingAreaCrcyP13Amt
ControllingAreaCrcyP14Amt ControllingAreaCrcyP14Amt
ControllingAreaCrcyP15Amt ControllingAreaCrcyP15Amt
ControllingAreaCrcyP16Amt ControllingAreaCrcyP16Amt
ObjectCrcyP01Amt ObjectCrcyP01Amt
ObjectCrcyP02Amt ObjectCrcyP02Amt
ObjectCrcyP03Amt ObjectCrcyP03Amt
ObjectCrcyP04Amt ObjectCrcyP04Amt
ObjectCrcyP05Amt ObjectCrcyP05Amt
ObjectCrcyP06Amt ObjectCrcyP06Amt
ObjectCrcyP07Amt ObjectCrcyP07Amt
ObjectCrcyP08Amt ObjectCrcyP08Amt
ObjectCrcyP09Amt ObjectCrcyP09Amt
ObjectCrcyP10Amt ObjectCrcyP10Amt
ObjectCrcyP11Amt ObjectCrcyP11Amt
ObjectCrcyP12Amt ObjectCrcyP12Amt
ObjectCrcyP13Amt ObjectCrcyP13Amt
ObjectCrcyP14Amt ObjectCrcyP14Amt
ObjectCrcyP15Amt ObjectCrcyP15Amt
ObjectCrcyP16Amt ObjectCrcyP16Amt

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_COCostCompGrpAmountByOrder.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFICCGAMTBYORD
-- Parameters: P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_CostComponentGroup : char100

CREATE VIEW I_COCostCompGrpAmountByOrder AS
SELECT
  ControllingObject,
  cast(_COCostCompGrp.OrderID as fis_order_number) AS OrderID,
  ControllingArea,
  CompanyCode,
  _ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  ControllingAreaCrcyP01Amt,
  ControllingAreaCrcyP02Amt,
  ControllingAreaCrcyP03Amt,
  ControllingAreaCrcyP04Amt,
  ControllingAreaCrcyP05Amt,
  ControllingAreaCrcyP06Amt,
  ControllingAreaCrcyP07Amt,
  ControllingAreaCrcyP08Amt,
  ControllingAreaCrcyP09Amt,
  ControllingAreaCrcyP10Amt,
  ControllingAreaCrcyP11Amt,
  ControllingAreaCrcyP12Amt,
  ControllingAreaCrcyP13Amt,
  ControllingAreaCrcyP14Amt,
  ControllingAreaCrcyP15Amt,
  ControllingAreaCrcyP16Amt,
  ObjectCrcyP01Amt,
  ObjectCrcyP02Amt,
  ObjectCrcyP03Amt,
  ObjectCrcyP04Amt,
  ObjectCrcyP05Amt,
  ObjectCrcyP06Amt,
  ObjectCrcyP07Amt,
  ObjectCrcyP08Amt,
  ObjectCrcyP09Amt,
  ObjectCrcyP10Amt,
  ObjectCrcyP11Amt,
  ObjectCrcyP12Amt,
  ObjectCrcyP13Amt,
  ObjectCrcyP14Amt,
  ObjectCrcyP15Amt,
  ObjectCrcyP16Amt
FROM P_COCostCompGrpAmountByOrder
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;

Learn More