SAP Table DM42V

Generated Table for View

DM42V (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DM42V to other SAP tables.

DM42V table fields

Field Data element Checktable Datatype Length Decimals
ENTIDTO Target entity type UDENTITO DM02L CHAR 26 0
AS4LOCAL Activation Status of a Repository Object AS4LOCAL CHAR 1 0
A Entry activated or generated in this form
L Lock entry (first N version)
N Entry edited, but not activated
S Previously active entry, backup copy
T Temporary version when editing
ENTIDFROM Start entity type UDENTIFR DM02L CHAR 26 0
EBROLNR Relationship role UDEBROLNR CHAR 1 0
SPRACHE Language Key SPRAS T002 LANG 1 0
FLG_DEF Flag: documentation object exists UDFLGDOC CHAR 1 0
NULL
X
FLG_COM Flag: documentation object exists UDFLGDOC CHAR 1 0
NULL
X
EBVAR Temporary reference for relationships UDRELREST CHAR 1 0
NULL No reference restriction
X Reference restriction
EBTYP Relationship type UDRELTYPE CHAR 1 0
A Aggregating
H Hierarchical
R Referential
X External
CARD1 Cardinality of a relationship UDCDLEFT CHAR 2 0
1 Each dependent entity has exactly one source entity
C Each dependent entity has a maximum of one source entity
CARD2 Cardinality of a relationship UDCDRIGHT CHAR 2 0
1 Each source entity has exactly one dependent entity
C Each source entity has a maximum of one dependent entity
N Each source entity has at least one dependent entity
CN Each source entity has any number of dependent entities
XX Relationship to objects not belonging to the SAP data model
FSTUSER Created by UDFUSER CHAR 12 0
FSTDATE Date on which the record was created UDFDATE DATS 8 0
FSTTIME Creation Time UDFTIME TIMS 6 0
LSTUSER Changed by UDLUSER CHAR 12 0
LSTDATE Changed on UDLDATE DATS 8 0
LSTTIME Last changed at UDLTIME TIMS 6 0
LOESCHZ Deletion Indicator UDLOEKZ CHAR 1 0
RELTXT1 Relationship name UDRELTXT CHAR 30 0
RELTXT2 Relationship name UDRELTXT CHAR 30 0

DM42V foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DM42V ENTIDFROM DM42V ENTIDFROM DM02L DM Entity Type ENTID
DM42V ENTIDFROM DM42V AS4LOCAL DM02L DM Entity Type AS4LOCAL
DM42V ENTIDTO DM42V AS4LOCAL DM02L DM Entity Type AS4LOCAL
DM42V ENTIDTO DM42V ENTIDTO DM02L DM Entity Type ENTID
DM42V SPRACHE DM42V SPRACHE T002 Language Keys (Component BC-I18) SPRAS