I_CREDITMEMOREQUEST

CDS View

Credit Memo Request

I_CREDITMEMOREQUEST is a CDS View in S/4HANA. Credit Memo Request. It contains 38 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
A_CreditMemoRequest view from COMPOSITE Credit Memo Request Header
A_CreditMemoRequestSimulation view_entity from COMPOSITE Credit Memo Request Simulation
C_BSOrdProcFlwCrdtMemoReq view from CONSUMPTION CrdtMemoReq Attrib for BSOrd Prgrs
C_Credit_Memo_F2200 view from CONSUMPTION CDS view for credit memos
C_Creditmemorequestfs view from CONSUMPTION Credit Memo Request
C_CreditMemoRequestWl_F1989 view from CONSUMPTION Credit Memo Requests
C_CreditMemoReqWorkflowDetail view from CONSUMPTION Credit Memo Request Workflow Details
C_Customer360CreditMemoRequest view_entity from CONSUMPTION Customer 360 Credit Memo Request
ESH_N_CREDITMEMOREQUEST view from
I_CreditMemoRequestStdVH view from COMPOSITE Credit Memo Request
R_CreditMemoRequestTP view_entity from TRANSACTIONAL Credit Memo Request - TP

Fields (38)

KeyField CDS FieldsUsed in Views
KEY CreditMemoRequest CreditMemoRequest 3
_CreditMemoRequestType _CreditMemoRequestType 1
_DistributionChannel _DistributionChannel 1
_HeaderBillingBlockReason _HeaderBillingBlockReason 1
_OrganizationDivision _OrganizationDivision 1
_OverallBillingBlockStatus _OverallBillingBlockStatus 1
_OverallOrdReltdBillgStatus _OverallOrdReltdBillgStatus 1
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_SalesDocApprovalStatus _SalesDocApprovalStatus 1
_SalesOrganization _SalesOrganization 1
_SDDocumentReason _SDDocumentReason 1
_SoldToParty _SoldToParty 1
_TransactionCurrency _TransactionCurrency 1
BillingDocumentDate BillingDocumentDate 2
CreatedByUser CreatedByUser 3
CreationDate CreationDate 2
CreditMemoRequestDate CreditMemoRequestDate 2
CreditMemoRequestType CreditMemoRequestType 2
DistributionChannel DistributionChannel 2
HeaderBillingBlockReason HeaderBillingBlockReason 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 3
OrganizationDivision OrganizationDivision 2
OverallBillingBlockStatus OverallBillingBlockStatus 2
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 2
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts 2
OverallSDProcessStatus OverallSDProcessStatus 2
PurchaseOrderByCustomer PurchaseOrderByCustomer 2
ReferenceSDDocument ReferenceSDDocument 2
SalesDocApprovalStatus SalesDocApprovalStatus 2
SalesGroup SalesGroup 3
SalesOffice SalesOffice 3
SalesOrganization SalesOrganization 2
SDDocumentReason SDDocumentReason 2
SoldToParty SoldToParty 2
TotalNetAmount TotalNetAmount 2
TransactionCurrency TransactionCurrency 2
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.compositionRoot: true
@ObjectModel.representativeKey: 'CreditMemoRequest'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B 
@ObjectModel.usageType.sizeCategory:  #M
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]   
@EndUserText.label: 'Credit Memo Request'
@Analytics:{dataCategory:#DIMENSION}
@Metadata.allowExtensions: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#CHECK
@AccessControl.privilegedAssociations: [ '_CreatedByUser', '_LastChangedByUser'
//--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

,'_BusinessAreaText','_CostCenterBusinessAreaText','_CreditControlAreaText'
// ]--GENERATED

]
@AbapCatalog.sqlViewName: 'ISDCREDITMEMOREQ'
@Metadata.ignorePropagatedAnnotations:true 

define view I_CreditMemoRequest
as select from I_SalesDocument as SalesDocument
//Associations


  //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

  association [0..*] to I_BusinessAreaText            as _BusinessAreaText            on $projection.BusinessArea = _BusinessAreaText.BusinessArea
  association [0..*] to I_BusinessAreaText            as _CostCenterBusinessAreaText  on $projection.CostCenterBusinessArea = _CostCenterBusinessAreaText.BusinessArea
  association [0..*] to I_CreditControlAreaText       as _CreditControlAreaText       on $projection.CreditControlArea = _CreditControlAreaText.CreditControlArea
  // ]--GENERATED

  association [0..*] to I_CreditMemoRequestItem       as _Item                        on $projection.CreditMemoRequest = _Item.CreditMemoRequest
  association [0..1] to I_CreditMemoRequestType       as _CreditMemoRequestType       on $projection.CreditMemoRequestType = _CreditMemoRequestType.CreditMemoRequestType
  association [1..*] to I_CreditMemoReqPartner        as _Partner                     on $projection.CreditMemoRequest     = _Partner.CreditMemoRequest
  association [0..*] to I_CreditMemoReqPrcgElmnt      as _PricingElement              on $projection.CreditMemoRequest     = _PricingElement.CreditMemoRequest
  association [0..1] to I_CreditMemoReqApprovalReason as _CreditMemoReqApprovalReason on $projection.CreditMemoReqApprovalReason = _CreditMemoReqApprovalReason.CreditMemoReqApprovalReason
  
  
  


//Extensibility

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

{
    // Key

    key cast(SalesDocument as credit_memo_request preserving type ) as CreditMemoRequest,
   
    // Category

    @ObjectModel.foreignKey.association: '_CreditMemoRequestType'
    SalesDocumentType as CreditMemoRequestType,
    SalesDocumentProcessingType as CreditMemoRequestProcgType,
   
    // Admin

    CreatedByUser,
    LastChangedByUser,
    @Semantics.systemDate.createdAt: true
    CreationDate,
    CreationTime,
    @Semantics.systemDate.lastChangedAt: true
    LastChangeDate,
    @Semantics.systemDateTime.lastChangedAt: true
    LastChangeDateTime,
   
    // Organization

    @ObjectModel.foreignKey.association: '_SalesOrganization'
    SalesOrganization,
    @ObjectModel.foreignKey.association: '_DistributionChannel'
    DistributionChannel,
    @ObjectModel.foreignKey.association: '_OrganizationDivision'
    OrganizationDivision, 
    @ObjectModel.foreignKey.association: '_SalesGroup'
    SalesGroup, 
    @ObjectModel.foreignKey.association: '_SalesOffice'
    SalesOffice,
   
    // Sales

      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_Customer_VH',
                     element: 'Customer' }
        }]
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_SoldToParty'
    SoldToParty,    
    @ObjectModel.foreignKey.association: '_CustomerGroup'
    CustomerGroup,
    @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup1'
    AdditionalCustomerGroup1,
    @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup2'
    AdditionalCustomerGroup2,
    @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup3'
    AdditionalCustomerGroup3,
    @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup4'
    AdditionalCustomerGroup4,
    @ObjectModel.foreignKey.association: '_AdditionalCustomerGroup5'
    AdditionalCustomerGroup5,
      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CreditControlAreaStdVH',
                     element: 'CreditControlArea' }
        }]
      @ObjectModel.text.association: '_CreditControlAreaText'
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_CreditControlArea'
    CreditControlArea,
    SalesDocumentDate as CreditMemoRequestDate, 
    ServicesRenderedDate, 
    @ObjectModel.foreignKey.association: '_SDDocumentReason'
    SDDocumentReason,
    PurchaseOrderByCustomer,
    CustomerPurchaseOrderType,
    CustomerPurchaseOrderDate,
    CustomerPurchaseOrderSuplmnt,
    @ObjectModel.foreignKey.association: '_SalesDistrict'
    SalesDistrict,
    
    
    // Pricing

    @DefaultAggregation: #SUM
    @Semantics.amount.currencyCode: 'TransactionCurrency'
    TotalNetAmount,
    @Semantics.currencyCode: true
    @ObjectModel.foreignKey.association: '_TransactionCurrency'
    TransactionCurrency, 
    SDPricingProcedure,
    PricingDate,
    PriceDetnExchangeRate,
    SalesDocumentCondition as CreditMemoRequestCondition, 
    CustomerTaxClassification1,
    CustomerTaxClassification2,
    CustomerTaxClassification3,
    CustomerTaxClassification4,
    CustomerTaxClassification5,
    CustomerTaxClassification6,
    CustomerTaxClassification7,
    CustomerTaxClassification8,
    CustomerTaxClassification9,
    
    //Shipping

    @ObjectModel.foreignKey.association: '_IncotermsClassification'
    IncotermsClassification,
    IncotermsTransferLocation,
    IncotermsLocation1,
    IncotermsLocation2,
    @ObjectModel.foreignKey.association: '_IncotermsVersion'
    IncotermsVersion,
   
    //Approval Management

    @Analytics.internalName: #LOCAL
    @ObjectModel.foreignKey.association: '_CreditMemoReqApprovalReason'
    SalesDocApprovalReason                                    as  CreditMemoReqApprovalReason,
   
    // Billing

    BillingDocumentDate,
      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_BillingCompanyCode'
    BillingCompanyCode,
       
    @ObjectModel.foreignKey.association: '_HeaderBillingBlockReason'
    HeaderBillingBlockReason,
    
    // Payment

    @ObjectModel.foreignKey.association: '_CustomerPaymentTerms'
    CustomerPaymentTerms,
    PaymentMethod,
    
    //Accounting

    FiscalYear,
    FiscalPeriod,
    ExchangeRateDate,
    @ObjectModel.foreignKey.association: '_ExchangeRateType'
    ExchangeRateType,
      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BusinessAreaStdVH',
                     element: 'BusinessArea' }
        }]
      @ObjectModel.text.association: '_BusinessAreaText'
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_BusinessArea'
    BusinessArea,
    @ObjectModel.foreignKey.association: '_CustomerAccountAssgmtGroup'
    CustomerAccountAssignmentGroup,
      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BusinessAreaStdVH',
                     element: 'BusinessArea' }
        }]
      @ObjectModel.text.association: '_CostCenterBusinessAreaText'
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_CostCenterBusinessArea'
    CostCenterBusinessArea,
    CostCenter,
      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_ControllingAreaStdVH',
                     element: 'ControllingArea' }
        }]
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_ControllingArea'
    ControllingArea,
    OrderID,
      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_ControllingObjectStdVH',
                     element: 'ControllingObject' }
        }]
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_ControllingObject'
    ControllingObject,

    //Reference

    ReferenceSDDocument,
    @ObjectModel.foreignKey.association: '_ReferenceSDDocumentCategory'
    ReferenceSDDocumentCategory,

    //Status

    @ObjectModel.foreignKey.association: '_OverallSDProcessStatus'
    OverallSDProcessStatus,
    @ObjectModel.foreignKey.association: '_OverallSDDocumentRejectionSts'
    OverallSDDocumentRejectionSts,
    @ObjectModel.foreignKey.association: '_TotalBlockStatus'
    TotalBlockStatus,
    @ObjectModel.foreignKey.association: '_OverallOrdReltdBillgStatus'
    OverallOrdReltdBillgStatus,
    @ObjectModel.foreignKey.association: '_OverallBillingBlockStatus'
    OverallBillingBlockStatus,
    @ObjectModel.foreignKey.association: '_OverallTotalSDDocRefStatus'
    OverallTotalSDDocRefStatus,
    @ObjectModel.foreignKey.association: '_OverallSDDocReferenceStatus'
    OverallSDDocReferenceStatus,
    @ObjectModel.foreignKey.association: '_TotalCreditCheckStatus'
    TotalCreditCheckStatus,
    @ObjectModel.foreignKey.association: '_MaxDocValueCreditCheckStatus'
    MaxDocValueCreditCheckStatus,
    @ObjectModel.foreignKey.association: '_PaymentTermCreditCheckStatus'
    PaymentTermCreditCheckStatus,
    @ObjectModel.foreignKey.association: '_FinDocCreditCheckStatus'
    FinDocCreditCheckStatus,
    @ObjectModel.foreignKey.association: '_ExprtInsurCreditCheckStatus'
    ExprtInsurCreditCheckStatus,
    @ObjectModel.foreignKey.association: '_PaytAuthsnCreditCheckSts'
    PaytAuthsnCreditCheckSts,
    @ObjectModel.foreignKey.association: '_CentralCreditCheckStatus'
    CentralCreditCheckStatus,
    @ObjectModel.foreignKey.association: '_CentralCreditChkTechErrSts'
    CentralCreditChkTechErrSts,
    @ObjectModel.foreignKey.association: '_HdrGeneralIncompletionStatus'
    HdrGeneralIncompletionStatus,
    @ObjectModel.foreignKey.association: '_OverallPricingIncompletionSts'
    OverallPricingIncompletionSts,
    @ObjectModel.foreignKey.association: '_HeaderBillgIncompletionStatus'
    HeaderBillgIncompletionStatus,
    @ObjectModel.foreignKey.association: '_OvrlItmGeneralIncompletionSts'
    OvrlItmGeneralIncompletionSts,
    @ObjectModel.foreignKey.association: '_OvrlItmBillingIncompletionSts'
    OvrlItmBillingIncompletionSts,
    @Analytics.internalName: #LOCAL
    @ObjectModel.foreignKey.association: '_SalesDocApprovalStatus'
    SalesDocApprovalStatus,
    
    @Analytics.internalName: #LOCAL
    AccountingDocExternalReference,
    AssignmentReference,
  
    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
    _Item,
    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
    _Partner,
    _StandardPartner,
    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
    _PricingElement,
    _CreditMemoRequestType,
    _CreatedByUser,
    _LastChangedByUser,
    _SalesOrganization,
    _DistributionChannel,
    _OrganizationDivision,
    _SalesGroup,
    _SalesOffice,
    _SoldToParty,
    _CustomerGroup,
    _AdditionalCustomerGroup1,
    _AdditionalCustomerGroup2,
    _AdditionalCustomerGroup3,
    _AdditionalCustomerGroup4,
    _AdditionalCustomerGroup5,
    _CreditControlArea,
    _SDDocumentReason,
    _CustomerPurchaseOrderType,
    _SalesDistrict,   
    _TransactionCurrency,
    //Todo:SalesDocumentCondition,

    _IncotermsClassification,
    _IncotermsVersion,
    _CreditMemoReqApprovalReason,
    _BillingCompanyCode,  
    _CustomerPaymentTerms,
    _HeaderBillingBlockReason,
    //Todo: _PaymentMethod,

    _ExchangeRateType, 
    _BusinessArea,
    _CustomerAccountAssgmtGroup,
    _CostCenterBusinessArea,
    _CostCenter, 
    _ControllingArea,
    _ControllingObject,
    //Todo: ReferenceSDDocument,

    _ReferenceSDDocumentCategory,    
    _OverallSDProcessStatus,
    _OverallSDDocumentRejectionSts,
    _TotalBlockStatus,
    _OverallOrdReltdBillgStatus,
    _OverallBillingBlockStatus,
    _OverallTotalSDDocRefStatus,
    _OverallSDDocReferenceStatus,   
    _TotalCreditCheckStatus,
    _MaxDocValueCreditCheckStatus,
    _PaymentTermCreditCheckStatus,
    _FinDocCreditCheckStatus,
    _ExprtInsurCreditCheckStatus,
    _PaytAuthsnCreditCheckSts,
    _CentralCreditCheckStatus,
    _CentralCreditChkTechErrSts,   
    _HdrGeneralIncompletionStatus,
    _OverallPricingIncompletionSts,
    _HeaderBillgIncompletionStatus,
    _OvrlItmGeneralIncompletionSts,
    _OvrlItmBillingIncompletionSts,
    _SalesDocApprovalStatus,
       
      //--[ GENERATED:012:GlBfhyFV7jY4ibFExWVH{G

      @Consumption.hidden: true
      _BusinessAreaText,
      @Consumption.hidden: true
      _CostCenterBusinessAreaText,
      @Consumption.hidden: true
      _CreditControlAreaText
      // ]--GENERATED



}
where SDDocumentCategory = 'K';                                                                                                                             
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENT"
],
"ASSOCIATED":
[
"E_SALESDOCUMENTBASIC",
"I_ADDITIONALCUSTOMERGROUP1",
"I_ADDITIONALCUSTOMERGROUP2",
"I_ADDITIONALCUSTOMERGROUP3",
"I_ADDITIONALCUSTOMERGROUP4",
"I_ADDITIONALCUSTOMERGROUP5",
"I_BILLINGBLOCKREASON",
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_CENTRALCREDITCHECKSTATUS",
"I_CENTRALCREDITCHKTECHERRSTS",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECT",
"I_COSTCENTER",
"I_CREDITCONTROLAREA",
"I_CREDITCONTROLAREATEXT",
"I_CREDITMEMOREQAPPROVALREASON",
"I_CREDITMEMOREQPARTNER",
"I_CREDITMEMOREQPRCGELMNT",
"I_CREDITMEMOREQUESTITEM",
"I_CREDITMEMOREQUESTTYPE",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERACCOUNTASSGMTGROUP",
"I_CUSTOMERGROUP",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPURCHASEORDERTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_EXCHANGERATETYPE",
"I_EXPRTINSURCREDITCHECKSTATUS",
"I_FINDOCCREDITCHECKSTATUS",
"I_HDRBILLGINCOMPLETIONSTATUS",
"I_HDRGENINCOMPLETIONSTATUS",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_MAXDOCVALUECREDITCHECKSTS",
"I_OVERALLBILLINGBLOCKSTATUS",
"I_OVERALLORDRELTDBILLGSTATUS",
"I_OVERALLPRCINCOMPLETIONSTS",
"I_OVERALLSDDOCREFERENCESTATUS",
"I_OVERALLSDDOCUMENTRJCNSTATUS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVERALLTOTALSDDOCREFSTATUS",
"I_OVRLITMBILLGINCOMPLTNSTS",
"I_OVRLITMGENINCOMPLETIONSTS",
"I_PAYMENTTERMCREDITCHECKSTS",
"I_PAYTAUTHSNCREDITCHECKSTS",
"I_SALESDISTRICT",
"I_SALESDOCAPPROVALSTATUS",
"I_SALESDOCUMENTSTANDARDPARTNER",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTREASON",
"I_TOTALBLOCKSTATUS",
"I_TOTALCREDITCHECKSTATUS",
"I_USER"
],
"BASE":
[
"I_SALESDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/