CREDITMEMOREQUEST

82 Fields

CREDITMEMOREQUEST is an SAP database table in S/4HANA. It contains 82 fields.

Fields (82)

KeyField CDS FieldsUsed in Views
KEY CreditMemoRequest CreditMemoRequest 4
_ControllingArea _ControllingArea 1
_CreatedByUser _CreatedByUser 1
_CreditMemoRequestType _CreditMemoRequestType 1
_DistributionChannel _DistributionChannel 1
_HdrGeneralIncompletionStatus _HdrGeneralIncompletionStatus 1
_HeaderBillingBlockReason _HeaderBillingBlockReason 1
_LastChangedByUser _LastChangedByUser 1
_OrganizationDivision _OrganizationDivision 1
_OverallBillingBlockStatus _OverallBillingBlockStatus 1
_OverallOrdReltdBillgStatus _OverallOrdReltdBillgStatus 1
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts 1
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory 1
_SalesDistrict _SalesDistrict 1
_SalesDocApprovalStatus _SalesDocApprovalStatus 1
_SalesGroup _SalesGroup 1
_SalesOffice _SalesOffice 1
_SDDocumentReason _SDDocumentReason 1
_SDPricingProcedure _SDPricingProcedure 1
_TransactionCurrency _TransactionCurrency 1
AccountingDocExternalReference AccountingDocExternalReference 1
AssignmentReference AssignmentReference 1
BillingCompanyCode BillingCompanyCode 2
BillingDocumentDate BillingDocumentDate 3
ControllingArea ControllingArea 2
CorrespncExternalReference CorrespncExternalReference 1
CorrespncExtRefByShipToParty CorrespncExtRefByShipToParty 1
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
CreationTime CreationTime 3
CreditMemoReqApprovalReason CreditMemoReqApprovalReason 2
CreditMemoRequestDate CreditMemoRequestDate 4
CreditMemoRequestType CreditMemoRequestType 2
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 1
CustomerGroup CustomerGroup 1
CustomerName CustomerName,SoldToPartyName 2
CustomerPaymentTerms CustomerPaymentTerms 2
CustomerPriceGroup CustomerPriceGroup 1
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 3
CustomerPurchaseOrderType CustomerPurchaseOrderType 3
CustPurOrdTypeByShipToParty CustPurOrdTypeByShipToParty 1
DistributionChannel DistributionChannel 4
HdrGeneralIncompletionStatus HdrGeneralIncompletionStatus 2
HeaderBillingBlockReason HeaderBillingBlockReason 3
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsVersion IncotermsVersion 2
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 3
OrganizationDivision OrganizationDivision 4
OutputRequestUUID OutputRequestUUID 1
OverallBillingBlockStatus OverallBillingBlockStatus 3
OverallOrdReltdBillgStatus OverallOrdReltdBillgStatus 2
OverallSDDocReferenceStatus OverallSDDocReferenceStatus 1
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts 3
OverallSDProcessStatus OverallSDProcessStatus 3
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts 2
PaymentMethod PaymentMethod 2
PriceListType PriceListType 1
PricingDate PricingDate 3
PurchaseOrderByCustomer PurchaseOrderByCustomer 3
PurchaseOrderByShipToParty PurchaseOrderByShipToParty 1
ReferenceDistributionChannel ReferenceDistributionChannel 2
ReferenceSDDocument ReferenceSDDocument 3
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 3
SalesDistrict SalesDistrict 3
SalesDocApprovalStatus SalesDocApprovalStatus 3
SalesDocumentCreationDateTime SalesDocumentCreationDateTime 2
SalesGroup SalesGroup 3
SalesOffice SalesOffice 3
SalesOrganization SalesOrganization,SalesOrganizationForFilter 4
SDDocumentReason SDDocumentReason,SDDocumentReasonForFilter 4
SDPricingProcedure SDPricingProcedure 3
ServicesRenderedDate ServicesRenderedDate 3
SoldToParty SoldToParty 4
TotalBlockStatus TotalBlockStatus 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CREDITMEMOREQUEST (
    CREDITMEMOREQUEST,
    _CONTROLLINGAREA,
    _CREATEDBYUSER,
    _CREDITMEMOREQUESTTYPE,
    _DISTRIBUTIONCHANNEL,
    _HDRGENERALINCOMPLETIONSTATUS,
    _HEADERBILLINGBLOCKREASON,
    _LASTCHANGEDBYUSER,
    _ORGANIZATIONDIVISION,
    _OVERALLBILLINGBLOCKSTATUS,
    _OVERALLORDRELTDBILLGSTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _REFERENCESDDOCUMENTCATEGORY,
    _SALESDISTRICT,
    _SALESDOCAPPROVALSTATUS,
    _SALESGROUP,
    _SALESOFFICE,
    _SDDOCUMENTREASON,
    _SDPRICINGPROCEDURE,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCEXTERNALREFERENCE,
    ASSIGNMENTREFERENCE,
    BILLINGCOMPANYCODE,
    BILLINGDOCUMENTDATE,
    CONTROLLINGAREA,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCEXTREFBYSHIPTOPARTY,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CREDITMEMOREQAPPROVALREASON,
    CREDITMEMOREQUESTDATE,
    CREDITMEMOREQUESTTYPE,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERGROUP,
    CUSTOMERNAME,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERPURCHASEORDERTYPE,
    CUSTPURORDTYPEBYSHIPTOPARTY,
    DISTRIBUTIONCHANNEL,
    HDRGENERALINCOMPLETIONSTATUS,
    HEADERBILLINGBLOCKREASON,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    ORGANIZATIONDIVISION,
    OUTPUTREQUESTUUID,
    OVERALLBILLINGBLOCKSTATUS,
    OVERALLORDRELTDBILLGSTATUS,
    OVERALLSDDOCREFERENCESTATUS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVRLITMGENERALINCOMPLETIONSTS,
    PAYMENTMETHOD,
    PRICELISTTYPE,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    REFERENCEDISTRIBUTIONCHANNEL,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    SALESDISTRICT,
    SALESDOCAPPROVALSTATUS,
    SALESDOCUMENTCREATIONDATETIME,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SDDOCUMENTREASON,
    SDPRICINGPROCEDURE,
    SERVICESRENDEREDDATE,
    SOLDTOPARTY,
    TOTALBLOCKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CREDITMEMOREQUEST)
);

Learn More