V_Mmim_DDL_Om_Param_PI

DDL: V_MMIM_DDL_OM_PARAM_PI SQL: V_MMIM_OM_PAR_PI Type: view

Physical Inventory Parameters

V_Mmim_DDL_Om_Param_PI is a CDS View that provides data about "Physical Inventory Parameters" in SAP S/4HANA. It reads from 3 data sources (I_PhysInvtryDocItem, t001w, t001k) and exposes 11 fields with key fields SAPClient, pidockey. It has 1 association to related views.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_PhysInvtryDocItem document from
t001w plant inner
t001k val inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PhysInvtryDocumentItem _PrintExtension $projection.PhysicalInventoryYear = _PrintExtension.FiscalYear and $projection.PhysicalInventoryDocument = _PrintExtension.PhysicalInventoryDocument and $projection.PhysicalInventoryItem = _PrintExtension.PhysicalInventoryDocumentItem

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName V_MMIM_OM_PAR_PI view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.modelingPattern #OUTPUT_PARAMETER_DETERMINATION_DATA_SOURCE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Physical Inventory Parameters view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SAPClient I_PhysInvtryDocItem mandt
KEY pidockey
PhysicalInventoryDocument I_PhysInvtryDocItem PhysicalInventoryDocument
PhysicalInventoryYear I_PhysInvtryDocItem FiscalYear
PhysicalInventoryItem I_PhysInvtryDocItem PhysicalInventoryDocumentItem
Plant I_PhysInvtryDocItem Plant
StorageLocation I_PhysInvtryDocItem StorageLocation
CompanyCode t001k bukrs
Language t001w spras
Country t001w land1
SalesPriceValuation t001k xvkbw 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'V_MMIM_OM_PAR_PI'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass:      #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory:   #XL
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking:#NOT_REQUIRED
@ObjectModel.supportedCapabilities: [ #OUTPUT_PARAMETER_DETERMINATION_DATA_SOURCE ]
@ObjectModel.modelingPattern:#OUTPUT_PARAMETER_DETERMINATION_DATA_SOURCE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Physical Inventory Parameters'
/* View used for BRF plus application GOODS_MOVEMENT */
define view V_Mmim_DDL_Om_Param_PI
  as select from I_PhysInvtryDocItem  as document
    inner join   t001w as plant on document.Plant = plant.werks
    inner join   t001k as val   on plant.bwkey = val.bwkey
  /*left outer join V_Mmim_Ddl_Om_PI_PRINT as printit on  printit.iblnr = document.iblnr
                                                    and printit.gjahr = document.gjahr
                                                    and printpo.zeili = document.zeili */
  // Custom Fields extensibility  

  association [0..1] to E_PhysInvtryDocumentItem    as _PrintExtension              on  $projection.PhysicalInventoryYear = _PrintExtension.FiscalYear
                                                                                    and $projection.PhysicalInventoryDocument = _PrintExtension.PhysicalInventoryDocument
                                                                                    and $projection.PhysicalInventoryItem = _PrintExtension.PhysicalInventoryDocumentItem                                             
{
  key document.mandt                                                     as  SAPClient,
  key concat( document.PhysicalInventoryDocument, concat (document.FiscalYear, document.PhysicalInventoryDocumentItem ) ) as  pidockey,
      document.PhysicalInventoryDocument                                 as  PhysicalInventoryDocument,
      document.FiscalYear                                                as  PhysicalInventoryYear,
      document.PhysicalInventoryDocumentItem                             as  PhysicalInventoryItem,
      document.Plant                                                     as  Plant,
      document.StorageLocation                                           as  StorageLocation,
      val.bukrs                                                          as  CompanyCode,
      plant.spras                                                        as  Language,
      plant.land1                                                        as  Country,
      val.xvkbw                                                          as  SalesPriceValuation
      // printit.xprint                                                     as  OperationIsPrinted

      //'X'                                                                as  OperationIsPrinted

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PHYSINVTRYDOCITEM",
"T001K",
"T001W"
],
"ASSOCIATED":
[
"E_PHYSINVTRYDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More