C_DebitMemoReqItmWorkflowInbox

DDL: C_DEBITMEMOREQITMWORKFLOWINBOX SQL: CSDDMRIWFINBOX Type: view CONSUMPTION

Debit Memo Request Workflow Item Inbox

C_DebitMemoReqItmWorkflowInbox is a Consumption CDS View that provides data about "Debit Memo Request Workflow Item Inbox" in SAP S/4HANA. It reads from 1 data source (I_DebitMemoRequestItem) and exposes 11 fields with key fields DebitMemoRequest, DebitMemoRequestItem. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_DebitMemoRequestItem I_DebitMemoRequestItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_SalesDocumentItemBasic _Extension $projection.DebitMemoRequest = _Extension.SalesDocument and $projection.DebitMemoRequestItem = _Extension.SalesDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSDDMRIWFINBOX view
AbapCatalog.preserveKey true view
EndUserText.label Debit Memo Request Workflow Item Inbox view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY DebitMemoRequest DebitMemoRequest
KEY DebitMemoRequestItem DebitMemoRequestItem
Product Product
ProductName
TargetQuantity TargetQuantity
TargetQuantityUnit TargetQuantityUnit
NetAmount NetAmount
TransactionCurrency TransactionCurrency
_TransactionCurrency _TransactionCurrency
_DebitMemoRequest _DebitMemoRequest
_TargetQuantityUnit _TargetQuantityUnit 
@AbapCatalog.sqlViewName: 'CSDDMRIWFINBOX'
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Debit Memo Request Workflow Item Inbox'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM.viewType: #CONSUMPTION
@ObjectModel.semanticKey: ['DebitMemoRequest', 'DebitMemoRequestItem']
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:  #L
@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

define view C_DebitMemoReqItmWorkflowInbox as select from I_DebitMemoRequestItem

  //Extensibility

  association [0..1] to E_SalesDocumentItemBasic     as _Extension         on  $projection.DebitMemoRequest     = _Extension.SalesDocument
                                                                           and $projection.DebitMemoRequestItem = _Extension.SalesDocumentItem
{

      @UI.hidden: true
      @ObjectModel.foreignKey.association: '_DebitMemoRequest'
  key DebitMemoRequest,

      @UI.lineItem: { qualifier: 'DebitMemoRequestInItems', position: 10, importance: #HIGH, label: 'Item' }
      @UI.identification: { position: 10, importance: #HIGH, label: 'Item' }
      @ObjectModel.readOnly: true
  key DebitMemoRequestItem,

      @ObjectModel.text.element: [ 'ProductName' ]
      @UI.lineItem: { qualifier: 'DebitMemoRequestInItems', position: 20, importance: #HIGH, label: 'Product' }
      @UI.identification: { position: 10, importance: #HIGH }
      @ObjectModel.readOnly: true
      Product,
      @Semantics.text: true
      _Product._Text[1: Language=$session.system_language ].ProductName as ProductName,

      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'TargetQuantityUnit'
      @UI.lineItem: { qualifier: 'DebitMemoRequestInItems', position: 30, importance: #HIGH, label: 'Target Quantity' }
      @ObjectModel.readOnly: true
      TargetQuantity,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_TargetQuantityUnit'
      TargetQuantityUnit,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      @UI.lineItem: { qualifier: 'DebitMemoRequestInItems', position: 40, importance: #HIGH, label: 'Net Value' }
      @ObjectModel.readOnly: true
      NetAmount,

      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      TransactionCurrency,
      
      _TransactionCurrency, 
      _DebitMemoRequest,
      _TargetQuantityUnit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEBITMEMOREQUESTITEM",
"I_PRODUCT",
"I_PRODUCTTEXT"
],
"ASSOCIATED":
[
"E_SALESDOCUMENTITEMBASIC",
"I_CURRENCY",
"I_DEBITMEMOREQUEST",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_DEBITMEMOREQUESTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More