C_JntOpgAgrmtObjectPage

DDL: C_JNTOPGAGRMTOBJECTPAGE SQL: CJOAOBJPG Type: view CONSUMPTION
37 Fields 1 Data Sources 9 Associations

Object Page for Joint Operating Agrmt

C_JntOpgAgrmtObjectPage is a Consumption CDS View that provides data about "Object Page for Joint Operating Agrmt" in SAP S/4HANA. It reads from 1 data source (I_JntOpgAgrmtDetail) and exposes 37 fields with key fields CompanyCode, JntOpgAgrmt. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_JntOpgAgrmtDetail I_JntOpgAgrmtDetail from

Associations (9)

CardinalityTargetAliasCondition
[0..*] C_JntOpgAgrmtObjPgEquityGrp _JntOpgAgrmtObjPgEquityGrp $projection.CompanyCode = _JntOpgAgrmtObjPgEquityGrp.CompanyCode and $projection.JntOpgAgrmt = _JntOpgAgrmtObjPgEquityGrp.JntOpgAgrmt
[0..*] C_JntOpgAgrmtProjSteppedRate _JntOpgAgrmtProjSteppedRate $projection.CompanyCode = _JntOpgAgrmtProjSteppedRate.CompanyCode and $projection.JntOpgAgrmt = _JntOpgAgrmtProjSteppedRate.JntOpgAgrmt
[0..*] C_JntVntrProdgStstclRatio _JntVntrProdgStstclAssgmt $projection.CompanyCode = _JntVntrProdgStstclAssgmt.CompanyCode and $projection.JntOpgAgrmt = _JntVntrProdgStstclAssgmt.JntOpgAgrmt
[0..*] C_JntVntrDrillingStstclAssgmt _JntVntrDrillingStstclAssgmt $projection.CompanyCode = _JntVntrDrillingStstclAssgmt.CompanyCode and $projection.JntOpgAgrmt = _JntVntrDrillingStstclAssgmt.JntOpgAgrmt
[0..*] C_JntOpgAgrmtOvhdBurdenRatePct _JntOpgAgrmtOvhdBurdenRatePct $projection.CompanyCode = _JntOpgAgrmtOvhdBurdenRatePct.CompanyCode and $projection.JntOpgAgrmt = _JntOpgAgrmtOvhdBurdenRatePct.JntOpgAgrmt
[0..*] C_JntOpgAgrmtParentCoOvhd _JntOpgAgrmtParentCoOvhd $projection.CompanyCode = _JntOpgAgrmtParentCoOvhd.CompanyCode and $projection.JntOpgAgrmt = _JntOpgAgrmtParentCoOvhd.JntOpgAgrmt
[0..*] C_JntOpgAgrmtPnltyCatRcvryPct _JntOpgAgrmtPnltyCatRcvryPct $projection.CompanyCode = _JntOpgAgrmtPnltyCatRcvryPct.CompanyCode and $projection.JntOpgAgrmt = _JntOpgAgrmtPnltyCatRcvryPct.JntOpgAgrmt
[0..1] C_JointVentureCompanyCodeVH _JointVentureCompanyCodeVH $projection.CompanyCode = _JointVentureCompanyCodeVH.CompanyCode
[0..1] C_JntOpgAgrmtVH _JntOpgAgrmtVH $projection.CompanyCode = _JntOpgAgrmtVH.CompanyCode and $projection.JntOpgAgrmt = _JntOpgAgrmtVH.JntOpgAgrmt

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CJOAOBJPG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.draftEnabled false view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
EndUserText.label Object Page for Joint Operating Agrmt view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY JntOpgAgrmt JntOpgAgrmt Joint Operating Agreement
JntOpgAgrmtText JntOpgAgrmtText
JntOpgAgrmtClass JntOpgAgrmtClass JOA Class
JntVntrContractNmbr JntVntrContractNmbr
JVAOvhdPercentProdg JVAOvhdPercentProdg Producing Overhead %
JVAExclsnAcctSetPercentProdg JVAExclsnAcctSetPercentProdg Producing Exclusion Set Account
JVAOvhdPercentDev JVAOvhdPercentDev Development Overhead %
JVAExclsnAcctSetPercentDev JVAExclsnAcctSetPercentDev Development Exclusion Set Account
JntVntrExpnIsEscalated JntVntrExpnIsEscalated
CompanyCodeCurrency CompanyCodeCurrency Local Currency
JntVntrOvhdFlatRateAmt JntVntrOvhdFlatRateAmt
JntVntrOvhdOffsetCostCtr JntVntrOvhdOffsetCostCtr
JntVntrOvhdRecurringDoc JntVntrOvhdRecurringDoc
JntOpgAgrmtCreatedByUser JntOpgAgrmtCreatedByUser Created By
JntOpgAgrmtLastChangedByUser JntOpgAgrmtLastChangedByUser Changed By
JntOpgAgrmtLastChangedDateTime JntOpgAgrmtLastChangedDateTime Changed On
JntVntrConstructionOvhdRule JntVntrConstructionOvhdRule Construction Overhead Rule
JntVntrConstructionExclsnSet JntVntrConstructionExclsnSet Exclude Set Account Construction O/H
JntVntrCatastropheExclsnSet JntVntrCatastropheExclsnSet Exclude Set Account Catastrophe O/H
JntVntrCatastropheOvhdRule JntVntrCatastropheOvhdRule Catastrophe Overhead Rule
JVAParCoOvhdSectionIsVisible JVAParCoOvhdSectionIsVisible
JVASteppedRateSectionIsVisible JVASteppedRateSectionIsVisible
_CompanyCode _CompanyCode
_JntOpgAgrmtClass _JntOpgAgrmtClass
_JntOpgAgrmtText _JntOpgAgrmtText
_CreatedByUserContactCard _CreatedByUserContactCard
_ChangedByUserContactCard _ChangedByUserContactCard
_JointVentureCompanyCodeVH _JointVentureCompanyCodeVH
_JntOpgAgrmtVH _JntOpgAgrmtVH
_JntOpgAgrmtObjPgEquityGrp _JntOpgAgrmtObjPgEquityGrp
_JntOpgAgrmtProjSteppedRate _JntOpgAgrmtProjSteppedRate
_JntVntrProdgStstclAssgmt _JntVntrProdgStstclAssgmt
_JntVntrDrillingStstclAssgmt _JntVntrDrillingStstclAssgmt
_JntOpgAgrmtOvhdBurdenRatePct _JntOpgAgrmtOvhdBurdenRatePct
_JntOpgAgrmtParentCoOvhd _JntOpgAgrmtParentCoOvhd
_JntOpgAgrmtPnltyCatRcvryPct _JntOpgAgrmtPnltyCatRcvryPct

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_JntOpgAgrmtObjectPage.
-- 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: CJOAOBJPG

CREATE VIEW C_JntOpgAgrmtObjectPage AS
SELECT
  CompanyCode,
  JntOpgAgrmt,
  JntOpgAgrmtText,
  JntOpgAgrmtClass,
  JntVntrContractNmbr,
  JVAOvhdPercentProdg,
  JVAExclsnAcctSetPercentProdg,
  JVAOvhdPercentDev,
  JVAExclsnAcctSetPercentDev,
  JntVntrExpnIsEscalated,
  CompanyCodeCurrency,
  JntVntrOvhdFlatRateAmt,
  JntVntrOvhdOffsetCostCtr,
  JntVntrOvhdRecurringDoc,
  JntOpgAgrmtCreatedByUser,
  JntOpgAgrmtLastChangedByUser,
  JntOpgAgrmtLastChangedDateTime,
  JntVntrConstructionOvhdRule,
  JntVntrConstructionExclsnSet,
  JntVntrCatastropheExclsnSet,
  JntVntrCatastropheOvhdRule,
  JVAParCoOvhdSectionIsVisible,
  JVASteppedRateSectionIsVisible
FROM I_JntOpgAgrmtDetail
LEFT OUTER JOIN C_JntOpgAgrmtObjPgEquityGrp AS _JntOpgAgrmtObjPgEquityGrp ON CompanyCode = _JntOpgAgrmtObjPgEquityGrp.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtObjPgEquityGrp.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN C_JntOpgAgrmtProjSteppedRate AS _JntOpgAgrmtProjSteppedRate ON CompanyCode = _JntOpgAgrmtProjSteppedRate.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtProjSteppedRate.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN C_JntVntrProdgStstclRatio AS _JntVntrProdgStstclAssgmt ON CompanyCode = _JntVntrProdgStstclAssgmt.CompanyCode AND JntOpgAgrmt = _JntVntrProdgStstclAssgmt.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN C_JntVntrDrillingStstclAssgmt AS _JntVntrDrillingStstclAssgmt ON CompanyCode = _JntVntrDrillingStstclAssgmt.CompanyCode AND JntOpgAgrmt = _JntVntrDrillingStstclAssgmt.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN C_JntOpgAgrmtOvhdBurdenRatePct AS _JntOpgAgrmtOvhdBurdenRatePct ON CompanyCode = _JntOpgAgrmtOvhdBurdenRatePct.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtOvhdBurdenRatePct.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN C_JntOpgAgrmtParentCoOvhd AS _JntOpgAgrmtParentCoOvhd ON CompanyCode = _JntOpgAgrmtParentCoOvhd.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtParentCoOvhd.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN C_JntOpgAgrmtPnltyCatRcvryPct AS _JntOpgAgrmtPnltyCatRcvryPct ON CompanyCode = _JntOpgAgrmtPnltyCatRcvryPct.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtPnltyCatRcvryPct.JntOpgAgrmt  -- association [0..*]
LEFT OUTER JOIN C_JointVentureCompanyCodeVH AS _JointVentureCompanyCodeVH ON CompanyCode = _JointVentureCompanyCodeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_JntOpgAgrmtVH AS _JntOpgAgrmtVH ON CompanyCode = _JntOpgAgrmtVH.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmtVH.JntOpgAgrmt  -- association [0..1]
;

Learn More