I_ProviderContractItem

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_ProviderContractItem.
-- 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_ProviderContractItem AS
SELECT
  vtkey AS ProviderContract,
  vtpos AS ProviderContractItem,
  erdat AS CreationDate,
  cast(ertim as ttet_dt_cr_time preserving type ) AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aetim AS LastChangeTime,
  aenam AS LastChangedByUser,
  vtpid AS CAProviderContractItemUUID,
  papid AS CAPrvdrContrParentItemUUID,
  valfr AS CAPrvdrContrItmValidFromDteTme,
  valto AS CAPrvdrContrItmValidToDateTime,
  cancl AS CAPrvdrContrItemCanclnDateTime,
  withdrawn_at AS PrvdrContrItmWthdrwlDateTime,
  status AS CAProviderContractStatus,
  vtitt AS CAProviderContractItemText,
  vkont AS ContractAccount,
  ppacc AS CAPrepaidAccount,
  vttrg AS CATechnicalResourceGroup,
  srvrp AS CAServiceRecipient,
  adrsr AS CAAddressIDOfServiceRecipient,
  prdnr AS CAProduct,
  cuobj AS ProductConfiguration,
  prdnr_sp AS CASalesPackageProduct,
  makey AS CAMasterAgreement,
  maprd AS CAMasterAgreementProduct,
  ptsrl AS CAPartnerSettlementRule,
  vtkrf AS CASharingContract,
  txjcd AS TaxJurisdiction,
  landl AS CAReceivingCountry,
  tax_country AS TaxCountry,
  charge_type AS CASubscriptionChargeType,
  solution_order_id AS BusinessSolutionOrder,
  solution_order_item_id AS BusinessSolutionOrderItem,
  matnr_copa AS SoldProduct,
  rev_rec_key AS RevenueRecognitionKey,
  rev_rec_key AS EBRRResultAnalysisInternalID,
  bundling AS EBRRIsBundleActive,
  quantity AS CAProviderContractQuantity,
  quantity_unit AS CAProviderContractQuantityUnit,
  uti_dso_bp AS DistrSystOperatorBP,
  uti_dso_maco_id AS DistrSystOperatorMarketCommID,
  uti_metop_bp AS MeterOperatorBusinessPartner,
  uti_metop_maco_id AS MeterOperatorMarketCommID,
  uti_malo_id AS MarketLocationIdentifier,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  bukrs AS CompanyCode,
  ico_bukrs_sup AS CAIntcoCompanyCodeSupplying,
  gsber AS BusinessArea,
  segmt AS Segment,
  prctr AS ProfitCenter,
  spart AS Division,
  vber1 AS CAPrvdrContrSalesAreaAttrib1,
  vber2 AS CAPrvdrContrSalesAreaAttrib2,
  cast( ps_psp_pnr as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  aufnr AS InternalOrder,
  x_vt_copa AS PrvdrContrItmIsRlvtForPrfSgDrv,
  cycle AS CABillgCycle,
  cycle_day AS CALastDayOfBillingPeriod,
  cycle_date AS CABillgCyclePeriodStartDate,
  inv_schedule AS CAInvcgSchedule,
  rating_area AS CARatingArea,
  billplanno AS CABillgPlnNumber,
  cb_soldto AS CAConsumptionBillgSoldToParty,
  cb_billto AS CAConsumptionBillgInvoiceRcpnt,
  cb_dzterm AS ConsumptionBillingPaymentTerms,
  cb_bemot AS CnsmpnBillgBillableControl,
  cb_mndid AS ConsumptionBillingSEPAMandate,
  cb_ccard_id AS CAConsumptionBillgPaymentCard,
  rarel AS CAIsRevenueAccountingRelevant,
  ra_mig_package AS CARevenueAcctgMigrationPackage,
  ra_reftype AS RevenueAccountingRefType,
  ra_reftype AS CARevenueAccountingRefType,
  ra_refid AS RevenueAccountingReference,
  ra_srcdoc_id AS CARevenueAcctgDocumentItem,
  trprc_curr AS TransactionPriceCurrency,
  trprc AS TransactionPrice,
  trprc_total AS TotalTransactionPrice,
  trprc_freq_unit AS TransacPriceRcrrcPerdTimeUnit,
  trprc_freq_duration AS TransacPriceRcrrcPerdDuration,
  ssprc_curr AS StandAloneSellingPriceCurrency,
  ssprc AS StandAloneSellingPrice,
  ssprc_total AS TotalStandAloneSellingPrice,
  ssprc_freq_unit AS SSPriceRecurrencePerdTimeUnit,
  ssprc_freq_duration AS SSPriceRecurrencePerdDuration,
  chrsn AS CAPrvdrContrItmChgReason,
  valto_ctrterm AS CAEndOfDurationDateTime,
  recurr_service_type AS CARevnAcctgRecrrgServiceType,
  ra_oi_orig AS CARevnAcctgTransfRecordOrigin,
  pay_par_active AS CAOriginOfPaymentMasterData,
  zahlkond AS PaymentCondition,
  ezawe AS CAPaymentMethodForIncgPayment,
  abwre AS CAAlternativePayer,
  adrre AS CAAddressIDOfAlternativePayer,
  ebvty AS CABankIDForIncomingPayments,
  mndid AS SEPAMandate,
  ccard_id AS CAPaymentCardIDForIncomingPayt,
  azawe AS CAPaymentMethodForOutgPayment,
  abwra AS CAAlternativePayee,
  adrra AS CAAddressIDOfAlternativePayee,
  abvty AS CABankIDForOutgoingPayments,
  ccard_out AS CAPaymentCardIDForOutgoingPayt,
  pcard_guid AS CAKeyForPaymentCardSupplement,
  dunn_par_active AS CAOriginOfDunningMasterData,
  mahnv AS CADunningProcedure,
  xdiscoexempt AS CAServiceDisconncnIsProhibited,
  strat AS CACollectionStrategy,
  cmgrp AS CACollectionsMasterDataGroup,
  cpers AS CACollectionsContactPerson,
  bstkd AS PurchaseOrderByCustomer,
  bstdk AS CustomerPurchaseOrderDate
FROM dfkk_vt_i
LEFT OUTER JOIN E_CAProviderContractItem AS _PCoExtension ON ProviderContract = _PCoExtension.CAProviderContract AND ProviderContractItem = _PCoExtension.CAProviderContractItemNumber  -- association [1..1]
LEFT OUTER JOIN I_CABillgPln AS _BillgPln ON CABillgPlnNumber = _BillgPln.CABillgPlnNumber  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_CABillgCycle AS _BillgCycle ON CABillgCycle = _BillgCycle.CABillgCycle  -- association [0..1]
LEFT OUTER JOIN I_CADunningMasterDataOrigin AS _CADunningMasterDataOrigin ON CAOriginOfDunningMasterData = _CADunningMasterDataOrigin.CAOriginOfDunningMasterData  -- association [0..1]
LEFT OUTER JOIN I_CADunningProcedure AS _CADunningProcedure ON CADunningProcedure = _CADunningProcedure.CADunningProcedure  -- association [0..1]
LEFT OUTER JOIN I_CACollectionStrategy AS _CACollectionStrategy ON CACollectionStrategy = _CACollectionStrategy.CACollectionStrategy  -- association [0..1]
LEFT OUTER JOIN I_CACollMasterDataGroup AS _CACollMasterDataGroup ON CACollectionsMasterDataGroup = _CACollMasterDataGroup.CACollectionsMasterDataGroup  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CACollectionsContactPerson ON CACollectionsContactPerson = _CACollectionsContactPerson.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgSchedule AS _InvcgSchedule ON CAInvcgSchedule = _InvcgSchedule.CAInvcgSchedule  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentMasterDataOrigin AS _CAPaymentMasterDataOrigin ON CAOriginOfPaymentMasterData = _CAPaymentMasterDataOrigin.CAOriginOfPaymentMasterData  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentMethod AS _CAPaymentMethod ON CAPaymentMethodForIncgPayment = _CAPaymentMethod.CAPaymentMethod AND CAReceivingCountry = _CAPaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_CARevnAcctgServiceType AS _CARevnAcctgServiceType ON CARevnAcctgRecrrgServiceType = _CARevnAcctgServiceType.CARevenueAccountingServiceType  -- association [0..1]
LEFT OUTER JOIN I_CARevnAcctgTransfRecdOrigin AS _CARevnAcctgTransfRecdOrigin ON CARevnAcctgTransfRecordOrigin = _CARevnAcctgTransfRecdOrigin.CARevnAcctgTransfRecordOrigin  -- association [0..1]
LEFT OUTER JOIN I_CARatingArea AS _CARatingArea ON CARatingArea = _CARatingArea.CARatingArea  -- association [1..1]
LEFT OUTER JOIN I_CASubscriptionChargeType AS _CASubscriptionChargeType ON CASubscriptionChargeType = _CASubscriptionChargeType.CASubscriptionChargeType  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCodeSup ON CAIntcoCompanyCodeSupplying = _CompCodeSup.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContrAcc ON ContractAccount = _ContrAcc.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON CAReceivingCountry = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_PaymentCondition AS _PaymentCondition ON PaymentCondition = _PaymentCondition.PaymentCondition  -- association [1..1]
LEFT OUTER JOIN I_ProviderContract AS _PrvdrContr ON ProviderContract = _PrvdrContr.ProviderContract  -- association [1..1]
LEFT OUTER JOIN I_ProviderContractStatus AS _ProviderContractStatus ON CAProviderContractStatus = _ProviderContractStatus.CAProviderContractStatus  -- association [1..1]
LEFT OUTER JOIN I_PrvdrContrItemChgReason AS _PrvdrContrItemChgReason ON CAPrvdrContrItmChgReason = _PrvdrContrItemChgReason.CAPrvdrContrItmChgReason  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
;