I_ELECTRONICDOC
eDocument
I_ELECTRONICDOC is a CDS View in S/4HANA. eDocument. It contains 38 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_EDocCockpitRelevantOvw | view_entity | from | CONSUMPTION | Entity for Create Electronic Documents |
| C_ElectronicDocByMetaStatus | view_entity | from | CONSUMPTION | eDocument by Metastatus |
| C_ElectronicDocCockpitFilter | view | from | CONSUMPTION | Mng Electronic Documents: Filter |
| C_ElectronicDocCockpitHistory | view | union | CONSUMPTION | Mng Electronic Documents: History |
| C_ElectronicDocMetaStatusSum | view_entity | from | CONSUMPTION | eDocument Metastatus Summary |
| I_EDCElectronicDocRelation | view_entity | from | BASIC | eDocument Consistency Relationship |
| I_ElectronicDocCockpitList | view | from | COMPOSITE | Electronic Document List |
| I_ElectronicDocCockpitList | view | union | COMPOSITE | Electronic Document List |
| I_ElectronicDocFile | view | from | COMPOSITE | eDocument File |
| I_ElectronicDocFile | view | union_all | COMPOSITE | eDocument File |
| I_PE_ElectronicDocument | view_entity | from | COMPOSITE | Peru eDocument |
| I_TR_ElectronicDocInvoice | view | from | COMPOSITE | eDocument Turkey eInvoice |
| R_EDCElectronicDoc | view_entity | from | BASIC | EDC Electronic Doc |
Fields (38)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ElectronicDocCompanyCode | ElectronicDocCompanyCode | 7 |
| KEY | ElectronicDocCountry | Country,ElectronicDocCountry | 6 |
| KEY | ElectronicDocInterfaceType | ElectronicDocInterfaceType | 3 |
| KEY | ElectronicDocProcess | ElectronicDocProcess | 6 |
| KEY | ElectronicDocSourceKey | ElectronicDocSourceKey | 4 |
| KEY | ElectronicDocSourceType | ElectronicDocSourceType | 4 |
| KEY | ElectronicDocType | ElectronicDocType | 4 |
| KEY | ElectronicDocUUID | ElectronicDocUUID | 6 |
| ElectronicDocApprovalIDValue | ElectronicDocApprovalIDValue | 1 | |
| ElectronicDocClassName | ElectronicDocClassName | 1 | |
| ElectronicDocCreatedByUser | ElectronicDocCreatedByUser | 3 | |
| ElectronicDocCreationDate | ElectronicDocCreationDate | 5 | |
| ElectronicDocCreationTime | ElectronicDocCreationTime | 3 | |
| ElectronicDocFileUUID | ElectronicDocFileUUID | 2 | |
| ElectronicDocHasError | ElectronicDocHasError | 2 | |
| ElectronicDocInterfaceID | ElectronicDocInterfaceID | 2 | |
| ElectronicDocInterfaceUUID | ElectronicDocInterfaceUUID | 1 | |
| ElectronicDocInterfaceVersion | ElectronicDocInterfaceVersion | 2 | |
| ElectronicDocIsArchPrprocgDone | ElectronicDocIsArchPrprocgDone | 2 | |
| ElectronicDocIsCntdInArchive | ElectronicDocIsCntdInArchive | 2 | |
| ElectronicDocIsContingency | ElectronicDocIsContingency | 2 | |
| ElectronicDocLastChangeDate | ElectronicDocLastChangeDate | 3 | |
| ElectronicDocLastChangedByUser | ElectronicDocLastChangedByUser | 2 | |
| ElectronicDocLastChangeTime | ElectronicDocLastChangeTime | 3 | |
| ElectronicDocLastProcStep | ElectronicDocLastProcStep | 2 | |
| ElectronicDocLastProcStepVar | ElectronicDocLastProcStepVar | 2 | |
| ElectronicDocLogicalSystem | ElectronicDocLogicalSystem | 1 | |
| ElectronicDocMetaStatus | ElectronicDocMetaStatus | 3 | |
| ElectronicDocPostingDate | ElectronicDocPostingDate | 3 | |
| ElectronicDocProcessForStatus | ElectronicDocProcessForStatus | 1 | |
| ElectronicDocProcessStatus | ElectronicDocProcessStatus | 4 | |
| ElectronicDocProcessVersion | ElectronicDocProcessVersion | 2 | |
| ElectronicDocReferenceProcess | ElectronicDocReferenceProcess | 2 | |
| ElectronicDocRefSqncNmbr | ElectronicDocRefSqncNmbr | 1 | |
| ElectronicDocResponseCodeValue | ElectronicDocResponseCodeValue | 1 | |
| ElectronicDocSequenceNmbr | ElectronicDocSequenceNmbr | 2 | |
| ElectronicDocSrceCreatedByUser | ElectronicDocSrceCreatedByUser | 3 | |
| ElectronicDocStatus | ElectronicDocStatus | 2 |
@AbapCatalog: {
sqlViewName: 'IEDOCUMENT',
compiler.compareFilter: true,
preserveKey: true
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'eDocument'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
dataClass: #TRANSACTIONAL,
serviceQuality: #A,
sizeCategory: #M
}
define view I_ElectronicDoc
as select from edocument
{
key edoc_guid as ElectronicDocUUID,
seq_no as ElectronicDocSequenceNmbr,
bukrs as ElectronicDocCompanyCode,
land as ElectronicDocCountry,
source_type as ElectronicDocSourceType,
source_key as ElectronicDocSourceKey,
edoc_type as ElectronicDocType,
proc_status as ElectronicDocProcessStatus,
logsys as ElectronicDocLogicalSystem,
changed_by as ElectronicDocLastChangedByUser,
change_date as ElectronicDocLastChangeDate,
change_time as ElectronicDocLastChangeTime,
created_by as ElectronicDocCreatedByUser,
create_date as ElectronicDocCreationDate,
create_time as ElectronicDocCreationTime,
source_created_by as ElectronicDocSrceCreatedByUser,
process as ElectronicDocProcess,
last_procstep as ElectronicDocLastProcStep,
last_procstep_variant as ElectronicDocLastProcStepVar,
error_flag as ElectronicDocHasError,
process_version as ElectronicDocProcessVersion,
docref_seqnr as ElectronicDocRefSqncNmbr,
status as ElectronicDocStatus,
posting_date as ElectronicDocPostingDate,
contingency as ElectronicDocIsContingency,
ref_process as ElectronicDocReferenceProcess,
edocument_class as ElectronicDocClassName,
archive_prep as ElectronicDocIsArchPrprocgDone,
interface_type as ElectronicDocInterfaceType,
approval_id as ElectronicDocApprovalIDValue,
interface_guid as ElectronicDocInterfaceUUID,
file_guid as ElectronicDocFileUUID,
response_code as ElectronicDocResponseCodeValue,
interface_id as ElectronicDocInterfaceID,
int_version as ElectronicDocInterfaceVersion,
count_archive as ElectronicDocIsCntdInArchive,
metastatus as ElectronicDocMetaStatus,
case when edocument.ref_process is initial then edocument.process
else edocument.ref_process
end as ElectronicDocProcessForStatus
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EDOCUMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/