C_PRATstCombinedMktgCompareUI

DDL: C_PRATSTCOMBINEDMKTGCOMPAREUI SQL: CPRATVCMKTC Type: view CONSUMPTION Package: OIU_TV
32 Fields 1 Data Sources

TV - Combine Run Marketing - UI

C_PRATstCombinedMktgCompareUI is a Consumption CDS View that provides data about "TV - Combine Run Marketing - UI" in SAP S/4HANA. It reads from 1 data source (I_PRATstCombinedMktgCompareUI) and exposes 32 fields with key fields CurrentValnDocument, CurrentValnDocumentYear, DeliveryNetwork, SalesDate, Well. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstCombinedMktgCompareUI I_PRATstCombinedMktgCompareUI from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPRATVCMKTC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label TV - Combine Run Marketing - UI view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName Combined Run Marketing view
UI.headerInfo.typeNamePlural Combined Run Marketings view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CurrentValnDocument CurrentValnDocument DocNr
KEY CurrentValnDocumentYear CurrentValnDocumentYear Document year
KEY DeliveryNetwork DeliveryNetwork Delivery network ID
KEY SalesDate SalesDate Sales Date
KEY Well Well Well
KEY WellCompletion WellCompletion Well Completion
KEY OriginatingMeasurementPt OriginatingMeasurementPt
KEY PRAJointVenture PRAJointVenture Ext vent name
KEY DivisionOfInterest DivisionOfInterest Venture/DOI
KEY PRAContract PRAContract Contract
KEY Material Material Vehicle Model
KEY MarketingType MarketingType
KEY CombinedHdrSqncNumber CombinedHdrSqncNumber
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ActlInternalMktgStsCritlty ActlInternalMktgStsCritlty
ActualInternalMarketingAmt ActualInternalMarketingAmt
BslnActlInternalMktgAmt BslnActlInternalMktgAmt
ActlExternalMktgStsCritlty ActlExternalMktgStsCritlty
ActualExternalMarketingAmt ActualExternalMarketingAmt
BslnActlExtMktgAmt BslnActlExtMktgAmt
EntldInternalMktgStsCritlty EntldInternalMktgStsCritlty
EntldInternalMarketingAmt EntldInternalMarketingAmt
BslnEntldInternalMktgAmt BslnEntldInternalMktgAmt
EntldExtMktgStsCritlty EntldExtMktgStsCritlty
EntldExternalMarketingAmt EntldExternalMarketingAmt
BslnEntldExternalMktgAmt BslnEntldExternalMktgAmt
ActlMktgReimbmtStsCritlty ActlMktgReimbmtStsCritlty
ActlMktgReimbmtAmt ActlMktgReimbmtAmt
BslnActlMktgReimbmtAmt BslnActlMktgReimbmtAmt
EntldMktgReimbmtStsCritlty EntldMktgReimbmtStsCritlty
EntldMktgReimbmtAmt EntldMktgReimbmtAmt
BslnEntldMktgReimbmtAmt BslnEntldMktgReimbmtAmt

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 C_PRATstCombinedMktgCompareUI.
-- 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: CPRATVCMKTC

CREATE VIEW C_PRATstCombinedMktgCompareUI AS
SELECT
  CurrentValnDocument,
  CurrentValnDocumentYear,
  DeliveryNetwork,
  SalesDate,
  Well,
  WellCompletion,
  OriginatingMeasurementPt,
  PRAJointVenture,
  DivisionOfInterest,
  PRAContract,
  Material,
  MarketingType,
  CombinedHdrSqncNumber,
  CompanyCodeCurrency,
  ActlInternalMktgStsCritlty,
  ActualInternalMarketingAmt,
  BslnActlInternalMktgAmt,
  ActlExternalMktgStsCritlty,
  ActualExternalMarketingAmt,
  BslnActlExtMktgAmt,
  EntldInternalMktgStsCritlty,
  EntldInternalMarketingAmt,
  BslnEntldInternalMktgAmt,
  EntldExtMktgStsCritlty,
  EntldExternalMarketingAmt,
  BslnEntldExternalMktgAmt,
  ActlMktgReimbmtStsCritlty,
  ActlMktgReimbmtAmt,
  BslnActlMktgReimbmtAmt,
  EntldMktgReimbmtStsCritlty,
  EntldMktgReimbmtAmt,
  BslnEntldMktgReimbmtAmt
FROM I_PRATstCombinedMktgCompareUI
;

Learn More