SPCFILE SAP (SPEC 2000 messages & fields) Table details

Dictionary Type: Table
Description: SPEC 2000 messages & fields




ABAP Code to SELECT data from SPCFILE
Related tables to SPCFILE
Access table SPCFILE




Table field list including key, data, relationships and ABAP select examples

SPCFILE is a standard SAP Table which is used to store SPEC 2000 messages & fields data and is available within R/3 SAP systems depending on the version and release level.

The SPCFILE table consists of various fields, each holding specific information or linking keys about SPEC 2000 messages & fields data available in SAP. These include VERSION (Version defines different rules to map and check the fields), MESTYP (Message Type), MESFCT (Logical message function), MESCOD (Logical Message Variant).. 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. .

Delivery Class: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP SPCFILE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VERSIONVersion defines different rules to map and check the fields ADSPC_S2K_VERCHAR5CHAR5
MESTYPMessage Type EDI_MESTYPCHAR30Assigned to domainEDI_MESTYPMES
MESFCTLogical message function EDI_MESFCTCHAR3EDI_MESFCT
MESCODLogical Message Variant EDI_MESCODCHAR3EDI_MESCOD
FIELDSSPEC 2000 Text Element Identifier ADSPC_S2K_TEICHAR10SPCDTELCHAR10
CATEGORYSpecifies, whether SPEC 2000 field is mandatory or optional ADSPC_CATEGORYCHAR1CHAR1
SEQUENCESequence in which the SPEC 2000 fields occur in the message ADSPC_SEQUENCENUMC2NUMC2
BLANKSpecifies, whether the field can be blank ADSPC_BLANKCHAR1CHAR1
OCCURANCESpecifies, whether SPEC 2000 field can occur multiple times ADSPC_OCCURANCECHAR1CHAR1
RELATIONIndicates which fields in the given message are related ADSPC_RELATIONCHAR1CHAR1
REL_FLAGIndicates dependency of the related SPEC 2000 fields ADSPC_REL_FLAGCHAR1CHAR1
LINE_FLAGSpecifies, whether S2K-field can appear only once per line ADSPC_LINE_FLAGCHAR1CHAR1
SLASH_FLAGSpecifies, whether '/' is required after this S2K-field ADSPC_SLASH_FLAGCHAR1CHAR1
TEI_FLAGSpecifies, whether TEI is required before this S2K-field ADSPC_TEI_FLAGCHAR1CHAR1
SBRTNFunction module which should be called to do technical check ADSPC_SBRTNCHAR30CHAR30
DESCPDescription of the SPEC 2000 Data Element ADSPC_DESCCHAR40CHAR40
MESSAGEMessage Text NATXTCHAR73NATXT

Key field Non-key field



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

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

SELECT SINGLE *
FROM SPCFILE
INTO CORRESPONDING FIELDS OF WA_SPCFILE
WHERE...

How to access SAP table SPCFILE

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

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


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!