C_BPUnloadingPoint

DDL: C_BPUNLOADINGPOINT SQL: CBPUNLOADING Type: view CONSUMPTION
43 Fields 1 Data Sources 3 Associations

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.

Data Sources (1)

SourceAliasJoin Type
I_BPUnloadingPointTP BusinessPartnerUnloadingPoint from

Associations (3)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY Customer I_BPUnloadingPointTP Customer Sold-to Party
KEY UnloadingPointName I_BPUnloadingPointTP UnloadingPointName Unloading Point Name
KEY BusinessPartner I_BPUnloadingPointTP BusinessPartner Issuing Authority
CustomerForEdit I_BPUnloadingPointTP CustomerForEdit Customer
UnloadingPointNameForEdit I_BPUnloadingPointTP UnloadingPointNameForEdit Unloading Point
IsDfltBPUnloadingPoint I_BPUnloadingPointTP IsDfltBPUnloadingPoint Default unld.pt
CustomerFactoryCalenderCode I_BPUnloadingPointTP CustomerFactoryCalenderCode Cust.calendar
BPGoodsReceivingHoursCode I_BPUnloadingPointTP BPGoodsReceivingHoursCode Goods rec.hours
BusinessPartnerForEdit I_BPUnloadingPointTP BusinessPartnerForEdit Busn. Partner
BusinessPartnerUUID I_BPUnloadingPointTP BusinessPartnerUUID UUID
MondayMorningOpeningTime I_BPUnloadingPointTP MondayMorningOpeningTime Monday
MondayMorningClosingTime I_BPUnloadingPointTP MondayMorningClosingTime Monday
MondayAfternoonOpeningTime I_BPUnloadingPointTP MondayAfternoonOpeningTime Monday
MondayAfternoonClosingTime I_BPUnloadingPointTP MondayAfternoonClosingTime Monday
TuesdayMorningOpeningTime I_BPUnloadingPointTP TuesdayMorningOpeningTime Tuesday
TuesdayMorningClosingTime I_BPUnloadingPointTP TuesdayMorningClosingTime Tuesday
TuesdayAfternoonOpeningTime I_BPUnloadingPointTP TuesdayAfternoonOpeningTime Tuesday
TuesdayAfternoonClosingTime I_BPUnloadingPointTP TuesdayAfternoonClosingTime Tuesday
WednesdayMorningOpeningTime I_BPUnloadingPointTP WednesdayMorningOpeningTime Wednesday
WednesdayMorningClosingTime I_BPUnloadingPointTP WednesdayMorningClosingTime Wednesday
WednesdayAfternoonOpeningTime I_BPUnloadingPointTP WednesdayAfternoonOpeningTime Wednesday
WednesdayAfternoonClosingTime I_BPUnloadingPointTP WednesdayAfternoonClosingTime Wednesday
ThursdayMorningOpeningTime I_BPUnloadingPointTP ThursdayMorningOpeningTime Thursday
ThursdayMorningClosingTime I_BPUnloadingPointTP ThursdayMorningClosingTime Thursday
ThursdayAfternoonOpeningTime I_BPUnloadingPointTP ThursdayAfternoonOpeningTime Thursday
ThursdayAfternoonClosingTime I_BPUnloadingPointTP ThursdayAfternoonClosingTime Thursday
FridayMorningOpeningTime I_BPUnloadingPointTP FridayMorningOpeningTime Friday
FridayMorningClosingTime I_BPUnloadingPointTP FridayMorningClosingTime Friday
FridayAfternoonOpeningTime I_BPUnloadingPointTP FridayAfternoonOpeningTime Friday
FridayAfternoonClosingTime I_BPUnloadingPointTP FridayAfternoonClosingTime Friday
SaturdayMorningOpeningTime I_BPUnloadingPointTP SaturdayMorningOpeningTime Saturday
SaturdayMorningClosingTime I_BPUnloadingPointTP SaturdayMorningClosingTime Saturday
SaturdayAfternoonOpeningTime I_BPUnloadingPointTP SaturdayAfternoonOpeningTime Saturday
SaturdayAfternoonClosingTime I_BPUnloadingPointTP SaturdayAfternoonClosingTime Saturday
SundayMorningOpeningTime I_BPUnloadingPointTP SundayMorningOpeningTime Sunday
SundayMorningClosingTime I_BPUnloadingPointTP SundayMorningClosingTime Sunday
SundayAfternoonOpeningTime I_BPUnloadingPointTP SundayAfternoonOpeningTime Sunday
SundayAfternoonClosingTime I_BPUnloadingPointTP SundayAfternoonClosingTime Sunday
BPGoodsReceivingHoursText _BPGoodsReceivingHoursText BPGoodsReceivingHoursText
_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_BPUnloadingPoint.
-- 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: CBPUNLOADING

CREATE VIEW C_BPUnloadingPoint AS
SELECT
  BusinessPartnerUnloadingPoint.Customer AS Customer,
  BusinessPartnerUnloadingPoint.UnloadingPointName AS UnloadingPointName,
  BusinessPartnerUnloadingPoint.BusinessPartner AS BusinessPartner,
  BusinessPartnerUnloadingPoint.CustomerForEdit AS CustomerForEdit,
  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
FROM I_BPUnloadingPointTP 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]
;

Learn More