Which tables does I_PackingInstructionHeader use?

I_PackingInstructionHeader reads from 1 data source(s): packkp.

How many fields does I_PackingInstructionHeader have?

I_PackingInstructionHeader has 47 fields. Key fields: PackingInstructionSystemUUID.

I_PackingInstructionHeader

DDL: I_PACKINGINSTRUCTIONHEADER SQL: IPACKINSTRHEADER Type: view BASIC

Packing Instruction Header

I_PackingInstructionHeader is a Basic CDS View that provides data about "Packing Instruction Header" in SAP S/4HANA. It reads from 1 data source (packkp) and exposes 47 fields with key field PackingInstructionSystemUUID. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
packkp	packkp	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	I_PackingInstructionComponent	_PackingInstructionComponent	`$projection.PackingInstructionSystemUUID = _PackingInstructionComponent.PackingInstructionSystemUUID`
[0..1]	I_UnitOfMeasure	_UnitOfMeasureDimension	`_UnitOfMeasureDimension.UnitOfMeasure = $projection.HandlingUnitUoMDimension`
[0..1]	I_UnitOfMeasure	_HandlingUnitVolumeUnit	`_HandlingUnitVolumeUnit.UnitOfMeasure = $projection.HandlingUnitVolumeUnit`
[0..1]	I_UnitOfMeasure	_HandlingUnitTareVolumeUnit	`_HandlingUnitTareVolumeUnit.UnitOfMeasure = $projection.HandlingUnitTareVolumeUnit`
[0..1]	I_UnitOfMeasure	_HandlingUnitWeightUnit	`_HandlingUnitWeightUnit.UnitOfMeasure = $projection.HandlingUnitWeightUnit`
[0..1]	I_UnitOfMeasure	_HandlingUnitTareWeightUnit	`_HandlingUnitTareWeightUnit.UnitOfMeasure = $projection.HandlingUnitWeightUnit`
[0..*]	I_PackingInstructionText	_Text	`$projection.PackingInstructionSystemUUID = _Text.PackingInstructionSystemUUID`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	IPACKINSTRHEADER	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Packing Instruction Header	view
Search.searchable	true	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.compositionRoot	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.modelingPattern	#NONE	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (47)

Key	Field	Source Field	Description
KEY	PackingInstructionSystemUUID	packnr
	PackingInstructionNumber	pobjid	Packing Object
	PackingInstructionExternalName	partid	External Name
	HandlingUnitHeight	height
	HandlingUnitWidth	width
	HandlingUnitLength	length
	HandlingUnitInnerHeight	iheight	Height of Inside Dimensions
	HandlingUnitInnerWidth	iwidth	Width of Inside Dimensions
	HandlingUnitInnerLength	ilength	Length of Inside Dimensions
	HandlingUnitUoMDimension	unitdim	Unit of Dimension Length/Width/Height
	HandlingUnitMeasuresAreFixed	sizefix	Measurement Fix
	HandlingUnitGrossVolume	totlvol	Total Volume
	HandlingUnitLoadVolume	loadvol	Loading Volume
	HandlingUnitAllowedLoadVolume	allovol	Allowed Loading Volume
	HandlingUnitVolumeUnit	unitvol_max	Volume Unit
	HandlingUnitTareVolume	tarevol	Tare Volume
	HandlingUnitTareVolumeUnit	unitvol	Volume Unit
	HandlingUnitVolumesAreFixed	volumfix	Volume Fix
	ExcessVolumeToleranceValue	tolevol	Excess Volume Tolerance
	HandlingUnitGrossWeight	totlwei	Total Weight
	HandlingUnitLoadWeight	loadwei	Loading Weight
	HandlingUnitAllowedLoadWeight	allowei	Allowed Loading Weight
	HandlingUnitWeightUnit	unitwei_max	Unit of Weight
	HandlingUnitTareWeight	tarewei	Tare Weight
	HandlingUnitTareWeightUnit	unitwei	Unit of Weight
	HandlingUnitWeightsAreFixed	weightfix	Weights Fix
	ExcessWeightToleranceValue	tolewei	Excess Weight Tolerance
	PackingInstructionAllwdLoadQty	maxstwe
	HandlingUnitIsClosed	indclopa	Indicator: Packaging Closed
	LoadCarrierSystUUID
	PackingInstructionIsDeleted	inddel
	PackingInstructionCheckProfSts	checkprof	Packing Status Check Profile
	StackingFactor	stfac	Stack Factor
	HandlingUnitType	hu_type	HU Type
	CreatedByUser	crnam	Created By
	CreationDate	crdat	Created At
	LastChangedByUser	chnam	Changed By
	LastChangeDate	chdat	Changed At Date
	LastChangeTime	chtim	Changed At Time
	LastChangeDateTime	lastchangeddatetime
	_PackingInstructionComponent	_PackingInstructionComponent
	_UnitOfMeasureDimension	_UnitOfMeasureDimension
	_HandlingUnitVolumeUnit	_HandlingUnitVolumeUnit
	_HandlingUnitTareVolumeUnit	_HandlingUnitTareVolumeUnit
	_HandlingUnitWeightUnit	_HandlingUnitWeightUnit
	_HandlingUnitTareWeightUnit	_HandlingUnitTareWeightUnit
	_Text	_Text

@AbapCatalog.sqlViewName: 'IPACKINSTRHEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Packing Instruction Header'
@Search.searchable: true

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #PUBLIC_LOCAL_API

@ObjectModel.compositionRoot: true
@ObjectModel: {
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MIXED,
     sizeCategory:    #L
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ],
   modelingPattern: #NONE
}

@Metadata.ignorePropagatedAnnotations: true

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } Key field HDCOUNT not used */
define view I_PackingInstructionHeader
  as select from packkp
  association [0..*] to I_PackingInstructionComponent as _PackingInstructionComponent 
        on $projection.PackingInstructionSystemUUID = _PackingInstructionComponent.PackingInstructionSystemUUID
  association [0..1] to I_UnitOfMeasure             as _UnitOfMeasureDimension                  on _UnitOfMeasureDimension.UnitOfMeasure                   = $projection.HandlingUnitUoMDimension
  association [0..1] to I_UnitOfMeasure             as _HandlingUnitVolumeUnit              on _HandlingUnitVolumeUnit.UnitOfMeasure               = $projection.HandlingUnitVolumeUnit
  association [0..1] to I_UnitOfMeasure             as _HandlingUnitTareVolumeUnit                  on _HandlingUnitTareVolumeUnit.UnitOfMeasure                   = $projection.HandlingUnitTareVolumeUnit
  association [0..1] to I_UnitOfMeasure             as _HandlingUnitWeightUnit                  on _HandlingUnitWeightUnit.UnitOfMeasure                   = $projection.HandlingUnitWeightUnit
  association [0..1] to I_UnitOfMeasure             as _HandlingUnitTareWeightUnit                  on _HandlingUnitTareWeightUnit.UnitOfMeasure                   = $projection.HandlingUnitWeightUnit
  association [0..*] to I_PackingInstructionText as _Text on  $projection.PackingInstructionSystemUUID  = _Text.PackingInstructionSystemUUID
 
{
  @Semantics.uuid:true 
//  key cast( packnr as packing_instruction_number preserving type ) as PackingInstructionSystemUUID,

    key packnr                                                     as PackingInstructionSystemUUID,
      //  key hdcount as Counter,

      @EndUserText.label: 'Packing Object'
      pobjid                                                       as PackingInstructionNumber,
      //  packtyp as PackagingType, // always 'P'

      @Search.defaultSearchElement: true
      @EndUserText.label: 'External Name'
      partid                                                       as PackingInstructionExternalName,

      // dimensions

      @Semantics.quantity.unitOfMeasure: 'HandlingUnitUoMDimension'
      height                                                       as HandlingUnitHeight,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitUoMDimension'
      width                                                        as HandlingUnitWidth,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitUoMDimension'
      length                                                       as HandlingUnitLength,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitUoMDimension'
      @EndUserText.label: 'Height of Inside Dimensions'
      iheight                                                      as HandlingUnitInnerHeight,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitUoMDimension'
      @EndUserText.label: 'Width of Inside Dimensions'
      iwidth                                                       as HandlingUnitInnerWidth,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitUoMDimension'
      @EndUserText.label: 'Length of Inside Dimensions'
      ilength                                                      as HandlingUnitInnerLength,
      @EndUserText.label: 'Unit of Dimension Length/Width/Height'
      unitdim                                                      as HandlingUnitUoMDimension,
      @EndUserText.label: 'Measurement Fix'
      sizefix                                                      as HandlingUnitMeasuresAreFixed,

      // volumes

      @Semantics.quantity.unitOfMeasure: 'HandlingUnitVolumeUnit'
      @EndUserText.label: 'Total Volume'
      totlvol                                                      as HandlingUnitGrossVolume,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitVolumeUnit'
      @EndUserText.label: 'Loading Volume'
      loadvol                                                      as HandlingUnitLoadVolume,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitVolumeUnit'
      @EndUserText.label: 'Allowed Loading Volume'
      allovol                                                      as HandlingUnitAllowedLoadVolume,
      @EndUserText.label: 'Volume Unit'
      unitvol_max                                                  as HandlingUnitVolumeUnit,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
      @EndUserText.label: 'Tare Volume'
      tarevol                                                      as HandlingUnitTareVolume,
      @EndUserText.label: 'Volume Unit'
      unitvol                                                      as HandlingUnitTareVolumeUnit,
      @EndUserText.label: 'Volume Fix'
      volumfix                                                     as HandlingUnitVolumesAreFixed,
      @EndUserText.label: 'Excess Volume Tolerance'
      tolevol                                                      as ExcessVolumeToleranceValue,


      // weights

      @Semantics.quantity.unitOfMeasure: 'HandlingUnitWeightUnit'
      @EndUserText.label: 'Total Weight'
      totlwei                                                      as HandlingUnitGrossWeight,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitWeightUnit'
      @EndUserText.label: 'Loading Weight'
      loadwei                                                      as HandlingUnitLoadWeight,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitWeightUnit'
      @EndUserText.label: 'Allowed Loading Weight'
      allowei                                                      as HandlingUnitAllowedLoadWeight,
      @EndUserText.label: 'Unit of Weight'
      unitwei_max                                                  as HandlingUnitWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitTareWeightUnit'
      @EndUserText.label: 'Tare Weight'
      tarewei                                                      as HandlingUnitTareWeight,
      @EndUserText.label: 'Unit of Weight'
      unitwei                                                      as HandlingUnitTareWeightUnit,
      @EndUserText.label: 'Weights Fix'
      weightfix                                                    as HandlingUnitWeightsAreFixed,
      @EndUserText.label: 'Excess Weight Tolerance'
      tolewei                                                      as ExcessWeightToleranceValue,
      @Semantics.quantity.unitOfMeasure: 'HandlingUnitWeightUnit'
      maxstwe                                                      as PackingInstructionAllwdLoadQty,
      @EndUserText.label: 'Indicator: Packaging Closed'
      indclopa                                                     as HandlingUnitIsClosed,
      @Semantics.uuid:true
      cast( mapaco_item as packing_instruction_component preserving type ) as LoadCarrierSystUUID,
      inddel                                                       as PackingInstructionIsDeleted,
      @EndUserText.label: 'Packing Status Check Profile'
      checkprof                                                    as PackingInstructionCheckProfSts,
      @EndUserText.label: 'Stack Factor'
      stfac                                                        as StackingFactor,
      @EndUserText.label: 'HU Type'
      hu_type                                                      as HandlingUnitType,

      //admin

      @Semantics.user.createdBy: true
      @EndUserText.label: 'Created By'
      crnam                                                        as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      @EndUserText.label: 'Created At'
      crdat                                                        as CreationDate,
      @Semantics.user.lastChangedBy: true
      @EndUserText.label: 'Changed By'
      chnam                                                        as LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      @EndUserText.label: 'Changed At Date'
      chdat                                                        as LastChangeDate,
      @Semantics.systemTime.lastChangedAt: true
      @EndUserText.label: 'Changed At Time'
      chtim                                                        as LastChangeTime,
      @Semantics.systemDateTime.lastChangedAt: true
      lastchangeddatetime                                          as LastChangeDateTime,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _PackingInstructionComponent,

      //      vegr1, // use extensibility

      //      vegr2,

      //      vegr3,

      //      vegr4,

      //      vegr5

      
     _UnitOfMeasureDimension,
     _HandlingUnitVolumeUnit,
     _HandlingUnitTareVolumeUnit,
     _HandlingUnitWeightUnit,
     _HandlingUnitTareWeightUnit,
     _Text
     
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PACKKP"
],
"ASSOCIATED":
[
"I_PACKINGINSTRUCTIONCOMPONENT",
"I_PACKINGINSTRUCTIONTEXT",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_PackingInstructionHeader view

packkp

I_PackingInstructionStdVH view
R_PackingInstructionHeaderTP view_entity