SAP DPR_TS_LOCATION_WITH_TEXT Location with Text Table data and field list

DPR_TS_LOCATION_WITH_TEXT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Location with Text" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DPR_TS_LOCATION_WITH_TEXT TYPE DPR_TS_LOCATION_WITH_TEXT.

The DPR_TS_LOCATION_WITH_TEXT table consists of various fields, each holding specific information or linking keys about Location with Text data available in SAP. These include AREA (Area), CALENDAR_ID (Factory Calendar), HOURS_PER_DAY (Hours per Day), COUNTRY (Country Key)... 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. .

DPR_TS_LOCATION_WITH_TEXT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP DPR_TS_LOCATION_WITH_TEXT structure 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 DPR_TS_LOCATION_WITH_TEXT 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
LOCATION	Location	DPR_TV_LOCATION	CHAR	4	Assigned to domain		DPR_LOCATION
AREA	Area	DPR_TV_AREA	CHAR	4	Assigned to domain		DPR_AREA
CALENDAR_ID	Factory Calendar	WFCID	CHAR	2	Assigned to domain		WFCID	FCI
HOURS_PER_DAY	Hours per Day	DPR_TV_HOURS_PER_DAY	DEC	4(2)			DPR_HOURS_PER_DAY
COUNTRY	Country Key	LAND1	CHAR	3	Assigned to domain		LAND1	LND
REGION	STATE (State, Province, County)	REGIO	CHAR	3	Assigned to domain		REGIO
POST_CODE	Postal Code	POST_CODE	CHAR	10	Assigned to domain		POST_CODE	PSC	PSTC
TEXT	Location Text	DPR_TV_LOCATION_TEXT	CHAR	30			TEXT30

Key field

Non-key field

< DPR_TS_LOCATION_AREA - Location and Area with Text DPR_TS_LOCATOR_DATA - External Element Key Data of Locator >

How do I retrieve data from SAP structure DPR_TS_LOCATION_WITH_TEXT using ABAP code?

As DPR_TS_LOCATION_WITH_TEXT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DPR_TS_LOCATION_WITH_TEXT as there is no data to select.

How to access SAP table DPR_TS_LOCATION_WITH_TEXT

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

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