CUSTOMERRETURNITEM

86 Fields

CUSTOMERRETURNITEM is an SAP database table in S/4HANA. It contains 86 fields.

Fields (86)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 1
KEY CustomerReturnItem CustomerReturnItem 1
_ProductGroup _ProductGroup 1
_SalesDocumentRjcnReason _SalesDocumentRjcnReason 1
_SDPricingProcedure _SDPricingProcedure 1
Batch Batch 2
CRMLogicalSystem CRMLogicalSystem 1
CRMObjectID CRMObjectID 1
CRMObjectType CRMObjectType 1
CRMObjectUUID CRMObjectUUID 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerRetMatlInspResultCode CustomerRetMatlInspResultCode 1
CustomerReturnItemCategory CustomerReturnItemCategory 2
CustomerReturnItemText CustomerReturnItemText 2
CustomerReturnType CustomerReturnType 2
CustRetItmCustomerText CustRetItmCustomerText 1
CustRetItmFollowUpActivity CustRetItmFollowUpActivity 2
CustRetItmInspectionText CustRetItmInspectionText 2
CustRetMatlAuthzn CustRetMatlAuthzn 2
CustRetReleaseStatus CustRetReleaseStatus 1
DeliveryPriority DeliveryPriority 1
DistributionChannel DistributionChannel 2
HigherLevelItem HigherLevelItem 2
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
ItemBillingBlockReason ItemBillingBlockReason 1
ItemGrossWeight ItemGrossWeight 1
ItemNetWeight ItemNetWeight 2
ItemVolume ItemVolume 1
ItemVolumeUnit ItemVolumeUnit 1
ItemWeightUnit ItemWeightUnit 2
MaterialByCustomer MaterialByCustomer 2
NetAmount NetAmount 2
NextFllwUpActivityForMatlInsp NextFllwUpActivityForMatlInsp 1
NextPlantForFollowUpActivity NextPlantForFollowUpActivity 1
OrganizationDivision OrganizationDivision 2
PrelimRefundIsDetermined PrelimRefundIsDetermined 1
PricingDate PricingDate 1
Product Product 2
ProductGroup ProductGroup 2
ProductionPlant ProductionPlant 1
ProductIsInspectedAtCustSite ProductIsInspectedAtCustSite 1
ProfitCenter ProfitCenter 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 2
ReferenceSDDocument ReferenceSDDocument 1
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 1
ReferenceSDDocumentItem ReferenceSDDocumentItem 1
ReplacementMaterial ReplacementMaterial 2
ReplacementMaterialIsRequested ReplacementMaterialIsRequested 1
ReplacementMaterialQtyUnit ReplacementMaterialQtyUnit 2
ReplacementMaterialQuantity ReplacementMaterialQuantity 2
ReplacementMatlSupplyingPlant ReplacementMatlSupplyingPlant 1
RequestedQuantity RequestedQuantity 2
RequestedQuantityUnit RequestedQuantityUnit 2
RetMatlInspResultCode RetMatlInspResultCode 2
RetsMgmtItmCompnProcgStatus RetsMgmtItmCompnProcgStatus 2
RetsMgmtItmLogProcgStatus RetsMgmtItmLogProcgStatus 2
RetsMgmtItmProcgStatus RetsMgmtItmProcgStatus 2
RetsMgmtProcess RetsMgmtProcess 1
RetsMgmtProcessingBlock RetsMgmtProcessingBlock 2
RetsMgmtProcessItem RetsMgmtProcessItem 1
RetsProdValnIsSuspended RetsProdValnIsSuspended 1
ReturnReason ReturnReason 2
ReturnsDocumentApprovalStatus ReturnsDocumentApprovalStatus 1
ReturnsDocumentStatus ReturnsDocumentStatus 1
ReturnsMaterialHasBeenReceived ReturnsMaterialHasBeenReceived 1
ReturnsRefundExtent ReturnsRefundExtent 2
ReturnsRefundProcgMode ReturnsRefundProcgMode 2
ReturnsRefundRjcnReason ReturnsRefundRjcnReason 1
ReturnsRefundType ReturnsRefundType 2
ReturnsTransshipmentPlant ReturnsTransshipmentPlant 1
SalesDocumentRjcnReason SalesDocumentRjcnReason 2
SalesOrganization SalesOrganization 2
SDDocumentRejectionStatus SDDocumentRejectionStatus 2
SDPricingProcedure SDPricingProcedure 1
SDProcessStatus SDProcessStatus 1
ShippingPoint ShippingPoint 1
StorageLocation StorageLocation 2
SuplrRetMatlAuthznIsRequired SuplrRetMatlAuthznIsRequired 1
Supplier Supplier 2
SupplierName SupplierName 1
SupplierRetMatlAuthzn SupplierRetMatlAuthzn 1
TaxAmount TaxAmount 1
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 CUSTOMERRETURNITEM (
    CUSTOMERRETURN,
    CUSTOMERRETURNITEM,
    _PRODUCTGROUP,
    _SALESDOCUMENTRJCNREASON,
    _SDPRICINGPROCEDURE,
    BATCH,
    CRMLOGICALSYSTEM,
    CRMOBJECTID,
    CRMOBJECTTYPE,
    CRMOBJECTUUID,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERRETMATLINSPRESULTCODE,
    CUSTOMERRETURNITEMCATEGORY,
    CUSTOMERRETURNITEMTEXT,
    CUSTOMERRETURNTYPE,
    CUSTRETITMCUSTOMERTEXT,
    CUSTRETITMFOLLOWUPACTIVITY,
    CUSTRETITMINSPECTIONTEXT,
    CUSTRETMATLAUTHZN,
    CUSTRETRELEASESTATUS,
    DELIVERYPRIORITY,
    DISTRIBUTIONCHANNEL,
    HIGHERLEVELITEM,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    ITEMBILLINGBLOCKREASON,
    ITEMGROSSWEIGHT,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MATERIALBYCUSTOMER,
    NETAMOUNT,
    NEXTFLLWUPACTIVITYFORMATLINSP,
    NEXTPLANTFORFOLLOWUPACTIVITY,
    ORGANIZATIONDIVISION,
    PRELIMREFUNDISDETERMINED,
    PRICINGDATE,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTIONPLANT,
    PRODUCTISINSPECTEDATCUSTSITE,
    PROFITCENTER,
    PURCHASEORDERBYCUSTOMER,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    REFERENCESDDOCUMENTITEM,
    REPLACEMENTMATERIAL,
    REPLACEMENTMATERIALISREQUESTED,
    REPLACEMENTMATERIALQTYUNIT,
    REPLACEMENTMATERIALQUANTITY,
    REPLACEMENTMATLSUPPLYINGPLANT,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    RETMATLINSPRESULTCODE,
    RETSMGMTITMCOMPNPROCGSTATUS,
    RETSMGMTITMLOGPROCGSTATUS,
    RETSMGMTITMPROCGSTATUS,
    RETSMGMTPROCESS,
    RETSMGMTPROCESSINGBLOCK,
    RETSMGMTPROCESSITEM,
    RETSPRODVALNISSUSPENDED,
    RETURNREASON,
    RETURNSDOCUMENTAPPROVALSTATUS,
    RETURNSDOCUMENTSTATUS,
    RETURNSMATERIALHASBEENRECEIVED,
    RETURNSREFUNDEXTENT,
    RETURNSREFUNDPROCGMODE,
    RETURNSREFUNDRJCNREASON,
    RETURNSREFUNDTYPE,
    RETURNSTRANSSHIPMENTPLANT,
    SALESDOCUMENTRJCNREASON,
    SALESORGANIZATION,
    SDDOCUMENTREJECTIONSTATUS,
    SDPRICINGPROCEDURE,
    SDPROCESSSTATUS,
    SHIPPINGPOINT,
    STORAGELOCATION,
    SUPLRRETMATLAUTHZNISREQUIRED,
    SUPPLIER,
    SUPPLIERNAME,
    SUPPLIERRETMATLAUTHZN,
    TAXAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CUSTOMERRETURN, CUSTOMERRETURNITEM)
);

Learn More