I_COProductCostByOrder

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_COProductCostByOrder.
-- 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: ICOPRDTCOSTBYORD
-- Parameters: P_FromFiscalYearPeriod : fis_jahrper, P_ToFiscalYearPeriod : fis_jahrper, P_PlanningCategory : fcom_category, P_ResultAnalysisVersion : versn

CREATE VIEW I_COProductCostByOrder AS
SELECT
  OrderID,
  ObjectInternalID,
  OrderType,
  OrderCategory,
  ReferenceOrder,
  ExternalOrder,
  OrderDescription,
  Plant,
  BaseUnit,
  ControllingArea,
  CompanyCode,
  BusinessArea,
  ProfitCenter,
  ResponsibleCostCenter,
  _RepresentativeOrderItem.WBSElementInternalID AS WBSElementInternalID,
  _RepresentativeOrderItem.ProductionVersion AS ProductionVersion,
  IsMarkedForDeletion,
  MfgOrderHasMultipleItems,
  ActualCostsCostingVariant,
  PlannedReleaseDate,
  PlannedCompletionDate,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  TechnicalCompletionDate,
  cast (ProducedProduct as fco_rtwip_product preserving type ) AS Material,
  _RepresentativeOrderItem.MRPPlant AS MRPPlant,
  _RepresentativeOrderItem.StorageLocation AS StorageLocation,
  cast(_RepresentativeOrderItem.ProductionUnit as fis_meinh preserving type ) AS ProductionUnit,
  _RepresentativeOrderItem.OrderItem AS OrderItem,
  ScheduledBasicEndDate,
  ScheduledReleaseDate,
  ActualStartDate,
  ConfirmedEndDate,
  ActualReleasedDate,
  ControllingObjectStatus,
  _ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  CompanyCodeCurrency,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityDate,
  _RepresentativeOrderItem.SalesOrder AS SalesOrder,
  cast(CreditActlCostInGlobalCrcy as fis_cr_actlcost_in_cocrcy) AS CreditActlCostInCtrlgAreaCrcy,
  cast(DebitActlCostInGlobalCrcy as fis_dr_actlcost_in_cocrcy) AS DebitActlCostInCtrlgAreaCrcy,
  cast(CreditActlCostInCoCodeCrcy as fis_cr_actlcost_in_cccrcy) AS CreditActlCostInCoCodeCrcy,
  cast(DebitActlCostInCoCodeCrcy as fis_dr_actlcost_in_cccrcy) AS DebitActlCostInCoCodeCrcy,
  cast(CrdtActlFxdCostInGlobalCrcy as fis_cr_actlfxdcost_in_cocrcy) AS CrdtActlFxdCostInCOCrcy,
  cast(DebitActlFxdCostInGlobalCrcy as fis_dr_actlfxdcost_in_cocrcy) AS DebitActlFxdCostInCOCrcy,
  cast(DebitActlFixedCostInCCCrcy as fis_dr_actlfxdcost_in_cccrcy) AS DebitActlFixedCostInCoCodeCrcy,
  cast(CreditActlFixedCostInCCCrcy as fis_cr_actlfxdcost_in_cccrcy) AS CreditActlFixedCostInCCCrcy,
  cast(CreditPlanCostInGlobalCrcy as fis_cr_plancost_in_cocrcy) AS CreditPlanCostInCtrlgAreaCrcy,
  cast(DebitPlanCostInGlobalCrcy as fis_dr_plancost_in_cocrcy) AS DebitPlanCostInCtrlgAreaCrcy,
  cast(CreditPlanCostInCoCodeCrcy as fis_cr_plancost_in_cccrcy) AS CreditPlanCostInCoCodeCrcy,
  cast(DebitPlanCostInCoCodeCrcy as fis_dr_plancost_in_cccrcy) AS DebitPlanCostInCoCodeCrcy,
  cast(CrdtPlnFxdCostInGlobalCrcy as fis_cr_plnfxdcost_in_cocrcy) AS CrdtPlnFxdCostInCtrlgAreaCrcy,
  cast(DebitPlnFxdCostInGlobalCrcy as fis_dr_plnfxdcost_in_cocrcy) AS DebitPlnFxdCostInCtrlgAreaCrcy,
  cast(DebitPlanFixedCostInCoCodeCrcy as fis_dr_planfxdcost_in_cccrcy) AS DebitPlanFixedCostInCoCodeCrcy,
  cast(CreditPlanFixedCostInCCCrcy as fis_cr_planfxdcost_in_cccrcy) AS CreditPlanFixedCostInCCCrcy,
  cast( CrdtTargetCostInGlobalCrcy as fis_cr_tgtcost_in_cocrcy) AS CrdtTargetCostInCtrlgAreaCrcy,
  cast(DebitTargetCostInGlobalCrcy as fis_dr_tgtcost_in_cocrcy) AS DebitTargetCostInCtrlgAreaCrcy,
  cast(CreditTargetCostInCoCodeCrcy as fis_cr_tgtcost_in_cccrcy) AS CreditTargetCostInCoCodeCrcy,
  cast(DebitTargetCostInCoCodeCrcy as fis_dr_tgtcost_in_cccrcy) AS DebitTargetCostInCoCodeCrcy,
  cast(InptPrVarcAmtInGlobalCrcy as fis_inptprvarcamt_in_cocrcy) AS InptPrVarcAmtInCtrlgAreaCrcy,
  cast(InptQtyVarcAmtInGlobalCrcy as fis_inptqtyvarcamt_in_cocrcy) AS InptQtyVarcAmtInCtrlgAreaCrcy,
  cast(RsceUsgeVarcAmtInGlobalCrcy as fis_rsceusgevarcamt_in_cocrcy) AS RsceUsgeVarcAmtInCtrlgAreaCrcy,
  cast(InptRmngVarcAmtInGlobalCrcy as fis_inptrmngvarcamt_in_cocrcy) AS InptRmngVarcAmtInCtrlgAreaCrcy,
  cast(MixedPrVarcAmtInGlobalCrcy as fis_mixedprvarcamt_in_cocrcy) AS MixedPrVarcAmtInCtrlgAreaCrcy,
  cast(OutpPrVarcAmtInGlobalCrcy as fis_outpprvarcamt_in_cocrcy) AS OutpPrVarcAmtInCtrlgAreaCrcy,
  cast(LotSizeVarcAmtInGlobalCrcy as fis_lotsizevarcamt_in_cocrcy) AS LotSizeVarcAmtInCtrlgAreaCrcy,
  cast(OutpQtyVarcAmtInGlobalCrcy as fis_qutpqtyvarcamt_in_cocrcy) AS OutpQtyVarcAmtInCtrlgAreaCrcy,
  cast(OutpRmngVarcAmtInGlobalCrcy as fis_outprmngvarcamt_in_cocrcy) AS OutpRmngVarcAmtInCtrlgAreaCrcy,
  cast(ScrapVarcAmtInGlobalCrcy as fis_scrapvarcamt_in_cocrcy) AS ScrapVarcAmtInCtrlgAreaCrcy,
  cast(InptPriceVarcAmtInCoCodeCrcy as fis_inptprvarcamt_in_cccrcy) AS InptPriceVarcAmtInCoCodeCrcy,
  cast(InptQtyVarcAmtInCoCodeCrcy as fis_inptqtyvarcamt_in_cccrcy) AS InptQtyVarcAmtInCoCodeCrcy,
  cast(RsceUsgeVarcAmtInCoCodeCrcy as fis_rsceusgevarcamt_in_cccrcy) AS RsceUsgeVarcAmtInCoCodeCrcy,
  cast(InputRmngVarcAmtInCoCodeCrcy as fis_inptrmngvarcamt_in_cccrcy) AS InputRmngVarcAmtInCoCodeCrcy,
  cast(MixedPrVarcAmtInCoCodeCrcy as fis_mixedprvarcamt_in_cccrcy) AS MixedPrVarcAmtInCoCodeCrcy,
  cast(OutpPrVarcAmtInCoCodeCrcy as fis_outpprvarcamt_in_cccrcy) AS OutpPrVarcAmtInCoCodeCrcy,
  cast(LotSizeVarcAmtInCoCodeCrcy as fis_lotsizevarcamt_in_cccrcy) AS LotSizeVarcAmtInCoCodeCrcy,
  cast(OutpQtyVarcAmtInCoCodeCrcy as fis_outpqtyvarcamt_in_cccrcy) AS OutpQtyVarcAmtInCoCodeCrcy,
  cast(OutputRmngVarcAmtInCoCodeCrcy as fis_outprmngvarcamt_in_cccrcy) AS OutputRmngVarcAmtInCoCodeCrcy,
  cast(ScrapVarcAmtInCoCodeCrcy as fis_scrapvarcamt_in_cccrcy) AS ScrapVarcAmtInCoCodeCrcy,
  cast(WIPAmountInGlobalCrcy as fis_wipcost_in_ctrlgareacrcy) AS WIPCostInCtrlgAreaCrcy,
  cast(UnrlzdCostRsrvAmtInGlobCrcy as fis_abgruekfk) AS UnrlzdCostRsrvAmtInGlobCrcy,
  cast(WIPCostInCoCodeCrcy as fis_wipcost_in_cccrcy) AS WIPCostInCoCodeCrcy,
  cast(UnrlzdCostRsrvAmtInCoCodeCrcy as fis_abgruekfk) AS UnrlzdCostRsrvAmtInCoCodeCrcy,
  cast(WIPAmountInGlobalCrcy - UnrlzdCostRsrvAmtInGlobCrcy as fco_eb_totalwipamt_in_dspcrcy) AS TotalWIPAmountInCOCrcy,
  cast(WIPCostInCoCodeCrcy - UnrlzdCostRsrvAmtInCoCodeCrcy as fco_eb_totalwipamt_in_dspcrcy) AS TotalWIPAmountInCoCodeCrcy,
  cast(PlanOutputQuantity as fis_plan_output_quantity) AS PlanOutputQuantity,
  cast(ActualOutputQuantity as fis_actual_output_quantity) AS ActualOutputQuantity,
  cast((DebitActlCostInGlobalCrcy - DebitPlanCostInGlobalCrcy) as fis_dr_actlplndiffcostincocrcy) AS DebitActlPlnDiffCostInCOCrcy,
  cast((DebitActlCostInCoCodeCrcy - DebitPlanCostInCoCodeCrcy) as fis_dractlplndiffcostincccrcy) AS DebitActlPlnDiffCostInCCCrcy,
  cast((DebitActlCostInCoCodeCrcy - DebitTargetCostInCoCodeCrcy) as fis_dractltgtdiffcostincccrcy) AS DebitActlTgtDiffCostInCCCrcy,
  ActualOutputQuantity - PlanOutputQuantity AS ActlPlanDiffOutputQuantity
FROM P_COProductCostByOrder
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ControllingAreaCurrency ON controllingareacurrency = _ControllingAreaCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON ControllingArea = _ResponsibleCostCenter.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter AND ValidityDate >= _ResponsibleCostCenter.ValidityStartDate AND ValidityDate <= _ResponsibleCostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter AND ValidityDate >= _ProfitCenter.ValidityStartDate AND ValidityDate <= _ProfitCenter.ValidityEndDate  -- association [0..*]
LEFT OUTER JOIN I_ProductCostCtrlgOrderItem AS _RepresentativeOrderItem ON OrderID = _RepresentativeOrderItem.OrderID AND _RepresentativeOrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_COCostCompGrpAmountByOrder AS _CostCompGrpAmountByOrder ON ObjectInternalID = _CostCompGrpAmountByOrder.ControllingObject AND OrderID = _CostCompGrpAmountByOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderSettlementRule AS _OrderSettlementRule ON ObjectInternalID = _OrderSettlementRule.ControllingObject AND _OrderSettlementRule.SettlementDistributionRuleGrp = '0000000000' AND _OrderSettlementRule.SettlementType = 'PER' AND _OrderSettlementRule.AccountAssignmentType = 'MA'  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON wbselementinternalid = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByContactCard ON CreatedByUser = _CreatedByContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON CreatedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN E_ProductCostCtrlgOrder AS _Extension ON OrderID = _Extension.OrderID  -- association [1..1]
;