I_PRAMaintSlidingScale

DDL: I_PRAMAINTSLIDINGSCALE Type: view BASIC
15 Fields 3 Data Sources

Maintain Owner Sliding Scale XI

I_PRAMaintSlidingScale is a Basic CDS View that provides data about "Maintain Owner Sliding Scale XI" in SAP S/4HANA. It reads from 3 data sources (oiu_do_do, oiuow_oss, oiuow_ssh) and exposes 15 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest, PRACustomerSupplierCode, PRAOwner.

Data Sources (3)

SourceAliasJoin Type
oiu_do_do oiu_do_do inner
oiuow_oss oiuow_oss from
oiuow_ssh oiuow_ssh inner

Annotations (11)

NameValueLevelField
EndUserText.label Maintain Owner Sliding Scale XI view
AbapCatalog.sqlViewName IPRAOSS 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 (15)

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_oss ssh_no Slid.scale no
KEY PRASlidingScaleRangeFromVal oiuow_oss vl_from_rng Vol.from.rng
PRASlidingScaleRangeToVal oiuow_oss vl_to_rng Vol to rng.qty
PRASlidingScaleRangeIncrmtVal oiuow_oss vl_incr_dec Vl.incr.dec.qt
CreatedByUser oiuow_oss oiu_cruser Created By
CreationDateTime oiuow_oss oiu_timestamp Timestamp
_PRAMaintSlidingScaleHdr _PRAMaintSlidingScaleHdr

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_PRAMaintSlidingScale.
-- 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_PRAMaintSlidingScale 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_oss.ssh_no AS PRASlidingScaleNumber,
  oiuow_oss.vl_from_rng AS PRASlidingScaleRangeFromVal,
  oiuow_oss.vl_to_rng AS PRASlidingScaleRangeToVal,
  oiuow_oss.vl_incr_dec AS PRASlidingScaleRangeIncrmtVal,
  oiuow_oss.oiu_cruser AS CreatedByUser,
  oiuow_oss.oiu_timestamp AS CreationDateTime
FROM oiuow_oss
INNER JOIN oiuow_ssh ON /* join condition not captured in parsed metadata */
INNER JOIN oiu_do_do ON /* join condition not captured in parsed metadata */
;

Learn More