SAP EDISCACT DiscDoc.: Activities Table data and field list

EDISCACT is a standard SAP Table which is used to store DiscDoc.: Activities data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The EDISCACT table consists of various fields, each holding specific information or linking keys about DiscDoc.: Activities data available in SAP. These include DISCNO (Disconnection document number), DISCACT (Disconnection activity number), DISCACTTYP (Disconnection Activity Category), ACTDATE (Date of a disconnection activity)... 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. .

EDISCACT table Technical Details:

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 (character-type)


SAP EDISCACT table 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 EDISCACT 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
MANDTClient MANDTCLNT3T000MANDT
DISCNODisconnection document number DISCNOCHAR12EDISCDOCALPHADISCNOEDNEDISCDOCSUM
DISCACTDisconnection activity number DISCACTNUMC4DISCACT
DISCACTTYPDisconnection Activity Category DISCACTTYPCHAR2DISCACTTYP
ACTDATEDate of a disconnection activity DISCACTDATDATS8DISCACTDAT
ACTTIMETime of a disconnection activity DISCACTTIMTIMS6DISCACTTIM
ORDSTATEStatus of disconnection or reconnection order EDC_ORDSTATNUMC2EDISCORDSTATEEDC_ORDSTAT
NEWORDERGenerate new order EDC_NEWORDERCHAR1EBA_FLAG
ORDERNUMOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
BC_CONTACTBusiness Partner Contact BC_CONTACTCHAR12Assigned to domainALPHACT_CONTACTBPC
CHARGE_OPBELContract account document number EDC_OPBELCHAR12Assigned to domainALPHAOPBEL_KK8OBERDK
ORDERACTDisconnection activity number DISCACTNUMC4DISCACT
BBPCHANGEDBudget billing plan changed EDC_BBPCHANGEDCHAR1EBA_FLAG
DISCCANCELDReverse indicator for disconnection activity DISCCANCELEDCHAR1KENNZX
VACANTACTIndicate whether vacant status disconnection produced act. VACANTACTCHAR1KENNZX
AMIACTIndicates an AMI Disconnection Activity EDC_AMIACTCHAR1KENNZX
AMIREQIDRequest ID used in message transmission to or from MDUS EDC_AMIREQIDNUMC12EDC_AMIREQID
AMIFLAGGEDAMI processing flag EDC_AMIFLAGCHAR1KENNZX
INTERIM_BILLINGCreate interim billing from disconnection EDC_INTERIM_BILLING_FLAGCHAR1KENNZX
APRVL_REQDDisconnection or reconnection: Notification required EDC_APPROVAL_REQDCHAR1KENNZX
APRVD_DATEAgreed date for disconnection or reconnection EDC_APPROVED_DATEDATS8DISCACTDAT
APRVD_TIMEAgreed time for disconnection or reconnection EDC_APPROVED_TIMETIMS6DISCACTTIM
APRVL_DATENotification date for disconnection or reconnection EDC_APPROVAL_DATEDATS8DISCACTDAT
APRVL_TIMENotification time for disconnection or reconnection EDC_APPROVAL_TIMETIMS6DISCACTTIM
APRVL_AGENTNotification agent EDC_APPROVAL_AGENTCHAR12Assigned to domainXUBNAME
WORKITEMNotification Work Item ID EDC_APPROVAL_WORKITEMCHAR32SYSUUID_C
APRVL_SRCNotification source EDC_APPROVAL_SOURCECHAR2EDC_APRVL_SRC
ORDERCODEOrder code for creating service orders EDC_ORDERCODECHAR4CHAR004
ORDERWERKPM planning plant for disconnection order EDC_ORDERWERKCHAR4Assigned to domainWERKS
CREA_USERFirst changed by SWO_CREABYCHAR12Assigned to domainXUBNAME
CREA_DATEDate of first change SWO_CREADADATS8SYDATS
CHAN_USERLast changed by SWO_CHANBYCHAR12Assigned to domainXUBNAME
CHAN_DATEDate of Last Change SWO_CHANDADATS8SYDATS

Key field Non-key field



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

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

SELECT SINGLE *
FROM EDISCACT
INTO CORRESPONDING FIELDS OF WA_EDISCACT
WHERE...

How to access SAP table EDISCACT

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

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