I_BPSiteReceivingPointTP

DDL: I_BPSITERECEIVINGPOINTTP SQL: IBPRECEIVINGTP Type: view TRANSACTIONAL

TP View for Customer Receiving Points

I_BPSiteReceivingPointTP is a Transactional CDS View that provides data about "TP View for Customer Receiving Points" in SAP S/4HANA. It reads from 1 data source (I_SiteReceivingPoint) and exposes 12 fields with key fields SiteCustomer, ReceivingPoint, BusinessPartner. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SiteReceivingPoint BusinessPartnerReceivingPoint from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.businesspartner = _BusinessPartner.BusinessPartner
[1..1] I_Site _CustomerSite $projection.SiteCustomer = _CustomerSite.SiteCustomer

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IBPRECEIVINGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label TP View for Customer Receiving Points view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence BUPA_WRF12_D view
ObjectModel.writeEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SiteCustomer I_SiteReceivingPoint SiteCustomer
KEY ReceivingPoint I_SiteReceivingPoint ReceivingPoint
KEY BusinessPartner
SiteCustomerForEdit I_SiteReceivingPoint SiteCustomer
ReceivingPointForEdit I_SiteReceivingPoint ReceivingPoint
BusinessPartnerForEdit
BusinessPartnerUUID
UnloadingPointName I_SiteReceivingPoint UnloadingPointName
_Customer _Customer
_CustomerUnloadingPoint _CustomerUnloadingPoint
_BusinessPartner _BusinessPartner
_CustomerSite _CustomerSite
@AbapCatalog.sqlViewName: 'IBPRECEIVINGTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'TP View for Customer Receiving Points'
@VDM.viewType: #TRANSACTIONAL

@ObjectModel.writeDraftPersistence: 'BUPA_WRF12_D'
@ObjectModel.writeEnabled: true

@ObjectModel.semanticKey: ['BusinessPartner', 'SiteCustomer', 'ReceivingPoint']
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

define view I_BPSiteReceivingPointTP 
    as select from I_SiteReceivingPoint as BusinessPartnerReceivingPoint
    
    association [1..1] to I_BusinessPartnerTP       as _BusinessPartner     on  $projection.businesspartner = _BusinessPartner.BusinessPartner
    
    /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
    association [1..1] to I_Site                    as _CustomerSite        on  $projection.SiteCustomer = _CustomerSite.SiteCustomer

    
{
    key BusinessPartnerReceivingPoint.SiteCustomer,
    key BusinessPartnerReceivingPoint.ReceivingPoint,
    key BusinessPartnerReceivingPoint._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
    
    BusinessPartnerReceivingPoint.SiteCustomer                                                               as SiteCustomerForEdit,
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH
    @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
    BusinessPartnerReceivingPoint.ReceivingPoint                                                             as ReceivingPointForEdit,
    
    BusinessPartnerReceivingPoint._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner      as BusinessPartnerForEdit,
    BusinessPartnerReceivingPoint._Customer._CustomerToBusinessPartner.BusinessPartnerUUID,
    BusinessPartnerReceivingPoint.UnloadingPointName,

    _Customer,
    _CustomerUnloadingPoint,
    
    @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
    _BusinessPartner,
    
    _CustomerSite
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_SITERECEIVINGPOINT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP",
"I_CUSTOMER",
"I_CUSTOMERUNLOADINGPOINT",
"I_SITE"
],
"BASE":
[
"I_SITERECEIVINGPOINT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/