R_CUSTOMERRETURNITEMTP
Returns Order Item - TP
R_CUSTOMERRETURNITEMTP is a CDS View in S/4HANA. Returns Order Item - TP. It contains 86 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_CustomerReturnItem_2 | view_entity | projection | CONSUMPTION | Returns Order Items |
| A_CustRetItemSimulation_2 | view_entity | from | CONSUMPTION | Returns Order Items |
| C_CustomerReturnItemManageTP | view_entity | projection | CONSUMPTION | Returns Order Item - Manage |
| I_CustomerReturnItemTP | view_entity | projection | TRANSACTIONAL | Returns Order Item - TP |
Fields (86)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CustomerReturn | CustomerReturn | 1 |
| KEY | CustomerReturnItem | CustomerReturnItem | 1 |
| Batch | Batch | 1 | |
| BillingDocumentDate | BillingDocumentDate | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CorrespncExternalReference | CorrespncExternalReference | 1 | |
| CorrespncExtRefByShipToParty | CorrespncExtRefByShipToParty | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 1 | |
| CustomerPriceGroup | CustomerPriceGroup | 1 | |
| CustomerPurchaseOrderType | CustomerPurchaseOrderType | 1 | |
| CustomerReturnItemCategory | CustomerReturnItemCategory | 1 | |
| CustomerReturnItemText | CustomerReturnItemText | 1 | |
| CustPurOrdTypeByShipToParty | CustPurOrdTypeByShipToParty | 1 | |
| CustRetItmFollowUpActivity | CustRetItmFollowUpActivity | 1 | |
| DeliveryPriority | DeliveryPriority | 1 | |
| FixedValueDate | FixedValueDate | 1 | |
| HigherLevelItem | HigherLevelItem | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| InternationalArticleNumber | InternationalArticleNumber | 1 | |
| ItemBillingBlockReason | ItemBillingBlockReason | 1 | |
| ItemGeneralIncompletionStatus | ItemGeneralIncompletionStatus | 1 | |
| ItemGrossWeight | ItemGrossWeight | 1 | |
| ItemNetWeight | ItemNetWeight | 1 | |
| ItemVolume | ItemVolume | 1 | |
| ItemVolumeUnit | ItemVolumeSAPUnit | 1 | |
| ItemWeightUnit | ItemWeightSAPUnit | 1 | |
| MaterialByCustomer | MaterialByCustomer | 1 | |
| MaterialPricingGroup | MaterialPricingGroup | 1 | |
| MatlAccountAssignmentGroup | MatlAccountAssignmentGroup | 1 | |
| NetAmount | NetAmount | 1 | |
| NextFllwUpActivityForMatlInsp | NextFllwUpActivityForMatlInsp | 1 | |
| OriginallyRequestedMaterial | OriginallyRequestedMaterial | 1 | |
| Plant | Plant | 1 | |
| PrelimRefundIsDetermined | PrelimRefundIsDetermined | 1 | |
| PricingDate | PricingDate | 1 | |
| Product | Product | 1 | |
| ProductGroup | ProductGroup | 1 | |
| ProductIsInspectedAtCustSite | ProductIsInspectedAtCustSite | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 1 | |
| PurchaseOrderByShipToParty | PurchaseOrderByShipToParty | 1 | |
| ReferenceSDDocument | ReferenceSDDocument | 1 | |
| ReferenceSDDocumentCategory | ReferenceSDDocumentCategory | 1 | |
| ReferenceSDDocumentItem | ReferenceSDDocumentItem | 1 | |
| ReplacementMaterial | ReplacementProduct | 1 | |
| ReplacementMaterialIsRequested | RplcmtProdFrmSuplrIsReqd | 1 | |
| ReplacementMaterialQtyUnit | RplcmtProdQtySAPUnit | 1 | |
| ReplacementMaterialQuantity | ReplacementProductQuantity | 1 | |
| ReplacementMatlSupplyingPlant | RplcmtProdSupplyingPlant | 1 | |
| RequestedQuantity | RequestedQuantity | 1 | |
| RequestedQuantityUnit | RequestedQuantitySAPUnit | 1 | |
| RetMatlInspResultCode | ReturnsInspectionCode | 1 | |
| RetsInspIsCrtedAutomly | RetsInspIsCrtedAutomly | 1 | |
| RetsMgmtProcessingBlock | RetsMgmtProcessingBlock | 1 | |
| RetsProdValnIsSuspended | RetsProdValnIsSuspended | 1 | |
| ReturnReason | ReturnReason | 1 | |
| ReturnsMaterialHasBeenReceived | ReturnsProductHasBeenReceived | 1 | |
| ReturnsRefundExtent | ReturnsRefundCode | 1 | |
| ReturnsRefundProcgMode | ReturnsRefundProcgMode | 1 | |
| ReturnsRefundRjcnReason | ReturnsRefundRjcnReason | 1 | |
| ReturnsRefundType | ReturnsRefundType | 1 | |
| SalesDocumentRjcnReason | SalesDocumentRjcnReason | 1 | |
| SDDocumentRejectionStatus | SDDocumentRejectionStatus | 1 | |
| SDProcessStatus | SDProcessStatus | 1 | |
| ServicesRenderedDate | ServicesRenderedDate | 1 | |
| ShippingPoint | ShippingPoint | 1 | |
| ShippingType | ShippingType | 1 | |
| StorageLocation | StorageLocation | 1 | |
| Subtotal1Amount | Subtotal1Amount | 1 | |
| Subtotal2Amount | Subtotal2Amount | 1 | |
| Subtotal3Amount | Subtotal3Amount | 1 | |
| Subtotal4Amount | Subtotal4Amount | 1 | |
| Subtotal5Amount | Subtotal5Amount | 1 | |
| Subtotal6Amount | Subtotal6Amount | 1 | |
| SuplrRetMatlAuthznIsRequired | SuplrRetMatlAuthznIsRequired | 1 | |
| Supplier | Supplier | 1 | |
| SupplierRetMatlAuthzn | SupplierRetMatlAuthzn | 1 | |
| TaxAmount | TaxAmount | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| UnderlyingPurchaseOrderItem | UnderlyingPurchaseOrderItem | 1 | |
| UndrlgPurOrdItmByShipToParty | UndrlgPurOrdItmByShipToParty | 1 | |
| 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.
-- Returns Order Item - TP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_CUSTOMERRETURNITEMTP (
CUSTOMERRETURN,
CUSTOMERRETURNITEM,
BATCH,
BILLINGDOCUMENTDATE,
BUSINESSAREA,
CORRESPNCEXTERNALREFERENCE,
CORRESPNCEXTREFBYSHIPTOPARTY,
CUSTOMERGROUP,
CUSTOMERPAYMENTTERMS,
CUSTOMERPRICEGROUP,
CUSTOMERPURCHASEORDERTYPE,
CUSTOMERRETURNITEMCATEGORY,
CUSTOMERRETURNITEMTEXT,
CUSTPURORDTYPEBYSHIPTOPARTY,
CUSTRETITMFOLLOWUPACTIVITY,
DELIVERYPRIORITY,
FIXEDVALUEDATE,
HIGHERLEVELITEM,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSVERSION,
INTERNATIONALARTICLENUMBER,
ITEMBILLINGBLOCKREASON,
ITEMGENERALINCOMPLETIONSTATUS,
ITEMGROSSWEIGHT,
ITEMNETWEIGHT,
ITEMVOLUME,
ITEMVOLUMEUNIT,
ITEMWEIGHTUNIT,
MATERIALBYCUSTOMER,
MATERIALPRICINGGROUP,
MATLACCOUNTASSIGNMENTGROUP,
NETAMOUNT,
NEXTFLLWUPACTIVITYFORMATLINSP,
ORIGINALLYREQUESTEDMATERIAL,
PLANT,
PRELIMREFUNDISDETERMINED,
PRICINGDATE,
PRODUCT,
PRODUCTGROUP,
PRODUCTISINSPECTEDATCUSTSITE,
PROFITCENTER,
PURCHASEORDERBYCUSTOMER,
PURCHASEORDERBYSHIPTOPARTY,
REFERENCESDDOCUMENT,
REFERENCESDDOCUMENTCATEGORY,
REFERENCESDDOCUMENTITEM,
REPLACEMENTMATERIAL,
REPLACEMENTMATERIALISREQUESTED,
REPLACEMENTMATERIALQTYUNIT,
REPLACEMENTMATERIALQUANTITY,
REPLACEMENTMATLSUPPLYINGPLANT,
REQUESTEDQUANTITY,
REQUESTEDQUANTITYUNIT,
RETMATLINSPRESULTCODE,
RETSINSPISCRTEDAUTOMLY,
RETSMGMTPROCESSINGBLOCK,
RETSPRODVALNISSUSPENDED,
RETURNREASON,
RETURNSMATERIALHASBEENRECEIVED,
RETURNSREFUNDEXTENT,
RETURNSREFUNDPROCGMODE,
RETURNSREFUNDRJCNREASON,
RETURNSREFUNDTYPE,
SALESDOCUMENTRJCNREASON,
SDDOCUMENTREJECTIONSTATUS,
SDPROCESSSTATUS,
SERVICESRENDEREDDATE,
SHIPPINGPOINT,
SHIPPINGTYPE,
STORAGELOCATION,
SUBTOTAL1AMOUNT,
SUBTOTAL2AMOUNT,
SUBTOTAL3AMOUNT,
SUBTOTAL4AMOUNT,
SUBTOTAL5AMOUNT,
SUBTOTAL6AMOUNT,
SUPLRRETMATLAUTHZNISREQUIRED,
SUPPLIER,
SUPPLIERRETMATLAUTHZN,
TAXAMOUNT,
TRANSACTIONCURRENCY,
UNDERLYINGPURCHASEORDERITEM,
UNDRLGPURORDITMBYSHIPTOPARTY,
WBSELEMENTEXTERNALID,
PRIMARY KEY (CUSTOMERRETURN, CUSTOMERRETURNITEM)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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