I_PRAContrMarketingDet

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_PRAContrMarketingDet.
-- 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: IPRACTMKTGDET

CREATE VIEW I_PRAContrMarketingDet AS
SELECT
  cmcc_no AS ContractMarketingCostControl,
  mkct_type_cd AS MarketingType,
  ded_rmb_cd AS DeductionReimbursementType,
  ded_rmb_pc AS DeductionReimbursementPercent,
  vbas_cd AS PRAVolumeBasisCode,
  ded_rmbrt_am AS DeductionReimbursementRateAmt,
  fix_am_u AS Currency,
  fix_am AS PRADdctdFixedAmount,
  recoup_fl AS AmountIsRecoupedFlag,
  ss_table_cd AS MethodTableCode,
  bukrs AS CompanyCode,
  vname AS CreditPlantVenture,
  doi_no AS CreditPlantDivisionOfInterest,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS PRACreationDateTime
FROM oiu_rv_cmcd
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAJointVenture AS _JointVenture ON CompanyCode = _JointVenture.CompanyCode AND CreditPlantVenture = _JointVenture.PRAJointVenture  -- association [1..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _DivisionOfInterest ON CompanyCode = _DivisionOfInterest.CompanyCode AND CreditPlantVenture = _DivisionOfInterest.JointVenture AND CreditPlantDivisionOfInterest = _DivisionOfInterest.DivisionOfInterest  -- association [1..1]
;