A_CustomerUnloadingPoint

DDL: A_CUSTOMERUNLOADINGPOINT SQL: ACSTMRUNLDNGPNT Type: view BASIC Package: ODATA_MASTER_DATA_BP

Customer Unloading Point

A_CustomerUnloadingPoint is a Basic CDS View that provides data about "Customer Unloading Point" in SAP S/4HANA. It reads from 1 data source (I_CustomerUnloadingPoint) and exposes 34 fields with key fields Customer, UnloadingPointName. It has 1 association to related views. Part of development package ODATA_MASTER_DATA_BP.

Data Sources (1)

SourceAliasJoin Type
I_CustomerUnloadingPoint I_CustomerUnloadingPoint from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACSTMRUNLDNGPNT view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Customer Unloading Point view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer Sold-to Party
KEY UnloadingPointName UnloadingPointName Unloading Point Name
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

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 A_CustomerUnloadingPoint.
-- 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: ACSTMRUNLDNGPNT

CREATE VIEW A_CustomerUnloadingPoint AS
SELECT
  Customer,
  UnloadingPointName,
  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_CustomerUnloadingPoint
LEFT OUTER JOIN A_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
;