_CUSTOMERRETURN

_CUSTOMERRETURN is an SAP database table in S/4HANA. It contains 43 fields.

Fields (43)

KeyField CDS FieldsUsed in Views
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1 1
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2 1
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3 1
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4 1
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5 1
_BillingCompanyCode _BillingCompanyCode 1
_CreditControlArea _CreditControlArea 1
_CustomerGroup _CustomerGroup 1
_HdrGeneralIncompletionStatus _HdrGeneralIncompletionStatus 1
_HeaderBillingBlockReason _HeaderBillingBlockReason 1
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 1
_SalesDocApprovalStatus _SalesDocApprovalStatus 1
_SDPricingProcedure _SDPricingProcedure 1
_ShippingCondition _ShippingCondition 1
AdditionalCustomerGroup1 AdditionalCustomerGroup1 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 1
AdditionalCustomerGroup3 AdditionalCustomerGroup3 1
AdditionalCustomerGroup4 AdditionalCustomerGroup4 1
AdditionalCustomerGroup5 AdditionalCustomerGroup5 1
BillingCompanyCode BillingCompanyCode 1
BillingDocumentDate BillingDocumentDate 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreditControlArea CreditControlArea 1
CustomerGroup CustomerGroup 1
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 1
CustomerReturnType CustomerReturnType 19
DistributionChannel DistributionChannel 17
LastChangeDateTime LastChangeDateTime 3
OrderID OrderID 1
OrganizationDivision OrganizationDivision 17
OverallSDProcessStatus OverallSDProcessStatus 1
OverallTotalDeliveryStatus OverallTotalDeliveryStatus 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
SalesDocApprovalStatus SalesDocApprovalStatus 1
SalesDocumentDate CustomerReturnDate 1
SalesDocumentType SalesDocumentType 1
SalesOrganization SalesOrganization 17
SDPricingProcedure SDPricingProcedure 1
ShippingCondition ShippingCondition 1
TotalBlockStatus TotalBlockStatus 1
TransactionCurrency TransactionCurrency 1

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 _CUSTOMERRETURN (
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _BILLINGCOMPANYCODE,
    _CREDITCONTROLAREA,
    _CUSTOMERGROUP,
    _HDRGENERALINCOMPLETIONSTATUS,
    _HEADERBILLINGBLOCKREASON,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _SALESDOCAPPROVALSTATUS,
    _SDPRICINGPROCEDURE,
    _SHIPPINGCONDITION,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    BILLINGCOMPANYCODE,
    BILLINGDOCUMENTDATE,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREDITCONTROLAREA,
    CUSTOMERGROUP,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERRETURNTYPE,
    DISTRIBUTIONCHANNEL,
    LASTCHANGEDATETIME,
    ORDERID,
    ORGANIZATIONDIVISION,
    OVERALLSDPROCESSSTATUS,
    OVERALLTOTALDELIVERYSTATUS,
    PURCHASEORDERBYCUSTOMER,
    SALESDOCAPPROVALSTATUS,
    SALESDOCUMENTDATE,
    SALESDOCUMENTTYPE,
    SALESORGANIZATION,
    SDPRICINGPROCEDURE,
    SHIPPINGCONDITION,
    TOTALBLOCKSTATUS,
    TRANSACTIONCURRENCY
);