I_CUSTOMERUNLOADINGPOINT

CDS View

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)

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

KeyField CDS FieldsUsed 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
}