R_PurgCatProdClassificationTP

DDL: R_PURGCATPRODCLASSIFICATIONTP Type: view_entity TRANSACTIONAL Package: MD_PUC_RAP
14 Fields 1 Data Sources

Purchasing Category Product Classificatn

R_PurgCatProdClassificationTP is a Transactional CDS View that provides data about "Purchasing Category Product Classificatn" in SAP S/4HANA. It reads from 1 data source (R_PurgCatProductClassification) and exposes 14 fields with key fields PurgCatUUID, PurgCatProductClassificationID. Part of development package MD_PUC_RAP.

Data Sources (1)

SourceAliasJoin Type
R_PurgCatProductClassification R_PurgCatProductClassification from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey PurgCatProductClassificationID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Purchasing Category Product Classificatn view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurgCatUUID PurgCatUUID
KEY PurgCatProductClassificationID PurgCatProductClassificationID
PurgCatProdClassfctnTypeCode PurgCatProdClassfctnTypeCode
PurchasingCategoryUNSPSC PurchasingCategoryUNSPSC
PurchasingCategoryUNSPSCName PurchasingCategoryUNSPSCName
PurchasingCategoryECLASSCode PurchasingCategoryECLASSCode
PurchasingCategoryECLASSName PurchasingCategoryECLASSName
PurgCatCstmClassificationCode PurgCatCstmClassificationCode
PurgCatCstmClassificationName PurgCatCstmClassificationName
PurgCatCstmClassfctnDomain PurgCatCstmClassfctnDomain
IsActive IsActive Object active?
LogicalSystem LogicalSystem Logical System
_PurchasingCategory _PurchasingCategory
_PurgCatProdClassfctnTypeCode _PurgCatProdClassfctnTypeCode

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_PurgCatProdClassificationTP.
-- 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_PurgCatProdClassificationTP AS
SELECT
  PurgCatUUID,
  PurgCatProductClassificationID,
  PurgCatProdClassfctnTypeCode,
  PurchasingCategoryUNSPSC,
  PurchasingCategoryUNSPSCName,
  PurchasingCategoryECLASSCode,
  PurchasingCategoryECLASSName,
  PurgCatCstmClassificationCode,
  PurgCatCstmClassificationName,
  PurgCatCstmClassfctnDomain,
  IsActive,
  LogicalSystem
FROM R_PurgCatProductClassification
;

Learn More