SAP TTED_ACQUISI_COM Acquisition Table data and field list

TTED_ACQUISI_COM is a standard SAP Table which is used to store Acquisition data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TTED_ACQUISI_COM table consists of various fields, each holding specific information or linking keys about Acquisition data available in SAP. These include COUNTRY (Country), DOCUMENTNAME (Document Name), ITEMNODEID (Node ID), COUNTRY1 (Country)... 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. .

TTED_ACQUISI_COM 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: Not classified

SAP TTED_ACQUISI_COM 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 TTED_ACQUISI_COM 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
CLIENT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
COUNTRY	Country	TTET_COUNTRY_COM	CHAR	2			TTET_COUNTRY_COM	TTET_COUNTRY_PD
DOCUMENTNAME	Document Name	TTET_DOCNAME_COM	CHAR	32	Assigned to domain		TTET_DOCNAME_COM	TTET_NAME
ITEMNODEID	Node ID	TTET_NODEID_COM	CHAR	12			TTET_CHAR12_COM
COUNTRY1	Country	TTET_COUNTRY1_COM	CHAR	2			TTET_COUNTRY_COM
COMMUNITY	Community	TTET_COMMUNITY_COM	CHAR	5			TTET_CHAR5_COM
TAXREGION	Tax Region	TTET_TAXREGION_COM	CHAR	3			TTET_CHAR3_COM
JURISDICTIONCODE	Jurisdiction Code	TTET_JURISDICTIONCODE_COM	CHAR	15			TTET_CHAR15_COM
COUNTRY2	Country	TTET_COUNTRY2_COM	CHAR	2			TTET_COUNTRY_COM
REGION	Region	TTET_REGION_COM	CHAR	3			TTET_CHAR3_COM
COUNTY	County	TTET_COUNTY_COM	CHAR	30			TTET_CHAR30_COM
CITY	City	TTET_CITY_COM	CHAR	30			TTET_CHAR30_COM
POSTALCODE	Postal Code	TTET_POSTALCODE_COM	CHAR	10			TTET_CHAR10_COM
STREET	Street	TTET_STREET_COM	CHAR	30			TTET_CHAR30_COM
STREETNUMBER	Street Number	TTET_STREETNUMBER_COM	CHAR	5			TTET_CHAR5_COM
GEOCODE	Geo Code	TTET_GEOCODE_COM	CHAR	32			TTET_CHAR32_COM

Key field

Non-key field

< TTEC_XTAXSYS_T - External Tax System TTED_ANALYS_COM - Output Trace >

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

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

SELECT SINGLE *
FROM TTED_ACQUISI_COM
INTO CORRESPONDING FIELDS OF WA_TTED_ACQUISI_COM
WHERE...

How to access SAP table TTED_ACQUISI_COM

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

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