I_MaintOrderSettlmtDistrRule_2

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_MaintOrderSettlmtDistrRule_2.
-- 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: IMAINTORDSETRUL2

CREATE VIEW I_MaintOrderSettlmtDistrRule_2 AS
SELECT
  afih.aufnr AS MaintenanceOrder,
  cobrb.lednr AS Ledger,
  cobrb.ldgrp AS LedgerGroup,
  cobrb.bureg AS SettlementDistributionRuleGrp,
  cobrb.lfdnr AS SettlmtDistrRuleSequence,
  cobrb.objnr AS ControllingObject,
  cast (cobrb.perbz as perbz) AS SettlementType,
  cast (cobrb.konty as fis_obart) AS AccountAssignmentType,
  cobrb.rec_objnr1 AS SettlementReceiver,
  cobrb.prozs AS SettlementPercentageRate,
  cobrb.aqzif AS SettlementEquivalenceFactor,
  cobrb.betrr AS SettlementAmount,
  cobrb.bwaer AS SettlementAmountCurrency,
  cobrb.avorg AS SettlementTransaction,
  cobrb.dfreg AS SettlementDefaultRule,
  cobrb.kokrs AS ControllingArea,
  cobrb.kostl AS CostCenter,
  cast (cobrb.paobjnr as rkeobjnr_char ) AS ProfitabilitySegment,
  cast (cobrb.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cobrb.nplnr AS ProjectNetwork,
  cobrb.kstrg AS CostObject,
  cobrb.prznr AS BusinessProcess,
  cobrb.kdauf AS SalesOrder,
  cobrb.kdpos AS SalesOrderItem,
  cobrb.aufnr AS OrderID,
  cobrb.posnr AS OrderItem,
  cobrb.bukrs 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.gsber AS BusinessArea,
  cobrb.nplnr AS NetworkNumberForAcctAssgmt,
  cobrb.extnr AS AltvSettlmtDistrRuleSequence,
  cobrb.urzuo AS DistributionSourceAssignment,
  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.used_in_ledger AS SettlmtDistrRuleIsUsedInLedger
FROM cobrb
INNER JOIN onror ON /* join condition not captured in parsed metadata */
INNER JOIN afih ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [1..1]
LEFT OUTER JOIN I_ControllingObject AS _ControllingObject ON ControllingObject = _ControllingObject.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_CtrlgObjectSettlementRule AS _CtrlgObjectSettlementRule ON ControllingObject = _CtrlgObjectSettlementRule.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_OrderBasic AS _OrderID ON OrderID = _OrderID.OrderID  -- 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_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_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_Currency AS _Currency ON SettlementAmountCurrency = _Currency.Currency  -- association [0..1]
;