I_PackingInstructionComponent

DDL: I_PACKINGINSTRUCTIONCOMPONENT SQL: IPACKINSTCOMP Type: view BASIC

Packing Instruction Component

I_PackingInstructionComponent is a Basic CDS View that provides data about "Packing Instruction Component" in SAP S/4HANA. It reads from 1 data source (packpo) and exposes 17 fields with key field PackingInstructionItemSystUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
packpo packpo from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PackingInstructionHeader _PackingInstructionHeader $projection.PackingInstructionSystemUUID = _PackingInstructionHeader.PackingInstructionSystemUUID
[0..1] I_UnitOfMeasure _BaseUnitofMeasure _BaseUnitofMeasure.UnitOfMeasure = $projection.BaseUnitofMeasure

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IPACKINSTCOMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Packing Instruction Component view
Search.searchable true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API 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 (17)

KeyFieldSource TableSource FieldDescription
KEY PackingInstructionItemSystUUID
PackingInstructionSystemUUID
PackingInstructionItem packitem Item Number
PackingInstructionItemCategory paitemtype Packing Object Item Category
Material matnr Material
ItemPackingInstructionSystUUID subpacknr Sub Packing Instruction Number
PackingInstructionItmTargetQty trgqty Target Quantity
PackingInstructionItemMinQty minqty Minimum Quantity
PackingInstructionItemRndQty rndqty Rounding Quantity
BaseUnitofMeasure baseunit
UnitOfMeasure unitqty Unit of Measure
MaterialMixIsAllowed matmixawd
BatchMixIsAllowed indchmix
MaterialIsNotHandlingUnitRel indnohu Not Relevant for HU
PackingInstructionItemIsDel inddel
_PackingInstructionHeader _PackingInstructionHeader
_BaseUnitofMeasure _BaseUnitofMeasure
@AbapCatalog.sqlViewName: 'IPACKINSTCOMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

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

@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 ITCOUNT not used */
define view I_PackingInstructionComponent
  as select from packpo
  association [1..1] to I_PackingInstructionHeader as _PackingInstructionHeader on $projection.PackingInstructionSystemUUID = _PackingInstructionHeader.PackingInstructionSystemUUID
  association [0..1] to I_UnitOfMeasure             as _BaseUnitofMeasure on _BaseUnitofMeasure.UnitOfMeasure = $projection.BaseUnitofMeasure
 
{
       @Semantics.uuid:true
  key cast( packitemid as packing_instruction_component preserving type ) as PackingInstructionItemSystUUID,
      //  key itcount as Counter,

      @Semantics.uuid:true
      cast( packnr as packing_instruction_number preserving type ) as PackingInstructionSystemUUID,
      /* annotations at element level */
      @EndUserText.label: 'Item Number'
      packitem                                                     as PackingInstructionItem,
      @Search.defaultSearchElement : true    
      @Search.fuzzinessThreshold : 0.8        
      @Search.ranking : #HIGH      
      @EndUserText.label: 'Packing Object Item Category'
      paitemtype                                                   as PackingInstructionItemCategory,
      @EndUserText.label: 'Material'
      matnr                                                        as Material,
      @Search.fuzzinessThreshold : 0.8        
      @Search.ranking : #MEDIUM   
      @EndUserText.label: 'Sub Packing Instruction Number'  
      subpacknr                                                    as ItemPackingInstructionSystUUID,
      @Semantics.quantity.unitOfMeasure: 'BaseUnitofMeasure'/*UnitOfMeasure*/
      @EndUserText.label: 'Target Quantity'
      trgqty                                                       as PackingInstructionItmTargetQty,
      @Semantics.quantity.unitOfMeasure: 'BaseUnitofMeasure'/*UnitOfMeasure*/
      @EndUserText.label: 'Minimum Quantity'
      minqty                                                       as PackingInstructionItemMinQty,
      @Semantics.quantity.unitOfMeasure: 'BaseUnitofMeasure' /*UnitOfMeasure this field is connected to T006 table for input help  */ 
      @EndUserText.label: 'Rounding Quantity'
      rndqty                                                       as PackingInstructionItemRndQty,
      baseunit                                                     as BaseUnitofMeasure,
      @EndUserText.label: 'Unit of Measure'
      unitqty                                                      as UnitOfMeasure,
      @Semantics.booleanIndicator: true
      matmixawd                                                    as MaterialMixIsAllowed,
      indchmix                                                     as BatchMixIsAllowed,
      @Semantics.booleanIndicator: true
      @EndUserText.label: 'Not Relevant for HU'
      indnohu                                                      as MaterialIsNotHandlingUnitRel,
      inddel                                                       as PackingInstructionItemIsDel,
//      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _PackingInstructionHeader,
      _BaseUnitofMeasure
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PACKPO"
],
"ASSOCIATED":
[
"I_PACKINGINSTRUCTIONHEADER",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/