CUSTOMERRETURNITEM

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

Fields (128)

KeyField CDS FieldsUsed in Views
KEY CustomerReturn CustomerReturn 3
KEY CustomerReturnItem CustomerReturnItem 3
_HigherLevelItem _HigherLevelItem 1
_MatlAccountAssignmentGroup _MatlAccountAssignmentGroup 1
_ProductGroup _ProductGroup 1
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory 1
_SalesDocumentRjcnReason _SalesDocumentRjcnReason 1
_SDPricingProcedure _SDPricingProcedure 1
Batch Batch 3
BillingDocumentDate BillingDocumentDate 1
BusinessArea BusinessArea 1
BusinessSolutionOrderItem BusinessSolutionOrderItem 1
BusSolnOrdItemBundleItem BusSolnOrdItemBundleItem 1
ControllingArea ControllingArea 1
CorrespncExternalReference CorrespncExternalReference 1
CorrespncExtRefByShipToParty CorrespncExtRefByShipToParty 1
CRMLogicalSystem CRMLogicalSystem 1
CRMObjectID CRMObjectID 1
CRMObjectType CRMObjectType 1
CRMObjectUUID CRMObjectUUID 1
CustomerGroup CustomerGroup 1
CustomerPaymentTerms CustomerPaymentTerms 2
CustomerPriceGroup CustomerPriceGroup 1
CustomerPurchaseOrderType CustomerPurchaseOrderType 1
CustomerRetMatlInspResultCode CustomerRetMatlInspResultCode 1
CustomerReturnItemCategory CustomerReturnItemCategory 3
CustomerReturnItemText CustomerReturnItemText 3
CustomerReturnType CustomerReturnType 3
CustPurOrdTypeByShipToParty CustPurOrdTypeByShipToParty 1
CustRetItmCustomerText CustRetItmCustomerText 1
CustRetItmFollowUpActivity CustRetItmFollowUpActivity 3
CustRetItmInspectionText CustRetItmInspectionText 1
CustRetMatlAuthzn CustRetMatlAuthzn 3
CustRetReleaseStatus CustRetReleaseStatus 1
DeliveryPriority DeliveryPriority 2
DistributionChannel DistributionChannel 4
FixedValueDate FixedValueDate 1
HigherLevelItem HigherLevelItem 3
HigherLevelItemCategory HigherLevelItemCategory 1
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
InternationalArticleNumber InternationalArticleNumber 1
ItemBillingBlockReason ItemBillingBlockReason 2
ItemCategoryGroup ItemCategoryGroup 1
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus 1
ItemGrossWeight ItemGrossWeight 2
ItemNetWeight ItemNetWeight 3
ItemVolume ItemVolume 2
ItemVolumeUnit ItemVolumeSAPUnit,ItemVolumeUnit 2
ItemWeightUnit ItemWeightSAPUnit,ItemWeightUnit 3
MaterialByCustomer MaterialByCustomer 3
MaterialPricingGroup MaterialPricingGroup 1
MatlAccountAssignmentGroup MatlAccountAssignmentGroup 2
NetAmount NetAmount 3
NextFllwUpActivityForMatlInsp NextFllwUpActivityForMatlInsp 2
NextPlantForFollowUpActivity NextPlantForFollowUpActivity 1
OrganizationDivision OrganizationDivision 4
OriginallyRequestedMaterial OriginallyRequestedMaterial 1
Plant Plant 2
PrelimRefundIsDetermined PrelimRefundIsDetermined 2
PricingDate PricingDate 2
Product Product,ProductForFilter 3
ProductConfiguration ProductConfiguration 1
ProductGroup ProductGroup 3
ProductionPlant ProductionPlant 1
ProductIsInspectedAtCustSite ProductIsInspectedAtCustSite 2
ProfitCenter ProfitCenter 3
PurchaseOrderByCustomer PurchaseOrderByCustomer 3
PurchaseOrderByShipToParty PurchaseOrderByShipToParty 1
ReferenceSDDocument ReferenceSDDocument 3
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 3
ReferenceSDDocumentItem ReferenceSDDocumentItem 3
ReplacementMaterial ReplacementMaterial,ReplacementProduct 3
ReplacementMaterialIsRequested ReplacementMaterialIsRequested,RplcmtProdFrmSuplrIsReqd 2
ReplacementMaterialQtyUnit ReplacementMaterialQtyUnit,RplcmtProdQtySAPUnit 3
ReplacementMaterialQuantity ReplacementMaterialQuantity,ReplacementProductQuantity 3
ReplacementMatlSupplyingPlant ReplacementMatlSupplyingPlant,RplcmtProdSupplyingPlant 3
RequestedQuantity RequestedQuantity 3
RequestedQuantityUnit RequestedQuantitySAPUnit,RequestedQuantityUnit 3
RetMatlInspResultCode RetMatlInspResultCode,ReturnsInspectionCode 3
RetsInspIsCrtedAutomly RetsInspIsCrtedAutomly 1
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
SalesDocumentType SalesDocumentType 1
SalesOrganization SalesOrganization 4
SDDocumentItemUsage SDDocumentItemUsage 1
SDDocumentRejectionStatus SDDocumentRejectionStatus 3
SDPricingProcedure SDPricingProcedure 1
SDProcessStatus SDProcessStatus 2
ServicesRenderedDate ServicesRenderedDate 1
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
UnderlyingPurchaseOrderItem UnderlyingPurchaseOrderItem 1
UndrlgPurOrdItmByShipToParty UndrlgPurOrdItmByShipToParty 1
VarConfigurationBusObjectKey VarConfigurationBusObjectKey 1
VarConfigurationBusObjectType VarConfigurationBusObjectType 1
WBSElementExternalID WBSElementExternalID 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,
    _HIGHERLEVELITEM,
    _MATLACCOUNTASSIGNMENTGROUP,
    _PRODUCTGROUP,
    _REFERENCESDDOCUMENTCATEGORY,
    _SALESDOCUMENTRJCNREASON,
    _SDPRICINGPROCEDURE,
    BATCH,
    BILLINGDOCUMENTDATE,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDERITEM,
    BUSSOLNORDITEMBUNDLEITEM,
    CONTROLLINGAREA,
    CORRESPNCEXTERNALREFERENCE,
    CORRESPNCEXTREFBYSHIPTOPARTY,
    CRMLOGICALSYSTEM,
    CRMOBJECTID,
    CRMOBJECTTYPE,
    CRMOBJECTUUID,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERPURCHASEORDERTYPE,
    CUSTOMERRETMATLINSPRESULTCODE,
    CUSTOMERRETURNITEMCATEGORY,
    CUSTOMERRETURNITEMTEXT,
    CUSTOMERRETURNTYPE,
    CUSTPURORDTYPEBYSHIPTOPARTY,
    CUSTRETITMCUSTOMERTEXT,
    CUSTRETITMFOLLOWUPACTIVITY,
    CUSTRETITMINSPECTIONTEXT,
    CUSTRETMATLAUTHZN,
    CUSTRETRELEASESTATUS,
    DELIVERYPRIORITY,
    DISTRIBUTIONCHANNEL,
    FIXEDVALUEDATE,
    HIGHERLEVELITEM,
    HIGHERLEVELITEMCATEGORY,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INTERNATIONALARTICLENUMBER,
    ITEMBILLINGBLOCKREASON,
    ITEMCATEGORYGROUP,
    ITEMGENERALINCOMPLETIONSTATUS,
    ITEMGROSSWEIGHT,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MATERIALBYCUSTOMER,
    MATERIALPRICINGGROUP,
    MATLACCOUNTASSIGNMENTGROUP,
    NETAMOUNT,
    NEXTFLLWUPACTIVITYFORMATLINSP,
    NEXTPLANTFORFOLLOWUPACTIVITY,
    ORGANIZATIONDIVISION,
    ORIGINALLYREQUESTEDMATERIAL,
    PLANT,
    PRELIMREFUNDISDETERMINED,
    PRICINGDATE,
    PRODUCT,
    PRODUCTCONFIGURATION,
    PRODUCTGROUP,
    PRODUCTIONPLANT,
    PRODUCTISINSPECTEDATCUSTSITE,
    PROFITCENTER,
    PURCHASEORDERBYCUSTOMER,
    PURCHASEORDERBYSHIPTOPARTY,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    REFERENCESDDOCUMENTITEM,
    REPLACEMENTMATERIAL,
    REPLACEMENTMATERIALISREQUESTED,
    REPLACEMENTMATERIALQTYUNIT,
    REPLACEMENTMATERIALQUANTITY,
    REPLACEMENTMATLSUPPLYINGPLANT,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    RETMATLINSPRESULTCODE,
    RETSINSPISCRTEDAUTOMLY,
    RETSMGMTITMCOMPNPROCGSTATUS,
    RETSMGMTITMLOGPROCGSTATUS,
    RETSMGMTITMPROCGSTATUS,
    RETSMGMTPROCESS,
    RETSMGMTPROCESSINGBLOCK,
    RETSMGMTPROCESSITEM,
    RETSPRODVALNISSUSPENDED,
    RETURNREASON,
    RETURNSDOCUMENTAPPROVALSTATUS,
    RETURNSDOCUMENTSTATUS,
    RETURNSMATERIALHASBEENRECEIVED,
    RETURNSREFUNDEXTENT,
    RETURNSREFUNDPROCGMODE,
    RETURNSREFUNDRJCNREASON,
    RETURNSREFUNDTYPE,
    RETURNSTRANSSHIPMENTPLANT,
    SALESDOCUMENTRJCNREASON,
    SALESDOCUMENTTYPE,
    SALESORGANIZATION,
    SDDOCUMENTITEMUSAGE,
    SDDOCUMENTREJECTIONSTATUS,
    SDPRICINGPROCEDURE,
    SDPROCESSSTATUS,
    SERVICESRENDEREDDATE,
    SHIPPINGPOINT,
    SHIPPINGTYPE,
    STORAGELOCATION,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    SUPLRRETMATLAUTHZNISREQUIRED,
    SUPPLIER,
    SUPPLIERNAME,
    SUPPLIERRETMATLAUTHZN,
    TAXAMOUNT,
    TRANSACTIONCURRENCY,
    UNDERLYINGPURCHASEORDERITEM,
    UNDRLGPURORDITMBYSHIPTOPARTY,
    VARCONFIGURATIONBUSOBJECTKEY,
    VARCONFIGURATIONBUSOBJECTTYPE,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (CUSTOMERRETURN, CUSTOMERRETURNITEM)
);