I_BPUnloadingPointTP

DDL: I_BPUNLOADINGPOINTTP SQL: IBPUNLOADINGTP Type: view TRANSACTIONAL

TP view for Customer Unloading Points

I_BPUnloadingPointTP is a Transactional CDS View that provides data about "TP view for Customer Unloading Points" in SAP S/4HANA. It reads from 1 data source (I_CustomerUnloadingPoint) and exposes 40 fields with key fields Customer, UnloadingPointName, BusinessPartner. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustomerUnloadingPoint BusinessPartnerUnloadingPoint from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPUNLOADINGTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP view for Customer Unloading Points view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeEnabled true view
ObjectModel.writeDraftPersistence BUPA_KNVA_D view
ObjectModel.draftEnabled true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustomerUnloadingPoint Customer
KEY UnloadingPointName I_CustomerUnloadingPoint UnloadingPointName
KEY BusinessPartner
CustomerForEdit I_CustomerUnloadingPoint Customer
UnloadingPointNameForEdit I_CustomerUnloadingPoint UnloadingPointName
BusinessPartnerForEdit
BusinessPartnerUUID
CustomerFactoryCalenderCode I_CustomerUnloadingPoint CustomerFactoryCalenderCode
IsDfltBPUnloadingPoint I_CustomerUnloadingPoint IsDfltBPUnloadingPoint
BPGoodsReceivingHoursCode I_CustomerUnloadingPoint BPGoodsReceivingHoursCode
MondayMorningOpeningTime I_CustomerUnloadingPoint MondayMorningOpeningTime
MondayMorningClosingTime I_CustomerUnloadingPoint MondayMorningClosingTime
MondayAfternoonOpeningTime I_CustomerUnloadingPoint MondayAfternoonOpeningTime
MondayAfternoonClosingTime I_CustomerUnloadingPoint MondayAfternoonClosingTime
TuesdayMorningOpeningTime I_CustomerUnloadingPoint TuesdayMorningOpeningTime
TuesdayMorningClosingTime I_CustomerUnloadingPoint TuesdayMorningClosingTime
TuesdayAfternoonOpeningTime I_CustomerUnloadingPoint TuesdayAfternoonOpeningTime
TuesdayAfternoonClosingTime I_CustomerUnloadingPoint TuesdayAfternoonClosingTime
WednesdayMorningOpeningTime I_CustomerUnloadingPoint WednesdayMorningOpeningTime
WednesdayMorningClosingTime I_CustomerUnloadingPoint WednesdayMorningClosingTime
WednesdayAfternoonOpeningTime I_CustomerUnloadingPoint WednesdayAfternoonOpeningTime
WednesdayAfternoonClosingTime I_CustomerUnloadingPoint WednesdayAfternoonClosingTime
ThursdayMorningOpeningTime I_CustomerUnloadingPoint ThursdayMorningOpeningTime
ThursdayMorningClosingTime I_CustomerUnloadingPoint ThursdayMorningClosingTime
ThursdayAfternoonOpeningTime I_CustomerUnloadingPoint ThursdayAfternoonOpeningTime
ThursdayAfternoonClosingTime I_CustomerUnloadingPoint ThursdayAfternoonClosingTime
FridayMorningOpeningTime I_CustomerUnloadingPoint FridayMorningOpeningTime
FridayMorningClosingTime I_CustomerUnloadingPoint FridayMorningClosingTime
FridayAfternoonOpeningTime I_CustomerUnloadingPoint FridayAfternoonOpeningTime
FridayAfternoonClosingTime I_CustomerUnloadingPoint FridayAfternoonClosingTime
SaturdayMorningOpeningTime I_CustomerUnloadingPoint SaturdayMorningOpeningTime
SaturdayMorningClosingTime I_CustomerUnloadingPoint SaturdayMorningClosingTime
SaturdayAfternoonOpeningTime I_CustomerUnloadingPoint SaturdayAfternoonOpeningTime
SaturdayAfternoonClosingTime I_CustomerUnloadingPoint SaturdayAfternoonClosingTime
SundayMorningOpeningTime I_CustomerUnloadingPoint SundayMorningOpeningTime
SundayMorningClosingTime I_CustomerUnloadingPoint SundayMorningClosingTime
SundayAfternoonOpeningTime I_CustomerUnloadingPoint SundayAfternoonOpeningTime
SundayAfternoonClosingTime I_CustomerUnloadingPoint SundayAfternoonClosingTime
_Customer _Customer
_BusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'IBPUNLOADINGTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP view for Customer Unloading Points'
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.writeEnabled: true
@ObjectModel.writeDraftPersistence: 'BUPA_KNVA_D'
@ObjectModel.semanticKey: [ 'BusinessPartner', 'Customer','UnloadingPointName' ]
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled
@ObjectModel.updateEnabled
@Search.searchable: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view I_BPUnloadingPointTP
  as select from I_CustomerUnloadingPoint as BusinessPartnerUnloadingPoint

  association [1..1] to I_BusinessPartnerTP       as _BusinessPartner     on  $projection.businesspartner = _BusinessPartner.BusinessPartner
  
 // association [0..*] to I_BPGoodsReceivingHoursTP as _GoodsReceivingHours on  $projection.businesspartner    = _GoodsReceivingHours.BusinessPartner

   //                                                                       and $projection.Customer           = _GoodsReceivingHours.Customer

     //                                                                     and $projection.UnloadingPointName = _GoodsReceivingHours.UnloadingPointName

{
  key BusinessPartnerUnloadingPoint.Customer,
  key BusinessPartnerUnloadingPoint.UnloadingPointName,
  key BusinessPartnerUnloadingPoint._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,

      BusinessPartnerUnloadingPoint.Customer                                                               as CustomerForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerUnloadingPoint.UnloadingPointName                                                     as UnloadingPointNameForEdit,
      BusinessPartnerUnloadingPoint._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner  as BusinessPartnerForEdit,
      BusinessPartnerUnloadingPoint._Customer._CustomerToBusinessPartner.BusinessPartnerUUID,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerUnloadingPoint.CustomerFactoryCalenderCode,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerUnloadingPoint.IsDfltBPUnloadingPoint,
      BusinessPartnerUnloadingPoint.BPGoodsReceivingHoursCode,

      BusinessPartnerUnloadingPoint.MondayMorningOpeningTime,
      BusinessPartnerUnloadingPoint.MondayMorningClosingTime,
      BusinessPartnerUnloadingPoint.MondayAfternoonOpeningTime,
      BusinessPartnerUnloadingPoint.MondayAfternoonClosingTime,

      BusinessPartnerUnloadingPoint.TuesdayMorningOpeningTime,
      BusinessPartnerUnloadingPoint.TuesdayMorningClosingTime,
      BusinessPartnerUnloadingPoint.TuesdayAfternoonOpeningTime,
      BusinessPartnerUnloadingPoint.TuesdayAfternoonClosingTime,

      BusinessPartnerUnloadingPoint.WednesdayMorningOpeningTime,
      BusinessPartnerUnloadingPoint.WednesdayMorningClosingTime,
      BusinessPartnerUnloadingPoint.WednesdayAfternoonOpeningTime,
      BusinessPartnerUnloadingPoint.WednesdayAfternoonClosingTime,

      BusinessPartnerUnloadingPoint.ThursdayMorningOpeningTime,
      BusinessPartnerUnloadingPoint.ThursdayMorningClosingTime,
      BusinessPartnerUnloadingPoint.ThursdayAfternoonOpeningTime,
      BusinessPartnerUnloadingPoint.ThursdayAfternoonClosingTime,

      BusinessPartnerUnloadingPoint.FridayMorningOpeningTime,
      BusinessPartnerUnloadingPoint.FridayMorningClosingTime,
      BusinessPartnerUnloadingPoint.FridayAfternoonOpeningTime,
      BusinessPartnerUnloadingPoint.FridayAfternoonClosingTime,

      BusinessPartnerUnloadingPoint.SaturdayMorningOpeningTime,
      BusinessPartnerUnloadingPoint.SaturdayMorningClosingTime,
      BusinessPartnerUnloadingPoint.SaturdayAfternoonOpeningTime,
      BusinessPartnerUnloadingPoint.SaturdayAfternoonClosingTime,

      BusinessPartnerUnloadingPoint.SundayMorningOpeningTime,
      BusinessPartnerUnloadingPoint.SundayMorningClosingTime,
      BusinessPartnerUnloadingPoint.SundayAfternoonOpeningTime,
      BusinessPartnerUnloadingPoint.SundayAfternoonClosingTime,

      _Customer,
      
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartner
     // @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

      //_GoodsReceivingHours


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_CUSTOMERUNLOADINGPOINT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERTP",
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTOMERUNLOADINGPOINT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/