I_JVAAssgdProdgStstclRatioThld

DDL: I_JVAASSGDPRODGSTSTCLRATIOTHLD SQL: IJVASGPRDSTRTTH Type: view BASIC
10 Fields 1 Data Sources 2 Associations

Assgd Prodg Statistical Ratio Threshold

I_JVAAssgdProdgStstclRatioThld is a Basic CDS View that provides data about "Assgd Prodg Statistical Ratio Threshold" in SAP S/4HANA. It reads from 1 data source (t8j8i) and exposes 10 fields with key fields CompanyCode, JntOpgAgrmt, JntVntrProducingStstclRatioID, JointVentureSequenceNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t8j8i t8j8i from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_JntOpgAgrmt _JntOpgAgrmt $projection.CompanyCode = _JntOpgAgrmt.CompanyCode and $projection.JntOpgAgrmt = _JntOpgAgrmt.JntOpgAgrmt

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IJVASGPRDSTRTTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Assgd Prodg Statistical Ratio Threshold view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY JntOpgAgrmt joa Joint Oper.Agr
KEY JntVntrProducingStstclRatioID prstat Prod.Stat.Rat.
KEY JointVentureSequenceNumber seqnum Sequential Number
JntVntrThresholdNumberOfWells threshold Upper Threshold (%)
JointVentureRatePerProdgWell rate Tax Rate
Currency _CompanyCode Currency Valuation Crcy
_CompanyCode _CompanyCode
_Currency _CompanyCode _Currency
_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 I_JVAAssgdProdgStstclRatioThld.
-- 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: IJVASGPRDSTRTTH

CREATE VIEW I_JVAAssgdProdgStstclRatioThld AS
SELECT
  bukrs AS CompanyCode,
  joa AS JntOpgAgrmt,
  prstat AS JntVntrProducingStstclRatioID,
  seqnum AS JointVentureSequenceNumber,
  threshold AS JntVntrThresholdNumberOfWells,
  rate AS JointVentureRatePerProdgWell,
  _CompanyCode.Currency AS Currency,
  _CompanyCode._Currency AS _Currency
FROM t8j8i
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntOpgAgrmt AS _JntOpgAgrmt ON CompanyCode = _JntOpgAgrmt.CompanyCode AND JntOpgAgrmt = _JntOpgAgrmt.JntOpgAgrmt  -- association [0..1]
;

Learn More