DEBITMEMOREQUEST

50 Fields

DEBITMEMOREQUEST is an SAP database table in S/4HANA. It contains 50 fields.

Fields (50)

KeyField CDS FieldsUsed in Views
KEY DebitMemoRequest DebitMemoRequest 2
BillingCompanyCode BillingCompanyCode 1
BillingDocumentDate BillingDocumentDate 1
ControllingArea ControllingArea 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
CustomerGroup CustomerGroup 1
CustomerName CustomerName 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 1
CustomerPurchaseOrderType CustomerPurchaseOrderType 1
DebitMemoReqApprovalReason DebitMemoReqApprovalReason 1
DebitMemoRequestDate DebitMemoRequestDate 2
DebitMemoRequestType DebitMemoRequestType 2
DistributionChannel DistributionChannel 2
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus 1
HeaderBillingBlockReason HeaderBillingBlockReason 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsVersion IncotermsVersion 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
OrganizationDivision OrganizationDivision 2
OverallBillingBlockStatus OverallBillingBlockStatus 1
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 1
OverallSDDocReferenceStatus OverallSDDocReferenceStatus 1
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts 1
OverallSDProcessStatus OverallSDProcessStatus 1
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts 1
PaymentMethod PaymentMethod 1
PricingDate PricingDate 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
ReferenceDistributionChannel ReferenceDistributionChannel 1
ReferenceSDDocument ReferenceSDDocument 1
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 1
SalesDistrict SalesDistrict 1
SalesDocApprovalStatus SalesDocApprovalStatus 1
SalesDocumentCreationDateTime SalesDocumentCreationDateTime 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrganization SalesOrganization 2
SDDocumentReason SDDocumentReason 2
SDPricingProcedure SDPricingProcedure 1
ServicesRenderedDate ServicesRenderedDate 1
SoldToParty SoldToParty 2
TotalBlockStatus TotalBlockStatus 1
TotalNetAmount TotalNetAmount 2
TransactionCurrency TransactionCurrency 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DEBITMEMOREQUEST (
    DEBITMEMOREQUEST,
    BILLINGCOMPANYCODE,
    BILLINGDOCUMENTDATE,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERGROUP,
    CUSTOMERNAME,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERPURCHASEORDERTYPE,
    DEBITMEMOREQAPPROVALREASON,
    DEBITMEMOREQUESTDATE,
    DEBITMEMOREQUESTTYPE,
    DISTRIBUTIONCHANNEL,
    HDRGENERALINCOMPLETIONSTATUS,
    HEADERBILLINGBLOCKREASON,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    ORGANIZATIONDIVISION,
    OVERALLBILLINGBLOCKSTATUS,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLSDDOCREFERENCESTATUS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVRLITMGENERALINCOMPLETIONSTS,
    PAYMENTMETHOD,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    REFERENCEDISTRIBUTIONCHANNEL,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    SALESDISTRICT,
    SALESDOCAPPROVALSTATUS,
    SALESDOCUMENTCREATIONDATETIME,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    SDPRICINGPROCEDURE,
    SERVICESRENDEREDDATE,
    SOLDTOPARTY,
    TOTALBLOCKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (DEBITMEMOREQUEST)
);

Learn More