SAP MSIT_PIRSYNC Complex datatype for Purchase info record Table data and field list

MSIT_PIRSYNC 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 "Complex datatype for Purchase info record" 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_MSIT_PIRSYNC TYPE MSIT_PIRSYNC.

The MSIT_PIRSYNC table consists of various fields, each holding specific information or linking keys about Complex datatype for Purchase info record data available in SAP. These include DATA (), MANDT (Client), INFNR (Number of Purchasing Info Record), MATNR (Material Number)... 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. .

MSIT_PIRSYNC structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP MSIT_PIRSYNC 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 MSIT_PIRSYNC 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
PIR_BASIC 0
DATA 0
MANDTClient MANDTCLNT3MANDT
INFNRNumber of Purchasing Info Record INFNRCHAR10ALPHAINFNRINFMEIN_C
MATNRMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
MATKLMaterial Group MATKLCHAR9MATKLMKLS_WBWG
LIFNRVendor Account Number ELIFNCHAR10ALPHALIFNRLIFKRED_C
LOEKZPurchasing info: General data flagged for deletion ILOEACHAR1XFELD
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
TXZ01Short Text for Purchasing Info Record EINATXCHAR40TEXT40
SORTLSort Term for Non-Stock Info Records SORTICHAR10CHAR10
MEINSPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
UMREZNumerator for Conversion of Order Unit to Base Unit UMBSZDEC5UMBSZ
UMRENDenominator for Conversion of Order Unit to Base Unit UMBSNDEC5UMBSN
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
VERKFSalesperson Responsible in the Event of Queries VERKFCHAR30TEXT30
TELF1Vendor's Telephone Number TELF0CHAR16TEXT16
MAHN1Number of Days for First Reminder/Expediter MAHN1DEC3MAHNT
MAHN2Number of Days for Second Reminder/Expediter MAHN2DEC3MAHNT
MAHN3Number of Days for Third Reminder/Expediter MAHN3DEC3MAHNT
URZNRCertificate Number URZNRCHAR10URZNR
URZDTCertificate of Origin Valid Until URZDTDATS8DATUM
URZLACountry of Issue of Certificate of Origin ULANDCHAR3LAND1
URZTPCertificate Category URZTPCHAR1URZTP
URZZTNumber URZZTCHAR16URZZT
LMEINBase Unit of Measure MEINSUNIT3CUNITMEINS
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
VABMEVariable Purchase Order Unit Active VABMECHAR1VABME
LTSNRVendor Subrange LTSNRCHAR6LTSNR
LTSSFSort Sequence Number LTSSFNUMC5NUMC5
WGLIFVendor Material Group WGLIFCHAR18CHAR18
RUECKReturn Agreement W_RUECKNVCHAR2W_RUECKNV
LIFABAvailable (Deliverable) From LIFABDATS8DATUM
LIFBIAvailable (Deliverable) Until LIFBIDATS8DATUM
KOLIFPrior Vendor KOLIFCHAR10ALPHALIFNR
ANZPUNumber of Points ANZPUQUAN13(3) MENG13
PUNEIPoints unit PUNEIUNIT3CUNITMEINS
RELIFRegular Vendor RELIFCHAR1XFELD
MFRNRManufacturer MFRNR1CHAR10ALPHALIFNR
DATA_X 0
MATNRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MATKLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LIFNRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LOEKZUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ERDATUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ERNAMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TXZ01Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
SORTLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MEINSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UMREZUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UMRENUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
IDNLFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VERKFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
TELF1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MAHN1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MAHN2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MAHN3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
URZNRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
URZDTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
URZLAUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
URZTPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
URZZTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LMEINUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
REGIOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VABMEUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LTSNRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LTSSFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
WGLIFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
RUECKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LIFABUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LIFBIUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KOLIFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ANZPUUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PUNEIUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
RELIFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MFRNRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UPDATE_TYPEType of Change UPDATE_TYPECHAR1UPDATE_TYPE

Key field Non-key field



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

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

How to access SAP table MSIT_PIRSYNC

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

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