I_ALLOCTOPDWNDISTRREFFLD

CDS View

Allocation TDD Reference Field

I_ALLOCTOPDWNDISTRREFFLD is a CDS View in S/4HANA. Allocation TDD Reference Field. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_AllocRcvrRefKeyFldTP view from TRANSACTIONAL Allocation TDD Receiver Reference Field
I_AllocRcvrTracingRefKeyFldTP view from TRANSACTIONAL Allocation TDD Receiver Reference Field
I_AllocSndrRefKeyFldTP view from TRANSACTIONAL Allocation TDD Sender Reference Field
P_AllocRcvrTracingRefCount view inner CONSUMPTION
@AbapCatalog.sqlViewName: 'ALOTDDREFFLD'
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Allocation TDD Reference Field'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M

@VDM.viewType: #BASIC
define view I_AllocTopDwnDistrRefFld as 
select from t811km 
{   
  //t811km  

  key tab as AllocationType, 
  key cycle as AllocationCycle, 
  key sdate as AllocationCycleStartDate, 
  key seqnr as AllocationCycleSegment, 
  key setkind as AllocationSetType, 
  key pos as AllocDocumentSequenceNumber, 
  key field as AllocationFieldName, 
  key field_pos as AllocRefDocumentSequenceNumber, 
      ref_setname as AllocationSetName, 
      ref_valmin as AllocReferenceFromValue, 
      ref_valmax as AllocReferenceToValue, 
      sender as AllocReferenceSourceFromValue, 
      sender_to as AllocReferenceSourceToValue,
      setid as AllocationSetId,
      cast( case when ref_valmin = '#' then 'X' else '' end as boolean ) as  AllocRefKeyFieldIsInitial,
      cast( case when ref_valmin = '*' then 'X' else '' end as boolean ) as AllocRefKeyFieldIsAllValues,
      cast( case when sender = '#' then 'X' else '' end as boolean ) as  AllocSourceKeyFieldIsInitial,
      cast( case when sender = '*' then 'X' else '' end as boolean ) as AllocSourceKeyFieldIsAllValues      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T811KM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/