Z_EXPORT_USER 
Default Table Name  Z_EXPORT_USER 
Definition 
 Name: User Export Control .     Description: This table is used to keep track of the steps during export process and which worktable the connection has been assigned.
 

Z_EXPORT_USER Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EMPL_ID(PK)    VARCHAR2(20)  NO 
Name: Employee ID. Description: Employee ID of the logged-in user
 
BATCH_ID(PK)    VARCHAR2(10)  NO 
Name: Batch ID. Description: The ID of the process that currently has the timesheet unavailable
 
WORK_TABLE_NO    NUMBER(2, 0)  YES 
Name: Work Table Number. Description: Indicates the worktable in which the data for this user is saved. Valid values are 1 - 10, indicating 10 work tables.
 
EXPORT_STEP_NO    NUMBER(2, 0)  YES 
Name: Export Step Number. Description: Indicates the step number during which the export process was aborted. Valid values are 1 – 3.
 
S_TYPE_CD(PK)    VARCHAR2(1)  NO 
 
IN_PROCESS_FL    VARCHAR2(1)  YES 
Name: In-Process Timesheet Export Flag. Description: Indicates whether the system is exporting approved timesheets or in-process timesheets.
 

Z_EXPORT_USER Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0104  PrimaryKey  EMPL_ID, BATCH_ID, S_TYPE_CD 
SI_0078  Index  WORK_TABLE_NO, S_TYPE_CD 

Z_EXPORT_USER Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable