I_DFS_PackingInstructionObjVH

DDL: I_DFS_PACKINGINSTRUCTIONOBJVH SQL: IDFSPACKINSVH Type: view BASIC

Value Help for Packing Instruction

I_DFS_PackingInstructionObjVH is a Basic CDS View that provides data about "Value Help for Packing Instruction" in SAP S/4HANA. It reads from 2 data sources (packkps, packkp) and exposes 4 fields with key field PackingInstructionSystemUUID.

Data Sources (2)

SourceAliasJoin Type
packkps _PACKKPS inner
packkp packkp from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IDFSPACKINSVH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Value Help for Packing Instruction view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey PackingInstructionSystemUUID view
Consumption.ranked true view
VDM.viewType #BASIC view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PackingInstructionSystemUUID
PackingInstructionNumber pobjid Packing object
PackingInstructionText packkps content Trusted Site Content
PackingInstructionExternalName partid Part ID

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 I_DFS_PackingInstructionObjVH.
-- 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: IDFSPACKINSVH

CREATE VIEW I_DFS_PackingInstructionObjVH AS
SELECT
  cast( packkp.packnr as packing_instruction_number preserving type ) AS PackingInstructionSystemUUID,
  pobjid AS PackingInstructionNumber,
  _PACKKPS.content AS PackingInstructionText,
  partid AS PackingInstructionExternalName
FROM packkp
INNER JOIN packkps AS _PACKKPS ON /* join condition not captured in parsed metadata */
;