SAP FRMLS_RCPS_API_BY_FRML RMS-FRM: Recipe API Data Per Formula Key (Internal) Table data and field list

FRMLS_RCPS_API_BY_FRML 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 "RMS-FRM: Recipe API Data Per Formula Key (Internal)" 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_FRMLS_RCPS_API_BY_FRML TYPE FRMLS_RCPS_API_BY_FRML.

The FRMLS_RCPS_API_BY_FRML table consists of various fields, each holding specific information or linking keys about RMS-FRM: Recipe API Data Per Formula Key (Internal) data available in SAP. These include MANDT (Client), GUID (Internal Identification for PVS Objects), AENNR (Change Number), GUID_MAST (Internal Identification for PVS Objects)... 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. .

FRMLS_RCPS_API_BY_FRML structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP FRMLS_RCPS_API_BY_FRML 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 FRMLS_RCPS_API_BY_FRML 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
RECN_OF_FRMLRMS-FRM: Object Identifier FRMLE_RECNCHAR32FRMLD_GUID
MANDTClient MANDTCLNT3Assigned to domainMANDT
GUIDInternal Identification for PVS Objects PVS_GUIDRAW16SYSUUID
AENNRChange Number AENNRCHAR12Assigned to domainAENNRAENNRAEN
GUID_MASTInternal Identification for PVS Objects PVS_GUIDRAW16SYSUUID
GUID_ROOTInternal Identification for PVS Objects PVS_GUIDRAW16SYSUUID
AENNR_ROOTChange Number AENNRCHAR12Assigned to domainAENNRAENNRAEN
LINEMODEProcessing Status/Mode of a Record/Step Loop Line RCPE_LINEMODECHAR1CHAR1
PNAMEObject Name RCPE_PNODECHAR40CHAR40
PNTYPERecipe Object Type RCPE_PNODE_TYPECHAR8CHAR8RCPE_PNTYPE
PVGUIDInternal Number of the PVS Variant PVS_PVGUIDRAW16SYSUUID
PVTYPEiPPE Variant Type PVS_POSV_TYPECHAR8Assigned to domainPVS_POSV_TYPE
PVCDCNTInternal Counter for iPPE Objects PVS_COUNTNUMC8NUMC8
RCPDCNTChange State in Recipe RCPCHSTCHAR10PVS_RCPCHST
STATUSIndividual Status of Object PVS_J_STATUSCHAR5J_STATUSPPERCP_ISTATUS
ISTATUS_OLDObject status J_STATUSCHAR5J_STATUS
OBJNRObject Number PVS_J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
VALFROMValid-From Date RCPE_ADATUMDATS8DATUM
VALTOValid-To Date RCPE_BDATUMDATS8DATUM
LOTMINLower Limit of Lot-Size Range RCPE_MINLOTSIZEQUAN13(3) MENG13
LOTMAXUpper Limit of Lot-Size Range RCPE_MAXLOTSIZEQUAN13(3) MENG13
LOTUNITUnit of Measure of Reference Quantity or Lot Size RCPE_QUNITUNIT3Assigned to domainCUNITMEINSH_T006
OTYPE_ORGIDObject Type for Responsibility RCPE_OTYPECHAR2ESD_ESTST_T778OOTYPEPOTESS_ESTST_OTYPE
REALOResponsibility RCPE_REALOCHAR45CHAR45
RCP_TIMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmss,mmmuuun) PVS_TIMSTMPDEC21(7) TZNTSTMPL
PV_PLANTPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
PV_MATMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
PV_NRProduction Version PVS_VERIDCHAR4Assigned to domainVERIDVER
REFQUANTReference Quantity RCPE_REFQUANTQUAN13(3) RCPD_REFQUANT
PROJECTWBS Element PS_POSNRNUMC8PRPSABPSPPS_POSNR
DEV_TIMERecipe Development Time RCPE_DEVTIMENUMC6RCPD_DEVTIME
PROD_TIMEProductive Time of Recipe RCPE_PRODTIMENUMC6RCPD_PRODTIME
CONF_FLAGConfidential RCPE_CONFFLAGCHAR1RCPD_CONFFLAG
REFLANGReference Language RCPE_OLANGLANG1Assigned to domainISOLASPRASSPRH_T002
PVTXCNTCounter for Text Tables PVS_TXTCOUNTNUMC5NUMC5
RESCREATXCNTCounter for Text Tables PVS_TXTCOUNTNUMC5NUMC5
COPY_FROMOrigin RCPE_CPYFROMRAW16RCPD_CPYFROM
TIMEUNITTime Unit for Productive Time and Development Time RCPE_TUNITUNIT3T006CUNITMEINS
AUTHGRPAuthorization Group of an Object RCPE_AUTHGRPCHAR10Assigned to domainESDAUTHGRPESS_TCG36_AUTHGRP
EHS_RECNSequential Number of Data Record ESERECNNUMC20ALPHAESDRECN
SUBCATObject Type RCPE_SUBCATCHAR10Assigned to domainESDSUBCATRCPE_SUBCAT_TCG32
SUBIDSpecification ESESUBIDCHAR12SPEC1ESDSUBIDES0
GUID_PREInternal Identification for PVS Objects PVS_GUIDRAW16SYSUUID
GUID_ORIInternal Identification for PVS Objects PVS_GUIDRAW16SYSUUID
NAMComplete Key of an Object Version RMSAE_OBJNAMCHAR40RMSAD_VRSNAM
VRS_TYPEVersion Category RMSAE_VRSTYPECHAR3RMSAD_VRSTYPE
FLG_INNRKey Was Generated from Internal Number Range RMSAE_FLG_INNRCHAR1RMSAD_FLG
RMS_CREADATDate on Which Object was Created RCPE_ANDATDATS8
RMS_CREABYCreated By RCPE_ANNAMCHAR12
RMS_CHNGDATDate of Last Change RCPE_AEDATDATS8
RMS_CHNGBYLast Changed By RCPE_AENAMCHAR12
RMS_LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
RCP_CREADATCreated On RCPE_ANDAT_RCPDATS8DATUM
RCP_CREABYCreated By RCPE_ANNAM_RCPCHAR12USNAM
RCP_CHNGDATDate of Last Change to Change State RCPE_AEDAT_RCPDATS8DATUM
RCP_CHNGBYPerson Responsible for Last Change to Change State RCPE_AENAM_RCPCHAR12USNAM
RCP_LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
COPY_FROM_RCPCopied from RCPE_CPYFROM_RCPRAW16RCPD_CPYFROM
PREF_RCP_FLGPreferred Recipe RCPE_PREF_RCPCHAR1RCPD_PREF_RCP
CONS_FLGConsistent RCPE_CONS_FLGCHAR1RCPD_CONS_FLG
TXT_REALOObject Name STEXTCHAR40TEXT40
USTATUSObject status J_STATUSCHAR5J_STATUS
AW_STSMAStatus Profile J_STSMACHAR8Assigned to domainJ_STSMA
MULT_ACTIVECheckbox XFELDCHAR1XFELD

Key field Non-key field



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

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

How to access SAP table FRMLS_RCPS_API_BY_FRML

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

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