I_ServiceEntrySheetAcctAssgmt

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_ServiceEntrySheetAcctAssgmt.
-- 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: ISRVCENTRSHTACCT

CREATE VIEW I_ServiceEntrySheetAcctAssgmt AS
SELECT
  Document.ServiceEntrySheet AS ServiceEntrySheet,
  Document.ServiceEntrySheetItem AS ServiceEntrySheetItem,
  Document.AccountAssignment AS AccountAssignment,
  Document.RefDocAccountAssignment AS RefDocAccountAssignment,
  Document.IsDeleted AS IsDeleted,
  QuantityUnit,
  Document.Quantity AS Quantity,
  Document.NetAmount AS NetAmount,
  Document.CostCenter AS CostCenter,
  Document.MultipleAcctAssgmtDistrPercent AS MultipleAcctAssgmtDistrPercent,
  Document.GLAccount AS GLAccount,
  Document.BusinessArea AS BusinessArea,
  Document.SalesOrder AS SalesOrder,
  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.WBSElementInternalID_2 AS WBSElementInternalID_2,
  Document.ProjectNetwork AS ProjectNetwork,
  Document.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  cast (' ' as ps_s4_vornr) AS NetworkActivity,
  Document.NetworkActivityInternalID AS NetworkActivityInternalID,
  Document.PartnerAccountNumber AS PartnerAccountNumber,
  cast( REInternalFinNumber as imkey ) AS RealEstateObject,
  REInternalFinNumber,
  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.CommitmentItem AS CommitmentItem,
  Document.CommitmentItemShortID AS CommitmentItemShortID,
  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,
  cast(Document.CreationDateTime as mmpur_ses_created_on) AS CreationDateTime,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.LastChangeUser AS LastChangeUser,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Plant AS Plant,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityDate,
  _ServiceEntrySheetItem.PurchaseOrderCurrency AS Currency,
  _ServiceEntrySheetItem.PurchaseOrderItemCompanyCode AS CompanyCode,
  _ControllingArea.ChartOfAccounts AS ChartOfAccounts,
  Document._UnitValueHelp AS _UnitValueHelp
FROM I_SrvEntrySheetAcctAssgmtBasic AS Document
LEFT OUTER JOIN I_ServiceEntrySheet AS _ServiceEntrySheet ON _ServiceEntrySheet.ServiceEntrySheet = ServiceEntrySheet  -- association [1..1]
LEFT OUTER JOIN I_ServiceEntrySheetItem AS _ServiceEntrySheetItem ON _ServiceEntrySheetItem.ServiceEntrySheet = ServiceEntrySheet AND _ServiceEntrySheetItem.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitText ON QuantityUnit = _UnitText.UnitOfMeasure  -- 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 = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON ChartOfAccounts = _GLAccountText.ChartOfAccounts AND GLAccount = _GLAccountText.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;