P_StoreStkAdjmtSchemaForStore

DDL: P_STORESTKADJMTSCHEMAFORSTORE SQL: PSTRSTKADJSCHEMA Type: view BASIC Package: RFM_STORE_STOCK_ADJUSTMENT

Stock adjustment Default schema

P_StoreStkAdjmtSchemaForStore is a Basic CDS View that provides data about "Stock adjustment Default schema" in SAP S/4HANA. It reads from 1 data source (I_RetailStoreUserAssignment) and exposes 2 fields with key field Store. It has 2 associations to related views. Part of development package RFM_STORE_STOCK_ADJUSTMENT.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_RetailStoreUserAssignment RetailStoreUserAssignment from

Associations (2)

CardinalityTargetAliasCondition
[0..1] twicscmf _StoreSchema RetailStoreUserAssignment.Store = _StoreSchema.werks and _StoreSchema.cstobj = '0250'
[0..1] twicscm _DefaultSchema _DefaultSchema.cstobj = '0250' and _DefaultSchema.flag_strd = 'X'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSTRSTKADJSCHEMA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Store I_RetailStoreUserAssignment Store
RetailStoreSchemaID 
@AbapCatalog.sqlViewName                 : 'PSTRSTKADJSCHEMA'
@AbapCatalog.compiler.compareFilter      : true
@AbapCatalog.preserveKey                 : true
@AccessControl.authorizationCheck        : #NOT_REQUIRED
@AccessControl.personalData.blocking     : #NOT_REQUIRED
@ObjectModel.usageType: { serviceQuality : #A, dataClass: #CUSTOMIZING, sizeCategory: #M }
@VDM.viewType                            : #BASIC
@VDM.private                             : true
@ClientHandling.algorithm                : #SESSION_VARIABLE

define view P_StoreStkAdjmtSchemaForStore
  as select from I_RetailStoreUserAssignment as RetailStoreUserAssignment
  
  association [0..1] to twicscmf as _StoreSchema   on  RetailStoreUserAssignment.Store  = _StoreSchema.werks
                                                   and _StoreSchema.cstobj              = '0250'

  association [0..1] to twicscm  as _DefaultSchema on  _DefaultSchema.cstobj            = '0250'
                                                   and _DefaultSchema.flag_strd         = 'X'
 
{
  key RetailStoreUserAssignment.Store,
      coalesce(_StoreSchema.cstscm, _DefaultSchema.cstscm ) as RetailStoreSchemaID

}
where
AssignedUser = $session.user

Learn More