R_RptvMfgConfMatlDocHndlgUntTP

DDL: R_RPTVMFGCONFMATLDOCHNDLGUNTTP Type: view_entity TRANSACTIONAL Package: PP_REM_RAP

Handling Unit of Material Document of REM confirmation

R_RptvMfgConfMatlDocHndlgUntTP is a Transactional CDS View that provides data about "Handling Unit of Material Document of REM confirmation" in SAP S/4HANA. It reads from 1 data source (I_RptvMfgConfMatlDocHndlgUnit) and exposes 15 fields with key fields RepetitiveMfgConfirmation, MaterialDocument, MaterialDocumentYear, MaterialDocumentItem, HandlingUnitExternalID. Part of development package PP_REM_RAP.

Data Sources (1)

SourceAliasJoin Type
I_RptvMfgConfMatlDocHndlgUnit I_RptvMfgConfMatlDocHndlgUnit from

Annotations (8)

NameValueLevelField
EndUserText.label Handling Unit of Material Document of REM confirmation view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY RepetitiveMfgConfirmation RepetitiveMfgConfirmation
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY HandlingUnitExternalID _HandlingUnitItem HandlingUnitExternalID Handling Unit
KEY HandlingUnitItem HandlingUnitItem
ConfirmationPlant ConfirmationPlant
Plant Plant Valuation Area
Customer Customer Sold-to Party
Supplier Supplier Supplier
_Customer _Customer
_CustomerCompanyByPlant _CustomerCompanyByPlant
_Supplier _Supplier
_SupplierCompanyByPlant _SupplierCompanyByPlant
_RepetitiveMfgConfirmationTP _RepetitiveMfgConfirmationTP

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_RptvMfgConfMatlDocHndlgUntTP.
-- 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_RptvMfgConfMatlDocHndlgUntTP AS
SELECT
  RepetitiveMfgConfirmation,
  MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  _HandlingUnitItem.HandlingUnitExternalID AS HandlingUnitExternalID,
  HandlingUnitItem,
  ConfirmationPlant,
  Plant,
  Customer,
  Supplier
FROM I_RptvMfgConfMatlDocHndlgUnit
;