SAP TDS_GOAL_CRET_ITEM Table in S/4 HANA - GOAL: Customer Return Item Data
TDS_GOAL_CRET_ITEM is a standard SAP Table which is used to store GOAL: Customer Return Item Data data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP TDS_GOAL_CRET_ITEM table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: TDS_GOAL_CRET_ITEM
TDS_GOAL_CRET_ITEM table structure field list
Below is the full TDS_GOAL_CRET_ITEM field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| HANDLE | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32(0) | SYSUUID_C | |||||
| ITEM_ID | Item number of the SD document | POSNR | NUMC | 6(0) | POSNR | |||||
| CATEGORY_CODE | Sales document item category | PSTYV | CHAR | 4(0) | PSTYV | |||||
| MATERIAL_ID | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
| ORDER_QTY | Cumulative order quantity in sales units | KWMENG | QUAN | 15(3) | MENG15 | |||||
| CONFIRMED_QTY | Cumulative Confirmed Quantity in Sales Unit | KBMENG | QUAN | 15(3) | MENG15 | |||||
| SALES_UOM | Sales unit | VRKME | UNIT | 3(0) | CUNIT | MEINS | ||||
| BASIC_UOM | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
| REQ_DELIVERY_DATE | Schedule line date | EDATU | DATS | 8(0) | DATUM | |||||
| ITEM_DESCR | Short text for sales order item | ARKTX | CHAR | 40(0) | TEXT40 | |||||
| CUSTOMER_MATERIAL_ID | Material Number Used by Customer | MATNR_KU | CHAR | 35(0) | IDNEX | |||||
| PURCHASE_ORDER_ID | Customer Reference | BSTKD | CHAR | 35(0) | BSTKD | |||||
| PURCHASE_ORDER_DATE | Customer Reference Date | BSTDK | DATS | 8(0) | DATUM | |||||
| PLANT_ID | Plant (Own or External) | WERKS_EXT | CHAR | 4(0) | WERKS | WRK | SH_T001W_EXTS | WERKS | ||
| NET_AMOUNT | Net Value of the Order Item in Document Currency | NETWR_AP | CURR | 15(2) | WERTV8 | |||||
| TAX_AMOUNT | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | |||||
| TOTAL_AMOUNT | Total amount of item | ENDBP | CURR | 15(2) | WERTV8 | |||||
| DOCUMENT_CURRENCY_CODE | SD document currency | WAERK | CUKY | 5(0) | WAERS | FWS | ||||
| REJECTION_REASON_CODE | Reason for Rejection of Sales Documents | ABGRU_VA | CHAR | 2(0) | ABGRU_VA | |||||
| CREATED_BY | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
| CREATED_ON | Date on which the record was created | ERDAT | DATS | 8(0) | DATUM | |||||
| CHANGED_BY | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
| CHANGED_ON | Date of Last Change | AEDAT | DATS | 8(0) | DATUM | |||||
| WBS_ELEMENT_ID | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
| WBS_ELEMENT_ID_EXT | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24(0) | ABPSN | PS_POSID | PRO | |||
| HIGHER_LEVEL_ITEM_ID | Higher-Level item in bill of material structures | UEPOS | NUMC | 6(0) | POSNR | |||||
| BILLING_BLOCK_CODE | Billing Block for Item | FAKSP_AP | CHAR | 2(0) | FAKSP | |||||
| PRGBZ | External Date Type | PRGBZ | CHAR | 1(0) | PRGBZ | |||||
| ETDAT | Schedule Line Date | ETDAT | CHAR | 10(0) | ETDAT | |||||
| DELIVERY_PRIORITY_CODE | Delivery Priority | LPRIO | NUMC | 2(0) | LPRIO | |||||
| INCOTERMS_CODE | Incoterms (Part 1) | INCO1 | CHAR | 3(0) | INCO1 | |||||
| INCOTERMS_LOCATION | Incoterms (Part 2) | INCO2 | CHAR | 28(0) | INCO2 | |||||
| INCOTERMS_LOCATION_1 | Incoterms Location 1 | INCO2_L | CHAR | 70(0) | INCO_L | |||||
| INCOTERMS_LOCATION_2 | Incoterms Location 2 | INCO3_L | CHAR | 70(0) | INCO_L | |||||
| INCOTERMS_VERSION | Incoterms Version | INCOV | CHAR | 4(0) | INCOV | |||||
| PAYMENT_TERM_CODE | Terms of payment key | DZTERM | CHAR | 4(0) | ZTERM | |||||
| PRICING_DATE | Date for Pricing and Exchange Rate | PRSDT | DATS | 8(0) | DATUM | |||||
| EXCHANGE_RATE | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | ||||
| EXCHANGE_RATE_EXT | CHAR | 12(0) | ||||||||
| DIP_PROFILE_ID | Dynamic Item Processor Profile | AD01PROFNR | CHAR | 8(0) | AD01PROFNR | AD0 | DIP_PROFILE | PROFNR | ||
| TARGET_QTY | Target Quantity in Sales Units | DZMENG | QUAN | 13(3) | MENG13 | |||||
| TARGET_UOM | Target Quantity UoM | DZIEME | UNIT | 3(0) | CUNIT | MEINS | ||||
| PARTIAL_DELIVERY_CODE | Partial delivery at item level | KZTLF | CHAR | 1(0) | KZTLF | |||||
| NUMBER_ALLOWED_DLVS | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1(0) | ANTLF | |||||
| PBS_STATE | State of Project-Based Service | SD_PBS_STATE | CHAR | 1(0) | SD_PBS_STATE | |||||
| UPDATE_INDICATOR | Update indicator | UPDKZ_D | CHAR | 1(0) | UPDKZ | |||||
| IS_NEW | General Flag | FLAG | CHAR | 1(0) | FLAG | |||||
| PROFIT_CENTER | Profit Center | PRCTR | CHAR | 10(0) | ALPHA | PRCTR | PRC | PRCTR_EMPTY | PRCTR | |
| FIXED_VALUE_DATE | Fixed Value Date | VALDT | DATS | 8(0) | DATUM | |||||
| ADDITIONAL_VALUE_DAYS | Additional Value Days | VALTG | NUMC | 2(0) | TAGE2 | |||||
| CUSTOMER_COND_GRP1_CODE | Customer condition group 1 | KDKG1 | CHAR | 2(0) | KDKGR | |||||
| CUSTOMER_COND_GRP2_CODE | Customer condition group 2 | KDKG2 | CHAR | 2(0) | KDKGR | |||||
| CUSTOMER_COND_GRP3_CODE | Customer condition group 3 | KDKG3 | CHAR | 2(0) | KDKGR | |||||
| CUSTOMER_COND_GRP4_CODE | Customer condition group 4 | KDKG4 | CHAR | 2(0) | KDKGR | |||||
| CUSTOMER_COND_GRP5_CODE | Customer condition group 5 | KDKG5 | CHAR | 2(0) | KDKGR | |||||
| MATERIAL_GROUP1_CODE | Material group 1 | MVGR1 | CHAR | 3(0) | MVGR1 | |||||
| MATERIAL_GROUP2_CODE | Material group 2 | MVGR2 | CHAR | 3(0) | MVGR2 | |||||
| MATERIAL_GROUP3_CODE | Material group 3 | MVGR3 | CHAR | 3(0) | MVGR3 | |||||
| MATERIAL_GROUP4_CODE | Material group 4 | MVGR4 | CHAR | 3(0) | MVGR4 | |||||
| MATERIAL_GROUP5_CODE | Material group 5 | MVGR5 | CHAR | 3(0) | MVGR5 | |||||
| EXTERNAL_ITEM_ID | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6(0) | ALPHA | POSEX | ||||
| MATERIAL_GROUP_ID | Material Group | MATKL | CHAR | 9(0) | MATKL | MKL | S_WBWG | MATKL | ||
| PURCHASE_ORDER_TYPE_CODE | Customer Purchase Order Type | BSARK | CHAR | 4(0) | BSARK | |||||
| INTERNATIONAL_ARTICLE_NO | International Article Number (EAN/UPC) | EAN11 | CHAR | 18(0) | EAN11 | EAN11 | EAN | |||
| RECEIVING_POINT_ID | Receiving Point | EMPST | CHAR | 25(0) | TEXT25 | |||||
| DUMMY_SLSDOCITEM_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1(0) | DUMMY | |||||
| REQUESTED_QTY | Requested Quantity | REQD_QTY | QUAN | 15(3) | MENG15 | |||||
| REQUESTED_UOM | Requested Quantity Unit | REQD_QTY_UNIT | UNIT | 3(0) | CUNIT | MEINS | ||||
| UNLOADING_POINT_ID | Unloading Point | ABLAD | CHAR | 25(0) | TEXT25 | |||||
| IFRS15_RELEVANCE | Item is relevant for IFRS 15 | IFRS15_RELEVANCE | CHAR | 1(0) | XFELD | |||||
| IFRS15_TOTAL_SSP | IFRS 15: Standalone Selling Price | IFRS15_TOTAL_SSP | CURR | 15(2) | WERTV8 | |||||
| STORAGE_LOCATION_ID | Storage location | LGORT_D | CHAR | 4(0) | LGORT | LAG | ||||
| SHIPPING_POINT_ID | Shipping Point / Receiving Point | VSTEL | CHAR | 4(0) | VSTEL | VST | ||||
| REF_DOCUMENT_ID | Document number of the reference document | VGBEL | CHAR | 10(0) | ALPHA | VBELN | ||||
| REF_ITEM_ID | Item number of the reference item | VGPOS | NUMC | 6(0) | POSNR | |||||
| EXT_REF_ITEM_ID | External Item ID | SD_EXT_REF_ITEM_ID | CHAR | 40(0) | CHAR40 | |||||
| .INCLU--AP | 0(0) | |||||||||
| REQUIREMENTSEGMENT | Requirement Segment | SGT_RCAT | CHAR | 40(0) | SGT_SRCA | SGT_R | SGT_CAT_FIELD_POPUP | VALUE | ||
| PRODUCTSEASONYEAR | Season Year | FSH_SAISJ | CHAR | 4(0) | FSH_CJAHR | WMSAISJ | ||||
| PRODUCTSEASON | Season | FSH_SAISO | CHAR | 10(0) | RFM_SAISO | SAISO | ||||
| PRODUCTCOLLECTION | Fashion Collection | FSH_COLLECTION | CHAR | 10(0) | Assigned to domain | FSH_COLLECTION | ||||
| PRODUCTTHEME | Fashion Theme | FSH_THEME | CHAR | 10(0) | FSH_THEME |
Search for further information about these or an SAP related objects