I_AllocationTableItemRcpntSts

DDL: I_ALLOCATIONTABLEITEMRCPNTSTS SQL: IALLOCTBLRCPSTS Type: view BASIC

Allocation Table Recipient Status

I_AllocationTableItemRcpntSts is a Basic CDS View that provides data about "Allocation Table Recipient Status" in SAP S/4HANA. It reads from 1 data source (ausb) and exposes 12 fields with key fields AllocationTable, AllocationTableItem, AllocationTableItemRcpntGrp, AllocationTableItemRecipient. It has 4 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
ausb ausb from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_AllocationTable _AllocationTable $projection.AllocationTable = _AllocationTable.AllocationTable
[1..1] I_AllocationTableItem _AllocationTableItem $projection.AllocationTable = _AllocationTableItem.AllocationTable and $projection.AllocationTableItem = _AllocationTableItem.AllocationTableItem
[1..1] I_AllocationTableItemRcpntGrp _AllocationTableItemRcpntGrp $projection.AllocationTable = _AllocationTableItemRcpntGrp.AllocationTable and $projection.AllocationTableItem = _AllocationTableItemRcpntGrp.AllocationTableItem and $projection.AllocationTableItemRcpntGrp = _AllocationTableItemRcpntGrp.AllocationTableItemRcpntGrp
[1..1] I_AllocationTableItemRecipient _AllocationTableItemRecipient $projection.AllocationTable = _AllocationTableItemRecipient.AllocationTable and $projection.AllocationTableItem = _AllocationTableItemRecipient.AllocationTableItem and $projection.AllocationTableItemRcpntGrp = _AllocationTableItemRecipient.AllocationTableItemRcpntGrp and $projection.AllocationTableItemRecipient = _AllocationTableItemRecipient.AllocationTableItemRecipient

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IALLOCTBLRCPSTS view
EndUserText.label Allocation Table Recipient Status view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.representativeKey AllocationTableItemRecipient view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY AllocationTable abeln
KEY AllocationTableItem abelp
KEY AllocationTableItemRcpntGrp abelg
KEY AllocationTableItemRecipient abelf
AllocTableSubsqntPurOrdSts bstst
AllocTableSubsqntSTOSts umlst
AllocTableSubsqntOutbDelivSts liest
AllocTableSubsqntSalesOrderSts kagst
_AllocationTable _AllocationTable
_AllocationTableItem _AllocationTableItem
_AllocationTableItemRcpntGrp _AllocationTableItemRcpntGrp
_AllocationTableItemRecipient _AllocationTableItemRecipient 
@AbapCatalog.sqlViewName: 'IALLOCTBLRCPSTS'
@EndUserText.label: 'Allocation Table Recipient Status'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@ObjectModel: {
    representativeKey: 'AllocationTableItemRecipient',
    usageType.serviceQuality: #A,
    usageType.sizeCategory: #L,
    usageType.dataClass: #TRANSACTIONAL
}

define view I_AllocationTableItemRcpntSts
  as select from ausb
  association [1..1] to I_AllocationTable              as _AllocationTable              on  $projection.AllocationTable = _AllocationTable.AllocationTable
  association [1..1] to I_AllocationTableItem          as _AllocationTableItem          on  $projection.AllocationTable     = _AllocationTableItem.AllocationTable
                                                                                        and $projection.AllocationTableItem = _AllocationTableItem.AllocationTableItem
  association [1..1] to I_AllocationTableItemRcpntGrp  as _AllocationTableItemRcpntGrp  on  $projection.AllocationTable             = _AllocationTableItemRcpntGrp.AllocationTable
                                                                                        and $projection.AllocationTableItem         = _AllocationTableItemRcpntGrp.AllocationTableItem
                                                                                        and $projection.AllocationTableItemRcpntGrp = _AllocationTableItemRcpntGrp.AllocationTableItemRcpntGrp
  association [1..1] to I_AllocationTableItemRecipient as _AllocationTableItemRecipient on  $projection.AllocationTable              = _AllocationTableItemRecipient.AllocationTable
                                                                                        and $projection.AllocationTableItem          = _AllocationTableItemRecipient.AllocationTableItem
                                                                                        and $projection.AllocationTableItemRcpntGrp  = _AllocationTableItemRecipient.AllocationTableItemRcpntGrp
                                                                                        and $projection.AllocationTableItemRecipient = _AllocationTableItemRecipient.AllocationTableItemRecipient
{
      @ObjectModel.foreignKey.association: '_AllocationTable'
  key abeln       as AllocationTable,
      @ObjectModel.foreignKey.association: '_AllocationTableItem'
  key abelp       as AllocationTableItem,
      @ObjectModel.foreignKey.association: '_AllocationTableItemRcpntGrp'
  key abelg       as AllocationTableItemRcpntGrp,
  key abelf       as AllocationTableItemRecipient,

      bstst       as AllocTableSubsqntPurOrdSts,
      umlst       as AllocTableSubsqntSTOSts,
      liest       as AllocTableSubsqntOutbDelivSts,
      kagst       as AllocTableSubsqntSalesOrderSts,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]
      _AllocationTable,
      _AllocationTableItem,
      _AllocationTableItemRcpntGrp,
      _AllocationTableItemRecipient
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUSB"
],
"ASSOCIATED":
[
"I_ALLOCATIONTABLE",
"I_ALLOCATIONTABLEITEM",
"I_ALLOCATIONTABLEITEMRCPNTGRP",
"I_ALLOCATIONTABLEITEMRECIPIENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More