I_PRATstBslnCombinedMktg

DDL: I_PRATSTBSLNCOMBINEDMKTG SQL: IPRATVBCOMBMK1 Type: view BASIC Package: OIU_TV
22 Fields 1 Data Sources

TV - Combine Run Marketing - Baseline

I_PRATstBslnCombinedMktg is a Basic CDS View that provides data about "TV - Combine Run Marketing - Baseline" in SAP S/4HANA. It reads from 1 data source (/pra/rd_crmkt) and exposes 22 fields with key fields BaselineValnDoc, BaselineValnDocYear, DeliveryNetwork, SalesDate, PRAJointVenture. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
/pra/rd_crmkt crmkt from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRATVBCOMBMK1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TV - Combine Run Marketing - Baseline view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BaselineValnDoc baseline BaselineValnDoc DocNr
KEY BaselineValnDocYear baseline BaselineValnDocYear Document year
KEY DeliveryNetwork baseline DeliveryNetwork Delivery network ID
KEY SalesDate baseline SalesDate Sales Date
KEY PRAJointVenture baseline PRAJointVenture Ext vent name
KEY DivisionOfInterest baseline DivisionOfInterest Venture/DOI
KEY PRAContract baseline PRAContract Contract
KEY Well baseline Well Well
KEY WellCompletion baseline WellCompletion Well Completion
KEY OriginatingMeasurementPt baseline OriginatingMeasurementPt
KEY Material baseline Material Vehicle Model
KEY CombinedHdrSqncNumber baseline CombinedHdrSqncNumber
KEY MarketingType /pra/rd_crmkt mkt_type Mrktg Type Code
ActualInternalMarketingAmt /pra/rd_crmkt actl_int_mkct Act mkct int
EntldInternalMarketingAmt /pra/rd_crmkt entl_int_mkct Entl mkct int
ActualExternalMarketingAmt /pra/rd_crmkt actl_ext_mkct Actl mkct ext
EntldExternalMarketingAmt /pra/rd_crmkt entl_ext_mkct Entl mkct ext
ActlMktgReimbmtAmt /pra/rd_crmkt actl_mkct_rmb Actual Market reimb
EntldMktgReimbmtAmt /pra/rd_crmkt entl_mkct_rmb Entld Market reimb
CompanyCodeCurrency baseline CompanyCodeCurrency Local Currency
VolumeUnit baseline VolumeUnit Volume Unit
EnergyUnit baseline EnergyUnit

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_PRATstBslnCombinedMktg.
-- 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: IPRATVBCOMBMK1

CREATE VIEW I_PRATstBslnCombinedMktg AS
SELECT
  baseline.BaselineValnDoc AS BaselineValnDoc,
  baseline.BaselineValnDocYear AS BaselineValnDocYear,
  baseline.DeliveryNetwork AS DeliveryNetwork,
  baseline.SalesDate AS SalesDate,
  baseline.PRAJointVenture AS PRAJointVenture,
  baseline.DivisionOfInterest AS DivisionOfInterest,
  baseline.PRAContract AS PRAContract,
  baseline.Well AS Well,
  baseline.WellCompletion AS WellCompletion,
  baseline.OriginatingMeasurementPt AS OriginatingMeasurementPt,
  baseline.Material AS Material,
  baseline.CombinedHdrSqncNumber AS CombinedHdrSqncNumber,
  crmkt.mkt_type AS MarketingType,
  crmkt.actl_int_mkct AS ActualInternalMarketingAmt,
  crmkt.entl_int_mkct AS EntldInternalMarketingAmt,
  crmkt.actl_ext_mkct AS ActualExternalMarketingAmt,
  crmkt.entl_ext_mkct AS EntldExternalMarketingAmt,
  crmkt.actl_mkct_rmb AS ActlMktgReimbmtAmt,
  crmkt.entl_mkct_rmb AS EntldMktgReimbmtAmt,
  baseline.CompanyCodeCurrency AS CompanyCodeCurrency,
  baseline.VolumeUnit AS VolumeUnit,
  baseline.EnergyUnit AS EnergyUnit
FROM /pra/rd_crmkt AS crmkt
;

Learn More