I_ProviderContract

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_ProviderContract.
-- 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.

CREATE VIEW I_ProviderContract AS
SELECT
  vtkey AS ProviderContract,
  cast(gpart as bu_partner preserving type ) AS BusinessPartner,
  erdat AS CreationDate,
  cast(ertim as ttet_dt_cr_time preserving type ) AS CreationTime,
  ernam AS CreatedByUser,
  cast(loevm as loevm preserving type ) AS IsMarkedForDeletion,
  aedat AS LastChangeDate,
  aetim AS LastChangeTime,
  aenam AS LastChangedByUser,
  vtbez AS CAProviderContractName,
  vtalt AS CAProviderContractExtReference,
  vtbeg AS CAPrvdrContrStartDateTime,
  vtend AS CAPrvdrContrEndDateTime,
  begru AS AuthorizationGroup,
  begru AS CAAuthorizationGroup,
  bukrs AS CompanyCode,
  cast(tzone as tznzone preserving type ) AS TimeZoneID,
  vtcat AS CAProviderContractCategory,
  migst AS CAProviderContractMigrtnStatus,
  vtchr AS CAProviderContractType,
  statu AS CAProviderContractStatus,
  sender AS CAProviderContractSender,
  vtend_min AS PrvdrContrEarliestEndDateTime,
  vtper_min AS MinNrOfMonthsForContractPeriod,
  vtper_rnwl AS NrOfMonthsForContractRenewal,
  vtper_canc AS NrOfDaysForContrNoticePeriod,
  uti_bbptype AS BudgetBillingPlanType
FROM dfkk_vt_h
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAAuthorizationGroup AS _CAAuthorizationGroup ON CAAuthorizationGroup = _CAAuthorizationGroup.CAAuthorizationGroup AND _CAAuthorizationGroup.CAAuthorizationGroupObject = 'CA_BILLCTR'  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ProviderContractCategory AS _ProviderContractCategory ON CAProviderContractCategory = _ProviderContractCategory.CAProviderContractCategory  -- association [1..1]
LEFT OUTER JOIN I_ProviderContractMigrtnSts AS _ProviderContractMigrtnSts ON CAProviderContractMigrtnStatus = _ProviderContractMigrtnSts.CAProviderContractMigrtnStatus  -- association [0..1]
LEFT OUTER JOIN I_ProviderContractType AS _ProviderContractType ON CAProviderContractType = _ProviderContractType.CAProviderContractType  -- association [1..1]
LEFT OUTER JOIN I_ProviderContractStatus AS _ProviderContractStatus ON CAProviderContractStatus = _ProviderContractStatus.CAProviderContractStatus  -- association [1..1]
LEFT OUTER JOIN I_ProviderContractSender AS _ProviderContractSender ON CAProviderContractSender = _ProviderContractSender.CAProviderContractSender  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_TimeZone AS _TimeZone ON TimeZoneID = _TimeZone.TimeZoneID  -- association [1..1]
LEFT OUTER JOIN E_CAProviderContractHeader AS _Extension ON ProviderContract = _Extension.CAProviderContract  -- association [1..1]
;