I_PRAValnDocTransFmlaMktgDet

DDL: I_PRAVALNDOCTRANSFMLAMKTGDET Type: view_entity BASIC
21 Fields 1 Data Sources 1 Associations

Valuation Tran Level 3 Marketing Detail

I_PRAValnDocTransFmlaMktgDet (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

PRAValnDocTransFmlaMktgDet · Cross Applications

I_PRAValnDocTransFmlaMktgDet is a Basic CDS View that provides data about "Valuation Tran Level 3 Marketing Detail" in SAP S/4HANA. It reads from 1 data source (oiurv_doc_frmmkt) and exposes 21 fields with key fields ValuationDocumentNumber, ValuationDocumentYear, ValuationDocumentLineNumber, PRAPositionNumber, MarketingType. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Production and Revenue Accounting (PRA)
Purpose
This CDS view provides information regarding the formula marketing costs and reimbursements for the marketing types that are processed by the valuation document.

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: O_OIU_TXN:ACTVT-03,O_OIU_TXN:OIU_TCODE-O3URV_DOC (Mapping role for I_PRAValnDocTransFmlaMktgDet )

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source in SQL Select
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides information regarding the formula marketing costs and reimbursements for the marketing types that are processed by the valuation document. </p>

Documentation

Data Sources (1)

SourceAliasJoin Type
oiurv_doc_frmmkt oiurv_doc_frmmkt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PRAMktgCostChangeLevelVH _PRAMktgCostChangeLevelVH _PRAMktgCostChangeLevelVH.PRAMktCostChangeLevel = $projection.PRAMktgCostChangeLevel

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Valuation Tran Level 3 Marketing Detail view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name PRAValnDocTransFmlaMktgDet view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ValuationDocumentNumber doc_no Val. document number
KEY ValuationDocumentYear doc_year Mat. Doc. Year
KEY ValuationDocumentLineNumber line_no Document Line Number
KEY PRAPositionNumber pos_no Tax doc. item number
KEY MarketingType mkt_type Marketing type code
KEY PRAActualEntitledSettlement aes_cd Actual / Entitled / Settlement Code
PRAMktgCostChangeLevel mkt_cost_chg_lvl Marketing Cost Change Level for VCR Reprocessing
PRATransporter trnsp_no Transporter number
PRATransporterContractNumber trnsp_ct_no Transporter contract number
PRAInternalCompanyCode int_bukrs Internal Company Code
PRAInternalVenture int_vname Internal venture name
PRAInternalDivisionOfInterest int_doi_no Internal division of interest number
PRAExternalCompanyCode ext_bukrs External Company Code
PRAExternalVenture ext_vname External venture name
PRAExternalDivisionOfInterest ext_doi_no External division of interest number
PRAExtActualMarketingCost mkct_ext Actual marketing cost external
PRAIntActualMarketingCost mkct_int Actual marketing cost internal
PRAReimbmtExtActlMktgCost mcr_ext Actual marketing cost reimbursement external
PRAGrossValueCurrency gr_val_curr Currency Key
AmountIsRecoupedFlag ext_recoup_fl Recoupment Flag
_PRAMktgCostChangeLevelVH _PRAMktgCostChangeLevelVH

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_PRAValnDocTransFmlaMktgDet.
-- 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_PRAValnDocTransFmlaMktgDet AS
SELECT
  doc_no AS ValuationDocumentNumber,
  doc_year AS ValuationDocumentYear,
  line_no AS ValuationDocumentLineNumber,
  pos_no AS PRAPositionNumber,
  mkt_type AS MarketingType,
  aes_cd AS PRAActualEntitledSettlement,
  mkt_cost_chg_lvl AS PRAMktgCostChangeLevel,
  trnsp_no AS PRATransporter,
  trnsp_ct_no AS PRATransporterContractNumber,
  int_bukrs AS PRAInternalCompanyCode,
  int_vname AS PRAInternalVenture,
  int_doi_no AS PRAInternalDivisionOfInterest,
  ext_bukrs AS PRAExternalCompanyCode,
  ext_vname AS PRAExternalVenture,
  ext_doi_no AS PRAExternalDivisionOfInterest,
  mkct_ext AS PRAExtActualMarketingCost,
  mkct_int AS PRAIntActualMarketingCost,
  mcr_ext AS PRAReimbmtExtActlMktgCost,
  gr_val_curr AS PRAGrossValueCurrency,
  ext_recoup_fl AS AmountIsRecoupedFlag
FROM oiurv_doc_frmmkt
LEFT OUTER JOIN I_PRAMktgCostChangeLevelVH AS _PRAMktgCostChangeLevelVH ON _PRAMktgCostChangeLevelVH.PRAMktCostChangeLevel = PRAMktgCostChangeLevel  -- association [1..1]
;

Learn More