R_PackingInstructionHeaderTP

DDL: R_PACKINGINSTRUCTIONHEADERTP Type: view_entity TRANSACTIONAL Package: LOHUM_RAP_PI
46 Fields 1 Data Sources 5 Associations

Packing Instruction Header TP

R_PackingInstructionHeaderTP is a Transactional CDS View that provides data about "Packing Instruction Header TP" in SAP S/4HANA. It reads from 1 data source (I_PackingInstructionHeader) and exposes 46 fields with key field PackingInstructionSystemUUID. It has 5 associations to related views. Part of development package LOHUM_RAP_PI.

Data Sources (1)

SourceAliasJoin Type
I_PackingInstructionHeader I_PackingInstructionHeader from

Associations (5)

CardinalityTargetAliasCondition
[0..1] R_PackInstructionComponentTP _LoadCarrier _LoadCarrier.PackingInstructionItemSystUUID = $projection.LoadCarrierSystUUID
[0..*] I_MaterialText _LoadCarrierText _LoadCarrierText.Material = $projection.LoadCarrier
[0..1] I_User _I_User $projection.CreatedByUser = _I_User.UserID
[0..*] R_PackInstructionComponentTP _PackingInstructionComponent
[0..*] R_PackingInstructionTextTP _PackingInstructionText

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Packing Instruction Header TP view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name PackingInstruction view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY PackingInstructionSystemUUID PackingInstructionSystemUUID Packing Instructi Nr
PackingInstructionNumber PackingInstructionNumber Packing object
PackingInstructionExternalName PackingInstructionExternalName Part ID
HandlingUnitHeight HandlingUnitHeight Height
HandlingUnitWidth HandlingUnitWidth Width
HandlingUnitLength HandlingUnitLength Text Length
HandlingUnitInnerHeight HandlingUnitInnerHeight Height inside
HandlingUnitInnerWidth HandlingUnitInnerWidth Width inside
HandlingUnitInnerLength HandlingUnitInnerLength Length inside
HandlingUnitUoMDimension HandlingUnitUoMDimension Unit
HandlingUnitMeasuresAreFixed HandlingUnitMeasuresAreFixed Fix measuremts
HandlingUnitGrossVolume HandlingUnitGrossVolume Total volume
HandlingUnitLoadVolume HandlingUnitLoadVolume Loading volume
HandlingUnitAllowedLoadVolume HandlingUnitAllowedLoadVolume Allowed load
HandlingUnitVolumeUnit HandlingUnitVolumeUnit Volume unit
HandlingUnitTareVolume HandlingUnitTareVolume Tare volume
HandlingUnitTareVolumeUnit HandlingUnitTareVolumeUnit Volume unit
HandlingUnitVolumesAreFixed HandlingUnitVolumesAreFixed Volume fix
ExcessVolumeToleranceValue ExcessVolumeToleranceValue Excess volume tol.
HandlingUnitGrossWeight HandlingUnitGrossWeight Total
HandlingUnitLoadWeight HandlingUnitLoadWeight Loading Weight
HandlingUnitAllowedLoadWeight HandlingUnitAllowedLoadWeight Allowed Load Wt
HandlingUnitWeightUnit HandlingUnitWeightUnit Unit of weight
HandlingUnitTareWeight HandlingUnitTareWeight Packaging wt
HandlingUnitTareWeightUnit HandlingUnitTareWeightUnit Unit of weight
HandlingUnitWeightsAreFixed HandlingUnitWeightsAreFixed Weights fix
ExcessWeightToleranceValue ExcessWeightToleranceValue Excess wt tolerance
PackingInstructionAllwdLoadQty PackingInstructionAllwdLoadQty Allowed Load
HandlingUnitIsClosed HandlingUnitIsClosed Packaging closed
LoadCarrierSystUUID LoadCarrierSystUUID
PackingInstructionIsDeleted PackingInstructionIsDeleted Del. ind.
PackingInstructionCheckProfSts PackingInstructionCheckProfSts Check profile
StackingFactor StackingFactor Stacking factor
HandlingUnitType HandlingUnitType HUTyp
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
LastChangeDateTime LastChangeDateTime Timestamp
LoadCarrier _LoadCarrier Material Vehicle Model
_PackingInstructionComponent _PackingInstructionComponent
_PackingInstructionText _PackingInstructionText
_LoadCarrier _LoadCarrier
_LoadCarrierText _LoadCarrierText
_I_User _I_User

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_PackingInstructionHeaderTP.
-- 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_PackingInstructionHeaderTP AS
SELECT
  PackingInstructionSystemUUID,
  PackingInstructionNumber,
  PackingInstructionExternalName,
  HandlingUnitHeight,
  HandlingUnitWidth,
  HandlingUnitLength,
  HandlingUnitInnerHeight,
  HandlingUnitInnerWidth,
  HandlingUnitInnerLength,
  HandlingUnitUoMDimension,
  HandlingUnitMeasuresAreFixed,
  HandlingUnitGrossVolume,
  HandlingUnitLoadVolume,
  HandlingUnitAllowedLoadVolume,
  HandlingUnitVolumeUnit,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  HandlingUnitVolumesAreFixed,
  ExcessVolumeToleranceValue,
  HandlingUnitGrossWeight,
  HandlingUnitLoadWeight,
  HandlingUnitAllowedLoadWeight,
  HandlingUnitWeightUnit,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  HandlingUnitWeightsAreFixed,
  ExcessWeightToleranceValue,
  PackingInstructionAllwdLoadQty,
  HandlingUnitIsClosed,
  LoadCarrierSystUUID,
  PackingInstructionIsDeleted,
  PackingInstructionCheckProfSts,
  StackingFactor,
  HandlingUnitType,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  _LoadCarrier.Material AS LoadCarrier
FROM I_PackingInstructionHeader
LEFT OUTER JOIN R_PackInstructionComponentTP AS _LoadCarrier ON _LoadCarrier.PackingInstructionItemSystUUID = LoadCarrierSystUUID  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _LoadCarrierText ON _LoadCarrierText.Material = LoadCarrier  -- association [0..*]
LEFT OUTER JOIN I_User AS _I_User ON CreatedByUser = _I_User.UserID  -- association [0..1]
LEFT OUTER JOIN R_PackInstructionComponentTP AS _PackingInstructionComponent ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PackingInstructionTextTP AS _PackingInstructionText ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More