Which tables does C_BPUnloadingPoint use?

C_BPUnloadingPoint reads from 1 data source(s): I_BPUnloadingPointTP.

How many fields does C_BPUnloadingPoint have?

C_BPUnloadingPoint has 43 fields. Key fields: Customer, UnloadingPointName, BusinessPartner.

C_BPUnloadingPoint

DDL: C_BPUNLOADINGPOINT SQL: CBPUNLOADING Type: view CONSUMPTION Package: VDM_MD_BP

Consumption view for unloading points

C_BPUnloadingPoint is a Consumption CDS View that provides data about "Consumption view for unloading points" in SAP S/4HANA. It reads from 1 data source (I_BPUnloadingPointTP) and exposes 43 fields with key fields Customer, UnloadingPointName, BusinessPartner. It has 3 associations to related views. Part of development package VDM_MD_BP.

Data Sources (1)

Source	Alias	Join Type
I_BPUnloadingPointTP	BusinessPartnerUnloadingPoint	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	C_BusinessPartnerCustomer	_BusinessPartnerCustomer	`$projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner`
[1..1]	C_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[0..1]	I_BPGdsRcvgHrsValHelpText	_BPGoodsReceivingHoursText	`$projection.BPGoodsReceivingHoursCode = _BPGoodsReceivingHoursText.BPGoodsReceivingHoursCode and _BPGoodsReceivingHoursText.Language = $session.system_language`

Annotations (17)

Name	Value	Level
AbapCatalog.sqlViewName	CBPUNLOADING	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	Consumption view for unloading points	view
Metadata.allowExtensions	true	view
ObjectModel.type	#CONSUMPTION	view
ObjectModel.writeEnabled	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
UI.headerInfo.typeName	Unloading Point	view
UI.headerInfo.typeNamePlural	Unloading Points	view
UI.headerInfo.title.label	Unloading Point Name	view
UI.headerInfo.title.value	UnloadingPointName	view
VDM.viewType	#CONSUMPTION	view

Fields (43)

Key	Field	Source Table	Source Field
KEY	Customer	I_BPUnloadingPointTP	Customer
KEY	UnloadingPointName	I_BPUnloadingPointTP	UnloadingPointName
KEY	BusinessPartner	I_BPUnloadingPointTP	BusinessPartner
	CustomerForEdit	I_BPUnloadingPointTP	CustomerForEdit
	UnloadingPointNameForEdit	I_BPUnloadingPointTP	UnloadingPointNameForEdit
	IsDfltBPUnloadingPoint	I_BPUnloadingPointTP	IsDfltBPUnloadingPoint
	CustomerFactoryCalenderCode	I_BPUnloadingPointTP	CustomerFactoryCalenderCode
	BPGoodsReceivingHoursCode	I_BPUnloadingPointTP	BPGoodsReceivingHoursCode
	BusinessPartnerForEdit	I_BPUnloadingPointTP	BusinessPartnerForEdit
	BusinessPartnerUUID	I_BPUnloadingPointTP	BusinessPartnerUUID
	MondayMorningOpeningTime	I_BPUnloadingPointTP	MondayMorningOpeningTime
	MondayMorningClosingTime	I_BPUnloadingPointTP	MondayMorningClosingTime
	MondayAfternoonOpeningTime	I_BPUnloadingPointTP	MondayAfternoonOpeningTime
	MondayAfternoonClosingTime	I_BPUnloadingPointTP	MondayAfternoonClosingTime
	TuesdayMorningOpeningTime	I_BPUnloadingPointTP	TuesdayMorningOpeningTime
	TuesdayMorningClosingTime	I_BPUnloadingPointTP	TuesdayMorningClosingTime
	TuesdayAfternoonOpeningTime	I_BPUnloadingPointTP	TuesdayAfternoonOpeningTime
	TuesdayAfternoonClosingTime	I_BPUnloadingPointTP	TuesdayAfternoonClosingTime
	WednesdayMorningOpeningTime	I_BPUnloadingPointTP	WednesdayMorningOpeningTime
	WednesdayMorningClosingTime	I_BPUnloadingPointTP	WednesdayMorningClosingTime
	WednesdayAfternoonOpeningTime	I_BPUnloadingPointTP	WednesdayAfternoonOpeningTime
	WednesdayAfternoonClosingTime	I_BPUnloadingPointTP	WednesdayAfternoonClosingTime
	ThursdayMorningOpeningTime	I_BPUnloadingPointTP	ThursdayMorningOpeningTime
	ThursdayMorningClosingTime	I_BPUnloadingPointTP	ThursdayMorningClosingTime
	ThursdayAfternoonOpeningTime	I_BPUnloadingPointTP	ThursdayAfternoonOpeningTime
	ThursdayAfternoonClosingTime	I_BPUnloadingPointTP	ThursdayAfternoonClosingTime
	FridayMorningOpeningTime	I_BPUnloadingPointTP	FridayMorningOpeningTime
	FridayMorningClosingTime	I_BPUnloadingPointTP	FridayMorningClosingTime
	FridayAfternoonOpeningTime	I_BPUnloadingPointTP	FridayAfternoonOpeningTime
	FridayAfternoonClosingTime	I_BPUnloadingPointTP	FridayAfternoonClosingTime
	SaturdayMorningOpeningTime	I_BPUnloadingPointTP	SaturdayMorningOpeningTime
	SaturdayMorningClosingTime	I_BPUnloadingPointTP	SaturdayMorningClosingTime
	SaturdayAfternoonOpeningTime	I_BPUnloadingPointTP	SaturdayAfternoonOpeningTime
	SaturdayAfternoonClosingTime	I_BPUnloadingPointTP	SaturdayAfternoonClosingTime
	SundayMorningOpeningTime	I_BPUnloadingPointTP	SundayMorningOpeningTime
	SundayMorningClosingTime	I_BPUnloadingPointTP	SundayMorningClosingTime
	SundayAfternoonOpeningTime	I_BPUnloadingPointTP	SundayAfternoonOpeningTime
	SundayAfternoonClosingTime	I_BPUnloadingPointTP	SundayAfternoonClosingTime
	BPGoodsReceivingHoursText	_BPGoodsReceivingHoursText	BPGoodsReceivingHoursText
	_BPGoodsReceivingHoursText		_BPGoodsReceivingHoursText
	_BusinessPartnerCustomer		_BusinessPartnerCustomer
	_BusinessPartner		_BusinessPartner
	_Customer		_Customer

@AbapCatalog.sqlViewName: 'CBPUNLOADING'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Consumption view for  unloading points'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: [ 'BusinessPartner', 'Customer','UnloadingPointNameForEdit' ],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@UI.headerInfo:{
  typeName: 'Unloading Point',
  typeNamePlural: 'Unloading Points',
  title:  { label: 'Unloading Point Name', value: 'UnloadingPointName'}
}

@VDM.viewType: #CONSUMPTION
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view C_BPUnloadingPoint
  as select from I_BPUnloadingPointTP as BusinessPartnerUnloadingPoint

  association [1..1] to C_BusinessPartnerCustomer  as _BusinessPartnerCustomer   on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

  association [1..1] to C_BusinessPartner          as _BusinessPartner           on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [0..1] to I_BPGdsRcvgHrsValHelpText  as _BPGoodsReceivingHoursText on  $projection.BPGoodsReceivingHoursCode = _BPGoodsReceivingHoursText.BPGoodsReceivingHoursCode
                                                                                 and _BPGoodsReceivingHoursText.Language   = $session.system_language

{
  key BusinessPartnerUnloadingPoint.Customer,
  key BusinessPartnerUnloadingPoint.UnloadingPointName,
  key BusinessPartnerUnloadingPoint.BusinessPartner,
      BusinessPartnerUnloadingPoint.CustomerForEdit,
      BusinessPartnerUnloadingPoint.UnloadingPointNameForEdit,
      BusinessPartnerUnloadingPoint.IsDfltBPUnloadingPoint,
      BusinessPartnerUnloadingPoint.CustomerFactoryCalenderCode,
      BusinessPartnerUnloadingPoint.BPGoodsReceivingHoursCode,
      BusinessPartnerUnloadingPoint.BusinessPartnerForEdit,
      BusinessPartnerUnloadingPoint.BusinessPartnerUUID,
      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,
      @ObjectModel.readOnly: true
      _BPGoodsReceivingHoursText.BPGoodsReceivingHoursText,

      _BPGoodsReceivingHoursText,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartner,
      @Consumption.hidden: true
      _Customer
}

Depth:

C_BPUnloadingPoint view

I_BPUnloadingPointTP view