P_Productunitofmeasuretextd

DDL: P_PRODUCTUNITOFMEASURETEXTD SQL: PPRDUOMTXTD Type: view BASIC
11 Fields 1 Data Sources

P_Productunitofmeasuretextd is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (prd_uom_text) and exposes 11 fields with key fields Draftkey, ActiveProduct, ActiveLanguage, ActiveProductUnit, ActiveProductUnitShortTextCode.

Data Sources (1)

SourceAliasJoin Type
prd_uom_text DraftDocument from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName PPRDUOMTXTD view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Draftkey prd_uom_text draftkey NodeID
KEY ActiveProduct prd_uom_text activeproduct Product
KEY ActiveLanguage prd_uom_text activelanguage Language Key
KEY ActiveProductUnit prd_uom_text activeproductunit Unit of Measure
KEY ActiveProductUnitShortTextCode prd_uom_text activeproductunitshorttextcode Short Text Code
KEY ActiveProductUnitTextSeqNum prd_uom_text activeproductunittextseqnum Consecutive Number
KEY HasActiveEntity prd_uom_text hasactiveentity TRUE
RootDraftKey prd_uom_text rootdraftkey NodeID
ParentDraftKey prd_uom_text parentdraftkey NodeID
language prd_uom_text language Report Text Language
productunit prd_uom_text productunit Unit of Measure

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 P_Productunitofmeasuretextd.
-- 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.
-- SQL view name: PPRDUOMTXTD

CREATE VIEW P_Productunitofmeasuretextd AS
SELECT
  DraftDocument.draftkey AS Draftkey,
  DraftDocument.activeproduct AS ActiveProduct,
  DraftDocument.activelanguage AS ActiveLanguage,
  DraftDocument.activeproductunit AS ActiveProductUnit,
  DraftDocument.activeproductunitshorttextcode AS ActiveProductUnitShortTextCode,
  DraftDocument.activeproductunittextseqnum AS ActiveProductUnitTextSeqNum,
  DraftDocument.hasactiveentity AS HasActiveEntity,
  DraftDocument.rootdraftkey AS RootDraftKey,
  DraftDocument.parentdraftkey AS ParentDraftKey,
  DraftDocument.language AS language,
  DraftDocument.productunit AS productunit
FROM prd_uom_text AS DraftDocument
;

Learn More