R_JntOpgAgrmtTP

DDL: R_JNTOPGAGRMTTP Type: view_entity TRANSACTIONAL
39 Fields 1 Data Sources 9 Associations

Joint Operating Agreement - TP

R_JntOpgAgrmtTP is a Transactional CDS View that provides data about "Joint Operating Agreement - TP" in SAP S/4HANA. It reads from 1 data source (I_JntOpgAgrmt) and exposes 39 fields with key fields CompanyCode, JntOpgAgrmt. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JntOpgAgrmt I_JntOpgAgrmt from

Associations (9)

CardinalityTargetAliasCondition
[1..*] R_JntOpgAgrmtTextTP _JntOpgAgrmtText
[1..*] R_JntOpgAgrmtEquityTypeGrpTP _JntOpgAgrmtEquityGrp
[1..*] R_JntOpgAgrmtPnltyCatRcvryTP _JntOpgAgrmtPnltyCatRcvry
[1..*] R_JntOpgAgrmtPayrollBurdenTP _JntOpgAgrmtPayrollBurden
[1..*] R_JntOpgAgrmtProjSteppedRateTP _JntOpgAgrmtProjSteppedRate
[1..*] R_JntOpgAgrmtProdgStatAssgmtTP _JntOpgAgrmtProdgStatAssgmt
[1..*] R_JntOpgAgrmtProdgStatThldTP _JntOpgAgrmtProdgStatThld
[1..*] R_JntOpgAgrmtDrillingRatioTP _JntOpgAgrmtDrillingRatio
[1..*] R_JntOpgAgrmtParentCoOvhdTP _JntOpgAgrmtParentCoOvhd

Annotations (9)

NameValueLevelField
EndUserText.label Joint Operating Agreement - TP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.sapObjectNodeType.name JointOperatingAgreement view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY JntOpgAgrmt JntOpgAgrmt Joint Oper.Agr
JntVntrContractNmbr JntVntrContractNmbr Trading Contract
JntVntrPayrollClearingSet JntVntrPayrollClearingSet Pay. Clear. Set
JntVntrConstructionExclsnSet JntVntrConstructionExclsnSet Exclude Con.
JntVntrCatastropheExclsnSet JntVntrCatastropheExclsnSet Exclude Cat.
JntVntrConstructionOvhdRule JntVntrConstructionOvhdRule Con. Rule
JntVntrCatastropheOvhdRule JntVntrCatastropheOvhdRule Cat. Rule
JVAOvhdPercentProdg JVAOvhdPercentProdg Payment Period
JVAExclsnAcctSetPercentProdg JVAExclsnAcctSetPercentProdg X Set Per. 1
JVAOvhdPercentDev JVAOvhdPercentDev Payment Period
JVAExclsnAcctSetPercentDev JVAExclsnAcctSetPercentDev X Set Per. 2
JntVntrExplorationOvhdRule JntVntrExplorationOvhdRule Exp. Rule
JntVntrDrillingOvhdRule JntVntrDrillingOvhdRule Drill. Rule
JntVntrCapitalExclsnSet JntVntrCapitalExclsnSet Exclude Cap.
JntVntrOvhdOffsetCostCtr JntVntrOvhdOffsetCostCtr Off. C.C.
JntOpgAgrmtProdgWellThld JntOpgAgrmtProdgWellThld JOA Thresh.
JntVntrOvhdRecurringDoc JntVntrOvhdRecurringDoc Rec. Doc.
CompanyCodeCurrency CompanyCodeCurrency Local Currency
JntVntrOvhdFlatRateAmt JntVntrOvhdFlatRateAmt Flat Rate
JntVntrExpnIsEscalated JntVntrExpnIsEscalated Response
JntOpgAgrmtClass JntOpgAgrmtClass JOA class
JntOpgAgrmtCreatedByUser JntOpgAgrmtCreatedByUser User Name
JntOpgAgrmtCreationTime JntOpgAgrmtCreationTime
JntOpgAgrmtCreationDate JntOpgAgrmtCreationDate
JntOpgAgrmtLastChangedByUser JntOpgAgrmtLastChangedByUser Who Changed
JntOpgAgrmtLastChangedTime JntOpgAgrmtLastChangedTime
JntOpgAgrmtLastChangedDate JntOpgAgrmtLastChangedDate
JntVntrPrioPerdDrillingIsCalc JntVntrPrioPerdDrillingIsCalc Prior Period
JntVntrWBSElmntOvhdIsCalc JntVntrWBSElmntOvhdIsCalc All WBS elem.
_JntOpgAgrmtText _JntOpgAgrmtText
_JntOpgAgrmtEquityGrp _JntOpgAgrmtEquityGrp
_JntOpgAgrmtPnltyCatRcvry _JntOpgAgrmtPnltyCatRcvry
_JntOpgAgrmtProjSteppedRate _JntOpgAgrmtProjSteppedRate
_JntOpgAgrmtProdgStatAssgmt _JntOpgAgrmtProdgStatAssgmt
_JntOpgAgrmtProdgStatThld _JntOpgAgrmtProdgStatThld
_JntOpgAgrmtDrillingRatio _JntOpgAgrmtDrillingRatio
_JntOpgAgrmtParentCoOvhd _JntOpgAgrmtParentCoOvhd
_JntOpgAgrmtPayrollBurden _JntOpgAgrmtPayrollBurden

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 R_JntOpgAgrmtTP.
-- 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 R_JntOpgAgrmtTP AS
SELECT
  CompanyCode,
  JntOpgAgrmt,
  JntVntrContractNmbr,
  JntVntrPayrollClearingSet,
  JntVntrConstructionExclsnSet,
  JntVntrCatastropheExclsnSet,
  JntVntrConstructionOvhdRule,
  JntVntrCatastropheOvhdRule,
  JVAOvhdPercentProdg,
  JVAExclsnAcctSetPercentProdg,
  JVAOvhdPercentDev,
  JVAExclsnAcctSetPercentDev,
  JntVntrExplorationOvhdRule,
  JntVntrDrillingOvhdRule,
  JntVntrCapitalExclsnSet,
  JntVntrOvhdOffsetCostCtr,
  JntOpgAgrmtProdgWellThld,
  JntVntrOvhdRecurringDoc,
  CompanyCodeCurrency,
  JntVntrOvhdFlatRateAmt,
  JntVntrExpnIsEscalated,
  JntOpgAgrmtClass,
  JntOpgAgrmtCreatedByUser,
  JntOpgAgrmtCreationTime,
  JntOpgAgrmtCreationDate,
  JntOpgAgrmtLastChangedByUser,
  JntOpgAgrmtLastChangedTime,
  JntOpgAgrmtLastChangedDate,
  JntVntrPrioPerdDrillingIsCalc,
  JntVntrWBSElmntOvhdIsCalc
FROM I_JntOpgAgrmt
LEFT OUTER JOIN R_JntOpgAgrmtTextTP AS _JntOpgAgrmtText ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtEquityTypeGrpTP AS _JntOpgAgrmtEquityGrp ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtPnltyCatRcvryTP AS _JntOpgAgrmtPnltyCatRcvry ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtPayrollBurdenTP AS _JntOpgAgrmtPayrollBurden ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtProjSteppedRateTP AS _JntOpgAgrmtProjSteppedRate ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtProdgStatAssgmtTP AS _JntOpgAgrmtProdgStatAssgmt ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtProdgStatThldTP AS _JntOpgAgrmtProdgStatThld ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtDrillingRatioTP AS _JntOpgAgrmtDrillingRatio ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_JntOpgAgrmtParentCoOvhdTP AS _JntOpgAgrmtParentCoOvhd ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More