C_PRAIntProcgFirstProdDateTP

DDL: C_PRAINTPROCGFIRSTPRODDATETP Type: view_entity CONSUMPTION Package: OIU_ODATA_REV_INTEREST
30 Fields 1 Data Sources 1 OData Services

PRA Interest Processing First Prodn Date

C_PRAIntProcgFirstProdDateTP is a Consumption CDS View that provides data about "PRA Interest Processing First Prodn Date" in SAP S/4HANA. It reads from 1 data source (R_PRAIntProcgFirstProdDateTP) and exposes 30 fields with key fields PRAFirstProdnUUID, PRAProduct. It is exposed through 1 OData service (UI_PIPFIRSTPRODNDATEMANAGE). Part of development package OIU_ODATA_REV_INTEREST.

Data Sources (1)

SourceAliasJoin Type
R_PRAIntProcgFirstProdDateTP R_PRAIntProcgFirstProdDateTP projection

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PRA Interest Processing First Prodn Date view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Search.searchable true view
OData.entityType.name PIPFirstProdnDate_Type view
OData.entitySet.name PIPFirstProdnDate view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PIPFIRSTPRODNDATEMANAGE UI_PIPFIRSTPRODNDATEMANAGE V4 C1 NOT_RELEASED

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PRAFirstProdnUUID PRAFirstProdnUUID
KEY PRAProduct PRAProduct Full Product
ProductName
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Well Well Well
WellName _Well WellName
WellCompletion WellCompletion Well Completion
WellCompletionName _WellCompletion WellCompletionName
PRAJointVenture PRAJointVenture Ext vent name
PRAJointVentureName _PRAJointVenture PRAJointVentureName
DivisionOfInterest DivisionOfInterest Venture/DOI
DivisionOfInterestName _DivisionOfInterest DivisionOfInterestName
CostCenter CostCenter Cost Center
CostCenterDescription
PRAFirstProductionMode PRAFirstProductionMode
PRAFirstProdnDateModeTxt
PRAFirstProductionDate PRAFirstProductionDate
PRACreatedByName PRACreatedByName
PRACreationDateTime PRACreationDateTime Time Stamp
PRALastChangedByName PRALastChangedByName
PRALastChangedAtDteTme PRALastChangedAtDteTme
_FirstProdnDateMode _FirstProdnDateMode
_CompanyCode _CompanyCode
_PRAJointVenture _PRAJointVenture
_DivisionOfInterest _DivisionOfInterest
_Well _Well
_WellCompletion _WellCompletion
_PRACostCenter _PRACostCenter
_PRAProduct _PRAProduct

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_PRAIntProcgFirstProdDateTP.
-- 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 C_PRAIntProcgFirstProdDateTP AS
SELECT
  PRAFirstProdnUUID,
  PRAProduct,
  _PRAProduct._Text[1: Language=$session.system_language].ProductName AS ProductName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Well,
  _Well.WellName AS WellName,
  WellCompletion,
  _WellCompletion.WellCompletionName AS WellCompletionName,
  PRAJointVenture,
  _PRAJointVenture.PRAJointVentureName AS PRAJointVentureName,
  DivisionOfInterest,
  _DivisionOfInterest.DivisionOfInterestName AS DivisionOfInterestName,
  CostCenter,
  _PRACostCenter._Text[1: Language=$session.system_language].CostCenterDescription AS CostCenterDescription,
  PRAFirstProductionMode,
  _FirstProdnDateMode._Text[1: Language=$session.system_language].PRAFirstProdnDateModeTxt AS PRAFirstProdnDateModeTxt,
  PRAFirstProductionDate,
  PRACreatedByName,
  PRACreationDateTime,
  PRALastChangedByName,
  PRALastChangedAtDteTme
FROM R_PRAIntProcgFirstProdDateTP
;

Learn More