C_PackagingMaterialVH

DDL: C_PACKAGINGMATERIALVH SQL: CPKGMATVH Type: view CONSUMPTION Package: LOHUM_ODATA_UI_MHU
8 Fields 1 Data Sources 3 Associations 8 OData Services 3 Fiori Apps

VH for Packaging Materials

C_PackagingMaterialVH is a Consumption CDS View that provides data about "VH for Packaging Materials" in SAP S/4HANA. It reads from 1 data source (mara) and exposes 8 fields with key field PackagingMaterial. It has 3 associations to related views. It is exposed through 8 OData services (ASQL_F4557, ASQL_F4713, ASQL_F4994, ...). It is used in 3 Fiori applications: Initiate Returns - By product, Process Cross-Plant Receipts, Process Receipt. Part of development package LOHUM_ODATA_UI_MHU.

Data Sources (1)

SourceAliasJoin Type
mara mara from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _Text $projection.PackagingMaterial = _Text.Material
[0..1] I_MaterialType _MaterialType $projection.MaterialType = _MaterialType.MaterialType
[0..1] I_PackagingMaterialType _PackagingMaterialType $projection.PackagingMaterialType = _PackagingMaterialType.PackagingMaterialType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPKGMATVH view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
EndUserText.label VH for Packaging Materials view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view

OData Services (8)

ServiceBindingVersionContractRelease
ASQL_F4557 ASQL_F4557 C2 NOT_RELEASED
ASQL_F4713 ASQL_F4713 C2 NOT_RELEASED
ASQL_F4994 ASQL_F4994 C2 NOT_RELEASED
ASQL_F7922 ASQL_F7922 C2 NOT_RELEASED
UI_PROCESS_RECEIPTS UI_PROCESS_RECEIPTS V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_RETURNPROCESSING UI_RETURNPROCESSING V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_RETURNSINITIATION UI_RETURNSINITIATION V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_WHSEINBOUNDDELIVERY UI_WHSEINBOUNDDELIVERY V4 C1 NOT_RELEASED

Fiori Apps (3)

App IDApp NameTypeDescription
F4252 Initiate Returns - By product Transactional An application to initiate Returns from a remote location in Field Logistics via the Product List View
F4713 Process Cross-Plant Receipts Transactional An application to process the receipts of items between plants in Field Logistics. It allows the direct receipts of delivery items or delivery items that are packed in a container.
F5316 Process Receipt Transactional This application is used to Receive Purchase Order Items and Inbound delivery items at Base Plant and Remote Plant. The items can consist of both Stock and Supplier Items.

Initiate Returns - By product

Business Role: Warehouse Clerk (Oil & Gas)

Process Cross-Plant Receipts

Business Role: Warehouse Clerk (Oil & Gas)

Process Receipt

Business Role: Receiving Specialist (Oil & Gas)

This feature enables you to: Create batches with supplier batches using the Create Batch action. View additional fields such as Order Category, Order Number, Recipient, Requisitioner, and Unloading Point details on the list page. Perform a two-step Goods Receipt (GR) process with an alternate unit of measurement. Create a Putaway Warehouse Task for non-stock and supplier items in a single-plant scenario.

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PackagingMaterial matnr Packaging Material
PackagingMaterialName Packaging Material Name
MaterialType mara mtart Product Type
PackagingMaterialType mara vhart Packag.Mat.Type
PackagingMaterialCategory _PackagingMaterialType PackagingMaterialCategory
AuthorizationGroup mara begru AuthorizGroup
_MaterialType _MaterialType
_PackagingMaterialType _PackagingMaterialType

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 C_PackagingMaterialVH.
-- 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: CPKGMATVH

CREATE VIEW C_PackagingMaterialVH AS
SELECT
  matnr AS PackagingMaterial,
  _Text[1: Language=$session.system_language].MaterialName AS PackagingMaterialName,
  mara.mtart AS MaterialType,
  mara.vhart AS PackagingMaterialType,
  _PackagingMaterialType.PackagingMaterialCategory AS PackagingMaterialCategory,
  mara.begru AS AuthorizationGroup
FROM mara
LEFT OUTER JOIN I_MaterialText AS _Text ON PackagingMaterial = _Text.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialType AS _MaterialType ON MaterialType = _MaterialType.MaterialType  -- association [0..1]
LEFT OUTER JOIN I_PackagingMaterialType AS _PackagingMaterialType ON PackagingMaterialType = _PackagingMaterialType.PackagingMaterialType  -- association [0..1]
;

Learn More