What is C_PRATstCombinedOwnrCompareUI in SAP S/4HANA?

C_PRATstCombinedOwnrCompareUI is a consumption CDS view in SAP S/4HANA. TV - Combine Run Owner - Consp Compare UI It contains 67 fields.

Which tables does C_PRATstCombinedOwnrCompareUI read from?

C_PRATstCombinedOwnrCompareUI reads data from: I_PRATstCombinedOwnrCompareUI.

What VDM layer is C_PRATstCombinedOwnrCompareUI?

C_PRATstCombinedOwnrCompareUI is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PRATstCombinedOwnrCompareUI

DDL: C_PRATSTCOMBINEDOWNRCOMPAREUI SQL: CPRATVCOWNC Type: view CONSUMPTION Package: OIU_TV

67 Fields 1 Data Sources

TV - Combine Run Owner - Consp Compare UI

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

Data Sources (1)

Source	Alias	Join Type
I_PRATstCombinedOwnrCompareUI	I_PRATstCombinedOwnrCompareUI	from

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CPRATVCOWNC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	TV - Combine Run Owner - Consp Compare 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 Owner	view
UI.headerInfo.typeNamePlural	Combined Run Owners	view

Fields (67)

Key	Field	Source Field	Description
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	PRAProduct	PRAProduct	Full Product
KEY	PRAContract	PRAContract	Contract
KEY	Material	Material	Vehicle Model
KEY	PRAOwner	PRAOwner
KEY	OwnerInterestType	OwnerInterestType
KEY	OwnerInterestSequence	OwnerInterestSequence
KEY	ProcessingCompanyCode	ProcessingCompanyCode
KEY	GLAccount	GLAccount	General Ledger
KEY	DisbursementDecimalRatio	DisbursementDecimalRatio
KEY	ValnDocAcctgItem	ValnDocAcctgItem
KEY	CombinedHdrSqncNumber	CombinedHdrSqncNumber
	OwnerPaymentStatus	OwnerPaymentStatus
	SuspenseReason	SuspenseReason
	PRALegalForm	PRALegalForm
	TaxBasis	TaxBasis
	OwnerIsJntIntrstBilgEnabled	OwnerIsJntIntrstBilgEnabled
	ItemIsReallocated	ItemIsReallocated
	AffiliatedCompanyCode	AffiliatedCompanyCode
	BaselineOwnerPaymentStatus	BaselineOwnerPaymentStatus
	BaselineSuspenseReason	BaselineSuspenseReason
	BaselinePRALegalForm	BaselinePRALegalForm
	BaselineTaxBasis	BaselineTaxBasis
	BslnIsJntIntrstBilgEnabled	BslnIsJntIntrstBilgEnabled
	BslnItemIsReallocated	BslnItemIsReallocated
	BslnAffiliatedCompanyCode	BslnAffiliatedCompanyCode
	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	VolumeUnit	VolumeUnit	Volume Unit
	EnergyUnit	EnergyUnit
	OwnerNetVolStsCritlty	OwnerNetVolStsCritlty
	OwnerNetVolInVolUnit	OwnerNetVolInVolUnit
	BaselineOwnerNetVolume	BaselineOwnerNetVolume
	OwnerGrossAmountStsCritlty	OwnerGrossAmountStsCritlty
	OwnerGrossAmount	OwnerGrossAmount
	BaselineOwnerGrossAmount	BaselineOwnerGrossAmount
	OwnerNetAmountStsCritlty	OwnerNetAmountStsCritlty
	OwnerNetAmount	OwnerNetAmount
	BaselineOnwerNetAmount	BaselineOnwerNetAmount
	NetMarketingAmtStsCritlty	NetMarketingAmtStsCritlty
	NetMarketingAmount	NetMarketingAmount
	BaselineNetMktgAmount	BaselineNetMktgAmount
	OwnerVolumeReducnStsCritlty	OwnerVolumeReducnStsCritlty
	OwnrVolReducnInVolUnit	OwnrVolReducnInVolUnit
	BaselineOwnrVolumeReducn	BaselineOwnrVolumeReducn
	OthDeductionAmtStsCritlty	OthDeductionAmtStsCritlty
	OtherDeductionAmount	OtherDeductionAmount
	BslnOtherDeductionAmt	BslnOtherDeductionAmt
	OwnerEnergyStsCritlty	OwnerEnergyStsCritlty
	OwnerEnergyInEnergyUnit	OwnerEnergyInEnergyUnit
	BaselineOwnerEnergy	BaselineOwnerEnergy
	NetReimbmtMktgAmtStsCritlty	NetReimbmtMktgAmtStsCritlty
	NetReimbmtMarketingAmt	NetReimbmtMarketingAmt
	BaselineNetReimbmtMktgAmt	BaselineNetReimbmtMktgAmt
	NetTaxReimbmtAmtStsCritlty	NetTaxReimbmtAmtStsCritlty
	NetTaxReimbmtAmt	NetTaxReimbmtAmt
	BaselineNetTaxReimbmtAmt	BaselineNetTaxReimbmtAmt
	NetTaxAmountStsCritlty	NetTaxAmountStsCritlty
	NetTaxAmount	NetTaxAmount
	BaselineNetTaxAmount	BaselineNetTaxAmount

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_PRATstCombinedOwnrCompareUI.
-- 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: CPRATVCOWNC

CREATE VIEW C_PRATstCombinedOwnrCompareUI AS
SELECT
  CurrentValnDocument,
  CurrentValnDocumentYear,
  DeliveryNetwork,
  SalesDate,
  Well,
  WellCompletion,
  OriginatingMeasurementPt,
  PRAJointVenture,
  DivisionOfInterest,
  PRAProduct,
  PRAContract,
  Material,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  ProcessingCompanyCode,
  GLAccount,
  DisbursementDecimalRatio,
  ValnDocAcctgItem,
  CombinedHdrSqncNumber,
  OwnerPaymentStatus,
  SuspenseReason,
  PRALegalForm,
  TaxBasis,
  OwnerIsJntIntrstBilgEnabled,
  ItemIsReallocated,
  AffiliatedCompanyCode,
  BaselineOwnerPaymentStatus,
  BaselineSuspenseReason,
  BaselinePRALegalForm,
  BaselineTaxBasis,
  BslnIsJntIntrstBilgEnabled,
  BslnItemIsReallocated,
  BslnAffiliatedCompanyCode,
  CompanyCodeCurrency,
  VolumeUnit,
  EnergyUnit,
  OwnerNetVolStsCritlty,
  OwnerNetVolInVolUnit,
  BaselineOwnerNetVolume,
  OwnerGrossAmountStsCritlty,
  OwnerGrossAmount,
  BaselineOwnerGrossAmount,
  OwnerNetAmountStsCritlty,
  OwnerNetAmount,
  BaselineOnwerNetAmount,
  NetMarketingAmtStsCritlty,
  NetMarketingAmount,
  BaselineNetMktgAmount,
  OwnerVolumeReducnStsCritlty,
  OwnrVolReducnInVolUnit,
  BaselineOwnrVolumeReducn,
  OthDeductionAmtStsCritlty,
  OtherDeductionAmount,
  BslnOtherDeductionAmt,
  OwnerEnergyStsCritlty,
  OwnerEnergyInEnergyUnit,
  BaselineOwnerEnergy,
  NetReimbmtMktgAmtStsCritlty,
  NetReimbmtMarketingAmt,
  BaselineNetReimbmtMktgAmt,
  NetTaxReimbmtAmtStsCritlty,
  NetTaxReimbmtAmt,
  BaselineNetTaxReimbmtAmt,
  NetTaxAmountStsCritlty,
  NetTaxAmount,
  BaselineNetTaxAmount
FROM I_PRATstCombinedOwnrCompareUI
;

Depth:

C_PRATstCombinedOwnrCompareUI view

I_PRATstCombinedOwnrCompareUI view