SAP TEXT_CTY_SPLIT Maintenance of Commodity Split Items Table data and field list

TEXT_CTY_SPLIT is a standard SAP Table which is used to store Maintenance of Commodity Split Items data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TEXT_CTY_SPLIT table consists of various fields, each holding specific information or linking keys about Maintenance of Commodity Split Items data available in SAP. These include MASTER_CTY (Master Commodity ID), COMPONENT_CTY (Master Commodity ID), SPLIT_PERCENT (Sub Raw Exposure Split Percentage), SPLIT_RATIO (Sub Raw Exposures Split ratio)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

TEXT_CTY_SPLIT table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP TEXT_CTY_SPLIT table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TEXT_CTY_SPLIT table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MASTER_CTYMaster Commodity ID FTR_MASTER_CTYCHAR18TRCOT_CTY_MASTERTPM_CTY_ID
COMPONENT_CTYMaster Commodity ID FTR_COMPONENT_CTYCHAR18TRCOT_CTY_MASTERTPM_CTY_ID
SPLIT_PERCENTSub Raw Exposure Split Percentage FTR_SPLIT_PERCENTAGEDEC5(2) DECV3_2
SPLIT_RATIOSub Raw Exposures Split ratio FTR_SPLIT_RATIOQUAN13(3)

Key field Non-key field



How do I retrieve data from SAP table TEXT_CTY_SPLIT using ABAP code

The following ABAP code Example will allow you to do a basic selection on TEXT_CTY_SPLIT to SELECT all data from the table
DATA: WA_TEXT_CTY_SPLIT TYPE TEXT_CTY_SPLIT.

SELECT SINGLE *
FROM TEXT_CTY_SPLIT
INTO CORRESPONDING FIELDS OF WA_TEXT_CTY_SPLIT
WHERE...

How to access SAP table TEXT_CTY_SPLIT

Within an ECC or HANA version of SAP you can also view further information about TEXT_CTY_SPLIT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).