R_JntOpgAgrmtPartShrTP

DDL: R_JNTOPGAGRMTPARTSHRTP SQL: RJOAPS Type: view_entity COMPOSITE
15 Fields 1 Data Sources

Joint Operating Agreement Partner Share

R_JntOpgAgrmtPartShrTP is a Composite CDS View that provides data about "Joint Operating Agreement Partner Share" in SAP S/4HANA. It reads from 1 data source (I_JntOpgAgrmtPartShr) and exposes 15 fields with key fields CompanyCode, JntOpgAgrmt, JntOpgAgrmtEquityGrp, JointVenturePartner.

Data Sources (1)

SourceAliasJoin Type
I_JntOpgAgrmtPartShr JntOpgAgrmtPartShr from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Joint Operating Agreement Partner Share view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JntOpgAgrmtPartShr CompanyCode Receiver Company Code
KEY JntOpgAgrmt I_JntOpgAgrmtPartShr JntOpgAgrmt Joint Oper.Agr
KEY JntOpgAgrmtEquityGrp I_JntOpgAgrmtPartShr JntOpgAgrmtEquityGrp Equity group
KEY JointVenturePartner I_JntOpgAgrmtPartShr JointVenturePartner Joint Venture Partner
JntVntrEquityShare I_JntOpgAgrmtPartShr JntVntrEquityShare Equity Share
JntVntrOwnrIsSuspended I_JntOpgAgrmtPartShr JntVntrOwnrIsSuspended Owner Suspended
JntVntrOwnrSuspendedPerd I_JntOpgAgrmtPartShr JntVntrOwnrSuspendedPerd OSusper
JntVntrOwnrSuspendedYr I_JntOpgAgrmtPartShr JntVntrOwnrSuspendedYr OSysY
JntVntrOwnrIsNotSuspended I_JntOpgAgrmtPartShr JntVntrOwnrIsNotSuspended OwnUsp
JntVntrOwnrNotSuspendedPerd I_JntOpgAgrmtPartShr JntVntrOwnrNotSuspendedPerd GUSUSP
JntVntrOwnrNotSuspendedYr I_JntOpgAgrmtPartShr JntVntrOwnrNotSuspendedYr Grp Unsusp Yr
JntVntrPayIsStppd I_JntOpgAgrmtPartShr JntVntrPayIsStppd StopPay
JntVntrOperatorAddressArea I_JntOpgAgrmtPartShr JntVntrOperatorAddressArea Resident Region
_JntOpgAgrmtEquityGrp _JntOpgAgrmtEquityGrp
_JntOpgAgrmt _JntOpgAgrmt

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_JntOpgAgrmtPartShrTP.
-- 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: RJOAPS

CREATE VIEW R_JntOpgAgrmtPartShrTP AS
SELECT
  JntOpgAgrmtPartShr.CompanyCode AS CompanyCode,
  JntOpgAgrmtPartShr.JntOpgAgrmt AS JntOpgAgrmt,
  JntOpgAgrmtPartShr.JntOpgAgrmtEquityGrp AS JntOpgAgrmtEquityGrp,
  JntOpgAgrmtPartShr.JointVenturePartner AS JointVenturePartner,
  JntOpgAgrmtPartShr.JntVntrEquityShare AS JntVntrEquityShare,
  JntOpgAgrmtPartShr.JntVntrOwnrIsSuspended AS JntVntrOwnrIsSuspended,
  JntOpgAgrmtPartShr.JntVntrOwnrSuspendedPerd AS JntVntrOwnrSuspendedPerd,
  JntOpgAgrmtPartShr.JntVntrOwnrSuspendedYr AS JntVntrOwnrSuspendedYr,
  JntOpgAgrmtPartShr.JntVntrOwnrIsNotSuspended AS JntVntrOwnrIsNotSuspended,
  JntOpgAgrmtPartShr.JntVntrOwnrNotSuspendedPerd AS JntVntrOwnrNotSuspendedPerd,
  JntOpgAgrmtPartShr.JntVntrOwnrNotSuspendedYr AS JntVntrOwnrNotSuspendedYr,
  JntOpgAgrmtPartShr.JntVntrPayIsStppd AS JntVntrPayIsStppd,
  JntOpgAgrmtPartShr.JntVntrOperatorAddressArea AS JntVntrOperatorAddressArea
FROM I_JntOpgAgrmtPartShr AS JntOpgAgrmtPartShr
;

Learn More