C_CustomerUnloadingPointTP

DDL: C_CUSTOMERUNLOADINGPOINTTP Type: view_entity CONSUMPTION

BP Customer Unloading Point

C_CustomerUnloadingPointTP is a Consumption CDS View that provides data about "BP Customer Unloading Point" in SAP S/4HANA. It reads from 1 data source (I_CustomerUnloadingPointTP) and exposes 37 fields with key fields Customer, BusinessPartner, UnloadingPointName.

Data Sources (1)

SourceAliasJoin Type
I_CustomerUnloadingPointTP I_CustomerUnloadingPointTP from

Annotations (8)

NameValueLevelField
EndUserText.label BP Customer Unloading Point view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer Sold-to Party
KEY BusinessPartner BusinessPartner Issuing Authority
KEY UnloadingPointName UnloadingPointName Unloading Point Name
UnloadingPointNameForEdit UnloadingPointNameForEdit Unloading Point
CustomerFactoryCalenderCode CustomerFactoryCalenderCode Cust.calendar
BPGoodsReceivingHoursCode BPGoodsReceivingHoursCode Goods rec.hours
IsDfltBPUnloadingPoint IsDfltBPUnloadingPoint Default unld.pt
MondayMorningOpeningTime MondayMorningOpeningTime Monday
MondayMorningClosingTime MondayMorningClosingTime Monday
MondayAfternoonOpeningTime MondayAfternoonOpeningTime Monday
MondayAfternoonClosingTime MondayAfternoonClosingTime Monday
TuesdayMorningOpeningTime TuesdayMorningOpeningTime Tuesday
TuesdayMorningClosingTime TuesdayMorningClosingTime Tuesday
TuesdayAfternoonOpeningTime TuesdayAfternoonOpeningTime Tuesday
TuesdayAfternoonClosingTime TuesdayAfternoonClosingTime Tuesday
WednesdayMorningOpeningTime WednesdayMorningOpeningTime Wednesday
WednesdayMorningClosingTime WednesdayMorningClosingTime Wednesday
WednesdayAfternoonOpeningTime WednesdayAfternoonOpeningTime Wednesday
WednesdayAfternoonClosingTime WednesdayAfternoonClosingTime Wednesday
ThursdayMorningOpeningTime ThursdayMorningOpeningTime Thursday
ThursdayMorningClosingTime ThursdayMorningClosingTime Thursday
ThursdayAfternoonOpeningTime ThursdayAfternoonOpeningTime Thursday
ThursdayAfternoonClosingTime ThursdayAfternoonClosingTime Thursday
FridayMorningOpeningTime FridayMorningOpeningTime Friday
FridayMorningClosingTime FridayMorningClosingTime Friday
FridayAfternoonOpeningTime FridayAfternoonOpeningTime Friday
FridayAfternoonClosingTime FridayAfternoonClosingTime Friday
SaturdayMorningOpeningTime SaturdayMorningOpeningTime Saturday
SaturdayMorningClosingTime SaturdayMorningClosingTime Saturday
SaturdayAfternoonOpeningTime SaturdayAfternoonOpeningTime Saturday
SaturdayAfternoonClosingTime SaturdayAfternoonClosingTime Saturday
SundayMorningOpeningTime SundayMorningOpeningTime Sunday
SundayMorningClosingTime SundayMorningClosingTime Sunday
SundayAfternoonOpeningTime SundayAfternoonOpeningTime Sunday
SundayAfternoonClosingTime SundayAfternoonClosingTime Sunday
_Customer _Customer
_BusinessPartner _BusinessPartner

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_CustomerUnloadingPointTP.
-- 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.

CREATE VIEW C_CustomerUnloadingPointTP AS
SELECT
  Customer,
  BusinessPartner,
  UnloadingPointName,
  UnloadingPointNameForEdit,
  CustomerFactoryCalenderCode,
  BPGoodsReceivingHoursCode,
  IsDfltBPUnloadingPoint,
  MondayMorningOpeningTime,
  MondayMorningClosingTime,
  MondayAfternoonOpeningTime,
  MondayAfternoonClosingTime,
  TuesdayMorningOpeningTime,
  TuesdayMorningClosingTime,
  TuesdayAfternoonOpeningTime,
  TuesdayAfternoonClosingTime,
  WednesdayMorningOpeningTime,
  WednesdayMorningClosingTime,
  WednesdayAfternoonOpeningTime,
  WednesdayAfternoonClosingTime,
  ThursdayMorningOpeningTime,
  ThursdayMorningClosingTime,
  ThursdayAfternoonOpeningTime,
  ThursdayAfternoonClosingTime,
  FridayMorningOpeningTime,
  FridayMorningClosingTime,
  FridayAfternoonOpeningTime,
  FridayAfternoonClosingTime,
  SaturdayMorningOpeningTime,
  SaturdayMorningClosingTime,
  SaturdayAfternoonOpeningTime,
  SaturdayAfternoonClosingTime,
  SundayMorningOpeningTime,
  SundayMorningClosingTime,
  SundayAfternoonOpeningTime,
  SundayAfternoonClosingTime
FROM I_CustomerUnloadingPointTP
;