SAP PLMN_S_SP_WELL_DATA Object type - well structure Table data and field list

PLMN_S_SP_WELL_DATA 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 "Object type - well structure" 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_PLMN_S_SP_WELL_DATA TYPE PLMN_S_SP_WELL_DATA.

The PLMN_S_SP_WELL_DATA table consists of various fields, each holding specific information or linking keys about Object type - well structure data available in SAP. These include TPLNR (Functional Location), WELL_ID (Well Id), WELL_NAME (Well Name), WELL_ALT_NAME (Well Name)... 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. .

PLMN_S_SP_WELL_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP PLMN_S_SP_WELL_DATA 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 PLMN_S_SP_WELL_DATA 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
TPLNR	Functional Location	TPLNR	CHAR	30	Assigned to domain	TPLNR	TPLNR	IFL	IFLM
WELL_ID	Well Id	PLMN_GEN_WELL_ID	CHAR	30			PLMN_GEN_OBJ_ID
WELL_NAME	Well Name	PLMN_GEN_WELL_NAME	CHAR	30			PLMN_GEN_OBJ_NAME
WELL_ALT_NAME	Well Name	PLMN_GEN_WELL_NAME	CHAR	30			PLMN_GEN_OBJ_NAME
WATER_DEPTH	Depth	PLMN_GEN_DEPTH	QUAN	13(3)			PLMN_GEN_DEPTH
WATER_DEPTH_UOM	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
DEPTH	Depth	PLMN_GEN_DEPTH	QUAN	13(3)			PLMN_GEN_DEPTH
DEPTH_UOM	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
TVD	Depth	PLMN_GEN_DEPTH	QUAN	13(3)			PLMN_GEN_DEPTH
TVD_UOM	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
WELL_TYPE_PROD	Well type	PLMN_GEN_WELL_TYPE	CHAR	1			PLMN_GEN_WELL_TYPE
WELL_TYPE_INJ	Well type	PLMN_GEN_WELL_TYPE	CHAR	1			PLMN_GEN_WELL_TYPE
WELL_TYPE_ONSH	Onshore or Offshore	PLMN_GEN_ONOFF_SHORE	CHAR	1			PLMN_GEN_ONOFF_SHORE
WELL_TYPE_OFFSH	Onshore or Offshore	PLMN_GEN_ONOFF_SHORE	CHAR	1			PLMN_GEN_ONOFF_SHORE
SPUD_DATE	Spud Date	PLMN_GEN_SPUD_DATE	DATS	8			DATS
CONNECTION_DATE	Connection date	PLMN_GEN_CONNECTION_DATE	DATS	8			DATS
COMPLETION_DATE	Completion date	PLMN_GEN_COMPLETION_DATE	DATS	8			DATS
PLUG_ABAN_DATE	Plug and abandon date	PLMN_GEN_PLUG_ABANDON_DATE	DATS	8			DATS
GUWI	GUWI/UWI	PLMN_GEN_GUWI	CHAR	30
FIELD_ID	Field Id	PLMN_GEN_FIELD_ID	CHAR	30			PLMN_GEN_OBJ_ID
ASSET_ID	Asset Id	PLMN_GEN_ASSET_ID	CHAR	30			PLMN_GEN_OBJ_ID
CONCESSION_ID	Concession Id	PLMN_GEN_CONCESSION_ID	CHAR	30			PLMN_GEN_OBJ_ID
RANK_ID	Concession Rank Id	PLMN_GEN_RANK_ID	NUMC	30			PLMN_GEN_RANK_ID
COUNTRY_ID	Country Id	PLMN_GEN_COUNTRY_ID	CHAR	3	Assigned to domain		LAND1
REGION_ID	Region Id	PLMN_GEN_REGION_ID	CHAR	3	Assigned to domain		REGIO
BH_LONGITUDE	Longitude - decimal	PLMN_GEN_LONGITUDE	DEC	15(12)			GEOLONLAT
BH_LATITUDE	Latitude - decimal	PLMN_GEN_LATITUDE	DEC	15(12)			GEOLONLAT
GRND_ELEV	Elevation	PLMN_GEN_ELEVATION	QUAN	13(3)			PLMN_GEN_ELEVATION
GRND_ELEV_UOM	Base Unit of Measure	MEINS	UNIT	3	Assigned to domain	CUNIT	MEINS
GRND_ELEV_REF	Elevation Reference	PLMN_GEN_ELEVATION_REF	CHAR	30			PLMN_GEN_ELEVATION_REF

Key field

Non-key field

< PLMN_S_SP_WELL_COMPLETION - Well Completion PLMN_S_UI_NETOBJ_POWLRET - Return Structure of Personalized POWL >

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

As PLMN_S_SP_WELL_DATA 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 PLMN_S_SP_WELL_DATA as there is no data to select.

How to access SAP table PLMN_S_SP_WELL_DATA

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

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