/TDAG/CPA_ISMDS SAP (Supplier MDS) Table details

Dictionary Type: Table
Description: Supplier MDS




ABAP Code to SELECT data from /TDAG/CPA_ISMDS
Related tables to /TDAG/CPA_ISMDS
Access table /TDAG/CPA_ISMDS




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

/TDAG/CPA_ISMDS is a standard SAP Table which is used to store Supplier MDS data and is available within R/3 SAP systems depending on the version and release level.

The /TDAG/CPA_ISMDS table consists of various fields, each holding specific information or linking keys about Supplier MDS data available in SAP. These include MANDT (Client), GUID (Globally Unique Identifier), CRDAT (Creation Date), CRNAM (Creation User).. 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: Cannot Be Enhanced


SAP /TDAG/CPA_ISMDS 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
GUIDGlobally Unique Identifier GUIDRAW16
CRDATCreation Date /TDAG/RCSE_CRDATDATS8DATUM
CRNAMCreation User /TDAG/RCSE_CRNAMCHAR12USNAM
CRTSTMPCreation Time Stamp /TDAG/RCSE_CRTSTMPDEC15TZNTSTMPS
UPDDATUpdate Date /TDAG/RCSE_UPDDATDATS8DATUM
UPDNAMUpdate User /TDAG/RCSE_UPDNAMCHAR12USNAM
UPDTSTMPUpdate Time Stamp /TDAG/RCSE_UPDTSTMPDEC15TZNTSTMPS
DELFLGDeletion Indicator ESEDELFLGCHAR1ESDFLAG
MODULE_IDMDS Module ID /TDAG/CPE_IMDSIDCHAR18
MODULE_VERSIONModule Version /TDAG/CPE_MODULE_VERSDEC6(3) DEC
NODE_IDNode ID /TDAG/CPE_IMDSNODECHAR18
PART_NOPart/Item/Material Number /TDAG/CPE_PARTNOCHAR50TEXT50
PART_NO_NORMPart/Item/Material Number /TDAG/CPE_PARTNOCHAR50TEXT50
PART_NAMEArticle Name /TDAG/CPE_PARTNAMECHAR250TEXT_250
PART_NAME_NORMArticle Name /TDAG/CPE_PARTNAMECHAR250TEXT_250
SPEC_IDAssignment of a Specification to a Supplier MDS /TDAG/CPE_SUP_SPEC_IDCHAR12SPEC1ESDSUBIDES0
MDS_TYPEMDS Type /TDAG/CPE_MDS_TYPECHAR1/TDAG/CPD_REQ_MDS_TYPE
MDS_STATUSMDS Status /TDAG/CPE_MDS_STATUS_SUPCHAR1/TDAG/CPD_MDS_STATUS_SUP
CHECK_STATUSCheck Status /TDAG/CPE_CHECK_STATUSCHAR1/TDAG/CPD_CHECK_STATUS
CHECK_DATECheck Date /TDAG/CPE_CHECK_DATEDATS8DATE
CREATE_DATECreation Date /TDAG/CPE_CREATE_DATEDATS8DATE
CHANGE_DATEChange Date /TDAG/CPE_CHG_DATEDATS8DATE
RELEASE_DATERelease Date /TDAG/CPE_RELEASE_DATEDATS8DATE
SUPPL_COMPSupplier Company ID /TDAG/CPE_SUPP_COMP_IDCHAR9Assigned to domain/TDAG/CPD_ORGID/TDAG/CPH_ORGIDS
SUPPL_ORGCompany ID / Organization ID /TDAG/CPE_COMPANY_IDCHAR9Assigned to domain/TDAG/CPD_ORGID/TDAG/CPH_ORGIDS
SUPPL_CONTPERSSupplier Contact Person ID /TDAG/CPE_SUPP_CONT_IDCHAR9Assigned to domain/TDAG/CPD_PERSID/TDAG/CP01/TDAG/CPH_OWN_CONTPERS
COMM_STATUSCommunication Status /TDAG/CPE_COMM_STATUSCHAR1/TDAG/CPD_COMM_STATUS
IMPORT_STATUSImport Status /TDAG/CPE_IMPORT_STATUSCHAR1/TDAG/CPD_IMPORT_STATUS
APPL_LOGApplication Log /TDAG/CPE_APPLOGCHAR22SYSUUID_22
SEND_DATETransmission Date /TDAG/CPE_SEND_DATEDATS8DATE
SEND_TIMETransmission Time /TDAG/CPE_SEND_TIMETIMS6TIME
DEVSAMPLEREPDevelopment Sample Report /TDAG/CPE_DEVSAMPLEREPCHAR1YESNO
RF_DOCTYPEDocument Type DOKARCHAR3Assigned to domainDOKARCV2
RF_DOCNUMBERDocument number DOKNRCHAR25Assigned to domainALPHADOKNRCV1
RF_DOCPARTDocument Part DOKTL_DCHAR3DOKTLCV4
RF_DOCVERSIONDocument Version DOKVRCHAR2DOKVRCV3
SF_DOCTYPEDocument Type DOKARCHAR3Assigned to domainDOKARCV2
SF_DOCNUMBERDocument number DOKNRCHAR25Assigned to domainALPHADOKNRCV1
SF_DOCPARTDocument Part DOKTL_DCHAR3DOKTLCV4
SF_DOCVERSIONDocument Version DOKVRCHAR2DOKVRCV3

Key field Non-key field



How do I retrieve data from SAP table /TDAG/CPA_ISMDS using ABAP code

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

SELECT SINGLE *
FROM /TDAG/CPA_ISMDS
INTO CORRESPONDING FIELDS OF WA_/TDAG/CPA_ISMDS
WHERE...

How to access SAP table /TDAG/CPA_ISMDS

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