I_RetailStoreOrderBusinessData

DDL: I_RETAILSTOREORDERBUSINESSDATA SQL: ISTRPKORDBUSDATA Type: view_entity BASIC

Business Data for Retail Store Order

I_RetailStoreOrderBusinessData is a Basic CDS View that provides data about "Business Data for Retail Store Order" in SAP S/4HANA. It reads from 1 data source (vbkd) and exposes 5 fields with key fields ReferenceStorePickUpOrder, ReferenceStorePickupOrderItem. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
vbkd vbkd from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesOrder _SalesOrder $projection.ReferenceStorePickUpOrder = _SalesOrder.SalesOrder

Annotations (6)

NameValueLevelField
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Data for Retail Store Order view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ReferenceStorePickUpOrder vbkd vbeln
KEY ReferenceStorePickupOrderItem vbkd posnr
RetailStoreCustomerReference vbkd bstkd
RetailStoreExternalReference vbkd ihrez
_SalesOrder _SalesOrder 
//@AbapCatalog.sqlViewName: 'ISTRPKORDBUSDATA'

@VDM.viewType: #BASIC
@ObjectModel: { usageType.serviceQuality: #B, 
                usageType.sizeCategory: #L, 
                usageType.dataClass: #TRANSACTIONAL
              }
// #Check is deprecated #mandatory is replcement for auth check

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking:#('TRANSACTIONAL_DATA')
@EndUserText.label: 'Business Data for Retail Store Order'
define view entity I_RetailStoreOrderBusinessData as select from vbkd
association [1..1] to I_SalesOrder   as _SalesOrder   on $projection.ReferenceStorePickUpOrder   = _SalesOrder.SalesOrder
{
  key vbkd.vbeln as ReferenceStorePickUpOrder,
  key vbkd.posnr as ReferenceStorePickupOrderItem,
  
  vbkd.bstkd as RetailStoreCustomerReference,
  vbkd.ihrez as RetailStoreExternalReference,
  
  _SalesOrder
}

Learn More