CUSTOMERRETURNITEM

95 Fields

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

Fields (95)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 2
KEY CustomerReturnItem CustomerReturnItem 2
_ProductGroup _ProductGroup 1
_SalesDocumentRjcnReason _SalesDocumentRjcnReason 1
_SDPricingProcedure _SDPricingProcedure 1
Batch Batch 3
CRMLogicalSystem CRMLogicalSystem 1
CRMObjectID CRMObjectID 1
CRMObjectType CRMObjectType 1
CRMObjectUUID CRMObjectUUID 1
CustomerPaymentTerms CustomerPaymentTerms 2
CustomerRetMatlInspResultCode CustomerRetMatlInspResultCode 1
CustomerReturnItemCategory CustomerReturnItemCategory 3
CustomerReturnItemText CustomerReturnItemText 3
CustomerReturnType CustomerReturnType 3
CustRetItmCustomerText CustRetItmCustomerText 1
CustRetItmFollowUpActivity CustRetItmFollowUpActivity 3
CustRetItmInspectionText CustRetItmInspectionText 2
CustRetMatlAuthzn CustRetMatlAuthzn 3
CustRetReleaseStatus CustRetReleaseStatus 1
DeliveryPriority DeliveryPriority 2
DistributionChannel DistributionChannel 3
HigherLevelItem HigherLevelItem 3
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 1
ItemBillingBlockReason ItemBillingBlockReason 2
ItemGrossWeight ItemGrossWeight 2
ItemNetWeight ItemNetWeight 3
ItemVolume ItemVolume 2
ItemVolumeUnit ItemVolumeSAPUnit,ItemVolumeUnit 2
ItemWeightUnit ItemWeightSAPUnit,ItemWeightUnit 3
MaterialByCustomer MaterialByCustomer 3
NetAmount NetAmount 3
NextFllwUpActivityForMatlInsp NextFllwUpActivityForMatlInsp 2
NextPlantForFollowUpActivity NextPlantForFollowUpActivity 1
OrganizationDivision OrganizationDivision 3
PrelimRefundIsDetermined PrelimRefundIsDetermined 2
PricingDate PricingDate 2
Product Product 3
ProductGroup ProductGroup 3
ProductionPlant ProductionPlant 2
ProductionVersion ProductionVersion 1
ProductIsInspectedAtCustSite ProductIsInspectedAtCustSite 2
ProfitCenter ProfitCenter 2
PurchaseOrderByCustomer PurchaseOrderByCustomer 3
ReferenceSDDocument ReferenceSDDocument 1
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 1
ReferenceSDDocumentItem ReferenceSDDocumentItem 1
ReplacementMaterial ReplacementMaterial,ReplacementProduct 3
ReplacementMaterialIsRequested ReplacementMaterialIsRequested,RplcmtProdFrmSuplrIsReqd 2
ReplacementMaterialQtyUnit ReplacementMaterialQtyUnit,RplcmtProdQtySAPUnit 3
ReplacementMaterialQuantity ReplacementMaterialQuantity,ReplacementProductQuantity 3
ReplacementMatlSupplyingPlant ReplacementMatlSupplyingPlant,RplcmtProdSupplyingPlant 2
RequestedQuantity RequestedQuantity 3
RequestedQuantityUnit RequestedQuantitySAPUnit,RequestedQuantityUnit 3
RetMatlInspResultCode RetMatlInspResultCode,ReturnsInspectionCode 3
RetsMgmtItmCompnProcgStatus RetsMgmtItmCompnProcgStatus 3
RetsMgmtItmLogProcgStatus RetsMgmtItmLogProcgStatus 3
RetsMgmtItmProcgStatus RetsMgmtItmProcgStatus 3
RetsMgmtProcess RetsMgmtProcess 2
RetsMgmtProcessingBlock RetsMgmtProcessingBlock 3
RetsMgmtProcessItem RetsMgmtProcessItem 2
RetsProdValnIsSuspended RetsProdValnIsSuspended 2
ReturnReason ReturnReason 3
ReturnsDocumentApprovalStatus ReturnsDocumentApprovalStatus 1
ReturnsDocumentStatus ReturnsDocumentStatus 1
ReturnsMaterialHasBeenReceived ReturnsMaterialHasBeenReceived,ReturnsProductHasBeenReceived 2
ReturnsRefundExtent ReturnsRefundCode,ReturnsRefundExtent 3
ReturnsRefundProcgMode ReturnsRefundProcgMode 3
ReturnsRefundRjcnReason ReturnsRefundRjcnReason 2
ReturnsRefundType ReturnsRefundType 3
ReturnsTransshipmentPlant ReturnsTransshipmentPlant 1
SalesDocumentRjcnReason SalesDocumentRjcnReason 3
SalesOrganization SalesOrganization 3
SDDocumentRejectionStatus SDDocumentRejectionStatus 3
SDPricingProcedure SDPricingProcedure 1
SDProcessStatus SDProcessStatus 2
ShippingPoint ShippingPoint 2
ShippingType ShippingType 1
StorageLocation StorageLocation 3
Subtotal1Amount Subtotal1Amount 1
Subtotal2Amount Subtotal2Amount 1
Subtotal3Amount Subtotal3Amount 1
Subtotal4Amount Subtotal4Amount 1
Subtotal5Amount Subtotal5Amount 1
Subtotal6Amount Subtotal6Amount 1
SuplrRetMatlAuthznIsRequired SuplrRetMatlAuthznIsRequired 2
Supplier Supplier 3
SupplierName SupplierName 1
SupplierRetMatlAuthzn SupplierRetMatlAuthzn 2
TaxAmount TaxAmount 2
TransactionCurrency TransactionCurrency 3
WBSElementExternalID WBSElementExternalID 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 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,
    PRODUCTIONVERSION,
    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,
    SHIPPINGTYPE,
    STORAGELOCATION,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    SUPLRRETMATLAUTHZNISREQUIRED,
    SUPPLIER,
    SUPPLIERNAME,
    SUPPLIERRETMATLAUTHZN,
    TAXAMOUNT,
    TRANSACTIONCURRENCY,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (CUSTOMERRETURN, CUSTOMERRETURNITEM)
);

Learn More