I_PRAMaintSlidingScaleHdr

DDL: I_PRAMAINTSLIDINGSCALEHDR Type: view BASIC
18 Fields 2 Data Sources 1 Associations

Maintain Sliding Scale Header XI

I_PRAMaintSlidingScaleHdr is a Basic CDS View that provides data about "Maintain Sliding Scale Header XI" in SAP S/4HANA. It reads from 2 data sources (oiu_do_do, oiuow_ssh) and exposes 18 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest, PRACustomerSupplierCode, PRAOwner. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
oiu_do_do oiu_do_do inner
oiuow_ssh oiuow_ssh from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_PRAMaintSlidingScale _PRAMaintSlidingScale

Annotations (11)

NameValueLevelField
EndUserText.label Maintain Sliding Scale Header XI view
AbapCatalog.sqlViewName IPRASSH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode oiu_do_do bukrs Value
KEY PRAJointVenture oiu_do_do vname Volatility Name
KEY DivisionOfInterest oiu_do_do doi_no Venture/DOI
KEY PRACustomerSupplierCode oiu_do_do cust_vend_cd Ocust vend cd
KEY PRAOwner oiu_do_do own_no Owner Number
KEY OwnerInterestType oiu_do_do own_int_type_cd Opart int type
KEY OwnerInterestSequence oiu_do_do own_isq_no Own. ISQ
KEY DOIOwnerEffectiveFromDate oiu_do_do eff_from_dt Effective From Date
KEY PRASlidingScaleNumber oiuow_ssh ssh_no Slid.scale no
PRASlidingScComprnOptrCode oiuow_ssh ltge_cd Lt gt eq cd
PRASlidingScaleMethod oiuow_ssh ssc_meth_cd Sliding sc.meth
PRASlidingScaleRangeCode oiuow_ssh vl_rng_cd Volume range cd
PRASlidingScaleGravityVal oiuow_ssh grv_qy Gravity qty.
PRADivisionOfInterestNmbr oiuow_ssh do_no Div.int.no
CreatedByUser oiuow_ssh oiu_cruser Created By
CreationDateTime oiuow_ssh oiu_timestamp Timestamp
_PRAMaintDOIOwner _PRAMaintDOIOwner
_PRAMaintSlidingScale _PRAMaintSlidingScale

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_PRAMaintSlidingScaleHdr.
-- 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 I_PRAMaintSlidingScaleHdr AS
SELECT
  oiu_do_do.bukrs AS CompanyCode,
  oiu_do_do.vname AS PRAJointVenture,
  oiu_do_do.doi_no AS DivisionOfInterest,
  oiu_do_do.cust_vend_cd AS PRACustomerSupplierCode,
  oiu_do_do.own_no AS PRAOwner,
  oiu_do_do.own_int_type_cd AS OwnerInterestType,
  oiu_do_do.own_isq_no AS OwnerInterestSequence,
  oiu_do_do.eff_from_dt AS DOIOwnerEffectiveFromDate,
  oiuow_ssh.ssh_no AS PRASlidingScaleNumber,
  oiuow_ssh.ltge_cd AS PRASlidingScComprnOptrCode,
  oiuow_ssh.ssc_meth_cd AS PRASlidingScaleMethod,
  oiuow_ssh.vl_rng_cd AS PRASlidingScaleRangeCode,
  oiuow_ssh.grv_qy AS PRASlidingScaleGravityVal,
  oiuow_ssh.do_no AS PRADivisionOfInterestNmbr,
  oiuow_ssh.oiu_cruser AS CreatedByUser,
  oiuow_ssh.oiu_timestamp AS CreationDateTime
FROM oiuow_ssh
INNER JOIN oiu_do_do ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PRAMaintSlidingScale AS _PRAMaintSlidingScale ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More