I_RevnAcctgFulfillment

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_RevnAcctgFulfillment.
-- 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.

CREATE VIEW I_RevnAcctgFulfillment AS
SELECT
  guid AS RevnAcctgFulfillmentUUID,
  cast(pob_id as farr_cds_pob_id preserving type) AS PerformanceObligation,
  recon_key AS RevnAcctgReconciliationKey,
  company_code AS CompanyCode,
  acct_principle AS AccountingPrinciple,
  group_guid AS RevnAcctgFulfillmentGroupUUID,
  compound_fulfill_group_guid AS RACompndFulfillmentGroupUUID,
  substring(recon_key, 1, 7) AS FiscalYearPeriod,
  cast(reported_qty as farr_cds_reported_fulf_qty preserving type) AS ReportedFulfilledQuantity,
  reported_qty_unt AS FulfilledQuantityUnit,
  cast (actual_qty as farr_actual_fulfilled_qty preserving type) AS ActualFulfilledQuantity,
  amount AS FulfilledAmountInSlsDocCrcy,
  amount_curk AS SalesDocumentCurrency,
  event_date AS PerfOblgnFulfillmentDate,
  event_type AS PerfOblgnEventType,
  created_by AS FulfillmentCreatedByUser,
  created_ts AS FulfillmentCreationDateTime,
  manual_spreading AS FlfmtAmtIsCrtedByMnlSprdg,
  entry_category AS RAFulfillmentItemCategory
FROM farr_d_fulfillmt
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON FulfilledQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON FulfillmentCreatedByUser = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_RAPerformanceObligation AS _PerformanceObligation ON PerformanceObligation = _PerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN I_RAPerfObligationEventType AS _PerfObligationEventType ON PerfOblgnEventType = _PerfObligationEventType.PerfOblgnEventType  -- association [0..1]
LEFT OUTER JOIN I_RAFulfillmentMapping AS _Mapping ON RevnAcctgFulfillmentGroupUUID = _Mapping.RevnAcctgFulfillmentGroupUUID  -- association [0..*]
;