I_AdjmtPostingMovementType

DDL: I_ADJMTPOSTINGMOVEMENTTYPE SQL: IPIADJMVT Type: view BASIC

PI Stock Adjustment Movement Type

I_AdjmtPostingMovementType is a Basic CDS View that provides data about "PI Stock Adjustment Movement Type" in SAP S/4HANA. It reads from 1 data source (t150) and exposes 8 fields with key fields PhysicalInventoryStockType, InventorySpecialStockType. It has 4 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
t150 t150 from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_InventorySpecialStockType _InventorySpecialStockType $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType
[0..1] I_PhysInvtryStockType _PhysicalInventoryStockType $projection.PhysicalInventoryStockType = _PhysicalInventoryStockType.PhysicalInventoryStockType
[0..1] I_GoodsMovementType _GoodsIssueMovementType $projection.PhysInvtryDecreasingQtyMvtType = _GoodsIssueMovementType.GoodsMovementType
[0..1] I_GoodsMovementType _GoodsReceiptMovementType $projection.PhysInvtryIncreasingQtyMvtType = _GoodsReceiptMovementType.GoodsMovementType

Annotations (15)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IPIADJMVT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PI Stock Adjustment Movement Type view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private false view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PhysicalInventoryStockType bstar
KEY InventorySpecialStockType sobkz
PhysInvtryDecreasingQtyMvtType bwarh
PhysInvtryIncreasingQtyMvtType bwars
_InventorySpecialStockType _InventorySpecialStockType
_PhysicalInventoryStockType _PhysicalInventoryStockType
_GoodsIssueMovementType _GoodsIssueMovementType
_GoodsReceiptMovementType _GoodsReceiptMovementType 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IPIADJMVT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering : { status : #ACTIVE, type: #GENERIC, numberOfKeyFields: 1 }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'PI Stock Adjustment Movement Type'

@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: false
@VDM.viewType: #BASIC

define view I_AdjmtPostingMovementType
  as select from t150

  association [0..1] to I_InventorySpecialStockType as _InventorySpecialStockType  on $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType

  association [0..1] to I_PhysInvtryStockType       as _PhysicalInventoryStockType on $projection.PhysicalInventoryStockType = _PhysicalInventoryStockType.PhysicalInventoryStockType

  association [0..1] to I_GoodsMovementType         as _GoodsIssueMovementType     on $projection.PhysInvtryDecreasingQtyMvtType = _GoodsIssueMovementType.GoodsMovementType

  association [0..1] to I_GoodsMovementType         as _GoodsReceiptMovementType   on $projection.PhysInvtryIncreasingQtyMvtType = _GoodsReceiptMovementType.GoodsMovementType

{
      @ObjectModel.foreignKey.association: '_PhysicalInventoryStockType'
  key bstar as PhysicalInventoryStockType,
      @ObjectModel.foreignKey.association: '_InventorySpecialStockType'
  key sobkz as InventorySpecialStockType,

      @ObjectModel.foreignKey.association: '_GoodsIssueMovementType'
      bwarh as PhysInvtryDecreasingQtyMvtType,
      @ObjectModel.foreignKey.association: '_GoodsReceiptMovementType'
      bwars as PhysInvtryIncreasingQtyMvtType,


      _InventorySpecialStockType,
      _PhysicalInventoryStockType,
      _GoodsIssueMovementType,
      _GoodsReceiptMovementType
}

Learn More