I_CUSTOMERUNLOADINGPOINT
Customer Unloading Point
I_CUSTOMERUNLOADINGPOINT is a CDS View in S/4HANA. Customer Unloading Point. It contains 34 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_CustomerUnloadingPoint | view | from | BASIC | Customer Unloading Point |
| C_JITUnloadingPointValueHelp | view_entity | from | CONSUMPTION | Unloading Point Value Help |
| C_SalesDocUnloadingPointVH | view_entity | from | CONSUMPTION | Unloading Point |
| I_BPCustUnldgPtAddrDepdntInfo | view | inner | COMPOSITE | BP and Cust unldg Addr Depdnt Info |
| I_BPCustUnloadingPointGov | view_entity | union_all | COMPOSITE | BP Customer Unloading Point Governance |
| I_BPUnloadingPointTP | view | from | TRANSACTIONAL | TP view for Customer Unloading Points |
| I_CustomerUnloadingPointTP | view_entity | from | TRANSACTIONAL | BP Customer Unloading Point - TP |
Fields (34)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Customer | Customer,CustomerForEdit | 2 |
| KEY | UnloadingPointName | UnloadingPointName,UnloadingPointNameForEdit | 3 |
| _Customer | _Customer | 1 | |
| BPGoodsReceivingHoursCode | BPGoodsReceivingHoursCode | 2 | |
| CustomerFactoryCalenderCode | CustomerFactoryCalenderCode | 2 | |
| FridayAfternoonClosingTime | FridayAfternoonClosingTime | 2 | |
| FridayAfternoonOpeningTime | FridayAfternoonOpeningTime | 2 | |
| FridayMorningClosingTime | FridayMorningClosingTime | 2 | |
| FridayMorningOpeningTime | FridayMorningOpeningTime | 2 | |
| IsDfltBPUnloadingPoint | IsDfltBPUnloadingPoint | 2 | |
| MondayAfternoonClosingTime | MondayAfternoonClosingTime | 2 | |
| MondayAfternoonOpeningTime | MondayAfternoonOpeningTime | 2 | |
| MondayMorningClosingTime | MondayMorningClosingTime | 2 | |
| MondayMorningOpeningTime | MondayMorningOpeningTime | 2 | |
| SaturdayAfternoonClosingTime | SaturdayAfternoonClosingTime | 2 | |
| SaturdayAfternoonOpeningTime | SaturdayAfternoonOpeningTime | 2 | |
| SaturdayMorningClosingTime | SaturdayMorningClosingTime | 2 | |
| SaturdayMorningOpeningTime | SaturdayMorningOpeningTime | 2 | |
| SundayAfternoonClosingTime | SundayAfternoonClosingTime | 2 | |
| SundayAfternoonOpeningTime | SundayAfternoonOpeningTime | 2 | |
| SundayMorningClosingTime | SundayMorningClosingTime | 2 | |
| SundayMorningOpeningTime | SundayMorningOpeningTime | 2 | |
| ThursdayAfternoonClosingTime | ThursdayAfternoonClosingTime | 2 | |
| ThursdayAfternoonOpeningTime | ThursdayAfternoonOpeningTime | 2 | |
| ThursdayMorningClosingTime | ThursdayMorningClosingTime | 2 | |
| ThursdayMorningOpeningTime | ThursdayMorningOpeningTime | 2 | |
| TuesdayAfternoonClosingTime | TuesdayAfternoonClosingTime | 2 | |
| TuesdayAfternoonOpeningTime | TuesdayAfternoonOpeningTime | 2 | |
| TuesdayMorningClosingTime | TuesdayMorningClosingTime | 2 | |
| TuesdayMorningOpeningTime | TuesdayMorningOpeningTime | 2 | |
| WednesdayAfternoonClosingTime | WednesdayAfternoonClosingTime | 2 | |
| WednesdayAfternoonOpeningTime | WednesdayAfternoonOpeningTime | 2 | |
| WednesdayMorningClosingTime | WednesdayMorningClosingTime | 2 | |
| WednesdayMorningOpeningTime | WednesdayMorningOpeningTime | 2 |
@AbapCatalog.sqlViewName: 'ICSTMRUNLDNGPNT'
@EndUserText.label: 'Customer Unloading Point'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: ['_BusinessPartner.IsBusinessPurposeCompleted']
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
automatic: true
}
}
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #BASIC
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE , #CDS_MODELING_DATA_SOURCE ,
#ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE,#CDS_MODELING_ASSOCIATION_TARGET]
@ObjectModel.modelingPattern: #NONE
@ObjectModel.sapObjectNodeType.name: 'CustomerUnloadingPoint'
@ObjectModel: {
representativeKey: 'UnloadingPointName',
usageType: {
serviceQuality: #A,
sizeCategory : #M,
dataClass: #MASTER
}
}
@Metadata.allowExtensions:true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_CustomerUnloadingPoint
as select from knva
association [1..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
{
@ObjectModel.foreignKey.association: '_Customer'
key kunnr as Customer,
key ablad as UnloadingPointName,
knfak as CustomerFactoryCalenderCode,
wanid as BPGoodsReceivingHoursCode,
defab as IsDfltBPUnloadingPoint,
moab1 as MondayMorningOpeningTime,
mobi1 as MondayMorningClosingTime,
moab2 as MondayAfternoonOpeningTime,
mobi2 as MondayAfternoonClosingTime,
diab1 as TuesdayMorningOpeningTime,
dibi1 as TuesdayMorningClosingTime,
diab2 as TuesdayAfternoonOpeningTime,
dibi2 as TuesdayAfternoonClosingTime,
miab1 as WednesdayMorningOpeningTime,
mibi1 as WednesdayMorningClosingTime,
miab2 as WednesdayAfternoonOpeningTime,
mibi2 as WednesdayAfternoonClosingTime,
doab1 as ThursdayMorningOpeningTime,
dobi1 as ThursdayMorningClosingTime,
doab2 as ThursdayAfternoonOpeningTime,
dobi2 as ThursdayAfternoonClosingTime,
frab1 as FridayMorningOpeningTime,
frbi1 as FridayMorningClosingTime,
frab2 as FridayAfternoonOpeningTime,
frbi2 as FridayAfternoonClosingTime,
saab1 as SaturdayMorningOpeningTime,
sabi1 as SaturdayMorningClosingTime,
saab2 as SaturdayAfternoonOpeningTime,
sabi2 as SaturdayAfternoonClosingTime,
soab1 as SundayMorningOpeningTime,
sobi1 as SundayMorningClosingTime,
soab2 as SundayAfternoonOpeningTime,
sobi2 as SundayAfternoonClosingTime,
_Customer
}