Which tables does C_ConcurIncomingDocumentTP use?

C_ConcurIncomingDocumentTP reads from 1 data source(s): R_ConcurIncomingDocumentTP.

C_ConcurIncomingDocumentTP

Q: How many fields does C_ConcurIncomingDocumentTP have?

C_ConcurIncomingDocumentTP has 50 fields. Key fields: ConcurSystemKey, ConcurDocumentType, ConcurDocumentID, ConcurDocumentRevisionNumber.

DDL: C_CONCURINCOMINGDOCUMENTTP Type: view_entity CONSUMPTION Package: CTE_RAP_DOC_MON

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)

Source	Alias	Join Type
R_ConcurIncomingDocumentTP	R_ConcurIncomingDocumentTP	projection

Associations (2)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Service	Binding	Version	Contract	Release
UI_CONCURINCOMINGDOCUMENTTP	UI_CONCURINCOMINGDOCUMENTTP	V4	C1	NOT_RELEASED

Fields (50)

Key	Field	Source Table	Source Field	Description
KEY	ConcurSystemKey	ConcurIncomingDocument	ConcurSystemKey
KEY	ConcurDocumentType	ConcurIncomingDocument	ConcurDocumentType
KEY	ConcurDocumentID	ConcurIncomingDocument	ConcurDocumentID
KEY	ConcurDocumentRevisionNumber	ConcurIncomingDocument	ConcurDocumentRevisionNumber
	ConcurDocumentStatus		ConcurDocumentStatus
	CompanyCode		CompanyCode
	ConcurIsAcknowledged		ConcurIsAcknowledged
	ConcurIsConfirmed		ConcurIsConfirmed
	ConcurIsPaymentSent		ConcurIsPaymentSent
	ConcurDocCustModifType		ConcurDocCustModifType
	ConcurDocumentName		ConcurDocumentName
	ConcurCreatedAtDateTime		ConcurCreatedAtDateTime
	ConcurUpdatedAtDateTime		ConcurUpdatedAtDateTime
	PaymentStatus		PaymentStatus
	BusinessPartner		BusinessPartner
	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
	BusinessPartnerFullName	_BusinessPartner	BusinessPartnerFullName
	SystemConnectionDescription1	_ConcurSystem	SystemConnectionDescription1	System Connection Description
	ConcurDocCustModifTypeName	_ConcurDocumentCustModifText	ConcurDocCustModifTypeName
	virtualConcurDocCntntIsAuthzdxfeld
	virtualConcurDocSendConfIsHidnxfeld
	virtualConcurDocResendConfIsHidnxfeld
	virtualConcurDocAttchIsHidnxfeld
	virtualConcurDocSendAcknIsHidnxfeld
	virtualConcurDocResendAcknIsHidnxfeld
	virtualConcurDocumentBlockIsHiddenxfeld
	virtualConcurDocumentSetNewIsHiddenxfeld
	virtualConcurDocSetObsoleteIsHiddenxfeld
	virtualConcurDocRvsObsltIsHidnxfeld
	virtualConcurDocRvsPostgIsHidnxfeld
	virtualConcurDocumentPostIsHiddenxfeld
	virtualConcurDocObsltNoteIsRqdxfeld
	virtualConcurDocHasMltplRevsnxfeld

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Concur Posting Documents Monitor'
@Metadata.allowExtensions: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.semanticKey: [ 'ConcurDocumentID' ]
@VDM.viewType:#CONSUMPTION
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define root view entity C_ConcurIncomingDocumentTP
  provider contract transactional_query
  as projection on R_ConcurIncomingDocumentTP as ConcurIncomingDocument
  association [0..*] to C_ConcurDocumentJournalEntry as _ConcurDocumentJournalEntry on  _ConcurDocumentJournalEntry.ConcurSystemKey              = $projection.ConcurSystemKey
                                                                                    and _ConcurDocumentJournalEntry.ConcurDocumentID             = $projection.ConcurDocumentID
                                                                                    and _ConcurDocumentJournalEntry.ConcurDocumentType           = $projection.ConcurDocumentType
                                                                                    and _ConcurDocumentJournalEntry.ConcurDocumentRevisionNumber = $projection.ConcurDocumentRevisionNumber
  association [0..*] to C_ConcurDocumentProtocol_2   as _ConcurDocumentProtocol_2   on  $projection.ConcurSystemKey              = _ConcurDocumentProtocol_2.ConcurSystemKey
                                                                                    and $projection.ConcurDocumentType           = _ConcurDocumentProtocol_2.ConcurDocumentType
                                                                                    and $projection.ConcurDocumentID             = _ConcurDocumentProtocol_2.ConcurDocumentID
                                                                                    and $projection.ConcurDocumentRevisionNumber = _ConcurDocumentProtocol_2.ConcurDocumentRevisionNumber


{
          @ObjectModel.text.element: [ 'SystemConnectionDescription1' ]
  key     ConcurIncomingDocument.ConcurSystemKey                                                          as ConcurSystemKey,

          @ObjectModel.text.element: [ 'ConcurDocumentTypeName' ]
  key     ConcurIncomingDocument.ConcurDocumentType                                                       as ConcurDocumentType,

  key     ConcurIncomingDocument.ConcurDocumentID                                                         as ConcurDocumentID,

  key     ConcurIncomingDocument.ConcurDocumentRevisionNumber                                             as ConcurDocumentRevisionNumber,


          @ObjectModel.text.element: [ 'ConcurDocEnhancedStatusText' ]
          ConcurDocumentStatus,

          @ObjectModel.text.element: [ 'CompanyCodeName' ]
          CompanyCode,

          ConcurIsAcknowledged,

          ConcurIsConfirmed,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          ConcurIsPaymentSent,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          @ObjectModel.text.element: [ 'ConcurDocCustModifTypeName' ]
          ConcurDocCustModifType,

          ConcurDocumentName,

          ConcurCreatedAtDateTime                                                                         as ConcurCreatedAtDateTime,

          ConcurUpdatedAtDateTime                                                                         as ConcurUpdatedAtDateTime,

          //          @ObjectModel.filter.enabled: false

          //          DocRefKey,


          @ObjectModel.text.element: [ 'ConcurDocPayStatusText' ]
          PaymentStatus,

          @ObjectModel.text.element: [ 'BusinessPartnerFullName' ]
          BusinessPartner,

          AttachmentInd                                                                                   as AttachmentInd,

          AttachmentTotalNumber,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          ConcurDocumentKey,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          ReportNumber,

          /* Associations */
          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _BusinessPartner,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurSystem,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _CompanyCode,

          //          _ConcurConfigRefKeyType,


          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocPaymentStatus,

          //          _ConcurDocRefKeyType,


          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocumentJournalEntry,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocumentAttachment,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocumentCustModif,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocumentPaymentInfo,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocumentProtocol,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocumentProtocol_2,

          @ObjectModel.filter.enabled: false
          @Semantics.text:true
          @UI.hidden: true
          _ConcurDocumentStatus.DomainFixValueName                                                        as ConcurDocumentStatusText,

          @ObjectModel.filter.enabled: false
          @Semantics.text:true
          _ConcurDocPaymentStatus.DomainFixValueName                                                      as ConcurDocPayStatusText,

          //          _ConcurDocRefKeyType.DomainFixValueName             as ConcurDocRefKeyTypeText,

          //          _ConcurConfigRefKeyType.DomainFixValueName          as ConcurConfigRefKeyTypeText,


          //          @EndUserText.label: 'Document Type Description'

          @ObjectModel.filter.enabled: false
          @Semantics.text:true
          cast( _ConcurDocumentType.ConcurDocumentTypeName as cte_fnd_rap_doc_type_text preserving type ) as ConcurDocumentTypeName,

          @ObjectModel.filter.enabled: false
          _CompanyCode.CompanyCodeName                                                                    as CompanyCodeName,

          @ObjectModel.filter.enabled: false
          _BusinessPartner.BusinessPartnerFullName                                                        as BusinessPartnerFullName,

          @EndUserText.label: 'System Connection Description'
          @ObjectModel.filter.enabled: false
          _ConcurSystem.SystemConnectionDescription1                                                      as SystemConnectionDescription1,

          @ObjectModel.filter.enabled: false
          @ObjectModel.sort.enabled: false
          _ConcurDocumentCustModifText.ConcurDocCustModifTypeName                                         as ConcurDocCustModifTypeName,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocCntntIsAuthzd         : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocSendConfIsHidn        : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocResendConfIsHidn      : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocAttchIsHidn           : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocSendAcknIsHidn        : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocResendAcknIsHidn      : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocumentBlockIsHidden    : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocumentUnblockIsHidden  : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocumentSetNewIsHidden   : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocSetObsoleteIsHidden   : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocRvsObsltIsHidn        : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocRvsPostgIsHidn        : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocumentPaymentIsHidden  : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocumentPostIsHidden     : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocSendPaytNotifIsHidden : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocResendPaytNotifIsHidn : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocNrOfAttch             : cte_fnd_post_doc_at_amount,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocObsltNoteIsRqd        : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
  virtual ConcurDocHasMltplRevsn         : xfeld,
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
          @ObjectModel.sort.transformedBy:  'ABAP:CL_CTE_RAP_DOC_MONI_SORTER'
  virtual ConcurDocumentReferenceNumber  : cte_fnd_post_doc_key,
          @Semantics.text:true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CTE_RAP_DOC_MONI_DYN_FIELDS'
          @ObjectModel.sort.transformedBy:  'ABAP:CL_CTE_RAP_DOC_MONI_SORTER'
  virtual ConcurDocEnhancedStatusText    : cte_fnd_rap_doc_status_text
}

Depth:

C_ConcurIncomingDocumentTP view_entity

R_ConcurIncomingDocumentTP view_entity