I_SESAccountAssignmentTP

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_SESAccountAssignmentTP.
-- 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: ISRVCENTRSH001TP

CREATE VIEW I_SESAccountAssignmentTP 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,
  cast(Document.SalesOrder as vdm_sales_order) AS SalesOrder,
  cast(SalesOrderItem as sales_order_item) 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,
  cast( Document.WBSElementInternalID_2 as ps_psp_pnr preserving type ) AS WBSElementInternalID,
  cast( ' ' as ps_posid_edit ) AS WBSElementExternalID,
  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,
  cast( CommitmentItemShortID as fipos preserving type ) AS CommitmentItem,
  Document.FundsCenter AS FundsCenter,
  Document.Fund AS Fund,
  Document.FunctionalArea AS FunctionalArea,
  Document.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  Document.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  Document.BudgetPeriod AS BudgetPeriod,
  Document.GrantID AS GrantID,
  Document.FundedProgram AS FundedProgram,
  Document.ServiceDocumentType AS ServiceDocumentType,
  Document.ServiceDocument AS ServiceDocument,
  Document.ServiceDocumentItem AS ServiceDocumentItem,
  Document.CreationDateTime AS CreationDateTime,
  cast(Document.CreatedByUser as mmpur_ses_createdbyuser preserving type ) AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  cast(Document.LastChangeUser as mmpur_ses_lastchangeuser preserving type ) AS LastChangeUser,
  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
FROM I_ServiceEntrySheetAcctAssgmt AS Document
LEFT OUTER JOIN I_ServiceEntrySheetTP AS _ServiceEntrySheet ON _ServiceEntrySheet.ServiceEntrySheet = ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN I_ServiceEntrySheetItemTP AS _ServiceEntrySheetItem ON _ServiceEntrySheetItem.ServiceEntrySheet = ServiceEntrySheet AND _ServiceEntrySheetItem.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitValueHelp ON _UnitValueHelp.UnitOfMeasure = QuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitText ON _UnitText.UnitOfMeasure = QuantityUnit  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON _ControllingArea.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON _GLAccount.CompanyCode = CompanyCode AND _GLAccount.GLAccount = GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON _BusinessArea.BusinessArea = BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON _BusinessAreaText.BusinessArea = BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;