FIN_SUBVAL_ACCTGSRVCDOC

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 FIN_SUBVAL_ACCTGSRVCDOC.
-- 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: FISACCSRVDOC

CREATE VIEW FIN_SUBVAL_ACCTGSRVCDOC AS
SELECT
  asdi.ServiceDocument AS ServiceDocument,
  asdi._ServiceDocumentItem.ServiceDocItemCategory AS ServiceDocItemCategory,
  asdi.ServiceDocumentType AS ServiceDocumentType,
  asdi.DistributionChannel AS DistributionChannel,
  asdi._ServiceDocumentItem._Division.Division AS Division,
  asdi._ServiceDocumentItem.Product AS Product,
  asdi.ProfitCenter AS ProfitCenter,
  asdi._ServiceDocumentItem.Plant AS Plant,
  asdi.SalesOrganization AS SalesOrganization,
  asdi.FunctionalArea AS FunctionalArea,
  asdi.CostingSheet AS CostingSheet,
  asdi.CompanyCode AS CompanyCode,
  cast('' as aprof) AS ControllingSettlementProfile,
  cast('' as gsber) AS BusinessArea,
  cast('' as ck_klvar) AS CostingVariant,
  cast('' as fco_revrec_active) AS RevenueRecognitionIsActive,
  cast('' as fins_trr_recgnkey ) AS ResultAnalysisInternalID,
  cast('' as kunag ) AS SoldToParty,
  cast('' as kunre ) AS BillToParty,
  cast('' as kunwe ) AS ShipToParty,
  cast('' as equnr ) AS Equipment,
  cast('' as vkbur ) AS SalesOffice,
  cast('' as vkgrp) AS SalesGroup,
  cast('00000000' as hrobjid) AS RespyMgmtTeamID,
  cast('' as bu_partner) AS ServiceTeam,
  cast('' as tplnr) AS FunctionalLocation,
  cast('' as kdgrp) AS CustomerGroup,
  cast('' as crmt_ac_indicator) AS BillableControl,
  asdi.ServiceObjectType AS ServiceObjectType,
  asdi.ServiceDocumentItem AS ServiceDocumentItem
FROM I_AcctgServiceDocumentItem AS asdi
LEFT OUTER JOIN I_Product AS _Product ON product = _Product.Product  -- association [1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON product = _ProductPlant.Product AND plant = _ProductPlant.Plant  -- association [1]
LEFT OUTER JOIN E_ServiceDocument AS _SrvcDocument ON asdi.ServiceObjectType = _SrvcDocument.ServiceCategory AND asdi.ServiceDocument = _SrvcDocument.ServiceOrder  -- association [1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _SrvcDocumentItem ON asdi.ServiceObjectType = _SrvcDocumentItem.ServiceCategory AND asdi.ServiceDocument = _SrvcDocumentItem.ServiceOrderItem AND asdi.ServiceDocumentItem = _SrvcDocumentItem.ServiceLineExternalID  -- association [1]
;