R_PFMMasterDataFootprintQtyTP

DDL: R_PFMMASTERDATAFOOTPRINTQTYTP Type: view_entity TRANSACTIONAL

Master Data Footprint Quantity

R_PFMMasterDataFootprintQtyTP is a Transactional CDS View that provides data about "Master Data Footprint Quantity" in SAP S/4HANA. It reads from 1 data source (I_PFMMasterDataFootprintQty) and exposes 15 fields with key field PFMMasterDataFootprintQtyUUID.

Data Sources (1)

SourceAliasJoin Type
I_PFMMasterDataFootprintQty I_PFMMasterDataFootprintQty from

Annotations (8)

NameValueLevelField
EndUserText.label Master Data Footprint Quantity view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey PFMMasterDataFootprintQtyUUID 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 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
PFMFootprintCategory PFMFootprintCategory Footprint Category
PFMFootprintReferenceBasis PFMFootprintReferenceBasis Reference Basis
PFMFootprintQuantity PFMFootprintQuantity Quantity
PFMFootprintUnit PFMFootprintUnit Unit
PFMAssessmentRunUUID PFMAssessmentRunUUID PFM Assessment Run UUID
_PFMMasterDataFootprint _PFMMasterDataFootprint
_UnitOfMeasure _UnitOfMeasure
_PFMFootprintCategory _PFMFootprintCategory
_PFMFootprintReferenceBasis _PFMFootprintReferenceBasis

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_PFMMasterDataFootprintQtyTP.
-- 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_PFMMasterDataFootprintQtyTP AS
SELECT
  PFMMasterDataFootprintQtyUUID,
  PFMMasterDataFootprintUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  PFMFootprintCategory,
  PFMFootprintReferenceBasis,
  PFMFootprintQuantity,
  PFMFootprintUnit,
  PFMAssessmentRunUUID
FROM I_PFMMasterDataFootprintQty
;