_CUSTOMERRETURN
_CUSTOMERRETURN is an SAP database table in S/4HANA. It contains 43 fields.
Fields (43)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA