A_DebitMemoRequest

DDL: A_DEBITMEMOREQUEST Type: view COMPOSITE

Debit Memo Request Header

A_DebitMemoRequest is a Composite CDS View that provides data about "Debit Memo Request Header" in SAP S/4HANA. It reads from 1 data source (I_DebitMemoRequest) and exposes 52 fields with key field DebitMemoRequest. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DebitMemoRequest DebitMemoRequest from

Associations (6)

CardinalityTargetAliasCondition
[0..*] A_DebitMemoRequestItem _Item _Item.DebitMemoRequest = $projection.DebitMemoRequest
[0..*] A_DebitMemoReqPartner _Partner _Partner.DebitMemoRequest = $projection.DebitMemoRequest
[0..*] A_DebitMemoReqPrcgElmnt _PricingElement _PricingElement.DebitMemoRequest = $projection.DebitMemoRequest
[0..*] A_DebitMemoReqText _Text _Text.DebitMemoRequest = $projection.DebitMemoRequest
[0..*] A_DebitMemoReqSubsqntProcFlow _SubsequentProcFlowDoc _SubsequentProcFlowDoc.DebitMemoRequest = $projection.DebitMemoRequest
[0..1] E_SalesDocumentBasic _Extension $projection.DebitMemoRequest = _Extension.SalesDocument

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Debit Memo Request Header view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ADEBITMEMOREQ view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey Debitmemorequest view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY DebitMemoRequest DebitMemoRequest
DebitMemoRequestType DebitMemoRequestType
SalesOrganization SalesOrganization
DistributionChannel DistributionChannel
OrganizationDivision OrganizationDivision
SalesGroup SalesGroup
SalesOffice SalesOffice
SalesDistrict SalesDistrict
SoldToParty SoldToParty
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
PurchaseOrderByCustomer PurchaseOrderByCustomer
CustomerPurchaseOrderType CustomerPurchaseOrderType
CustomerPurchaseOrderDate CustomerPurchaseOrderDate
DebitMemoRequestDate DebitMemoRequestDate
TotalNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
SDDocumentReason SDDocumentReason
PricingDate PricingDate
CustomerTaxClassification1 CustomerTaxClassification1
CustomerTaxClassification2 CustomerTaxClassification2
CustomerTaxClassification3 CustomerTaxClassification3
CustomerTaxClassification4 CustomerTaxClassification4
CustomerTaxClassification5 CustomerTaxClassification5
CustomerTaxClassification6 CustomerTaxClassification6
CustomerTaxClassification7 CustomerTaxClassification7
CustomerTaxClassification8 CustomerTaxClassification8
CustomerTaxClassification9 CustomerTaxClassification9
HeaderBillingBlockReason HeaderBillingBlockReason
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
IncotermsVersion IncotermsVersion
CustomerPaymentTerms CustomerPaymentTerms
PaymentMethod PaymentMethod
BillingDocumentDate BillingDocumentDate
ServicesRenderedDate ServicesRenderedDate
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
OverallSDProcessStatus OverallSDProcessStatus
TotalCreditCheckStatus TotalCreditCheckStatus
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus
AccountingDocExternalReference AccountingDocExternalReference
AssignmentReference AssignmentReference
_Item _Item
_Partner _Partner
_PricingElement _PricingElement
_Text _Text
_SubsequentProcFlowDoc _SubsequentProcFlowDoc
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Debit Memo Request Header'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ADEBITMEMOREQ',
    preserveKey: true,
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'Debitmemorequest',
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_DebitMemoRequest
  as select from I_DebitMemoRequest as DebitMemoRequest

  association [0..*] to A_DebitMemoRequestItem  as _Item           on _Item.DebitMemoRequest = $projection.DebitMemoRequest

  association [0..*] to A_DebitMemoReqPartner   as _Partner        on _Partner.DebitMemoRequest = $projection.DebitMemoRequest

  association [0..*] to A_DebitMemoReqPrcgElmnt as _PricingElement on _PricingElement.DebitMemoRequest = $projection.DebitMemoRequest
  
  association [0..*] to A_DebitMemoReqText as _Text on _Text.DebitMemoRequest = $projection.DebitMemoRequest
  association [0..*] to A_DebitMemoReqSubsqntProcFlow    as _SubsequentProcFlowDoc  on _SubsequentProcFlowDoc.DebitMemoRequest = $projection.DebitMemoRequest

  //Extensibility

  association [0..1] to E_SalesDocumentBasic    as _Extension      on $projection.DebitMemoRequest = _Extension.SalesDocument

{

  key DebitMemoRequest,
  
      
      DebitMemoRequestType,

      SalesOrganization,
      DistributionChannel,
      OrganizationDivision,

      SalesGroup,
      SalesOffice,
      SalesDistrict,

      SoldToParty,

      @ObjectModel.readOnly: true
      CreationDate,

      @ObjectModel.readOnly: true
      CreatedByUser,

      @ObjectModel.readOnly: true
      LastChangeDate,

      @ObjectModel.readOnly: true
      case tstmp_is_valid(LastChangeDateTime)
        when 0 then cast( dats_tims_to_tstmp( CreationDate, CreationTime, 'UTC', $session.client, 'NULL' ) as timestampl )
        else LastChangeDateTime
      end as LastChangeDateTime,

      PurchaseOrderByCustomer,
      @ObjectModel.sapObjectNodeTypeReference: 'PurchaseOrderTypeByCustomer'
      CustomerPurchaseOrderType,
      CustomerPurchaseOrderDate,

      DebitMemoRequestDate,

      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,

      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      @Semantics.currencyCode: true
      TransactionCurrency,

      @ObjectModel.sapObjectNodeTypeReference: 'SalesDocumentReason'
      SDDocumentReason,
      PricingDate,
      CustomerTaxClassification1,
      CustomerTaxClassification2,
      CustomerTaxClassification3,
      CustomerTaxClassification4,
      CustomerTaxClassification5,
      CustomerTaxClassification6,
      CustomerTaxClassification7,
      CustomerTaxClassification8,
      CustomerTaxClassification9, 
      
      @ObjectModel.sapObjectNodeTypeReference: 'BillingBlockReason'
      HeaderBillingBlockReason,

      @ObjectModel.sapObjectNodeTypeReference: 'IncotermsClassification'
      IncotermsClassification,
      IncotermsTransferLocation,
      IncotermsLocation1,
      IncotermsLocation2,
      @ObjectModel.sapObjectNodeTypeReference: 'IncotermsVersion'
      IncotermsVersion,
      CustomerPaymentTerms,
      PaymentMethod,

      BillingDocumentDate,
      ServicesRenderedDate,

      ReferenceSDDocument,
      
      @ObjectModel.readOnly: true
      ReferenceSDDocumentCategory,

      @ObjectModel.sapObjectNodeTypeReference: 'OverallSDProcessStatus'
      @ObjectModel.readOnly: true
      OverallSDProcessStatus,

      @ObjectModel.sapObjectNodeTypeReference: 'TotalCreditCheckStatus'
      @ObjectModel.readOnly: true
      TotalCreditCheckStatus,

      @ObjectModel.sapObjectNodeTypeReference: 'OverallSDDocumentRejectionSts'
      @ObjectModel.readOnly: true
      OverallSDDocumentRejectionSts,

      @ObjectModel.sapObjectNodeTypeReference: 'OverallOrdReltdBillgStatus'
      @ObjectModel.readOnly: true
      OverallOrdReltdBillgStatus,
      
      AccountingDocExternalReference,
      AssignmentReference,
      // Expose own associations

      _Item,
      _Partner,
      _PricingElement,
      _Text,
      _SubsequentProcFlowDoc
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEBITMEMOREQUEST"
],
"ASSOCIATED":
[
"A_DEBITMEMOREQPARTNER",
"A_DEBITMEMOREQPRCGELMNT",
"A_DEBITMEMOREQSUBSQNTPROCFLOW",
"A_DEBITMEMOREQTEXT",
"A_DEBITMEMOREQUESTITEM",
"E_SALESDOCUMENTBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/