I_CREDITMEMOREQUEST
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/