R_ProductionCampaignTP

DDL: R_PRODUCTIONCAMPAIGNTP Type: view_entity TRANSACTIONAL Package: VDM_PP_PRODNCMPGN
16 Fields 1 Data Sources 2 Associations

Production Campaign Header - TP

R_ProductionCampaignTP is a Transactional CDS View that provides data about "Production Campaign Header - TP" in SAP S/4HANA. It reads from 1 data source (I_ProductionCampaign) and exposes 16 fields with key field ProductionCampaign. It has 2 associations to related views. Part of development package VDM_PP_PRODNCMPGN.

Data Sources (1)

SourceAliasJoin Type
I_ProductionCampaign I_ProductionCampaign from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ProductPlantBasic _ProductPlant $projection.Plant = _ProductPlant.Plant and $projection.Product = _ProductPlant.Product
[0..1] I_ProdnCmpgnTotItmQty _ProdnCmpgnTotItmQty $projection.ProductionCampaign = _ProdnCmpgnTotItmQty.ProductionCampaign

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Production Campaign Header - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
ObjectModel.sapObjectNodeType.name ProductionCampaign view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProductionCampaign I_ProductionCampaign ProductionCampaign Campaign
ValidityStartDate I_ProductionCampaign ValidityStartDate Validity Start Date
ValidityEndDate I_ProductionCampaign ValidityEndDate ValidTo
ProductionCampaignTaktUnit I_ProductionCampaign ProductionCampaignTaktUnit UoM: Conv. to
ProductionCampaignTaktDuration I_ProductionCampaign ProductionCampaignTaktDuration Takt Time
ProductionCampaignText I_ProductionCampaign ProductionCampaignText Description
BusinessProcess I_ProductionCampaign BusinessProcess Business Process
BaseUnit I_ProductionCampaign BaseUnit Unit of Measure
ProductionCampaignQuantity I_ProductionCampaign ProductionCampaignQuantity WarrCountValue
Product I_ProductionCampaign Product Product Sold
Plant I_ProductionCampaign Plant Valuation Area
FixedLotSizeQuantity _ProductPlant FixedLotSizeQuantity Fixed lot size
MaterialBaseUnit _ProdnCmpgnTotItmQty MaterialBaseUnit Valuation Unit
PlannedTotalQtyInBaseUnit _ProdnCmpgnTotItmQty PlannedTotalQtyInBaseUnit Total Items
_ProductPlant _ProductPlant
_ProdnCmpgnTotItmQty _ProdnCmpgnTotItmQty

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 R_ProductionCampaignTP.
-- 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 R_ProductionCampaignTP AS
SELECT
  I_ProductionCampaign.ProductionCampaign AS ProductionCampaign,
  I_ProductionCampaign.ValidityStartDate AS ValidityStartDate,
  I_ProductionCampaign.ValidityEndDate AS ValidityEndDate,
  I_ProductionCampaign.ProductionCampaignTaktUnit AS ProductionCampaignTaktUnit,
  I_ProductionCampaign.ProductionCampaignTaktDuration AS ProductionCampaignTaktDuration,
  I_ProductionCampaign.ProductionCampaignText AS ProductionCampaignText,
  I_ProductionCampaign.BusinessProcess AS BusinessProcess,
  I_ProductionCampaign.BaseUnit AS BaseUnit,
  I_ProductionCampaign.ProductionCampaignQuantity AS ProductionCampaignQuantity,
  I_ProductionCampaign.Product AS Product,
  I_ProductionCampaign.Plant AS Plant,
  _ProductPlant.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  _ProdnCmpgnTotItmQty.MaterialBaseUnit AS MaterialBaseUnit,
  _ProdnCmpgnTotItmQty.PlannedTotalQtyInBaseUnit AS PlannedTotalQtyInBaseUnit
FROM I_ProductionCampaign
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON Plant = _ProductPlant.Plant AND Product = _ProductPlant.Product  -- association [0..1]
LEFT OUTER JOIN I_ProdnCmpgnTotItmQty AS _ProdnCmpgnTotItmQty ON ProductionCampaign = _ProdnCmpgnTotItmQty.ProductionCampaign  -- association [0..1]
;

Learn More