SAP PLMN_FL_EXT GHO Object characteristics Table data and field list

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

The PLMN_FL_EXT table consists of various fields, each holding specific information or linking keys about GHO Object characteristics data available in SAP. These include TPLNR (Functional Location), FIELD_ID (Field Id), ASSET_ID (Asset Id), CONCESSION_ID (Concession Id)... 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_FL_EXT 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: Can Be Enhanced (Deep)


SAP PLMN_FL_EXT 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 PLMN_FL_EXT 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 MANDTCLNT3Assigned to domainMANDT
TPLNRFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM
FIELD_IDField Id PLMN_GEN_FIELD_IDCHAR30PLMN_GEN_OBJ_ID
ASSET_IDAsset Id PLMN_GEN_ASSET_IDCHAR30PLMN_GEN_OBJ_ID
CONCESSION_IDConcession Id PLMN_GEN_CONCESSION_IDCHAR30PLMN_GEN_OBJ_ID
RANK_IDConcession Rank Id PLMN_GEN_RANK_IDNUMC30PLMN_GEN_RANK_ID
COUNTRY_IDCountry Id PLMN_GEN_COUNTRY_IDCHAR3Assigned to domainLAND1
REGION_IDRegion Id PLMN_GEN_REGION_IDCHAR3Assigned to domainREGIO
BH_LONGITUDELongitude - decimal PLMN_GEN_LONGITUDEDEC15(12) GEOLONLAT
BH_LATITUDELatitude - decimal PLMN_GEN_LATITUDEDEC15(12) GEOLONLAT
GRND_ELEVElevation PLMN_GEN_ELEVATIONQUAN13(3) PLMN_GEN_ELEVATION
GRND_ELEV_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
GRND_ELEV_REFElevation Reference PLMN_GEN_ELEVATION_REFCHAR30PLMN_GEN_ELEVATION_REF
WELL_IDWell Id PLMN_GEN_WELL_IDCHAR30PLMN_GEN_OBJ_ID
WELL_NAMEWell Name PLMN_GEN_WELL_NAMECHAR30PLMN_GEN_OBJ_NAME
WELL_ALT_NAMEWell Name PLMN_GEN_WELL_NAMECHAR30PLMN_GEN_OBJ_NAME
WATER_DEPTHDepth PLMN_GEN_DEPTHQUAN13(3) PLMN_GEN_DEPTH
WATER_DEPTH_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
DEPTHDepth PLMN_GEN_DEPTHQUAN13(3) PLMN_GEN_DEPTH
DEPTH_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
TVDDepth PLMN_GEN_DEPTHQUAN13(3) PLMN_GEN_DEPTH
TVD_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
WELL_TYPE_PRODWell type PLMN_GEN_WELL_TYPECHAR1PLMN_GEN_WELL_TYPE
WELL_TYPE_INJWell type PLMN_GEN_WELL_TYPECHAR1PLMN_GEN_WELL_TYPE
WELL_TYPE_ONSHOnshore or Offshore PLMN_GEN_ONOFF_SHORECHAR1PLMN_GEN_ONOFF_SHORE
WELL_TYPE_OFFSHOnshore or Offshore PLMN_GEN_ONOFF_SHORECHAR1PLMN_GEN_ONOFF_SHORE
SPUD_DATESpud Date PLMN_GEN_SPUD_DATEDATS8DATS
CONNECTION_DATEConnection date PLMN_GEN_CONNECTION_DATEDATS8DATS
COMPLETION_DATECompletion date PLMN_GEN_COMPLETION_DATEDATS8DATS
PLUG_ABAN_DATEPlug and abandon date PLMN_GEN_PLUG_ABANDON_DATEDATS8DATS
GUWIGUWI/UWI PLMN_GEN_GUWICHAR30
SEPARATOR_IDSeperator Id PLMN_GEN_SEPARATOR_IDCHAR30PLMN_GEN_OBJ_ID
SEPARATOR_NAMESeparator Name PLMN_GEN_SEPARATOR_NAMECHAR30PLMN_GEN_OBJ_NAME
PROD_PER_DAYFlared amount of product per Day PLMN_GEN_PROD_PER_DAYQUAN13(3) MENG13
PROD_PER_DAY_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
PLATFORM_IDPlatform Id PLMN_GEN_PLATFORM_IDCHAR30PLMN_GEN_OBJ_ID
PLATFORM_NAMEPlatform name PLMN_GEN_PLATFORM_NAMECHAR30PLMN_GEN_OBJ_NAME
PLATFORM_TYPEPlatform Type PLMN_GEN_PLATFORM_TYPECHAR30PLMN_GEN_PLATFORM_TYPE
NUMB_LEGSPlatform's number of legs PLMN_GEN_PLAT_NUMB_LEGSINT13PLMN_GEN_PLAT_NUMB_LEGS
NUMB_SLOTSPlatform's Number of slots PLMN_GEN_PLAT_NUMB_SLOTSINT13PLMN_GEN_PLAT_NUMB_SLOTS
NUMB_PILESPlatform's number of piles PLMN_GEN_PLAT_NUMB_PILESINT13PLMN_GEN_PLAT_NUMB_PILES
HEIGHTHeight PLMN_GEN_HEIGHTFLTP16(16) FLTP
HEIGHT_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
WEIGHT_TONSWeight in Tons PLMN_GEN_WEIGHT_TONSQUAN13(3) MENG13
WEIGHT_TONS_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
INSTAL_DATEInstallation Date PLMN_GEN_INSTALLATION_DATEDATS8PLMN_GEN_INSTALLATION_DATE
PERM_CREW_FLAGPermanent crew flag PLMN_GEN_GREW_FLAGCHAR1BOOLEAN

Key field Non-key field



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

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

SELECT SINGLE *
FROM PLMN_FL_EXT
INTO CORRESPONDING FIELDS OF WA_PLMN_FL_EXT
WHERE...

How to access SAP table PLMN_FL_EXT

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

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