A_PackingInstructionHeader

DDL: A_PACKINGINSTRUCTIONHEADER Type: view_entity CONSUMPTION Package: LOHUM_PI_ODATA_API

Packing Instruction Header

A_PackingInstructionHeader is a Consumption CDS View that provides data about "Packing Instruction Header" in SAP S/4HANA. It reads from 1 data source (R_PackingInstructionHeaderTP) and exposes 39 fields with key field PackingInstructionSystemUUID. It is exposed through 2 OData services (API_PACKINGINSTRUCTION, ASQL_F7577). Part of development package LOHUM_PI_ODATA_API.

Data Sources (1)

SourceAliasJoin Type
R_PackingInstructionHeaderTP R_PackingInstructionHeaderTP projection

Annotations (9)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Packing Instruction Header view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
API_PACKINGINSTRUCTION API_PACKINGINSTRUCTION V2 C2 C1
ASQL_F7577 ASQL_F7577 C2 NOT_RELEASED

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY PackingInstructionSystemUUID PackingInstructionSystemUUID Packing Instructi Nr
PackingInstructionNumber PackingInstructionNumber
PackingInstructionExternalName PackingInstructionExternalName
HandlingUnitHeight HandlingUnitHeight
HandlingUnitWidth HandlingUnitWidth
HandlingUnitLength HandlingUnitLength
HandlingUnitInnerHeight HandlingUnitInnerHeight
HandlingUnitInnerWidth HandlingUnitInnerWidth
HandlingUnitInnerLength HandlingUnitInnerLength
HandlingUnitUoMDimension HandlingUnitUoMDimension
HandlingUnitMeasuresAreFixed HandlingUnitMeasuresAreFixed
HandlingUnitGrossVolume HandlingUnitGrossVolume
HandlingUnitLoadVolume HandlingUnitLoadVolume
HandlingUnitAllowedLoadVolume HandlingUnitAllowedLoadVolume
HandlingUnitVolumeUnit HandlingUnitVolumeUnit
HandlingUnitTareVolume HandlingUnitTareVolume
HandlingUnitTareVolumeUnit HandlingUnitTareVolumeUnit
HandlingUnitVolumesAreFixed HandlingUnitVolumesAreFixed
ExcessVolumeToleranceValue ExcessVolumeToleranceValue
HandlingUnitGrossWeight HandlingUnitGrossWeight
HandlingUnitLoadWeight HandlingUnitLoadWeight
HandlingUnitAllowedLoadWeight HandlingUnitAllowedLoadWeight
HandlingUnitWeightUnit HandlingUnitWeightUnit
HandlingUnitTareWeight HandlingUnitTareWeight
HandlingUnitTareWeightUnit HandlingUnitTareWeightUnit
HandlingUnitWeightsAreFixed HandlingUnitWeightsAreFixed
ExcessWeightToleranceValue ExcessWeightToleranceValue
PackingInstructionAllwdLoadQty PackingInstructionAllwdLoadQty
HandlingUnitIsClosed HandlingUnitIsClosed
LoadCarrierSystUUID LoadCarrierSystUUID
PackingInstructionIsDeleted PackingInstructionIsDeleted
PackingInstructionCheckProfSts PackingInstructionCheckProfSts
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

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 A_PackingInstructionHeader.
-- 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 A_PackingInstructionHeader 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
FROM R_PackingInstructionHeaderTP
;