C_ConcurIncomingDocumentTP

DDL: C_CONCURINCOMINGDOCUMENTTP Type: view_entity CONSUMPTION Package: CTE_RAP_DOC_MON
50 Fields 1 Data Sources 2 Associations 1 OData Services

Concur Posting Documents Monitor

C_ConcurIncomingDocumentTP is a Consumption CDS View that provides data about "Concur Posting Documents Monitor" in SAP S/4HANA. It reads from 1 data source (R_ConcurIncomingDocumentTP) and exposes 50 fields with key fields ConcurSystemKey, ConcurDocumentType, ConcurDocumentID, ConcurDocumentRevisionNumber. It has 2 associations to related views. It is exposed through 1 OData service (UI_CONCURINCOMINGDOCUMENTTP). Part of development package CTE_RAP_DOC_MON.

Data Sources (1)

SourceAliasJoin Type
R_ConcurIncomingDocumentTP R_ConcurIncomingDocumentTP projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_ConcurDocumentJournalEntry _ConcurDocumentJournalEntry _ConcurDocumentJournalEntry.ConcurSystemKey = $projection.ConcurSystemKey and _ConcurDocumentJournalEntry.ConcurDocumentID = $projection.ConcurDocumentID and _ConcurDocumentJournalEntry.ConcurDocumentType = $projection.ConcurDocumentType and _ConcurDocumentJournalEntry.ConcurDocumentRevisionNumber = $projection.ConcurDocumentRevisionNumber
[0..*] C_ConcurDocumentProtocol_2 _ConcurDocumentProtocol_2 $projection.ConcurSystemKey = _ConcurDocumentProtocol_2.ConcurSystemKey and $projection.ConcurDocumentType = _ConcurDocumentProtocol_2.ConcurDocumentType and $projection.ConcurDocumentID = _ConcurDocumentProtocol_2.ConcurDocumentID and $projection.ConcurDocumentRevisionNumber = _ConcurDocumentProtocol_2.ConcurDocumentRevisionNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Concur Posting Documents Monitor view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CONCURINCOMINGDOCUMENTTP UI_CONCURINCOMINGDOCUMENTTP V4 C1 NOT_RELEASED

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY ConcurSystemKey ConcurIncomingDocument ConcurSystemKey
KEY ConcurDocumentType ConcurIncomingDocument ConcurDocumentType
KEY ConcurDocumentID ConcurIncomingDocument ConcurDocumentID
KEY ConcurDocumentRevisionNumber ConcurIncomingDocument ConcurDocumentRevisionNumber
ConcurDocumentStatus ConcurDocumentStatus
CompanyCode CompanyCode Receiver Company Code
ConcurIsAcknowledged ConcurIsAcknowledged
ConcurIsConfirmed ConcurIsConfirmed
ConcurIsPaymentSent ConcurIsPaymentSent
ConcurDocCustModifType ConcurDocCustModifType
ConcurDocumentName ConcurDocumentName
ConcurCreatedAtDateTime ConcurCreatedAtDateTime
ConcurUpdatedAtDateTime ConcurUpdatedAtDateTime
PaymentStatus PaymentStatus
BusinessPartner BusinessPartner Issuing Authority
AttachmentInd AttachmentInd
AttachmentTotalNumber AttachmentTotalNumber
ConcurDocumentKey ConcurDocumentKey
ReportNumber ReportNumber
_BusinessPartner _BusinessPartner
_ConcurSystem _ConcurSystem
_CompanyCode _CompanyCode
_ConcurDocPaymentStatus _ConcurDocPaymentStatus
_ConcurDocumentJournalEntry _ConcurDocumentJournalEntry
_ConcurDocumentAttachment _ConcurDocumentAttachment
_ConcurDocumentCustModif _ConcurDocumentCustModif
_ConcurDocumentPaymentInfo _ConcurDocumentPaymentInfo
_ConcurDocumentProtocol _ConcurDocumentProtocol
_ConcurDocumentProtocol_2 _ConcurDocumentProtocol_2
ConcurDocumentStatusText _ConcurDocumentStatus DomainFixValueName
ConcurDocPayStatusText _ConcurDocPaymentStatus DomainFixValueName
ConcurDocumentTypeName
CompanyCodeName _CompanyCode CompanyCodeName Company Name
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
SystemConnectionDescription1 _ConcurSystem SystemConnectionDescription1 System Connection Description
ConcurDocCustModifTypeName _ConcurDocumentCustModifText ConcurDocCustModifTypeName
virtualConcurDocCntntIsAuthzdxfeld
virtualConcurDocSendConfIsHidnxfeld
virtualConcurDocResendConfIsHidnxfeld
virtualConcurDocAttchIsHidnxfeld
virtualConcurDocSendAcknIsHidnxfeld
virtualConcurDocResendAcknIsHidnxfeld
virtualConcurDocumentBlockIsHiddenxfeld
virtualConcurDocumentSetNewIsHiddenxfeld
virtualConcurDocSetObsoleteIsHiddenxfeld
virtualConcurDocRvsObsltIsHidnxfeld
virtualConcurDocRvsPostgIsHidnxfeld
virtualConcurDocumentPostIsHiddenxfeld
virtualConcurDocObsltNoteIsRqdxfeld
virtualConcurDocHasMltplRevsnxfeld

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 C_ConcurIncomingDocumentTP.
-- 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 C_ConcurIncomingDocumentTP AS
SELECT
  ConcurIncomingDocument.ConcurSystemKey AS ConcurSystemKey,
  ConcurIncomingDocument.ConcurDocumentType AS ConcurDocumentType,
  ConcurIncomingDocument.ConcurDocumentID AS ConcurDocumentID,
  ConcurIncomingDocument.ConcurDocumentRevisionNumber AS ConcurDocumentRevisionNumber,
  ConcurDocumentStatus,
  CompanyCode,
  ConcurIsAcknowledged,
  ConcurIsConfirmed,
  ConcurIsPaymentSent,
  ConcurDocCustModifType,
  ConcurDocumentName,
  ConcurCreatedAtDateTime,
  ConcurUpdatedAtDateTime,
  PaymentStatus,
  BusinessPartner,
  AttachmentInd,
  AttachmentTotalNumber,
  ConcurDocumentKey,
  ReportNumber,
  _ConcurDocumentStatus.DomainFixValueName AS ConcurDocumentStatusText,
  _ConcurDocPaymentStatus.DomainFixValueName AS ConcurDocPayStatusText,
  cast( _ConcurDocumentType.ConcurDocumentTypeName as cte_fnd_rap_doc_type_text preserving type ) AS ConcurDocumentTypeName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _ConcurSystem.SystemConnectionDescription1 AS SystemConnectionDescription1,
  _ConcurDocumentCustModifText.ConcurDocCustModifTypeName AS ConcurDocCustModifTypeName,
  virtual ConcurDocCntntIsAuthzd : xfeld AS virtualConcurDocCntntIsAuthzdxfeld,
  virtual ConcurDocSendConfIsHidn : xfeld AS virtualConcurDocSendConfIsHidnxfeld,
  virtual ConcurDocResendConfIsHidn : xfeld AS virtualConcurDocResendConfIsHidnxfeld,
  virtual ConcurDocAttchIsHidn : xfeld AS virtualConcurDocAttchIsHidnxfeld,
  virtual ConcurDocSendAcknIsHidn : xfeld AS virtualConcurDocSendAcknIsHidnxfeld,
  virtual ConcurDocResendAcknIsHidn : xfeld AS virtualConcurDocResendAcknIsHidnxfeld,
  virtual ConcurDocumentBlockIsHidden : xfeld AS virtualConcurDocumentBlockIsHiddenxfeld,
  virtual ConcurDocumentSetNewIsHidden : xfeld AS virtualConcurDocumentSetNewIsHiddenxfeld,
  virtual ConcurDocSetObsoleteIsHidden : xfeld AS virtualConcurDocSetObsoleteIsHiddenxfeld,
  virtual ConcurDocRvsObsltIsHidn : xfeld AS virtualConcurDocRvsObsltIsHidnxfeld,
  virtual ConcurDocRvsPostgIsHidn : xfeld AS virtualConcurDocRvsPostgIsHidnxfeld,
  virtual ConcurDocumentPostIsHidden : xfeld AS virtualConcurDocumentPostIsHiddenxfeld,
  virtual ConcurDocObsltNoteIsRqd : xfeld AS virtualConcurDocObsltNoteIsRqdxfeld,
  virtual ConcurDocHasMltplRevsn : xfeld AS virtualConcurDocHasMltplRevsnxfeld
FROM R_ConcurIncomingDocumentTP
LEFT OUTER JOIN C_ConcurDocumentJournalEntry AS _ConcurDocumentJournalEntry ON _ConcurDocumentJournalEntry.ConcurSystemKey = ConcurSystemKey AND _ConcurDocumentJournalEntry.ConcurDocumentID = ConcurDocumentID AND _ConcurDocumentJournalEntry.ConcurDocumentType = ConcurDocumentType AND _ConcurDocumentJournalEntry.ConcurDocumentRevisionNumber = ConcurDocumentRevisionNumber  -- association [0..*]
LEFT OUTER JOIN C_ConcurDocumentProtocol_2 AS _ConcurDocumentProtocol_2 ON ConcurSystemKey = _ConcurDocumentProtocol_2.ConcurSystemKey AND ConcurDocumentType = _ConcurDocumentProtocol_2.ConcurDocumentType AND ConcurDocumentID = _ConcurDocumentProtocol_2.ConcurDocumentID AND ConcurDocumentRevisionNumber = _ConcurDocumentProtocol_2.ConcurDocumentRevisionNumber  -- association [0..*]
;

Learn More