FINOC_RULE_POI_BASE

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 FINOC_RULE_POI_BASE.
-- 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: FINOCV_RULE_POIB

CREATE VIEW FINOC_RULE_POI_BASE AS
SELECT
  PurgDocAccountAssignment.PurchasingDocument AS PurchasingDocument,
  PurgDocAccountAssignment.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurgDocAccountAssignment.AccountAssignmentNumber AS AccountAssignmentNumber,
  ProfitCenterToWBSElement.OrganizationalChange AS OrganizationalChange,
  ProfitCenterToWBSElement.ControllingArea AS ControllingArea,
  ProfitCenterToWBSElement.CompanyCode AS CompanyCode,
  ProfitCenterToWBSElement.ProfitCenterBeforeOrglChange AS ProfitCenterBeforeOrglChange,
  ProfitCenterToWBSElement.ProfitCenter AS ProfitCenterByOrglChange,
  cast(' ' as finoc_srce_matnr preserving type) AS SourceProduct,
  cast(' ' as finoc_srce_werks preserving type) AS SourcePlant,
  cast(' ' as finoc_srce_kdauf preserving type) AS SourceSalesDocument,
  cast('000000' as finoc_srce_kdpos preserving type) AS SourceSalesDocumentItem,
  cast(' ' as finoc_srce_kostl preserving type) AS SourceCostCenter,
  cast(' ' as finoc_srce_anln1 preserving type) AS SourceMasterFixedAsset,
  cast(' ' as finoc_srce_anln2 preserving type) AS SourceFixedAsset,
  cast(' ' as finoc_srce_aufnr preserving type) AS SourceOrder,
  cast(' ' as finoc_srce_vornr preserving type) AS SourceOperation,
  'WBS ' as SemanticObject AS PurchasingDocumentasPurchasingDocument,
  ProfitCenterToSalesOrderItem.SourceWBSElementInternalID AS SourceWBSElementInternalID,
  ProfitCenterToSalesOrderItem.SourceProjectInternalID AS SourceProjectInternalID,
  case when ProfitCenterToSalesOrderItem.ProfitCenterDerivationSrceType <> '' then cast(' ' as finoc_srce_kdauf preserving type ) else ProfitCenterToSalesOrderItem.SalesDocument end as SourceSalesDocument AS SalesDocumentendasSourceSalesDocument,
  cast('MA' as finoc_prctr_drvtn_source_type preserving type) AS ProfitCenterDerivationSrceType,
  case when ProfitCenterToNetworkActivity.ProfitCenterDerivationSrceType <> '' then ProfitCenterToNetworkActivity.SourceOrder else ProfitCenterToNetworkActivity.ProjectNetwork end as SourceOrder AS ProjectNetworkendasSourceOrder,
  case when ProfitCenterToNetworkActivity.ProfitCenterDerivationSrceType <> '' then cast(' ' as finoc_srce_vornr preserving type ) else ProfitCenterToNetworkActivity.NetworkActivity end as SourceOperation AS NetworkActivityendasSourceOperation,
  'REC' AS SemanticObject
FROM I_ProfitCenterToWBSElement AS ProfitCenterToWBSElement
INNER JOIN FINOC_RT_POI_ACC_ASGNMNT AS PurgDocAccountAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN FINOC_RT_POI_MONTHS AS PurchasingDocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrganizationalChange AS OrglChange ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProfitCenterToPurOrderItem AS ProfitCenterToPurOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderBasic AS AufkOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FINOC_RT_POI_ACC_ASGNMNT AS PurgDocAccountAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProjectNetwork AS ProjectNetwork ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ProfitCenterToSalesOrderItem, I_PrftCtrToProdCostCtrlgOrder, I_ProfitCenterToProduct, I_ProfitCenterToCostCenter, I_ProfitCenterToFixedAsset, I_ProfitCenterToNetworkActy, I_ProfitCenterToOrder, I_ProfitCenterToREContract
;