SAP Table STRNO_TPLNR

Output Fields for Function Module FUNC_LOCATION_GET_LIST

STRNO_TPLNR (Output Fields for Function Module FUNC_LOCATION_GET_LIST) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link STRNO_TPLNR to other SAP tables.

STRNO_TPLNR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
TPLNR_INT Functional Location TPLNR CHAR 30 0
TPLNR Functional Location Label ILOM_STRNO CHAR 40 0
ALKEY Labeling system for functional locations ILOM_ALKEY CHAR 1 0
0 Labeling system 0
1 Labeling system 1
2 Labeling system 2
3 Labeling system 3
4 Labeling system 4
5 Labeling system 5
6 Labeling system 6
7 Labeling system 7
8 Labeling system 8
9 Labeling system 9
A Labeling system A
B Labeling system B
C Labeling system C
D Labeling system D
E Labeling system E
F Labeling system F
G Labeling system G
H Labeling system H
I Labeling system I
J Labeling system J
K Labeling system K
L Labeling system L
M Labeling system M
N Labeling system N
O Labeling system O
P Labeling system P
Q Labeling system Q
R Labeling system R
S Labeling system S
T Labeling system T
U Labeling system U
V Labeling system V
W Labeling system W
X Labeling system X
Y Labeling system Y
Z Labeling system Z
SPRAS Language Key SPRAS T002 LANG 1 0
PLTXT Description of functional location PLTXT CHAR 40 0
TPLKZ Functional location structure indicator TPLKZ CHAR 5 0
FLTYP Functional location category FLTYP T370F CHAR 1 0
IWERK Maintenance Planning Plant IWERK T001W CHAR 4 0
SWERK Maintenance plant SWERK T001W CHAR 4 0
TPLMA Superior functional location TPLMA IFLOT CHAR 30 0
GEWRK Main work center for maintenance tasks GEWRK CHAR 8 0
BEGRU Technical object authorization group IAUTG T370B CHAR 4 0
INGRP Planner Group for Customer Service and Plant Maintenance INGRP T024I CHAR 3 0
EQART Type of Technical Object EQART CHAR 10 0
EQFNR Sort field EQFNR CHAR 30 0

STRNO_TPLNR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
STRNO_TPLNR BEGRU STRNO_TPLNR MANDT T370B Technical object authorization group MANDT
STRNO_TPLNR BEGRU STRNO_TPLNR BEGRU T370B Technical object authorization group BEGRU
STRNO_TPLNR FLTYP STRNO_TPLNR MANDT T370F Functional Location Category MANDT
STRNO_TPLNR FLTYP STRNO_TPLNR FLTYP T370F Functional Location Category FLTYP
STRNO_TPLNR INGRP STRNO_TPLNR MANDT T024I Maintenance planner groups MANDT
STRNO_TPLNR INGRP STRNO_TPLNR SWERK T024I Maintenance planner groups IWERK
STRNO_TPLNR INGRP STRNO_TPLNR INGRP T024I Maintenance planner groups INGRP
STRNO_TPLNR IWERK STRNO_TPLNR MANDT T001W Plants/Branches MANDT
STRNO_TPLNR IWERK STRNO_TPLNR IWERK T001W Plants/Branches WERKS
STRNO_TPLNR SPRAS STRNO_TPLNR SPRAS T002 Language Keys (Component BC-I18) SPRAS
STRNO_TPLNR SWERK STRNO_TPLNR MANDT T001W Plants/Branches MANDT
STRNO_TPLNR SWERK STRNO_TPLNR SWERK T001W Plants/Branches WERKS
STRNO_TPLNR TPLMA STRNO_TPLNR TPLMA IFLOT Functional Location (Table) TPLNR
STRNO_TPLNR TPLMA STRNO_TPLNR MANDT IFLOT Functional Location (Table) MANDT