What is C_BPCustUnldgPtAddrDepdntInfo in SAP S/4HANA?

C_BPCustUnldgPtAddrDepdntInfo is a consumption CDS view in SAP S/4HANA. C View for Addr Dep Unloading Points It contains 46 fields.

Which tables does C_BPCustUnldgPtAddrDepdntInfo read from?

C_BPCustUnldgPtAddrDepdntInfo reads data from: I_BPCustUnldgPtAddrDepdntTP.

What VDM layer is C_BPCustUnldgPtAddrDepdntInfo?

C_BPCustUnldgPtAddrDepdntInfo is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BPCustUnldgPtAddrDepdntInfo

DDL: C_BPCUSTUNLDGPTADDRDEPDNTINFO SQL: CBPADRDEPUP Type: view CONSUMPTION

46 Fields 1 Data Sources 3 Associations

C View for Addr Dep Unloading Points

C_BPCustUnldgPtAddrDepdntInfo is a Consumption CDS View that provides data about "C View for Addr Dep Unloading Points" in SAP S/4HANA. It reads from 1 data source (I_BPCustUnldgPtAddrDepdntTP) and exposes 46 fields with key fields AddressID, Customer, UnloadingPointName, BusinessPartner. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BPCustUnldgPtAddrDepdntTP	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	CBPADRDEPUP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
EndUserText.label	C View for Addr Dep Unloading Points	view
Metadata.allowExtensions	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	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	Address-Dependent Unloading Point	view
UI.headerInfo.typeNamePlural	Address-Dependent Unloading Points	view
VDM.viewType	#CONSUMPTION	view

Fields (46)

Key	Field	Source Table	Source Field	Description
KEY	AddressID	I_BPCustUnldgPtAddrDepdntTP	AddressID	Ship-to address
KEY	Customer	I_BPCustUnldgPtAddrDepdntTP	Customer	Sold-to Party
KEY	UnloadingPointName	I_BPCustUnldgPtAddrDepdntTP	UnloadingPointName	Unloading Point Name
KEY	BusinessPartner	I_BPCustUnldgPtAddrDepdntTP	BusinessPartner	Issuing Authority
	CustomerForEdit	I_BPCustUnldgPtAddrDepdntTP	CustomerForEdit	Customer
	AddressIDForEdit	I_BPCustUnldgPtAddrDepdntTP	AddressIDForEdit	Address Number
	UnloadingPointNameForEdit	I_BPCustUnldgPtAddrDepdntTP	UnloadingPointNameForEdit	Unloading Point
	IsDfltBPUnloadingPoint	I_BPCustUnldgPtAddrDepdntTP	IsDfltBPUnloadingPoint	Default unld.pt
	CustomerFactoryCalenderCode	I_BPCustUnldgPtAddrDepdntTP	CustomerFactoryCalenderCode	Cust.calendar
	BPGoodsReceivingHoursCode	I_BPCustUnldgPtAddrDepdntTP	BPGoodsReceivingHoursCode	Goods rec.hours
	BusinessPartnerForEdit	I_BPCustUnldgPtAddrDepdntTP	BusinessPartnerForEdit	Busn. Partner
	BusinessPartnerUUID	I_BPCustUnldgPtAddrDepdntTP	BusinessPartnerUUID	UUID
	MondayMorningOpeningTime	I_BPCustUnldgPtAddrDepdntTP	MondayMorningOpeningTime	Monday
	MondayMorningClosingTime	I_BPCustUnldgPtAddrDepdntTP	MondayMorningClosingTime	Monday
	MondayAfternoonOpeningTime	I_BPCustUnldgPtAddrDepdntTP	MondayAfternoonOpeningTime	Monday
	MondayAfternoonClosingTime	I_BPCustUnldgPtAddrDepdntTP	MondayAfternoonClosingTime	Monday
	TuesdayMorningOpeningTime	I_BPCustUnldgPtAddrDepdntTP	TuesdayMorningOpeningTime	Tuesday
	TuesdayMorningClosingTime	I_BPCustUnldgPtAddrDepdntTP	TuesdayMorningClosingTime	Tuesday
	TuesdayAfternoonOpeningTime	I_BPCustUnldgPtAddrDepdntTP	TuesdayAfternoonOpeningTime	Tuesday
	TuesdayAfternoonClosingTime	I_BPCustUnldgPtAddrDepdntTP	TuesdayAfternoonClosingTime	Tuesday
	WednesdayMorningOpeningTime	I_BPCustUnldgPtAddrDepdntTP	WednesdayMorningOpeningTime	Wednesday
	WednesdayMorningClosingTime	I_BPCustUnldgPtAddrDepdntTP	WednesdayMorningClosingTime	Wednesday
	WednesdayAfternoonOpeningTime	I_BPCustUnldgPtAddrDepdntTP	WednesdayAfternoonOpeningTime	Wednesday
	WednesdayAfternoonClosingTime	I_BPCustUnldgPtAddrDepdntTP	WednesdayAfternoonClosingTime	Wednesday
	ThursdayMorningOpeningTime	I_BPCustUnldgPtAddrDepdntTP	ThursdayMorningOpeningTime	Thursday
	ThursdayMorningClosingTime	I_BPCustUnldgPtAddrDepdntTP	ThursdayMorningClosingTime	Thursday
	ThursdayAfternoonOpeningTime	I_BPCustUnldgPtAddrDepdntTP	ThursdayAfternoonOpeningTime	Thursday
	ThursdayAfternoonClosingTime	I_BPCustUnldgPtAddrDepdntTP	ThursdayAfternoonClosingTime	Thursday
	FridayMorningOpeningTime	I_BPCustUnldgPtAddrDepdntTP	FridayMorningOpeningTime	Friday
	FridayMorningClosingTime	I_BPCustUnldgPtAddrDepdntTP	FridayMorningClosingTime	Friday
	FridayAfternoonOpeningTime	I_BPCustUnldgPtAddrDepdntTP	FridayAfternoonOpeningTime	Friday
	FridayAfternoonClosingTime	I_BPCustUnldgPtAddrDepdntTP	FridayAfternoonClosingTime	Friday
	SaturdayMorningOpeningTime	I_BPCustUnldgPtAddrDepdntTP	SaturdayMorningOpeningTime	Saturday
	SaturdayMorningClosingTime	I_BPCustUnldgPtAddrDepdntTP	SaturdayMorningClosingTime	Saturday
	SaturdayAfternoonOpeningTime	I_BPCustUnldgPtAddrDepdntTP	SaturdayAfternoonOpeningTime	Saturday
	SaturdayAfternoonClosingTime	I_BPCustUnldgPtAddrDepdntTP	SaturdayAfternoonClosingTime	Saturday
	SundayMorningOpeningTime	I_BPCustUnldgPtAddrDepdntTP	SundayMorningOpeningTime	Sunday
	SundayMorningClosingTime	I_BPCustUnldgPtAddrDepdntTP	SundayMorningClosingTime	Sunday
	SundayAfternoonOpeningTime	I_BPCustUnldgPtAddrDepdntTP	SundayAfternoonOpeningTime	Sunday
	SundayAfternoonClosingTime	I_BPCustUnldgPtAddrDepdntTP	SundayAfternoonClosingTime	Sunday
	BPGoodsReceivingHoursText	_BPGoodsReceivingHoursText	BPGoodsReceivingHoursText
	FormattedAddress	I_BPCustUnldgPtAddrDepdntTP	FormattedAddress
	_BPGoodsReceivingHoursText		_BPGoodsReceivingHoursText
	_BusinessPartnerCustomer		_BusinessPartnerCustomer
	_BusinessPartner		_BusinessPartner
	_Customer		_Customer

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_BPCustUnldgPtAddrDepdntInfo.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CBPADRDEPUP

CREATE VIEW C_BPCustUnldgPtAddrDepdntInfo AS
SELECT
  BusinessPartnerUnloadingPoint.AddressID AS AddressID,
  BusinessPartnerUnloadingPoint.Customer AS Customer,
  BusinessPartnerUnloadingPoint.UnloadingPointName AS UnloadingPointName,
  BusinessPartnerUnloadingPoint.BusinessPartner AS BusinessPartner,
  BusinessPartnerUnloadingPoint.CustomerForEdit AS CustomerForEdit,
  BusinessPartnerUnloadingPoint.AddressIDForEdit AS AddressIDForEdit,
  BusinessPartnerUnloadingPoint.UnloadingPointNameForEdit AS UnloadingPointNameForEdit,
  BusinessPartnerUnloadingPoint.IsDfltBPUnloadingPoint AS IsDfltBPUnloadingPoint,
  BusinessPartnerUnloadingPoint.CustomerFactoryCalenderCode AS CustomerFactoryCalenderCode,
  BusinessPartnerUnloadingPoint.BPGoodsReceivingHoursCode AS BPGoodsReceivingHoursCode,
  BusinessPartnerUnloadingPoint.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerUnloadingPoint.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerUnloadingPoint.MondayMorningOpeningTime AS MondayMorningOpeningTime,
  BusinessPartnerUnloadingPoint.MondayMorningClosingTime AS MondayMorningClosingTime,
  BusinessPartnerUnloadingPoint.MondayAfternoonOpeningTime AS MondayAfternoonOpeningTime,
  BusinessPartnerUnloadingPoint.MondayAfternoonClosingTime AS MondayAfternoonClosingTime,
  BusinessPartnerUnloadingPoint.TuesdayMorningOpeningTime AS TuesdayMorningOpeningTime,
  BusinessPartnerUnloadingPoint.TuesdayMorningClosingTime AS TuesdayMorningClosingTime,
  BusinessPartnerUnloadingPoint.TuesdayAfternoonOpeningTime AS TuesdayAfternoonOpeningTime,
  BusinessPartnerUnloadingPoint.TuesdayAfternoonClosingTime AS TuesdayAfternoonClosingTime,
  BusinessPartnerUnloadingPoint.WednesdayMorningOpeningTime AS WednesdayMorningOpeningTime,
  BusinessPartnerUnloadingPoint.WednesdayMorningClosingTime AS WednesdayMorningClosingTime,
  BusinessPartnerUnloadingPoint.WednesdayAfternoonOpeningTime AS WednesdayAfternoonOpeningTime,
  BusinessPartnerUnloadingPoint.WednesdayAfternoonClosingTime AS WednesdayAfternoonClosingTime,
  BusinessPartnerUnloadingPoint.ThursdayMorningOpeningTime AS ThursdayMorningOpeningTime,
  BusinessPartnerUnloadingPoint.ThursdayMorningClosingTime AS ThursdayMorningClosingTime,
  BusinessPartnerUnloadingPoint.ThursdayAfternoonOpeningTime AS ThursdayAfternoonOpeningTime,
  BusinessPartnerUnloadingPoint.ThursdayAfternoonClosingTime AS ThursdayAfternoonClosingTime,
  BusinessPartnerUnloadingPoint.FridayMorningOpeningTime AS FridayMorningOpeningTime,
  BusinessPartnerUnloadingPoint.FridayMorningClosingTime AS FridayMorningClosingTime,
  BusinessPartnerUnloadingPoint.FridayAfternoonOpeningTime AS FridayAfternoonOpeningTime,
  BusinessPartnerUnloadingPoint.FridayAfternoonClosingTime AS FridayAfternoonClosingTime,
  BusinessPartnerUnloadingPoint.SaturdayMorningOpeningTime AS SaturdayMorningOpeningTime,
  BusinessPartnerUnloadingPoint.SaturdayMorningClosingTime AS SaturdayMorningClosingTime,
  BusinessPartnerUnloadingPoint.SaturdayAfternoonOpeningTime AS SaturdayAfternoonOpeningTime,
  BusinessPartnerUnloadingPoint.SaturdayAfternoonClosingTime AS SaturdayAfternoonClosingTime,
  BusinessPartnerUnloadingPoint.SundayMorningOpeningTime AS SundayMorningOpeningTime,
  BusinessPartnerUnloadingPoint.SundayMorningClosingTime AS SundayMorningClosingTime,
  BusinessPartnerUnloadingPoint.SundayAfternoonOpeningTime AS SundayAfternoonOpeningTime,
  BusinessPartnerUnloadingPoint.SundayAfternoonClosingTime AS SundayAfternoonClosingTime,
  _BPGoodsReceivingHoursText.BPGoodsReceivingHoursText AS BPGoodsReceivingHoursText,
  BusinessPartnerUnloadingPoint.FormattedAddress AS FormattedAddress
FROM I_BPCustUnldgPtAddrDepdntTP AS BusinessPartnerUnloadingPoint
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPGdsRcvgHrsValHelpText AS _BPGoodsReceivingHoursText ON BPGoodsReceivingHoursCode = _BPGoodsReceivingHoursText.BPGoodsReceivingHoursCode AND _BPGoodsReceivingHoursText.Language = $session.system_language  -- association [0..1]
;

Depth:

C_BPCustUnldgPtAddrDepdntInfo view

I_BPCustUnldgPtAddrDepdntTP view