SAP Table PDM_FIELDCATALOG

Field Catalog for Display in Product Structure Browser

PDM_FIELDCATALOG (Field Catalog for Display in Product Structure Browser) 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 PDM_FIELDCATALOG to other SAP tables.

PDM_FIELDCATALOG table fields

Field Data element Checktable Datatype Length Decimals
RELATION Dependency in Product Structure Browser CPDM_RELATION CHAR 30 0
LOGSYS Logical system LOGSYS CHAR 10 0
OBJECT_TEXT Description of all objects in Product Structure Browser OBJECT_TEXT1 CHAR 40 0
CHARVALUES Indicator: display characterictic values to object and class CHARVALUES CHAR 1 0
WORKBENCH Open engineering workbench WORKBENCH CHAR 1 0
LABOR Laboratory/design office LABOR CHAR 3 0
LOEDK Deletion indicator LOEDK CHAR 1 0
X Yes
NULL No
CADKZ CAD Indicator CADKZ CHAR 1 0
X Yes
NULL No
STLST BOM status STLST NUMC 2 0
STTXT Description of maintenance status STTXT CHAR 40 0
STKTX Alternative BOM Text STKTX CHAR 40 0
ANTXT BOM usage text ANTXT CHAR 30 0
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLNR Bill of material STNUM CHAR 8 0
STLKN BOM item node number STLKN NUMC 8 0
STPOZ Internal counter CIM_COUNT NUMC 8 0
POSTP Item Category (Bill of Material) POSTP CHAR 1 0
SORTF Sort String SORTP CHAR 10 0
RFPNT Reference point for BOM transfer CN_RFPNT CHAR 20 0
MENGE Component quantity KMPMG QUAN 13 3
KMPME Component unit of measure KMPME UNIT 3 0
BDMNG Requirement Quantity BDMNG QUAN 13 3
POTX1 BOM Item Text (Line 1) POTX1 CHAR 40 0
POTX2 BOM item text (line 2) POTX2 CHAR 40 0
FMENG Fixed qty FMNGE CHAR 1 0
X Yes
NULL No
ERSKZ Indicator: spare part ERSKZ CHAR 1 0
SANFE Indicator: item relevant to production SANFE CHAR 1 0
X Yes
NULL No
SANIN Indicator: item relevant to plant maintenance SANIN CHAR 1 0
X Yes
NULL No
SANKA Indicator: item relevant to costing SANKA CHAR 1 0
SANKO Indicator: item relevant to engineering SANKO CHAR 1 0
X Yes
NULL No
STLKZ Indicator: assembly STLKZ CHAR 1 0
BEIKZ Material Provision Indicator BEIKZ CHAR 1 0
ATMST Status of a characteristic ATMST CHAR 1 0
ATSTT Characteristic Status ATSTT CHAR 20 0
ATFOR Data Type ATUDF CHAR 18 0
ANZST Number of Characters (Figures) CHARNUMBER NUMC 2 0
ANZDZ Decimal Places DECPLACES NUMC 2 0
ATSCH Value with template ATSCH CHAR 30 0
UNIT Unit of Measure, Language-Dependent ATEI6 CHAR 6 0
ATKLA Chars Group ATKLA CHAR 10 0
DATUV Valid-From Date DATUV DATS 8 0
DWNAM Name of person responsible DWNAM CHAR 12 0
STABK Status of a document (language-dependent) STABK CHAR 2 0
DOSTX Description of document status DOSTX CHAR 16 0
DOSAR Document status type DOSAR CHAR 1 0
I Initial status
P Primary status
T Temporary status
O Original processing status
S Locked status
A Archive status
NULL No special status type
C Check-in status
FRKNZ Indicator: released FRKNZ CHAR 1 0
X Yes
NULL No
FRTAE Completion message for engineering change management FRTAE CHAR 1 0
X Yes
NULL No
ORIGINAL Original application file exists C_PDM_ORIGINAL CHAR 1 0
MTART Material Type MTART CHAR 4 0
MBRSH Industry sector MBRSH CHAR 1 0
WRKST Basic Material WRKST CHAR 48 0
MSTAE Cross-Plant Material Status MSTAE CHAR 2 0
MTSTB Description of material status from MM/PP view MTSTB CHAR 25 0
MEINS Base Unit of Measure MEINS UNIT 3 0
NTGEW Net Weight NTGEW QUAN 13 3
BRGEW Gross Weight BRGEW QUAN 13 3
GEWEI Weight Unit GEWEI UNIT 3 0
VOLUM Volume VOLUM QUAN 13 3
VOLEH Volume unit VOLEH UNIT 3 0
GROES Size/dimensions GROES CHAR 32 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
NUMTP Category of International Article Number (EAN) NUMTP CHAR 2 0
NORMT Industry Standard Description (such as ANSI or ISO) NORMT CHAR 18 0
FORMT Page Format of Production Memo FORMT CHAR 4 0
AENST Status of change number AENST NUMC 2 0
AESTX Change status text AESTX CHAR 30 0
AEGRU Reason for change AEGRU CHAR 40 0
CCART Change Type CCART NUMC 3 0
ANNAM User who created record ANNAM CHAR 12 0
AEREL Released indicator CC_AEREL CHAR 1 0
X Yes
NULL No
RLKEY Release Key for Change Master Record CC_RLKEY NUMC 2 0
RLTXT Description for release key CC_RLTXT CHAR 30 0
S_EQUI Equipment data exists EQUIP_KNZ CHAR 1 0
X Yes
NULL No
LAGER Storage Location LGORT_D CHAR 4 0
EQTYP Equipment category EQTYP CHAR 1 0
EQART Type of Technical Object EQART CHAR 10 0
INVNR Inventory number INVNR CHAR 25 0
ANSDT Acquisition date ANDTI DATS 8 0
ANSWT Acquisition Value ANSWT CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
GWLEN Date on which the warranty ends GWLEN DATS 8 0
GWLDT Warranty Date GWLDT DATS 8 0
HERST Manufacturer of asset HERST CHAR 30 0
HERLD Country of manufacture HERLD CHAR 3 0
HZEIN Manufacturer drawing number HZEIN CHAR 30 0
SERGE Manufacturer serial number SERGE CHAR 30 0
TYPBZ Manufacturer model number TYPBZ CHAR 20 0
BAUJJ Year of construction BAUJJ CHAR 4 0
BAUMM Month of construction BAUMM CHAR 2 0
00
IWERK Maintenance Planning Plant IWERK CHAR 4 0
HEQNR Equipment position at InstallLoc (Superior Equip./FunctLoc) HEQNR CHAR 4 0
INGRP Planner Group for Customer Service and Plant Maintenance INGRP CHAR 3 0
RBNR Catalog Profile RBNR CHAR 9 0
ABCKZ ABC indicator for technical object ABCKZ CHAR 1 0
EQFNR Sort field EQFNR CHAR 30 0
SWERK Maintenance plant SWERK CHAR 4 0
MSGRP Room RAUMNR CHAR 8 0
BEBER Plant section BEBER CHAR 3 0
TPLKZ Functional location structure indicator TPLKZ CHAR 5 0
FLTYP Functional location category FLTYP CHAR 1 0
DATAB Start-up Date of the Technical Object ILOM_DATAB DATS 8 0
IEQUI Installation of equipment allowed at the functional location IEQUI CHAR 1 0
X Yes
NULL No
EINZL Single equipment installation at functional location EINZL CHAR 1 0
X Yes
NULL No
POSNR Position in superior technical object ILOM_POSNR CHAR 4 0
PREMS Premise ILOM_PREMS CHAR 10 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
STATU Class status KLSTATUS CHAR 1 0
STEXT Text for a table entry EINTEXT CHAR 40 0
KLAGR Class Group KLASSENGR CHAR 10 0
ANZUO Number of Assignments ANZUOR NUMC 5 0
SICHT Organizational Area ABTEILUNG CHAR 10 0
DINKZ DIN class indicator DINKEN CHAR 1 0
NNORM Name of standards organization NORM CHAR 10 0
NORMN Standard Number NORMNR CHAR 20 0
INACTIVE Indicator: PM object is active/inactive C_PDM_PM_ACTIVE CHAR 1 0
ACTUAL_VERSION Indicator: Current document version ACTUAL_DOC_VERSION CHAR 1 0
CAD_VAULTED Indicator: document original is checked in CAD_VAULTED CHAR 1 0
CAD_MATNR Material Number MATNR CHAR 18 0
CAD_MAKTX Material Description (Short Text) MAKTX CHAR 40 0
CAD_SAPDB Indicator: Document exists in the SAP System CAD_SAPDB CHAR 1 0
CAD_STRUC Indicator: Document ist part of the document structure CAD_STRUC CHAR 1 0
FLAG_MAT_SPEC Indicator: Material specification exists FLAG_MAT_SPEC CHAR 1 0
QMART Notification Type QMART CHAR 2 0
LIFE_CYCLE Key for the life cycle profile DE_CM_LIFE_CYCLE CHAR 5 0
LC_TEXT Life cycle profile DE_CM_LIFE_CYCLE_TXT CHAR 15 0
LC_PHASE Key for the life cycle phase DE_CM_LIFE_CYCLE_PHASE CHAR 5 0
LC_PHASE_TEXT Life cycle phase DE_CM_LC_PHASE_TXT CHAR 15 0
BASELINE_DATE Date in CHAR format DATE CHAR 8 0
PLNST Status PLNST CHAR 3 0
FLGAT Sequence category FOLGENART CHAR 1 0
FLG_LTXT Description of the sequence category FLG_LTXT CHAR 30 0
IDENT Operation ID OPRID CHAR 8 0
STEUS Control key STEUS CHAR 4 0
ARBPL Work center ARBPL CHAR 8 0
HERKUNFT Origin of an operation OPR_HER CHAR 1 0
0 Operation from current routing
1 Operation from referenced routing
2 Dummy operation
3 Referenced work center operation set
4 Sub-operation from current routing
5 Sub-operation from referenced routing
EQUNR Equipment Number EQUNR CHAR 18 0
SERNR Serial Number GERNR CHAR 18 0
DATUB Valid-to date DATUB DATS 8 0
REVLV Revision Level CC_REVLV CHAR 2 0
MFRPN Manufacturer Part Number MFRPN CHAR 40 0
MFRNR Number of a Manufacturer MFRNR CHAR 10 0
FUNC Execute Action on Object in Web for PDM Browser PDM_FUNC CHAR 1 0
NAME1 Name 1 NAME1_GP CHAR 35 0
AMPL_WERKS Plant WERKS_MASK CHAR 4 0
AMPL_DATUV Date as of which the MPN materail may be procured AMPAB DATS 8 0
AMPL_DATUB Date until which the MPN material may be procured AMPBI DATS 8 0
AMPL_REVLV Revision Level REVLV CHAR 2 0
AMPL_AMPSP Blocked manufacturer/part combinations AMPSP CHAR 4 0
AMPL_REOAM Deletion indicator: AMPL record REOAM CHAR 1 0
X Yes
NULL No
VOBJ Name of database table for object TABELLE CHAR 30 0
VKEY Document management object key OBJKY CHAR 50 0
VDIR Direction of document link active DRADDIR CHAR 1 0
X Yes
NULL No
MAPAR Manufacturer part number MAPAR CHAR 30 0
YY_RDS_PP Reference Designator (RDS-PP) Y_RDS_PP CHAR 40 0
YY_PDMLINKID PDMLink BOM Component ID Y_PDMLINKID CHAR 36 0
YY_ITEM_COMMONID BOMCommonID Y_COMMONID CHAR 36 0
YY_OWNING_SYSTEM Owning System Y_OWNING_SYSTEM NUMC 2 0
YY_MAINTAINED_BY Maintained By Y_MAINTAINED_BY CHAR 12 0
YY_MBOMBYTECH Technology R&D Approver Y_MBOMBYTECH CHAR 12 0
YY_MBOMBYPE Production Engineering Y_MBOMBYPE CHAR 12 0
YY_PDMLINKID_H PDMLink Header ID Y_PDMLINKID_H CHAR 36 0
YY_COMMONID BOMCommonID Y_COMMONID CHAR 36 0
CUFACTOR CU: Number of CU Instances /CUM/CUFACTOR NUMC 6 0
PVS_PXTYPE iPPE Node Type, Alternative Type, or Variant Type PVS_CUST_TYPE1 CHAR 8 0
PDESC Description of iPPE Object Type PVS_DESC CHAR 40 0
CCODE Color Supplement Key PVS_COL_CODE CHAR 10 0
STATUS_ICON Icon with output length 4 ICON_L4 CHAR 4 0