I_CtrlgObjectSettlementRule

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_CtrlgObjectSettlementRule.
-- 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: ICTRLGOBJSETRULE

CREATE VIEW I_CtrlgObjectSettlementRule AS
SELECT
  objnr AS ControllingObject,
  cast(ernam as fin_usnam preserving type ) AS CreatedByUser,
  erdat AS CreationDate,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  ktext AS CtrlgObjectSettlementRuleName,
  cast(absch as fco_brgabsch preserving type ) AS AllocationStructure,
  kstar AS SettlementGLAccount,
  cast(ursch as fco_ursch preserving type) AS SettlementSourceStructure,
  analg AS SettlementIsProportional,
  ersav AS SettlementRuleHasUpdateError,
  cast(aprof as fco_aprof preserving type ) AS ControllingSettlementProfile,
  abrnr AS SettlementSequentialNumber,
  cast(bzdat as fco_bzdat preserving type) AS AssetValueDate,
  cast(ersch as fco_ersch preserving type ) AS ProfitabilityAcctgTransfStruc,
  letpe AS SettlmtRuleLastUsgeFsclPeriod,
  letja AS SettlmtRuleLastUsageFiscalYear,
  cast(hienr as fco_brghienr preserving type) AS SettlmtRuleProcessingSequence,
  cast(timestmp as tzntstmpl ) AS SettlementRuleCreationDateTime,
  cast(srslist as fco_sr_slist preserving type ) AS SettlmtRuleAutoGnrtnStrgySqnc,
  cast(addcurr as fco_abr_addcurr preserving type ) AS SettlmtWithFreeDefinedCurrency
FROM cobra
LEFT OUTER JOIN I_CtrlgObjSettlmtDistrRule AS _CtrlgObjSettlmtDistrRule ON ControllingObject = _CtrlgObjSettlmtDistrRule.ControllingObject  -- association [0..*]
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON ControllingObject = _ControllingObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_AllocationStructure AS _AllocationStructure ON AllocationStructure = _AllocationStructure.AllocationStructure  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_ControllingSettlementProfile AS _ControllingSettlementProfile ON ControllingSettlementProfile = _ControllingSettlementProfile.ControllingSettlementProfile  -- association [0..1]
LEFT OUTER JOIN I_SettlmtAutomGnrtnStrgySqnc AS _SettlmtAutomGnrtnStrgySqnc ON SettlmtRuleAutoGnrtnStrgySqnc = _SettlmtAutomGnrtnStrgySqnc.SettlmtRuleAutoGnrtnStrgySqnc  -- association [0..1]
LEFT OUTER JOIN I_PrftbltyAcctgTransfStructure AS _PrftbltyAcctgTransfStructure ON ProfitabilityAcctgTransfStruc = _PrftbltyAcctgTransfStructure.ProfitabilityAcctgTransfStruc  -- association [0..1]
LEFT OUTER JOIN I_ControllingStructure AS _SourceStructure ON _SourceStructure.ControllingStructureType = 'U' AND SettlementSourceStructure = _SourceStructure.ControllingStructure  -- association [0..1]
LEFT OUTER JOIN I_SettlmtWithFreeDfndCurrency AS _SettlmtWithFreeDfndCurrency ON SettlmtWithFreeDefinedCurrency = _SettlmtWithFreeDfndCurrency.SettlmtWithFreeDefinedCurrency  -- association [0..1]
;