I_AcctgServiceDocumentItem

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_AcctgServiceDocumentItem.
-- 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: IFIACSRVDOCITM

CREATE VIEW I_AcctgServiceDocumentItem AS
SELECT
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  ControllingObject,
  BusinessSolutionOrder,
  CompanyCode,
  ControllingArea,
  ProfitCenter,
  FunctionalArea,
  SalesOrganization,
  DistributionChannel,
  Division,
  ResultAnalysisInternalID,
  Currency,
  CostingSheet,
  P_AcctgServiceDocument.WBSElementInternalID AS WBSElementInternalID,
  ServiceDocumentItemDescription,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  SrvcContrItmControllingObject,
  SrvcDocItemHierarchyProcessing,
  SettlementControl,
  Customer
FROM P_AcctgServiceDocument
LEFT OUTER JOIN I_ServiceDocument AS _ServiceDocument ON ServiceDocumentType = _ServiceDocument.ServiceDocumentType AND ServiceDocument = _ServiceDocument.ServiceDocument  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentItem AS _ServiceDocumentItem ON ServiceDocumentType = _ServiceDocumentItem.ServiceDocumentType AND ServiceDocument = _ServiceDocumentItem.ServiceDocument AND ServiceDocumentItem = _ServiceDocumentItem.ServiceDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_ServiceDocumentTypeText AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [1..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [1..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON _WBSElementBasicData.WBSElementInternalID = WBSElementInternalID  -- association [0..1]
;