/APE/C_ArchiveDocFull

DDL: /APE/C_ARCHIVEDOCFULL SQL: /APE/C_ARCHDOCF Type: view CONSUMPTION

Archiving Document with All Fields

/APE/C_ArchiveDocFull is a Consumption CDS View that provides data about "Archiving Document with All Fields" in SAP S/4HANA. It reads from 1 data source (/APE/I_ArchiveDoc) and exposes 23 fields with key field doc_uuid.

Data Sources (1)

SourceAliasJoin Type
/APE/I_ArchiveDoc /APE/I_ArchiveDoc from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName /APE/C_ARCHDOCF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Archiving Document with All Fields view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY doc_uuid doc_uuid UUID
arch_uuid arch_uuid
arch_tstmp arch_tstmp
client_uuid client_uuid
doc_no doc_no Posted Doc. No.
doc_type doc_type VAT Document Type
doc_tags doc_tags
doc_key_date doc_key_date
com_acc_uuid com_acc_uuid
bo_type_uuid bo_type_uuid
bo_uuid bo_uuid
trans_direct trans_direct
tech_msg_id tech_msg_id
bus_msg_id bus_msg_id
bus_status bus_status
doc_status doc_status VL Doc Status
test test Test
blocked blocked Complaint Locked
auth_grp auth_grp AuthorizGroup
created_at created_at Uploaded On
created_by created_by Version Created By
changed_at changed_at Timestamp
changed_by changed_by User Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view /APE/C_ArchiveDocFull.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: /APE/C_ARCHDOCF

CREATE VIEW /APE/C_ArchiveDocFull AS
SELECT
  doc_uuid,
  arch_uuid,
  arch_tstmp,
  client_uuid,
  doc_no,
  doc_type,
  doc_tags,
  doc_key_date,
  com_acc_uuid,
  bo_type_uuid,
  bo_uuid,
  trans_direct,
  tech_msg_id,
  bus_msg_id,
  bus_status,
  doc_status,
  test,
  blocked,
  auth_grp,
  created_at,
  created_by,
  changed_at,
  changed_by
FROM /APE/I_ArchiveDoc
;