I_IntOrderSettlementDistrRule

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_IntOrderSettlementDistrRule.
-- 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_IntOrderSettlementDistrRule AS
SELECT
  I_CtrlgObjSettlmtDistrRule.ControllingObject AS ControllingObject,
  I_CtrlgObjSettlmtDistrRule.Ledger AS Ledger,
  I_CtrlgObjSettlmtDistrRule.LedgerGroup AS LedgerGroup,
  I_CtrlgObjSettlmtDistrRule.SettlementDistributionRuleGrp AS SettlementDistributionRuleGrp,
  I_CtrlgObjSettlmtDistrRule.SettlmtDistrRuleSequence AS SettlmtDistrRuleSequence,
  I_CtrlgObjSettlmtDistrRule.SettlementType AS SettlementType,
  I_CtrlgObjSettlmtDistrRule.AccountAssignmentType AS AccountAssignmentType,
  I_CtrlgObjSettlmtDistrRule.SettlementReceiver AS SettlementReceiver,
  cast(I_CtrlgObjSettlmtDistrRule.SettlementPercentageRate as fco_sr_io_prozs preserving type ) AS SettlementPercentageRate,
  I_CtrlgObjSettlmtDistrRule.SettlementEquivalenceFactor AS SettlementEquivalenceFactor,
  I_CtrlgObjSettlmtDistrRule.SettlementAmount AS SettlementAmount,
  I_CtrlgObjSettlmtDistrRule.SettlementAmountCurrency AS SettlementAmountCurrency,
  I_CtrlgObjSettlmtDistrRule.SettlementTransaction AS SettlementTransaction,
  I_CtrlgObjSettlmtDistrRule.SettlementDefaultRule AS SettlementDefaultRule,
  I_CtrlgObjSettlmtDistrRule.ControllingArea AS ControllingArea,
  I_CtrlgObjSettlmtDistrRule.CostCenter AS CostCenter,
  I_CtrlgObjSettlmtDistrRule.ProfitabilitySegment AS ProfitabilitySegment,
  I_CtrlgObjSettlmtDistrRule.WBSElementInternalID AS WBSElementInternalID,
  I_CtrlgObjSettlmtDistrRule.WBSElementExternalID AS WBSElementExternalID,
  I_CtrlgObjSettlmtDistrRule.ProjectNetwork AS ProjectNetwork,
  I_CtrlgObjSettlmtDistrRule.CostObject AS CostObject,
  I_CtrlgObjSettlmtDistrRule.BusinessProcess AS BusinessProcess,
  I_CtrlgObjSettlmtDistrRule.SalesOrder AS SalesOrder,
  I_CtrlgObjSettlmtDistrRule.SalesOrderItem AS SalesOrderItem,
  I_CtrlgObjSettlmtDistrRule.OrderID AS OrderID,
  I_CtrlgObjSettlmtDistrRule.OrderItem AS OrderItem,
  I_CtrlgObjSettlmtDistrRule.CompanyCode AS CompanyCode,
  I_CtrlgObjSettlmtDistrRule.ProfitCenter AS ProfitCenter,
  I_CtrlgObjSettlmtDistrRule.MasterFixedAsset AS MasterFixedAsset,
  I_CtrlgObjSettlmtDistrRule.FixedAsset AS FixedAsset,
  I_CtrlgObjSettlmtDistrRule.Plant AS Plant,
  I_CtrlgObjSettlmtDistrRule.Material AS Material,
  I_CtrlgObjSettlmtDistrRule.GLAccount AS GLAccount,
  I_CtrlgObjSettlmtDistrRule.ValidityStartFiscalPeriod AS ValidityStartFiscalPeriod,
  I_CtrlgObjSettlmtDistrRule.ValidityStartFiscalYear AS ValidityStartFiscalYear,
  I_CtrlgObjSettlmtDistrRule.ValidityEndFiscalPeriod AS ValidityEndFiscalPeriod,
  I_CtrlgObjSettlmtDistrRule.ValidityEndFiscalYear AS ValidityEndFiscalYear,
  I_CtrlgObjSettlmtDistrRule.SettlmtRule1stUsgeFiscalPeriod AS SettlmtRule1stUsgeFiscalPeriod,
  I_CtrlgObjSettlmtDistrRule.SettlmtRule1stUsageFiscalYear AS SettlmtRule1stUsageFiscalYear,
  I_CtrlgObjSettlmtDistrRule.SettlmtRuleLastUsgeFsclPeriod AS SettlmtRuleLastUsgeFsclPeriod,
  I_CtrlgObjSettlmtDistrRule.SettlmtRuleLastUsageFiscalYear AS SettlmtRuleLastUsageFiscalYear,
  I_CtrlgObjSettlmtDistrRule.SettlmtDistributionRuleVersion AS SettlmtDistributionRuleVersion,
  I_CtrlgObjSettlmtDistrRule.SettlmtTracingFctrDetnMethod AS SettlmtTracingFctrDetnMethod,
  I_CtrlgObjSettlmtDistrRule.SettlementDistrAmountRuleType AS SettlementDistrAmountRuleType,
  I_CtrlgObjSettlmtDistrRule.SettlmtDistrRuleSrceAssignment AS SettlmtDistrRuleSrceAssignment,
  I_CtrlgObjSettlmtDistrRule.SettlmtDistributionRuleNumber AS SettlmtDistributionRuleNumber,
  I_CtrlgObjSettlmtDistrRule.SettlmtDistrManipulationRule AS SettlmtDistrManipulationRule,
  I_CtrlgObjSettlmtDistrRule.SettlmtRuleAutomStrategyGnrtn AS SettlmtRuleAutomStrategyGnrtn,
  I_CtrlgObjSettlmtDistrRule.SettlementDistrRuleRmngAmount AS SettlementDistrRuleRmngAmount,
  I_CtrlgObjSettlmtDistrRule.SettlementDistrRuleInternalID AS NetworkActivityInternalID,
  I_CtrlgObjSettlmtDistrRule.OperationOrderRoutingNumber AS ProjectNetworkInternalID,
  I_CtrlgObjSettlmtDistrRule.SettlmtDistrRuleIsUsedInLedger AS SettlmtDistrRuleIsUsedInLedger,
  I_CtrlgObjSettlmtDistrRule.SettlementSourceStructure AS SettlementSourceStructure,
  I_CtrlgObjSettlmtDistrRule.BusinessArea AS BusinessArea,
  I_CtrlgObjSettlmtDistrRule.AssetTransactionType AS AssetTransactionType,
  I_CtrlgObjSettlmtDistrRule._ControllingArea.OperatingConcern AS OperatingConcern,
  I_CtrlgObjSettlmtDistrRule.ServiceDocumentType AS ServiceDocumentType,
  I_CtrlgObjSettlmtDistrRule.ServiceDocument AS ServiceDocument,
  I_CtrlgObjSettlmtDistrRule.ServiceDocumentItem AS ServiceDocumentItem,
  I_CtrlgObjSettlmtDistrRule.SettlementDistributionRuleUUID AS SettlementDistributionRuleUUID,
  I_InternalOrderSettlementRule.SettlmtWithFreeDefinedCurrency AS SettlmtWithFreeDefinedCurrency,
  _InternalOrder.InternalOrder AS InternalOrder,
  _InternalOrder.OrderType AS OrderType,
  _NetworkActivityByInternalKey.NetworkActivity AS NetworkActivity,
  cast(I_InternalOrderSettlementRule.CompanyCode as fco_sr_io_bukrs preserving type ) AS InternalOrderCompanyCode,
  I_CtrlgObjSettlmtDistrRule._AccountAssignmentTypeT AS _AccountAssignmentTypeT,
  I_CtrlgObjSettlmtDistrRule._CompanyCode AS _CompanyCode,
  I_CtrlgObjSettlmtDistrRule._ControllingArea AS _ControllingArea,
  I_CtrlgObjSettlmtDistrRule._ControllingObject AS _ControllingObject,
  I_CtrlgObjSettlmtDistrRule._ControllingObjectSettlmtRcvr AS _ControllingObjectSettlmtRcvr,
  I_CtrlgObjSettlmtDistrRule._CostCenter AS _CostCenter,
  I_CtrlgObjSettlmtDistrRule._CtrlgObjectSettlementRule AS _CtrlgObjectSettlementRule,
  I_CtrlgObjSettlmtDistrRule._SourceStructureAssignment AS _SourceStructureAssignment,
  I_CtrlgObjSettlmtDistrRule._Currency AS _Currency,
  I_CtrlgObjSettlmtDistrRule._GLAccount AS _GLAccount,
  I_CtrlgObjSettlmtDistrRule._JntVntrMnpltnRuleRecoveryInd AS _JntVntrMnpltnRuleRecoveryInd,
  I_CtrlgObjSettlmtDistrRule._Ledger AS _Ledger,
  I_CtrlgObjSettlmtDistrRule._LedgerGroup AS _LedgerGroup,
  I_CtrlgObjSettlmtDistrRule._OrderID AS _OrderID,
  I_CtrlgObjSettlmtDistrRule._ProjectNetwork AS _ProjectNetwork,
  I_CtrlgObjSettlmtDistrRule._SettlementAutomGnrtnStrategy AS _SettlementAutomGnrtnStrategy,
  I_CtrlgObjSettlmtDistrRule._SettlementType AS _SettlementType,
  I_CtrlgObjSettlmtDistrRule._SettlementTypeText AS _SettlementTypeText,
  I_CtrlgObjSettlmtDistrRule._SettlmtDistrAmountRuleType AS _SettlmtDistrAmountRuleType,
  I_CtrlgObjSettlmtDistrRule._SettlmtTracingFctrDetnMethod AS _SettlmtTracingFctrDetnMethod,
  I_CtrlgObjSettlmtDistrRule._WBSElementBasicData AS _WBSElementBasicData,
  I_CtrlgObjSettlmtDistrRule._AssetTransactionType AS _AssetTransactionType,
  I_CtrlgObjSettlmtDistrRule._SalesOrderItem AS _SalesOrderItem,
  I_CtrlgObjSettlmtDistrRule._FixedAsset AS _FixedAsset,
  I_CtrlgObjSettlmtDistrRule._MasterFixedAsset AS _MasterFixedAsset,
  I_CtrlgObjSettlmtDistrRule._BusinessProcess AS _BusinessProcess,
  I_CtrlgObjSettlmtDistrRule._ProfitCenter AS _ProfitCenter,
  I_CtrlgObjSettlmtDistrRule._AcctgServiceDocumentItem AS _AcctgServiceDocumentItem,
  I_CtrlgObjSettlmtDistrRule._ServiceDocumentItem AS _ServiceDocumentItem,
  I_InternalOrderSettlementRule._SettlmtWithFreeDfndCurrency AS _SettlmtWithFreeDfndCurrency,
  I_InternalOrderSettlementRule._CompanyCode AS _InternalOrderCompanyCode,
  I_CtrlgObjSettlmtDistrRule._SettlmtTypeLanguageDependent AS _SettlmtTypeLanguageDependent
FROM I_CtrlgObjSettlmtDistrRule
INNER JOIN I_InternalOrderSettlementRule ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON ControllingObject = _InternalOrder.ControllingObject  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _NetworkActivityByInternalKey ON ProjectNetworkInternalID = _NetworkActivityByInternalKey.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityByInternalKey.NetworkActivityInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetworkBasicData AS _ProjectNetworkBasicData ON ProjectNetwork = _ProjectNetworkBasicData.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_AcctgSrvcDocumentItemBasic AS _AcctgSrvcDocumentItemBasic ON ServiceDocumentType = _AcctgSrvcDocumentItemBasic.ServiceDocumentType AND ServiceDocument = _AcctgSrvcDocumentItemBasic.ServiceDocument AND ServiceDocumentItem = _AcctgSrvcDocumentItemBasic.ServiceDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentType AS _AcctgServiceDocumentType ON ServiceDocumentType = _AcctgServiceDocumentType.ServiceDocumentType  -- association [0..1]
;