P_SrvcDocIntOrdFinCnvrsnData

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_SrvcDocIntOrdFinCnvrsnData.
-- 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_SrvcDocIntOrdFinCnvrsnData AS
SELECT
  _Conv.Ledger AS Ledger,
  _Conv.SourceLedger AS SourceLedger,
  _Conv.CompanyCode AS CompanyCode,
  _Conv.FiscalYear AS FiscalYear,
  _Conv.AccountingDocument AS AccountingDocument,
  _Conv.LedgerGLLineItem AS LedgerGLLineItem,
  _Conv.GLAccountHierarchy AS GLAccountHierarchy,
  _Conv.SemanticTag AS SemanticTag,
  _Conv.ValidityStartDate AS ValidityStartDate,
  _Conv.ValidityEndDate AS ValidityEndDate,
  _Conv.OrderID AS OrderID,
  _Conv.OrderItem AS OrderItem,
  _Conv.AccountAssignment AS AccountAssignment,
  _Conv.ServiceDocument AS ServiceDocument,
  _Conv.ServiceDocumentType AS ServiceDocumentType,
  cast( '' as crms4_number_int ) AS ServiceContractItem,
  _Enhcd.ServiceDocument AS ServiceContract,
  _Enhcd.ServiceDocumentType AS ServiceContractType,
  _Enhcd.ServiceObjectType AS ServiceObjectType,
  _Enhcd.ServiceDocumentDescription AS ServiceContractDescription,
  _Enhcd.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
  _Enhcd.ServiceDocumentTemplateType AS ServiceDocumentTemplateType,
  _Conv.CreationDate AS CreationDate,
  _Conv.PostingDate AS PostingDate,
  _Conv.DocumentDate AS DocumentDate,
  _Conv.FiscalYearVariant AS FiscalYearVariant,
  _Conv.FiscalPeriod AS FiscalPeriod,
  _Conv.FiscalQuarter AS FiscalQuarter,
  _CalendarPeriod.CalendarQuarter AS CalendarQuarter,
  _CalendarPeriod.CalendarYear AS CalendarYear,
  _CalendarPeriod.CalendarMonth AS CalendarMonth,
  _CalendarPeriod.CalendarWeek AS CalendarWeek,
  dats_days_between(_Enhcd.ServiceContractStartDate, _Enhcd.ServiceContractEndDate) as NumberOfDays AS ServiceContractEndDateasNumberOfDays,
  cast(:P_DisplayCurrency as currency) AS DisplayCurrency,
  _Conv.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Conv.RecognizedMarginAmtInCCCrcy AS RecognizedMarginAmtInCCCrcy,
  _Conv.RevenueAmountInCompanyCodeCrcy AS RevenueAmountInCompanyCodeCrcy,
  _Conv.CostAmountInCompanyCodeCrcy AS CostAmountInCompanyCodeCrcy,
  _Enhcd.TransactionCurrency AS TransactionCurrency,
  _Enhcd.ServiceDocNetAmount AS TotalSrvcContrValueInDC,
  _Conv.RevenueAmountInCompanyCodeCrcy AS RevenueAmountInDisplayCrcy,
  _Conv.CostAmountInCompanyCodeCrcy AS CostAmountInDisplayCurrency,
  _Conv.RecognizedMarginAmtInCCCrcy AS SrvcContrProfitabilityInDC,
  _Conv.YTDSrvcContrRevnAmtInDC AS YTDSrvcContrRevnAmtInDC,
  _Conv.YTDSrvcContrCostInDC AS YTDSrvcContrCostInDC,
  _Conv.YTDSrvcContrPrftMarginAmtInDC AS YTDSrvcContrPrftMarginAmtInDC,
  _Enhcd.SoldToParty AS SoldToParty,
  _Enhcd._SoldToParty.BusinessPartnerFullName AS SoldToPartyFullName,
  _Enhcd.SoldToPartyCountry AS SoldToPartyCountry,
  _Enhcd.SoldToPartyRegion AS SoldToPartyRegion,
  _Enhcd.ShipToParty AS ShipToParty,
  _Enhcd.ResponsibleEmployee AS ResponsibleEmployee,
  _Enhcd.ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  _Enhcd.ContactPerson AS ContactPerson,
  _Enhcd.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  _Enhcd.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  _Enhcd.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  _Enhcd.DistributionChannel AS DistributionChannel,
  _Enhcd.Division AS Division,
  _Enhcd.SalesOrganization AS SalesOrganization,
  _Enhcd.SalesOffice AS SalesOffice,
  _Enhcd.SalesGroup AS SalesGroup,
  _Enhcd.ServiceOrganization AS ServiceOrganization,
  _Enhcd.RefBusinessSolutionOrder AS RefBusinessSolutionOrder,
  _Enhcd.ServiceDocumentCanclnParty AS ServiceDocumentItemCanclnParty,
  _Enhcd.ServiceDocumentCanclnReason AS ServiceDocumentItmCanclnReason,
  _Conv._Ledger AS _Ledger,
  _Conv._SourceLedger AS _SourceLedger,
  _Conv._CompanyCode AS _CompanyCode,
  _Conv._FiscalYear AS _FiscalYear,
  _Conv._JournalEntry AS _JournalEntry,
  _Conv._Hierarchy AS _Hierarchy,
  _Conv._SemanticTag AS _SemanticTag,
  _Conv._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _Conv._FiscalYearVariant AS _FiscalYearVariant,
  _CalendarPeriod._CalendarMonth AS _CalendarMonth,
  _CalendarPeriod._CalendarYear AS _CalendarYear,
  _CalendarPeriod._CalendarQuarter AS _CalendarQuarter,
  _Enhcd._ServiceObjType AS _ServiceObjectType,
  _Enhcd._ServiceDocumentType AS _ServiceDocumentType,
  _Enhcd._ServiceDocumentIsOpen AS _ServiceDocumentIsOpen,
  _Enhcd._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
  _Enhcd._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
  _Enhcd._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
  _Enhcd._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
  _Enhcd._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
  _Enhcd._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
  _Enhcd._Division AS _Division,
  _Enhcd._SalesOffice AS _SalesOffice,
  _Enhcd._SalesGroup AS _SalesGroup,
  _Enhcd._SalesOrganization AS _SalesOrganization,
  _Enhcd._DistributionChannel AS _DistributionChannel,
  _Enhcd._SoldToParty AS _SoldToParty,
  _Enhcd._SoldToPartyCountry AS _SoldToPartyCountry,
  _Enhcd._SoldToPartyRegion AS _SoldToPartyRegion,
  _Enhcd._ShipToParty AS _ShipToParty,
  _Enhcd._RespEmployee AS _RespEmployee,
  _Conv._Order AS _Order,
  _Enhcd._ContactPerson AS _ContactPerson
FROM P_SrvcDocEnhcdWithCloudCheck AS _Enhcd
LEFT OUTER JOIN P_SrvcDocIntOrdFinData AS _Conv ON _Conv.ServiceDocument = _Enhcd.ServiceDocument  -- association [1]
LEFT OUTER JOIN I_BusinessPartner AS _RespEmployeeID ON RespEmployeeBusinessPartnerId = _RespEmployeeID.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusSolnOrdBasicFinancial AS _SolutionOrderVH ON RefBusinessSolutionOrder = _SolutionOrderVH.BusinessSolutionOrder  -- association [0..1]
;