SAP table OIU_PR_FIELD (Field)

SAP table OIU_PR_FIELD has 2 primary key fields being MANDT,FIELD.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
FIELD Field ID CHAR 10 0 OIU_FIELDID
NAME Field Name CHAR 35 0 OIU_FL_NM
SHTXT Description CHAR 35 0 OIU_SHTXT
MAJPD_CD Major product code CHAR 1 0 OIU_MAJPD_CD
1 Oil
2 Natural Gas
3 Condensate
4 Plant NGLS
5 Water
7 Sulfur
9 Injectants
WATER_DEPTH_U Water depth unit UNIT 3 0 T006 OIU_WATR_DPH_U
WATER_DEPTH Water depth QUAN 13 3 OIU_WATR_DPH
FL_GRP Field group CHAR 4 0 OIU_PR_FL_GRP OIU_FL_GRP
OIU_CRUSER Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS

OIU_PR_FIELD foreign key relationships

Table Field Check Table Check Field
0 OIU_PR_FIELD FL_GRP OIU_PR_FL_GRP PRA: Field Group Codes MANDT
1 OIU_PR_FIELD WATER_DEPTH_U T006 Units of Measurement MANDT