R_PFMMasterDataFprntQtyCompTP

DDL: R_PFMMASTERDATAFPRNTQTYCOMPTP Type: view_entity TRANSACTIONAL Package: RAP_SUS_PFM_MD_FOOTPRINT
15 Fields 1 Data Sources 1 Associations

Master Data Footprint Qty Component - TP

R_PFMMasterDataFprntQtyCompTP is a Transactional CDS View that provides data about "Master Data Footprint Qty Component - TP" in SAP S/4HANA. It reads from 1 data source (I_PFMMasterDataFprntQtyComp) and exposes 15 fields with key field PFMMasterDataFprntQtyCompUUID. It has 1 association to related views. Part of development package RAP_SUS_PFM_MD_FOOTPRINT.

Data Sources (1)

SourceAliasJoin Type
I_PFMMasterDataFprntQtyComp I_PFMMasterDataFprntQtyComp from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PFMMasterDataFootprintTP _PFMMasterDataFootprint $projection.PFMMasterDataFootprintUUID = _PFMMasterDataFootprint.PFMMasterDataFootprintUUID

Annotations (8)

NameValueLevelField
EndUserText.label Master Data Footprint Qty Component - TP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey PFMMasterDataFprntQtyCompUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PFMMasterDataFprntQtyCompUUID PFMMasterDataFprntQtyCompUUID
PFMMasterDataFootprintQtyUUID PFMMasterDataFootprintQtyUUID Master Data Footprint Quantity
PFMMasterDataFootprintUUID PFMMasterDataFootprintUUID Master Data Footprint
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
PFMFootprintQtyComponentGroup PFMFootprintQtyComponentGroup
PFMFootprintQtyComponentType PFMFootprintQtyComponentType
PFMFootprintQuantity PFMFootprintQuantity Quantity
PFMFootprintUnit PFMFootprintUnit Unit
_PFMMasterDataFootprintQty _PFMMasterDataFootprintQty
_PFMMasterDataFootprint _PFMMasterDataFootprint
_GHGCategory _GHGCategory
_UnitOfMeasure _UnitOfMeasure

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_PFMMasterDataFprntQtyCompTP.
-- 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_PFMMasterDataFprntQtyCompTP AS
SELECT
  PFMMasterDataFprntQtyCompUUID,
  PFMMasterDataFootprintQtyUUID,
  PFMMasterDataFootprintUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  PFMFootprintQtyComponentGroup,
  PFMFootprintQtyComponentType,
  PFMFootprintQuantity,
  PFMFootprintUnit
FROM I_PFMMasterDataFprntQtyComp
LEFT OUTER JOIN R_PFMMasterDataFootprintTP AS _PFMMasterDataFootprint ON PFMMasterDataFootprintUUID = _PFMMasterDataFootprint.PFMMasterDataFootprintUUID  -- association [1..1]
;

Learn More