SAP table EPDPROD (IS-U Master Data Generator: Master Data Template)

SAP table EPDPROD has 3 primary key fields being MANDT,ACTSTAT,PRODID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
ACTSTAT Activation Status of Entry CHAR 1 0 EBA_ACTIVE
Undefined
A Active
N Revised version
PRODID Node to Describe Master Data Template CHAR 20 0 EPD_PRODID
CRM_ACTSTAT Activation Status of Entry CHAR 1 0 EPD_ACTIVE
Undefined
A Active
F Released
O Obsolete
ISU_ACTSTAT Activation Status of Entry CHAR 1 0 EBA_ACTIVE
Undefined
A Active
N Revised version
MEDIA_ACTSTAT IS-M: Status of Master Data Template CHAR 1 0 EPD_MEDIA_ACTIVE
Undefined
A Active
F Released
O Obsolete
AUTONOM Master Data Template Category Can Be Created Independently CHAR 1 0 EPD_AUTONOM
TYPEID Master Data Template Category CHAR 20 0 EPD_TYPEID
FKEY_TYPEID Master Data Template Category of External Key Attribute CHAR 20 0 EPD_FKEY_TYPEID
SD_TEMPLATE Indicator: Master Data Template Can Be Used in SD CHAR 1 0 EPD_SDTEMPLATE
CRM_TEMPLATE Indicator: Master Data Template Can Be Used in CRM CHAR 1 0 EPD_CRMTEMPLATE
INDUSTRY Industry Sector (Master Data Generator) CHAR 1 0 EMDGEN_INDUSTRY
Utilities
M Media
U Utilities
MATERIAL Material Number CHAR 40 0 MATNR
PRODUCT Utility Product CHAR 18 0 EPD_SALES_PRODUCT
CRM_PRODUCT CRM Product CHAR 40 0 ESALES_CRM_PRODUCT
CRM_PRODUCT_GUID GUID in 'RAW' format RAW 16 0 GUID_16
CRM_M_PROD_STATE Current Status of Multiple CRM Prod. Allocation to Template CHAR 1 0 EPD_MP_VALID
VALIDFROM IS-U Master Data Template Description: Valid From DATS 8 0 EPD_VALIDFROM
VALIDTO IS-U Master Data Template Description: Valid To DATS 8 0 EPD_VALIDTO
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
IS_VALID Boolean Variable for Object Status Definition CHAR 1 0 EPD_VALID
False
X True
MEDIA_PATTERN IS-M: Parameter for Generation Model CHAR 32 0 EPD_MEDIA_PATTERN
IGNORE_DEVICES Boolean Variable for Object Status Definition CHAR 1 0 EPD_VALID
False
X True
OUCONT MDG: Indicator for Master Agreement CHAR 1 0 EPD_OUCONT
MIO_PRODUCT Template for Creating Contract CHAR 40 0 ECAMIO_PRODUCT
MIO_ACTSTAT Activation Status for Contract Template CHAR 1 0 EPM_ACTIVE
Undefined
E Increased Efficiency Released
CRM_SYSID Name of SAP System CHAR 8 0 SYSYSID
CRM_MANDT Client ID CLNT 3 0 SYMANDT
PFCGROUP Price Simulation Group CHAR 10 0 ISU_PFCGROUP