P_ConfMatlDocHndlgUnitAssgmt

DDL: P_CONFMATLDOCHNDLGUNITASSGMT Type: view_entity BASIC
7 Fields 1 Data Sources

P_ConfMatlDocHndlgUnitAssgmt is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (humseg) and exposes 7 fields with key fields HandlingUnitInternalID, HandlingUnitItem, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear.

Data Sources (1)

SourceAliasJoin Type
humseg humseg from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitInternalID venum Internal HU no.
KEY HandlingUnitItem vepos HU item
KEY MaterialDocument mblnr Material Doc.
KEY MaterialDocumentItem mblpo Mat. Doc.Item
KEY MaterialDocumentYear mjahr Mat. Doc. Year
MaterialDocumentPostingType attribute Type
HandlingUnitObjectKeyType object TRFM Object

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_ConfMatlDocHndlgUnitAssgmt.
-- 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 P_ConfMatlDocHndlgUnitAssgmt AS
SELECT
  venum AS HandlingUnitInternalID,
  vepos AS HandlingUnitItem,
  mblnr AS MaterialDocument,
  mblpo AS MaterialDocumentItem,
  mjahr AS MaterialDocumentYear,
  attribute AS MaterialDocumentPostingType,
  object AS HandlingUnitObjectKeyType
FROM humseg
;

Learn More