I_SALESDOCAPPROVALREASON

CDS View

Approval Reason for Sales Document

I_SALESDOCAPPROVALREASON is a CDS View in S/4HANA. Approval Reason for Sales Document. It contains 3 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 3 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_CreditMemoReqApprovalReason view from BASIC Approval Reason for Credit Memo Request
I_CustomerReturnApprovalReason view from BASIC Approval Reason for Returns Order
I_DebitMemoReqApprovalReason view from BASIC Approval Reason for Debit Memo Request
I_SalesContractApprovalReason view from BASIC Sales Contract Approval Reason
I_SalesOrderApprovalReason view from BASIC Approval Reason for Sales Order
I_SlsOrdWthoutChrgApprvlReason view from BASIC Sls Ord Without Charge Approval Reason
I_SlsQtanApprovalReason view from BASIC Sales Quotation Approval Reason

Fields (3)

KeyField CDS FieldsUsed in Views
KEY SalesDocApprovalReason CustomerReturnApprovalReason,DebitMemoReqApprovalReason,SlsOrdWthoutChrgApprvlReason 3
_SDApprovalReason _SDApprovalReason 3
_SDApprovalReasonT _SDApprovalReasonT 3 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel: {
  representativeKey: 'SalesDocApprovalReason',
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S
  },
  supportedCapabilities: [ #SQL_DATA_SOURCE,
                           #CDS_MODELING_DATA_SOURCE,
                           #CDS_MODELING_ASSOCIATION_TARGET]
}

@AbapCatalog: {
  sqlViewName: 'ISDAPMAPRRCAT',
  preserveKey:true,
  compiler.compareFilter: true,
  buffering: {
    status: #ACTIVE,
    type: #FULL
  }
}

@Analytics.internalName: #LOCAL
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Approval Reason for Sales Document'

define view I_SalesDocApprovalReason
  as select from sdapmaprrcat

  association [0..1] to I_SDDocumentCategory as _SDDocumentCategory on $projection.SDDocumentCategory     = _SDDocumentCategory.SDDocumentCategory
  association [0..1] to I_SDApprovalReason   as _SDApprovalReason   on $projection.SalesDocApprovalReason = _SDApprovalReason.SDApprovalReason
  association [0..*] to I_SDApprovalReasonT  as _SDApprovalReasonT  on $projection.SalesDocApprovalReason = _SDApprovalReasonT.SDApprovalReason

{
      @ObjectModel.foreignKey.association: '_SDDocumentCategory'
  key sd_document_category         as SDDocumentCategory,

      @ObjectModel.text.association: '_SDApprovalReasonT'
  key apm_approval_reason          as SalesDocApprovalReason,

      _SDDocumentCategory,     
      _SDApprovalReason,    
      @Analytics.hidden: true
      _SDApprovalReasonT
      
} where sd_document_category = 'B' or
        sd_document_category = 'K' or
        sd_document_category = 'C' or 
        sd_document_category = 'H' or
        sd_document_category = 'G' or
        sd_document_category = 'I' or
        sd_document_category = 'L';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SDAPMAPRRCAT"
],
"ASSOCIATED":
[
"I_SDAPPROVALREASON",
"I_SDAPPROVALREASONT",
"I_SDDOCUMENTCATEGORY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More