/TDAG/CPA_ICMDS SAP (Customer MDS) Table details

Dictionary Type: Table
Description: Customer MDS




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




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

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

The /TDAG/CPA_ICMDS table consists of various fields, each holding specific information or linking keys about Customer 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_ICMDS 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
SPEC_IDAssignment of a Specification to a Customer MDS /TDAG/CPE_CUS_SPEC_IDCHAR12SPEC1ESDSUBIDES0
MODULE_IDMDS Module ID /TDAG/CPE_IMDSIDCHAR18
MODULE_VERSIONModule Version /TDAG/CPE_MODULE_VERSDEC6(3) DEC
NODE_IDNode ID /TDAG/CPE_IMDSNODECHAR18
MDS_TYPEMDS Type /TDAG/CPE_MDS_TYPECHAR1/TDAG/CPD_REQ_MDS_TYPE
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
MDS_STATUSMDS Status /TDAG/CPE_MDS_STATUSCHAR1/TDAG/CPD_MDS_STATUS
PREC_MDS_STATUSMDS Status /TDAG/CPE_MDS_STATUSCHAR1/TDAG/CPD_MDS_STATUS
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
OWN_ORGIDCompany ID / Organization ID /TDAG/CPE_OWN_ORG_IDCHAR9Assigned to domain/TDAG/CPD_ORGID/TDAG/CP02/TDAG/CPH_OWN_ORGIDS
OWN_CONTPERSOwn Contact Person ID /TDAG/CPE_OWN_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_STATUSFile Status /TDAG/CPE_FILE_STATUSCHAR1/TDAG/CPD_FILE_STATUS
APPL_LOGApplication Log /TDAG/CPE_APPLOGCHAR22SYSUUID_22
OUTG_TEMPLOutgoing Template /TDAG/CPE_TEMPL_IDCHAR10Assigned to domain/TDAG/RCSD_TEMPLID/TDAG/CP14/TDAG/CPH_TEMPLID
CREATE_DATECreation Date /TDAG/CPE_CREATE_DATEDATS8DATE
CHECK_DATECheck Date /TDAG/CPE_CHECK_DATEDATS8DATE
CHANGE_DATEChange Date /TDAG/CPE_CHG_DATEDATS8DATE
RELEASE_DATERelease Date /TDAG/CPE_RELEASE_DATEDATS8DATE
DATASH_TYPEData Sheet Type /TDAG/CPE_DATASHEET_TYPECHAR1/TDAG/CPD_DATASHEET_TYPE

Key field Non-key field



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

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

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

How to access SAP table /TDAG/CPA_ICMDS

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