A_CustUnldgPtAddrDepdntInfo

DDL: A_CUSTUNLDGPTADDRDEPDNTINFO SQL: ACUSUNLPTADDEP Type: view BASIC Package: ODATA_MASTER_DATA_BP
35 Fields 1 Data Sources 1 Associations

Customer Unloading Point Address Dependent Information

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

Data Sources (1)

SourceAliasJoin Type
I_CustUnldgPtAddrDepdntInfo I_CustUnldgPtAddrDepdntInfo from

Associations (1)

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

Annotations (16)

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

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer Sold-to Party
KEY AddressID AddressID Ship-to address
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_CustUnldgPtAddrDepdntInfo.
-- 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: ACUSUNLPTADDEP

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

Learn More