P_ServiceDocLinItmFinConvData

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 P_ServiceDocLinItmFinConvData.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW P_ServiceDocLinItmFinConvData AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  GLAccountHierarchy,
  SemanticTag,
  ValidityStartDate,
  ValidityEndDate,
  ServiceContract,
  ServiceContractItem,
  ServiceDocument,
  ServiceDocumentItem,
  ServiceDocumentType,
  ServiceContractType,
  cast(:P_DisplayCurrency as currency) AS DisplayCurrency,
  CompanyCodeCurrency,
  RecognizedMarginAmtInCCCrcy,
  RevenueAmountInCompanyCodeCrcy,
  CostAmountInCompanyCodeCrcy,
  CreationDate,
  _GLAcctData.PostingDate AS PostingDate,
  DocumentDate,
  FiscalYearVariant,
  FiscalPeriod,
  FiscalQuarter,
  Product,
  ProductGroup,
  _CalendarPeriod.CalendarQuarter AS CalendarQuarter,
  _CalendarPeriod.CalendarYear AS CalendarYear,
  _CalendarPeriod.CalendarMonth AS CalendarMonth,
  _CalendarPeriod.CalendarWeek AS CalendarWeek,
  _ItemEnhcd.ServiceObjectType AS ServiceObjectType,
  _ItemEnhcd.ServiceDocumentDescription AS ServiceDocumentDescription,
  _ItemEnhcd.SalesOrganization AS SalesOrganization,
  _ItemEnhcd.DistributionChannel AS DistributionChannel,
  _ItemEnhcd.Division AS Division,
  _ItemEnhcd.SalesOffice AS SalesOffice,
  _ItemEnhcd.SalesGroup AS SalesGroup,
  _ItemEnhcd.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _ItemEnhcd.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _ItemEnhcd.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  _ItemEnhcd.ServiceOrganization AS ServiceOrganization,
  _ItemEnhcd.ResponsibleEmployee AS ResponsibleEmployee,
  _CalendarPeriod._CalendarMonth AS _CalendarMonth,
  _GLAcctData._ServiceContract AS _ServiceContract,
  _GLAcctData._ServiceContractItem AS _ServiceContractItem,
  _GLAcctData._ServiceContractType AS _ServiceContractType,
  _GLAcctData._ServiceDocument AS _ServiceDocument,
  _GLAcctData._ServiceDocumentType AS _ServiceDocumentType,
  _GLAcctData._ServiceDocumentItem AS _ServiceDocumentItem,
  _ItemEnhcd._ServiceObjType AS _ServiceObjType,
  _ItemEnhcd._SalesOrganization AS _SalesOrganization,
  _ItemEnhcd._DistributionChannel AS _DistributionChannel,
  _ItemEnhcd._Division AS _Division,
  _ItemEnhcd._SalesOffice AS _SalesOffice,
  _ItemEnhcd._SalesGroup AS _SalesGroup,
  _ItemEnhcd._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  _ItemEnhcd._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  _ItemEnhcd._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  _ItemEnhcd._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  _ItemEnhcd._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  _ItemEnhcd._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  _ItemEnhcd._RespEmployee AS _RespEmployee
FROM P_ServiceDocLinItmFinData AS _GLAcctData
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ItemEnhcd ON ServiceDocument = _ItemEnhcd.ServiceDocument AND ServiceDocumentItem = _ItemEnhcd.ServiceDocumentItem AND ( _ItemEnhcd.ServiceObjectType = 'BUS2000116' OR _ItemEnhcd.ServiceObjectType = 'BUS2000112' )  -- association [0..1]
;