A_CreditMemoRequest

DDL: A_CREDITMEMOREQUEST Type: view COMPOSITE

Credit Memo Request Header

A_CreditMemoRequest is a Composite CDS View that provides data about "Credit Memo Request Header" in SAP S/4HANA. It reads from 1 data source (I_CreditMemoRequest) and exposes 55 fields with key field CreditMemoRequest. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CreditMemoRequest CreditMemoRequest from

Associations (6)

CardinalityTargetAliasCondition
[0..*] A_CreditMemoRequestItem _Item _Item.CreditMemoRequest = $projection.CreditMemoRequest
[0..*] A_CreditMemoReqPartner _Partner _Partner.CreditMemoRequest = $projection.CreditMemoRequest
[0..*] A_CreditMemoReqPrcgElmnt _PricingElement _PricingElement.CreditMemoRequest = $projection.CreditMemoRequest
[0..*] A_CreditMemoReqText _Text _Text.CreditMemoRequest = $projection.CreditMemoRequest
[0..*] A_CreditMemoReqSubsqntProcFlow _SubsequentProcFlowDoc _SubsequentProcFlowDoc.CreditMemoRequest = $projection.CreditMemoRequest
[0..1] E_SalesDocumentBasic _Extension $projection.CreditMemoRequest = _Extension.SalesDocument

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Credit Memo Request Header view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ACREDITMEMOREQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey Creditmemorequest 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 (55)

KeyFieldSource TableSource FieldDescription
KEY CreditMemoRequest CreditMemoRequest
CreditMemoRequestType CreditMemoRequestType
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
CreditMemoRequestDate CreditMemoRequestDate
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
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup
HeaderBillingBlockReason HeaderBillingBlockReason
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
IncotermsVersion IncotermsVersion
CustomerPaymentTerms CustomerPaymentTerms
PaymentMethod PaymentMethod
BillingDocumentDate BillingDocumentDate
ServicesRenderedDate ServicesRenderedDate
ReferenceSDDocument ReferenceSDDocument
ReferenceSDDocumentCategory ReferenceSDDocumentCategory
CreditMemoReqApprovalReason CreditMemoReqApprovalReason
SalesDocApprovalStatus SalesDocApprovalStatus
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: 'Credit Memo Request Header'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ACREDITMEMOREQ',
  compiler.compareFilter: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'Creditmemorequest',
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_CreditMemoRequest
  as select from I_CreditMemoRequest as CreditMemoRequest

  association [0..*] to A_CreditMemoRequestItem  as _Item           on _Item.CreditMemoRequest = $projection.CreditMemoRequest

  association [0..*] to A_CreditMemoReqPartner   as _Partner        on _Partner.CreditMemoRequest = $projection.CreditMemoRequest

  association [0..*] to A_CreditMemoReqPrcgElmnt as _PricingElement on _PricingElement.CreditMemoRequest = $projection.CreditMemoRequest
  association [0..*] to A_CreditMemoReqText as _Text on _Text.CreditMemoRequest = $projection.CreditMemoRequest
  association [0..*] to A_CreditMemoReqSubsqntProcFlow    as _SubsequentProcFlowDoc  on _SubsequentProcFlowDoc.CreditMemoRequest = $projection.CreditMemoRequest

  //Extensibility

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

{

  key CreditMemoRequest,

      
      CreditMemoRequestType,

      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,

      CreditMemoRequestDate,
      
      @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: 'CustomerAccountAssignmentGroup'
      CustomerAccountAssignmentGroup,

      @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.readOnly: true
      CreditMemoReqApprovalReason,
      @ObjectModel.sapObjectNodeTypeReference: 'SalesDocApprovalStatus'
      @ObjectModel.readOnly: true
      SalesDocApprovalStatus,

      @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_CREDITMEMOREQUEST"
],
"ASSOCIATED":
[
"A_CREDITMEMOREQPARTNER",
"A_CREDITMEMOREQPRCGELMNT",
"A_CREDITMEMOREQSUBSQNTPROCFLOW",
"A_CREDITMEMOREQTEXT",
"A_CREDITMEMOREQUESTITEM",
"E_SALESDOCUMENTBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/