I_BPUNLOADINGPOINTTP
TP view for Customer Unloading Points
I_BPUNLOADINGPOINTTP is a CDS View in S/4HANA. TP view for Customer Unloading Points. It contains 38 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_BPUnloadingPoint | view | from | CONSUMPTION | Consumption view for unloading points |
Fields (38)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner | 1 |
| KEY | Customer | Customer | 1 |
| KEY | UnloadingPointName | UnloadingPointName | 1 |
| BPGoodsReceivingHoursCode | BPGoodsReceivingHoursCode | 1 | |
| BusinessPartnerForEdit | BusinessPartnerForEdit | 1 | |
| BusinessPartnerUUID | BusinessPartnerUUID | 1 | |
| CustomerFactoryCalenderCode | CustomerFactoryCalenderCode | 1 | |
| CustomerForEdit | CustomerForEdit | 1 | |
| FridayAfternoonClosingTime | FridayAfternoonClosingTime | 1 | |
| FridayAfternoonOpeningTime | FridayAfternoonOpeningTime | 1 | |
| FridayMorningClosingTime | FridayMorningClosingTime | 1 | |
| FridayMorningOpeningTime | FridayMorningOpeningTime | 1 | |
| IsDfltBPUnloadingPoint | IsDfltBPUnloadingPoint | 1 | |
| MondayAfternoonClosingTime | MondayAfternoonClosingTime | 1 | |
| MondayAfternoonOpeningTime | MondayAfternoonOpeningTime | 1 | |
| MondayMorningClosingTime | MondayMorningClosingTime | 1 | |
| MondayMorningOpeningTime | MondayMorningOpeningTime | 1 | |
| SaturdayAfternoonClosingTime | SaturdayAfternoonClosingTime | 1 | |
| SaturdayAfternoonOpeningTime | SaturdayAfternoonOpeningTime | 1 | |
| SaturdayMorningClosingTime | SaturdayMorningClosingTime | 1 | |
| SaturdayMorningOpeningTime | SaturdayMorningOpeningTime | 1 | |
| SundayAfternoonClosingTime | SundayAfternoonClosingTime | 1 | |
| SundayAfternoonOpeningTime | SundayAfternoonOpeningTime | 1 | |
| SundayMorningClosingTime | SundayMorningClosingTime | 1 | |
| SundayMorningOpeningTime | SundayMorningOpeningTime | 1 | |
| ThursdayAfternoonClosingTime | ThursdayAfternoonClosingTime | 1 | |
| ThursdayAfternoonOpeningTime | ThursdayAfternoonOpeningTime | 1 | |
| ThursdayMorningClosingTime | ThursdayMorningClosingTime | 1 | |
| ThursdayMorningOpeningTime | ThursdayMorningOpeningTime | 1 | |
| TuesdayAfternoonClosingTime | TuesdayAfternoonClosingTime | 1 | |
| TuesdayAfternoonOpeningTime | TuesdayAfternoonOpeningTime | 1 | |
| TuesdayMorningClosingTime | TuesdayMorningClosingTime | 1 | |
| TuesdayMorningOpeningTime | TuesdayMorningOpeningTime | 1 | |
| UnloadingPointNameForEdit | UnloadingPointNameForEdit | 1 | |
| WednesdayAfternoonClosingTime | WednesdayAfternoonClosingTime | 1 | |
| WednesdayAfternoonOpeningTime | WednesdayAfternoonOpeningTime | 1 | |
| WednesdayMorningClosingTime | WednesdayMorningClosingTime | 1 | |
| WednesdayMorningOpeningTime | WednesdayMorningOpeningTime | 1 |
@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":""
}
}*/