I_DEBITMEMOREQUEST

CDS View

Debit Memo Request

I_DEBITMEMOREQUEST is a CDS View in S/4HANA. Debit Memo Request. It contains 61 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
A_DebitMemoReqCreditSimulation view_entity from COMPOSITE Debit Memo Request Credit Simulation
A_DebitMemoRequest view from COMPOSITE Debit Memo Request Header
A_DebitMemoRequestSimulation view_entity from COMPOSITE Debit Memo Request Simulation
C_BillingDueListItem_F0798 view left_outer CONSUMPTION Billing Due List Item
C_BSOrdProcFlwDebitMemoReq view from CONSUMPTION DebitMemoReq Attrib for BSOrd Prgrs
C_Customer360DebitMemoRequest view_entity from CONSUMPTION Customer 360 DMR
C_Debitmemorequestfs view from CONSUMPTION Debit Memo Request
C_DebitMemoRequestWl_F1988 view from CONSUMPTION Debit Memo Requests
C_DebitMemoReqWorkflowInbox view from CONSUMPTION Debit Memo Request Workflow Inbox
C_InhRepairItmProcFlwDbtMmReq view from CONSUMPTION Process Flow Node for Debit Memo Request
C_PrelimBillingDueListItem view left_outer CONSUMPTION Billing Due List Items
ESH_N_DEBITMEMOREQUEST view from
I_DebitMemoRequestStdVH view from COMPOSITE Debit Memo Request
R_DebitMemoRequestTP view_entity from TRANSACTIONAL Debit Memo Request - TP

Fields (61)

KeyField CDS FieldsUsed in Views
KEY DebitMemoRequest DebitMemoRequest 6
_HeaderBillingBlockReason _HeaderBillingBlockReason 1
_OrganizationDivision _OrganizationDivision 1
_OverallBillingBlockStatus _OverallBillingBlockStatus 1
_OverallOrdReltdBillgStatus _OverallOrdReltdBillgStatus 1
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_SalesOrganization _SalesOrganization 1
_SDDocumentReason _SDDocumentReason 1
_SoldToParty _SoldToParty 1
_TransactionCurrency _TransactionCurrency 1
BillingDocumentDate BillingDocumentDate 3
CreatedByUser CreatedByUser 3
CreationDate CreationDate 2
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 1
CustomerPurchaseOrderType CustomerPurchaseOrderType 1
CustomerTaxClassification1 CustomerTaxClassification1 1
CustomerTaxClassification2 CustomerTaxClassification2 1
CustomerTaxClassification3 CustomerTaxClassification3 1
CustomerTaxClassification4 CustomerTaxClassification4 1
CustomerTaxClassification5 CustomerTaxClassification5 1
CustomerTaxClassification6 CustomerTaxClassification6 1
CustomerTaxClassification7 CustomerTaxClassification7 1
CustomerTaxClassification8 CustomerTaxClassification8 1
CustomerTaxClassification9 CustomerTaxClassification9 1
DebitMemoReqApprovalReason DebitMemoReqApprovalReason 1
DebitMemoRequestDate DebitMemoRequestDate 3
DebitMemoRequestProcessingType DebitMemoRequestProcessingType 2
DebitMemoRequestType DebitMemoRequestType 5
DistributionChannel DistributionChannel 5
HeaderBillingBlockReason HeaderBillingBlockReason 3
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
LastChangeDate LastChangeDate 2
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 3
OrganizationDivision OrganizationDivision 5
OverallBillingBlockStatus OverallBillingBlockStatus 2
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 2
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts 2
OverallSDProcessStatus OverallSDProcessStatus 2
PaymentMethod PaymentMethod 1
PricingDate PricingDate 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 4
ReferenceSDDocument ReferenceSDDocument 3
SalesDistrict SalesDistrict 1
SalesDocApprovalStatus SalesDocApprovalStatus 2
SalesGroup SalesGroup 3
SalesOffice SalesOffice 3
SalesOrganization SalesOrganization 5
SDDocumentReason SDDocumentReason 4
SDPricingProcedure SDPricingProcedure 1
ServicesRenderedDate ServicesRenderedDate 1
SoldToParty SoldToParty 4
TotalCreditCheckStatus TotalCreditCheckStatus 2
TotalNetAmount TotalNetAmount 4
TransactionCurrency TransactionCurrency 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Debit Memo Request
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEBITMEMOREQUEST (
    DEBITMEMOREQUEST,
    _HEADERBILLINGBLOCKREASON,
    _ORGANIZATIONDIVISION,
    _OVERALLBILLINGBLOCKSTATUS,
    _OVERALLORDRELTDBILLGSTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _SALESORGANIZATION,
    _SDDOCUMENTREASON,
    _SOLDTOPARTY,
    _TRANSACTIONCURRENCY,
    BILLINGDOCUMENTDATE,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERPURCHASEORDERTYPE,
    CUSTOMERTAXCLASSIFICATION1,
    CUSTOMERTAXCLASSIFICATION2,
    CUSTOMERTAXCLASSIFICATION3,
    CUSTOMERTAXCLASSIFICATION4,
    CUSTOMERTAXCLASSIFICATION5,
    CUSTOMERTAXCLASSIFICATION6,
    CUSTOMERTAXCLASSIFICATION7,
    CUSTOMERTAXCLASSIFICATION8,
    CUSTOMERTAXCLASSIFICATION9,
    DEBITMEMOREQAPPROVALREASON,
    DEBITMEMOREQUESTDATE,
    DEBITMEMOREQUESTPROCESSINGTYPE,
    DEBITMEMOREQUESTTYPE,
    DISTRIBUTIONCHANNEL,
    HEADERBILLINGBLOCKREASON,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    ORGANIZATIONDIVISION,
    OVERALLBILLINGBLOCKSTATUS,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    PAYMENTMETHOD,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    REFERENCESDDOCUMENT,
    SALESDISTRICT,
    SALESDOCAPPROVALSTATUS,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    SDPRICINGPROCEDURE,
    SERVICESRENDEREDDATE,
    SOLDTOPARTY,
    TOTALCREDITCHECKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (DEBITMEMOREQUEST)
);