I_CtrlgObjSettlmtDistrRule

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_CtrlgObjSettlmtDistrRule.
-- 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: ICODISTRULE

CREATE VIEW I_CtrlgObjSettlmtDistrRule AS
SELECT
  cobrb.objnr AS ControllingObject,
  cobrb.lednr AS Ledger,
  cobrb.ldgrp AS LedgerGroup,
  cast(cobrb.bureg as fco_brsgr preserving type) AS SettlementDistributionRuleGrp,
  cast(cobrb.lfdnr as fco_br_lfdnr preserving type) AS SettlmtDistrRuleSequence,
  cast (cobrb.perbz as perbz) AS SettlementType,
  cast (cobrb.konty as fis_obart) AS AccountAssignmentType,
  cast(cobrb.rec_objnr1 as fco_srec_objnr preserving type) AS SettlementReceiver,
  cobrb.prozs AS SettlementPercentageRate,
  cast(cobrb.aqzif as fco_aqzif preserving type) AS SettlementEquivalenceFactor,
  cobrb.betrr AS SettlementAmount,
  cobrb.bwaer AS SettlementAmountCurrency,
  cobrb.avorg AS SettlementTransaction,
  cobrb.dfreg AS SettlementDefaultRule,
  cast(cobrb.kokrs as fis_kokrs preserving type ) AS ControllingArea,
  cast(cobrb.kostl as fis_kostl preserving type ) AS CostCenter,
  cast(cobrb.paobjnr as rkeobjnr_char) AS ProfitabilitySegment,
  cast(cobrb.paobjnr as rkeobjnr_char ) AS ProfitabilitySegment_2,
  cast(cobrb.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  cobrb.nplnr AS ProjectNetwork,
  cobrb.kstrg AS CostObject,
  cobrb.prznr AS BusinessProcess,
  cast(cobrb.gsber as fis_rbusa preserving type ) AS BusinessArea,
  cobrb.anbwa AS AssetTransactionType,
  cobrb.kdauf AS SalesOrder,
  cobrb.kdpos AS SalesOrderItem,
  cobrb.service_doc_type AS ServiceDocumentType,
  cobrb.service_doc_id AS ServiceDocument,
  cobrb.service_doc_item_id AS ServiceDocumentItem,
  cobrb.aufnr AS OrderID,
  cobrb.posnr AS OrderItem,
  cast(cobrb.bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cobrb.prctr AS ProfitCenter,
  cobrb.anln1 AS MasterFixedAsset,
  cobrb.anln2 AS FixedAsset,
  cobrb.werks AS Plant,
  cobrb.matnr AS Material,
  cobrb.hkont AS GLAccount,
  cobrb.gabpe AS ValidityStartFiscalPeriod,
  cobrb.gabja AS ValidityStartFiscalYear,
  cobrb.gbisp AS ValidityEndFiscalPeriod,
  cobrb.gbisj AS ValidityEndFiscalYear,
  cobrb.erspe AS SettlmtRule1stUsgeFiscalPeriod,
  cobrb.ersja AS SettlmtRule1stUsageFiscalYear,
  cobrb.letpe AS SettlmtRuleLastUsgeFsclPeriod,
  cobrb.letja AS SettlmtRuleLastUsageFiscalYear,
  cobrb.versn AS SettlmtDistributionRuleVersion,
  cobrb.strat AS SettlmtTracingFctrDetnMethod,
  cast(cobrb.brtyp as fco_brtyp preserving type) AS SettlementDistrAmountRuleType,
  cobrb.urzuo AS SettlmtDistrRuleSrceAssignment,
  cast(cobrb.extnr as fco_cobr_extnr preserving type) AS SettlmtDistributionRuleNumber,
  cobrb.mrule AS SettlmtDistrManipulationRule,
  cobrb.srstrat AS SettlmtRuleAutomStrategyGnrtn,
  cobrb.brest AS SettlementDistrRuleRmngAmount,
  cobrb.aplzl AS SettlementDistrRuleInternalID,
  cobrb.aufpl AS OperationOrderRoutingNumber,
  cobrb.used_in_ledger AS SettlmtDistrRuleIsUsedInLedger,
  cobrb.unique_id AS SettlementDistributionRuleUUID,
  cobrb.pass_down_uid AS SettlmtDistrRulePassDownUUID,
  I_CtrlgObjectSettlementRule.SettlementSourceStructure AS SettlementSourceStructure,
  I_CtrlgObjectSettlementRule._SourceStructure AS _SourceStructure
FROM cobrb
INNER JOIN I_CtrlgObjectSettlementRule ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CtrlgObjectSettlementRule AS _CtrlgObjectSettlementRule ON ControllingObject = _CtrlgObjectSettlementRule.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON ControllingObject = _ControllingObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_LedgerGroup AS _LedgerGroup ON LedgerGroup = _LedgerGroup.LedgerGroup  -- association [0..1]
LEFT OUTER JOIN I_SettlementType AS _SettlementType ON SettlementType = _SettlementType.SettlementType  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_AccountAssignmentTypeT AS _AccountAssignmentTypeT ON AccountAssignmentType = _AccountAssignmentTypeT.AccountAssignmentType AND _AccountAssignmentTypeT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SettlementTypeText AS _SettlementTypeText ON SettlementType = _SettlementTypeText.SettlementType AND _SettlementTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_OrderBasic AS _OrderID ON OrderID = _OrderID.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderBasic AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ControllingObject AS _ControllingObjectSettlmtRcvr ON SettlementReceiver = _ControllingObjectSettlmtRcvr.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SettlementAmountCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SettlementAutomGnrtnStrategy AS _SettlementAutomGnrtnStrategy ON SettlmtRuleAutomStrategyGnrtn = _SettlementAutomGnrtnStrategy.SettlmtRuleAutomStrategyGnrtn  -- association [0..1]
LEFT OUTER JOIN I_CtrlgStructureAssignment AS _SourceStructureAssignment ON SettlementSourceStructure = _SourceStructureAssignment.ControllingStructure AND _SourceStructureAssignment.ControllingStructureType = 'U' AND SettlmtDistrRuleSrceAssignment = _SourceStructureAssignment.ControllingStructureAssignment  -- association [0..1]
LEFT OUTER JOIN I_JntVntrMnpltnRuleRecoveryInd AS _JntVntrMnpltnRuleRecoveryInd ON SettlmtDistrManipulationRule = _JntVntrMnpltnRuleRecoveryInd.SettlmtDistrManipulationRule AND ControllingArea = _JntVntrMnpltnRuleRecoveryInd.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_SettlmtTracingFctrDetnMethod AS _SettlmtTracingFctrDetnMethod ON SettlmtTracingFctrDetnMethod = _SettlmtTracingFctrDetnMethod.SettlmtTracingFctrDetnMethod  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDistrAmountRuleType AS _SettlmtDistrAmountRuleType ON SettlementDistrAmountRuleType = _SettlmtDistrAmountRuleType.SettlementDistrAmountRuleType  -- association [0..1]
LEFT OUTER JOIN I_SettlmtTypeLanguageDependent AS _SettlmtTypeLanguageDependent ON SettlementType = _SettlmtTypeLanguageDependent.SettlementType AND _SettlmtTypeLanguageDependent.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_AssetTransactionType AS _AssetTransactionType ON AssetTransactionType = _AssetTransactionType.AssetTransactionType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentItem AS _AcctgServiceDocumentItem ON ServiceDocumentType = _AcctgServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _AcctgServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _AcctgServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItem AS _ServiceDocumentItem ON ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAsset ON CompanyCode = _MasterFixedAsset.CompanyCode AND MasterFixedAsset = _MasterFixedAsset.MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAsset ON CompanyCode = _FixedAsset.CompanyCode AND MasterFixedAsset = _FixedAsset.MasterFixedAsset AND FixedAsset = _FixedAsset.FixedAsset  -- association [0..1]
LEFT OUTER JOIN I_BusinessProcess AS _BusinessProcess ON BusinessProcess = _BusinessProcess.BusinessProcess AND ControllingArea = _BusinessProcess.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ProfitCenter = _ProfitCenter.ProfitCenter AND ControllingArea = _ProfitCenter.ControllingArea  -- association [0..*]
;