I_ConcurAcctgDocItmRelation

DDL: I_CONCURACCTGDOCITMRELATION Type: view_entity BASIC
9 Fields 1 Data Sources

Concur Accounting Document Item Relation

I_ConcurAcctgDocItmRelation is a Basic CDS View that provides data about "Concur Accounting Document Item Relation" in SAP S/4HANA. It reads from 1 data source (cte_d_acc_attr_i) and exposes 9 fields with key fields ConcurSystemKey, ConcurDocumentType, ConcurDocumentID, ConcurDocumentRevisionNumber, ConcurEntryIdentifier.

Data Sources (1)

SourceAliasJoin Type
cte_d_acc_attr_i cte_d_acc_attr_i from

Annotations (6)

NameValueLevelField
EndUserText.label Concur Accounting Document Item Relation view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConcurSystemKey system_key System Key
KEY ConcurDocumentType document_type Unit
KEY ConcurDocumentID document_id Snapshot ID
KEY ConcurDocumentRevisionNumber revision_id Revision ID
KEY ConcurEntryIdentifier entry_id Concur Node ID
KEY CompanyCode bukrs Value
KEY JournalEntry belnr SD Document
KEY ConcurDocumentFiscalYear gjahr Settlement Year
KEY ReferenceDocumentItem awitem Ref. Doc. Line Item

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 I_ConcurAcctgDocItmRelation.
-- 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.

CREATE VIEW I_ConcurAcctgDocItmRelation AS
SELECT
  system_key AS ConcurSystemKey,
  document_type AS ConcurDocumentType,
  document_id AS ConcurDocumentID,
  revision_id AS ConcurDocumentRevisionNumber,
  entry_id AS ConcurEntryIdentifier,
  bukrs AS CompanyCode,
  belnr AS JournalEntry,
  gjahr AS ConcurDocumentFiscalYear,
  awitem AS ReferenceDocumentItem
FROM cte_d_acc_attr_i
;

Learn More