C_SESAccountAssignmentWD

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 C_SESAccountAssignmentWD.
-- 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: CSRVCENTRSH001WD

CREATE VIEW C_SESAccountAssignmentWD AS
SELECT
  Document.ServiceEntrySheet AS ServiceEntrySheet,
  Document.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  Document.AccountAssignment AS AccountAssignment,
  Document.RefDocAccountAssignment AS RefDocAccountAssignment,
  Document.IsDeleted AS IsDeleted,
  Document.QuantityUnit AS QuantityUnit,
  Document.Quantity AS Quantity,
  Document.CostCenter AS CostCenter,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  Document.GLAccount AS GLAccount,
  Document.BusinessArea AS BusinessArea,
  Document.SalesOrder AS SalesOrder,
  Document.SalesOrderItem AS SalesOrderItem,
  Document.SalesOrderScheduleLine AS SalesOrderScheduleLine,
  Document.MasterFixedAsset AS MasterFixedAsset,
  Document.FixedAsset AS FixedAsset,
  Document.OrderID AS OrderID,
  Document.ControllingArea AS ControllingArea,
  Document.CostObject AS CostObject,
  Document.ProfitabilitySegment AS ProfitabilitySegment,
  Document.ProfitCenter AS ProfitCenter,
  Document.WBSElementInternalID AS WBSElementInternalID,
  Document.ProjectNetwork AS ProjectNetwork,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  Document.NetworkActivityInternalID AS NetworkActivityInternalID,
  Document.NetworkActivity AS NetworkActivity,
  Document.RealEstateObject AS RealEstateObject,
  Document.CostCtrActivityType AS CostCtrActivityType,
  Document.BusinessProcess AS BusinessProcess,
  Document.SettlementReferenceDate AS SettlementReferenceDate,
  Document.GoodsRecipientName AS GoodsRecipientName,
  Document.UnloadingPointName AS UnloadingPointName,
  Document.OrderInternalID AS OrderInternalID,
  Document.OrderIntBillOfOperationsItem AS OrderIntBillOfOperationsItem,
  Document.Fund AS Fund,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.FunctionalArea AS FunctionalArea,
  Document.GrantID AS GrantID,
  Document.CommitmentItem AS CommitmentItem,
  Document.FundsCenter AS FundsCenter,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  Document.FundedProgram AS FundedProgram,
  Document.ServiceDocumentType AS ServiceDocumentType,
  Document.ServiceDocument AS ServiceDocument,
  Document.ServiceDocumentItem AS ServiceDocumentItem,
  Document.CreationDateTime AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangeUser AS LastChangedByUser,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Plant AS Plant,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.ValidityDate AS ValidityDate,
  Document.Currency AS Currency,
  Document.NetAmount AS NetAmount,
  Document.CompanyCode AS CompanyCode,
  Document.ChartOfAccounts AS ChartOfAccounts,
  Document._UnitValueHelp AS _UnitValueHelp,
  Document._UnitText AS _UnitText,
  Document._Currency AS _Currency
FROM I_SESAccountAssignmentTP AS Document
LEFT OUTER JOIN C_ServiceEntrySheetWD AS _ServiceEntrySheet ON _ServiceEntrySheet.ServiceEntrySheet = ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN C_ServiceEntrySheetItemWD AS _ServiceEntrySheetItem ON _ServiceEntrySheetItem.ServiceEntrySheet = ServiceEntrySheet AND _ServiceEntrySheetItem.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..1]
LEFT OUTER JOIN I_MM_CostCenterValueHelp AS _CostCenterValueHelp ON _CostCenterValueHelp.CostCenter = CostCenter AND _CostCenterValueHelp.ControllingArea = ControllingArea AND _CostCenterValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MM_SalesOrderValueHelp AS _SalesOrderValueHelp ON _SalesOrderValueHelp.SalesOrder = SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_MM_SalesOrderItemVH AS _SalesOrderItemValueHelp ON _SalesOrderItemValueHelp.SalesOrder = SalesOrder AND _SalesOrderItemValueHelp.SalesOrderItem = SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_MM_FixedAssetValueHelp AS _FixedAssetValueHelp ON _FixedAssetValueHelp.CompanyCode = CompanyCode AND _FixedAssetValueHelp.FixedAsset = FixedAsset AND _FixedAssetValueHelp.MasterFixedAsset = MasterFixedAsset  -- association [0..1]
LEFT OUTER JOIN I_MM_ProfitCenterValueHelp AS _ProfitCenterValueHelp ON _ProfitCenterValueHelp.ControllingArea = ControllingArea AND _ProfitCenterValueHelp.ProfitCenter = ProfitCenter AND _ProfitCenterValueHelp.ValidityEndDate >= ValidityDate  -- association [0..1]
LEFT OUTER JOIN I_MM_ProjectNetworkVH AS _ProjectNetworkValueHelp ON _ProjectNetworkValueHelp.ProjectNetwork = ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_MM_NetworkActivityVH AS _NetworkActivityValueHelp ON _NetworkActivityValueHelp.ProjectNetwork = ProjectNetwork AND _NetworkActivityValueHelp.NetworkActivity = NetworkActivity  -- association [0..1]
LEFT OUTER JOIN I_MM_GLAccountVH AS _GLAccountValueHelp ON _GLAccountValueHelp.CompanyCode = CompanyCode AND _GLAccountValueHelp.GLAccount = GLAccount  -- association [0..1]
LEFT OUTER JOIN I_MM_ControllingAreaVH AS _ControllingAreaVH ON _ControllingAreaVH.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FundStdVH AS _FundStdVH ON _FundStdVH.Fund = Fund  -- association [0..*]
LEFT OUTER JOIN I_BudgetPeriodStdVH AS _BudgetPeriodStdVH ON _BudgetPeriodStdVH.BudgetPeriod = BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterStdVH AS _FundsCenterStdVH ON _FundsCenterStdVH.FundsCenter = FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItemStdVH AS _CommitmentItemStdVH ON _CommitmentItemStdVH.CommitmentItem = CommitmentItem  -- association [0..*]
LEFT OUTER JOIN I_FndsMgmtFuncnlAreaStdVH AS _FndsMgmtFuncnlAreaStdVH ON _FndsMgmtFuncnlAreaStdVH.FunctionalArea = FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_EarmarkedFundsStdVH AS _EarmarkedFundsStdVH ON _EarmarkedFundsStdVH.EarmarkedFunds = EarmarkedFundsDocument  -- association [0..*]
LEFT OUTER JOIN I_GrantStdVH AS _GrantStdVH ON _GrantStdVH.GrantID = GrantID  -- association [0..1]
LEFT OUTER JOIN I_FundedProgramText AS _FundedProgramText ON _FundedProgramText.FundedProgram = FundedProgram  -- association [0..*]
LEFT OUTER JOIN I_AcctgServiceDocumentTypeVH AS _AcctgServiceDocumentTypeVH ON ServiceDocumentType = _AcctgServiceDocumentTypeVH.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_AcctgServiceDocumentVH AS _AcctgServiceDocumentVH ON ServiceDocument = _AcctgServiceDocumentVH.ServiceDocument  -- association [0..*]
LEFT OUTER JOIN I_AcctgServiceDocumentItemVH AS _AcctgServiceDocumentItemVH ON ServiceDocumentItem = _AcctgServiceDocumentItemVH.ServiceDocumentItem AND ServiceDocument = _AcctgServiceDocumentItemVH.ServiceDocument  -- association [0..*]
;