/ISDFPS/CS_EXLST SAP (Exception List: Overwritten Purchase Requisitions) Table details

Dictionary Type: Table
Description: Exception List: Overwritten Purchase Requisitions




ABAP Code to SELECT data from /ISDFPS/CS_EXLST
Related tables to /ISDFPS/CS_EXLST
Access table /ISDFPS/CS_EXLST




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

/ISDFPS/CS_EXLST is a standard SAP Table which is used to store Exception List: Overwritten Purchase Requisitions data and is available within R/3 SAP systems depending on the version and release level.

The /ISDFPS/CS_EXLST table consists of various fields, each holding specific information or linking keys about Exception List: Overwritten Purchase Requisitions data available in SAP. These include PREQ_NO (Purchase Requisition Number), PREQ_ITEM (Item Number of Purchase Requisition), COUNTER (5 Character Numeric NUMC), VERSION (Version of Purchase Requisition (Old/New)).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP /ISDFPS/CS_EXLST 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 MANDTCLNT3Assigned to domainMANDT
PREQ_NOPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
PREQ_ITEMItem Number of Purchase Requisition BNFPONUMC5Assigned to domainBNFPOBAP
COUNTER5 Character Numeric NUMC NUMC5NUMC5NUM5
VERSIONVersion of Purchase Requisition (Old/New) /ISDFPS/PREQ_VRSNCHAR1/ISDFPS/PREQ_VRSN
CHANGEDATEChange Date /ISDFPS/CHANGEDATEDATS8DATS
CHANGETIMEChange Time /ISDFPS/CHANGETIMETIMS6TIME
BNFPOItem Number of Purchase Requisition BNFPONUMC5Assigned to domainBNFPOBAP
BSARTPurchase Requisition Document Type BBSRTCHAR4Assigned to domainBSARTBBA
BSTYPPurchasing Document Category BSTYPCHAR1BSTYP
BSAKZControl indicator for purchasing document type BSAKZCHAR1BSAKZ
LOEKZDeletion Indicator in Purchasing Document ELOEKCHAR1ELOEK
STATUProcessing status of purchase requisition BANSTCHAR1BANST
ESTKZCreation Indicator (Purchase Requisition/Schedule Lines) ESTKZCHAR1ESTKZ
FRGKZRelease Indicator FRGKZCHAR1Assigned to domainFRGKZ
FRGZURelease status FRGZUCHAR8FRGZU
FRGSTRelease Strategy in Purchase Requisition FRGSTCHAR2FRGST
EKGRPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATChanged On AEDATDATS8DATUM
AFNAMName of Requisitioner/Requester AFNAMCHAR12AFNAM
TXZ01Short Text TXZ01CHAR40TEXT40
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
EMATNMaterial Number Corresponding to Manufacturer Part Number EMATNCHAR18Assigned to domainMATN1MATNRHTN
WERKSPlant EWERKCHAR4Assigned to domainWERKSWRK
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
BEDNRRequirement Tracking Number BEDNRCHAR10CHAR10
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
RESWKSupplying (Issuing) Plant in Stock Transport Order RESWKCHAR4Assigned to domainWERKS
MENGEPurchase Requisition Quantity BAMNGQUAN13(3) MENG13
MEINSPurchase Requisition Unit of Measure BAMEIUNIT3Assigned to domainCUNITMEINS
BUMNGShortage (stock undercoverage) quantity BUMNGQUAN13(3) MENG13
BADATRequisition (Request) Date BADATDATS8DATUM
LPEINCategory of Delivery Date LPEINCHAR1Assigned to domainPRGBZ
LFDATItem Delivery Date EINDTDATS8DATUM
FRGDTPurchase Requisition Release Date FRGDTDATS8DATUM
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
PREISPrice in Purchase Requisition BAPRECURR11(2) WERT11
PEINHPrice Unit EPEINDEC5DEC5
PSTYPItem Category in Purchasing Document PSTYPCHAR1Assigned to domainPSTYP
KNTTPAccount Assignment Category KNTTPCHAR1Assigned to domainKNTTPKNT
KZVBRConsumption Posting KZVBRCHAR1KZVBR
KFLAGAcct.asst.changeable KFLAGCHAR1XFELD
VRTKZDistribution indicator for multiple account assignment VRTKZCHAR1VRTKZ
TWRKZPartial Invoice Indicator TWRKZCHAR1TWRKZ
WEPOSGoods Receipt Indicator WEPOSCHAR1XFELD
WEUNBGoods Receipt, Non-Valuated WEUNBCHAR1XFELD
REPOSInvoice Receipt Indicator REPOSCHAR1XFELD
LIFNRDesired Vendor WLIEFCHAR10Assigned to domainALPHALIFNR
FLIEFFixed Vendor FLIEFCHAR10Assigned to domainALPHALIFNR
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
VRTYPPurchasing Document Category BSTYPCHAR1BSTYP
KONNRNumber of Principal Purchase Agreement KONNRCHAR10Assigned to domainALPHAEBELNKTR
KTPNRItem Number of Principal Purchase Agreement KTPNRNUMC5Assigned to domainEBELP
INFNRNumber of Purchasing Info Record INFNRCHAR10Assigned to domainALPHAINFNRINFMEIN_C
ZUGBAAssigned Source of Supply DZUGBACHAR1XFELD
QUNUMNumber of Quota Arrangement QUNUMCHAR10ALPHAQUNUM
QUPOSQuota Arrangement Item QUPOSNUMC3NUM03
DISPOMRP Controller (Materials Planner) DISPOCHAR3Assigned to domainDISPODGRHS_T024D
SERNRBOM explosion number SERNRCHAR8Assigned to domainSERNR
BVDATDate of last resubmission BVDATDATS8DATUM
BATOLResubmission Interval of Purchase Requisition BATOLDEC3BATOL
BVDRKNumber of resubmissions BVDRKDEC7ZAEHL
EBELNPurchase Order Number BSTNRCHAR10Assigned to domainALPHAEBELNBES
EBELPPurchase Order Item Number BSTPONUMC5Assigned to domainEBELP
BEDATPurchase Order Date BEDATDATS8DATUM
BSMNGQuantity Ordered Against this Purchase Requisition BSMNGQUAN13(3) MENG13
LBLNIEntry Sheet Number LBLNICHAR10Assigned to domainALPHALBLNILBLESSR
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
XOBLRItem affects commitments XOBLRCHAR1XFELD
EBAKZPurchase Requisition Closed EBAKZCHAR1XFELD
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
ARSNRSettlement reservation number ARSNRNUMC10MDNUM
ARSPSItem number of the settlement reservation ARSPSNUMC4RSPOS
FIXKZPurchase Requisition is Fixed BAFIXCHAR1XFELD
BMEINPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
VORABAdvance procurement: project stock VORABCHAR1XFELD
PACKNOPackage number PACKNONUMC10Assigned to domainPACKNO
KANBAKanban Indicator KBNKZCHAR1KBNKZ
BPUEBAdopt Requisition Price in Purchase Order BPUEBCHAR1BPUEB
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
FRGGRRelease group FRGGRCHAR2Assigned to domainFRGGR
FRGRLRelease Not Yet Completely Effected FRGRLCHAR1XFELD
AKTNRCOUPON WAKTIONCHAR10Assigned to domainALPHAWAKTIONWAK
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
UMSOKSpecial Stock Indicator for Physical Stock Transfer UMSOKCHAR1Assigned to domainSOBKZ
VERIDProduction Version VERIDCHAR4Assigned to domainVERIDVER
FIPOSCommitment Item FIPOSCHAR14Assigned to domainFIPOSFIP
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
KZKFGOrigin of Configuration KZCUHCHAR1KZCUH
SATNRCross-Plant Configurable Material SATNRCHAR18Assigned to domainMATN1MATNR
MNG02Committed Quantity MNG06QUAN13(3) MENGV13
DAT01Committed Date DAT05DATS8DATUM
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
ADRNRManual address number in purchasing document item ADRNR_MMCHAR10Assigned to domainALPHAAD_ADDRNUM
ADRN2Number of delivery address ADRN2CHAR10Assigned to domainALPHAAD_ADDRNUM
KUNNRCustomer EKUNNRCHAR10Assigned to domainALPHAKUNNRKUN
EMLIFVendor to be supplied/who is to receive delivery EMLIFCHAR10Assigned to domainALPHALIFNR
LBLKZSubcontracting vendor LBLKZCHAR1XFELD
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
GSWRTTotal Value of Item GSWRTCURR13(2) WERT7
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
GSFRGOverall release of purchase requisitions GSFRGCHAR1XFELD
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
KZFMEUnits of measure usage KZWSOCHAR1KZWSO
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
TECHSParameter Variant/Standard Variant TECHSCHAR12TECHS
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
FORDNFramework Order SFORDNCHAR10Assigned to domainALPHAEBELN
FORDPItem of framework order FORDPNUMC5Assigned to domainEBELP
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
BERIDMRP Area BERIDCHAR10Assigned to domainBERIDBERID
UZEITDelivery Date Time-Spot LZEITTIMS6UZEIT
REF_BANFNNumber of Reference Purchase Requisition REFBNCHAR10ALPHABANFN
REF_BNFPOItem of Reference Purchase Requisition RFBPSNUMC5Assigned to domainBNFPO
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
MEMORYPurchase Requisition not yet Complete MEMBFCHAR1XFELD
BANPRRequisition Processing State BANPRCHAR2BANPR
RLWRTTotal value at time of release RLWRTCURR15(2) WERT15
BLCKDPurchase Requisition Blocked BLCKDCHAR1BLCKD
BLCKTReason for Item Block BLCKTCHAR60CHAR60K
REVNOVersion number in Purchasing REVNOCHAR8ALPHAREVNO
BESWKProcuring Plant BESWKCHAR4Assigned to domainWERKSBESW
EPROFILEExternal Procurement Profile MEPROFILECHAR2EPROFILE
EPREFDOCExternal Procurement Reference Document EPREFDOCCHAR10EPREFDOC
EPREFITMExternal Procurement Reference Item EPREFITMNUMC5EPREFITM
GMMNGPO Quantity of Purchase Requisition in POs on Hold GMMNGQUAN13(3) MENG13
WRTKZValue-Based Commitment Reduction for Service Purchase Reqs WRTKZCHAR1XFELD
RESLOIssuing Storage Location for Stock Transport Order RESLOCHAR4Assigned to domainLGORT
KBLNRDocument Number for Earmarked Funds KBLNRCHAR10Assigned to domainALPHAKBLNRKBL
KBLPOSEarmarked Funds: Document Item KBLPOSNUMC3Assigned to domainKBLPOSKBP
PRIO_URGRequirement Urgency PRIO_URGNUMC2PURGPRIO_URG
PRIO_REQRequirement Priority PRIO_REQNUMC3PREQPRIO_REQ
ANZSNNumber of serial numbers ANZSNINT410INT4
SERNPSerial Number Profile SERAILCHAR4Assigned to domainSERAIL
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
MEMORYTYPECategory of Incompleteness MEMORYTYPECHAR1MM_MEMORYTYPE
EXT_PROC_STATUSProcessing State MEREQ_PROC_STATUSCHAR1PROC_STAT
EXT_PROC_DATETimestamp MMPUR_UTCCHAR14TIMESTAMP
PROC_STATUSProcessing State MEREQ_PROC_TYPECHAR1PROC_TYPE
PROC_DATETimestamp MMPUR_UTCCHAR14TIMESTAMP
EXT_DOC_NUMBERDocument Number of External Document ME_PUR_EXT_DOC_IDCHAR35ME_EXT_DOC_ID
EXT_DOC_ITEMItem Number of External Document ME_PUR_EXT_DOC_ITEM_IDCHAR10ME_EXT_DOC_ITEM_ID
EXT_DOC_TYPEExternal Document Type ME_PUR_EXT_DOC_TYPECHAR4ME_EXT_DOC_TYPE
NODISPInd: Reserv. not applicable to MRP;Purc. req. not created NODISPCHAR1XFELD
SRM_CONTRACT_IDCentral Contract SRM_CONTRACT_IDCHAR10ALPHABBP_BAPI_EBELNMMBSI_MEKK_CC
SRM_CONTRACT_ITMCentral Contract Item Number SRM_CONTRACT_ITEMNUMC10BBP_ITEMNO
SC_OBJECT_IDObject ID - Document Number /SRMERP/OBJECT_IDCHAR10/SRMERP/OBJECT_ID
SC_ITM_NOInternal Shopping Cart Item Number /SRMERP/SC_ITM_NOINT410INT4
MEREQITEMDUMMYCheckbox XFELDCHAR1XFELD
DUMMY1Type of consolidation of investments method XFELD1CHAR1XFELD
J_1BMATUSEUsage of the material J_1BMATUSECHAR1J_1BMATUSE
J_1BOWNPROProduced in-house J_1BOWNPROCHAR1XFELD
J_1BMATORGOrigin of the material J_1BMATORGCHAR1J_1BMATORG
J_1BINDUSTMaterial CFOP category J_1BINDUS3CHAR2ALPHAJ_1BINDUS3
J_1BNBMBrazilian NCM Code J_1BNBMCO1CHAR16Assigned to domainSTEUC
J_1AINDXPInflation Index J_1AINDXPCHAR5Assigned to domainJ_1AINDXP
J_1AIDATEPInflation Index Date J_1AIDATEPDATS8J_1AUDATEP
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
.INCLU--AP 0
PEROP_BEGPeriod of Performance Start FM_PEROP_LOWDATS8DATUM
PEROP_ENDPeriod of Performance End FM_PEROP_HIGHDATS8DATUM
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
.INCLU--AP 0
ADVCODEAdvice Code /ISDFPS/ADVCODECHAR2/ISDFPS/ADVCODE2/ISDFPS/ADVCODE
STACODEStatus Code /ISDFPS/STACODECHAR2/ISDFPS/CSTACODE/ISDFPS/STACODE
BANFN_CSCross-System PReq Number /ISDFPS/BANFN_CSCHAR10ALPHABANFN
BNFPO_CSCross-System PReq Item /ISDFPS/BNFPO_CSNUMC5Assigned to domainBNFPO
ITEM_CSCross-System Item Category /ISDFPS/ITEM_CSCHAR1/ISDFPS/ITEM_CS
BSMNG_SNDPO Quantity Sender /ISDFPS/BSMNG_SNDQUAN13(3) MENG13
NO_MARD_DATANo Storage Location Data Exists for Material /ISDFPS/NO_MARD_DATACHAR1XFELD
.INCLU--AP 0
ADMOIModel ID code ADMOICHAR4ADMOI
ADPRIOrder priority ADPRICHAR3ADPRI
ADACNAircraft registration number ADACNCHAR5ADACN
PNSTATFlag for the S1PNSTAT message ADSPC_PNSTATCHAR1ADSPC_FLAG
.INCLU--AP 0
SERRUType of subcontracting SERRUCHAR1SERRUSERRU
DISUB_SOBKZSpecial stock indicator Subcontracting - for help DISUB_SOBKZ_LB2CHAR1DISUB_SOBKZ_LB
DISUB_PSPNRWBS Element DISUB_PS_POSNR2NUMC8PRPSABPSPPS_POSNR
DISUB_KUNNRCustomer Number DISUB_KUNNR2CHAR10KNA1ALPHAKUNNRKUNC_KUNNR
DISUB_VBELNSales Document DISUB_VBELN_VA2CHAR10VBUKALPHAVBELNAUN
DISUB_POSNRItem number of the SD document DISUB_POSNR2NUMC6VBUPPOSNR
DISUB_OWNEROwner of stock DISUB_OWNER_DCHAR10LFA1ALPHALIFNR
.INCLU--AP 0
IUID_RELEVANTIUID-Relevant IUID_RELEVANTCHAR1UID_RELEVANT

Key field Non-key field



How do I retrieve data from SAP table /ISDFPS/CS_EXLST using ABAP code

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

SELECT SINGLE *
FROM /ISDFPS/CS_EXLST
INTO CORRESPONDING FIELDS OF WA_/ISDFPS/CS_EXLST
WHERE...

How to access SAP table /ISDFPS/CS_EXLST

Within an ECC or HANA version of SAP you can also view further information about /ISDFPS/CS_EXLST 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!