Which tables does C_CADocumentTP use?

C_CADocumentTP reads from 1 data source(s): R_CADocumentTP.

How many fields does C_CADocumentTP have?

C_CADocumentTP has 130 fields. Key fields: CADocumentNumber.

C_CADocumentTP

DDL: C_CADOCUMENTTP Type: view_entity CONSUMPTION

Document

C_CADocumentTP is a Consumption CDS View that provides data about "Document" in SAP S/4HANA. It reads from 1 data source (R_CADocumentTP) and exposes 130 fields with key field CADocumentNumber. It has 7 associations to related views. It is exposed through 1 OData service (UI_CADOCUMENT_MNG).

Data Sources (1)

Source	Alias	Join Type
R_CADocumentTP	R_CADocumentTP	projection

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	C_CADocumentSumBPItem	_SumBPItem	`$projection.CADocumentNumber = _SumBPItem.CADocumentNumber`
[0..*]	C_CADocumentSumGLItem	_SumGLItem	`$projection.CADocumentNumber = _SumGLItem.CADocumentNumber`
[0..*]	C_CADocumentSumClearedItem	_SumClearedItem	`$projection.CADocumentNumber = _SumClearedItem.CAClearingDocumentNumber`
[0..*]	C_CADocumentIssue	_DocIssue	`$projection.CADocumentNumber = _DocIssue.CADocumentNumber`
[0..*]	C_CADocumentTaxGLItem	_TaxItem	`$projection.CADocumentNumber = _TaxItem.CADocumentNumber`
[0..*]	C_CADocumentClearedItem	_ClearedItem	`$projection.CADocumentNumber = _ClearedItem.CAClearingDocumentNumber`
[0..*]	C_CADocumentLinkedObject	_LinkedObject	`$projection.CADocumentNumber = _LinkedObject.CADocumentNumber`

Annotations (10)

Name	Value	Level
EndUserText.label	Document	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.representativeKey	CADocumentNumber	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view
Search.searchable	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_CADOCUMENT_MNG	UI_CADOCUMENT_MNG	V4	C1	NOT_RELEASED

Fields (130)

Key	Field	Source Table	Source Field
KEY	CADocumentNumber
	CreatedByUser		CreatedByUser
	CreationDate		CreationDate
	CreationTime		CreationTime
	CreationDateTime		CreationDateTime
	LastChangeDate		LastChangeDate
	LastChangeTime		LastChangeTime
	LastChangeDateTime		LastChangeDateTime
	CATaxCompanyCode		CATaxCompanyCode
	CATaxCodeWasExchanged		CATaxCodeWasExchanged
	TaxReportingDate		TaxReportingDate
	CAReconciliationKey		CAReconciliationKey
	CASeparateDocIsCreatedInGL		CASeparateDocIsCreatedInGL
	CARequestedPeriodForGLTransfer		CARequestedPeriodForGLTransfer
	CAApplicationArea		CAApplicationArea
	CADocumentOriginCode		CADocumentOriginCode
	CADocumentOriginCodeName
	TransactionCurrency		TransactionCurrency
	DocumentDate		DocumentDate
	CAPostingDate		CAPostingDate
	ExchangeRateDate		ExchangeRateDate
	CAReferenceDocument		CAReferenceDocument
	CAReturnReason		CAReturnReason
	CAReturnReasonName
	CAPostingReason		CAPostingReason
	ReferenceDocumentType		ReferenceDocumentType
	OriginalReferenceDocument		OriginalReferenceDocument
	CAReversedDocumentNumber		CAReversedDocumentNumber
	CAClearingInformation		CAClearingInformation
	CAReversalDocumentNumber		CAReversalDocumentNumber
	CADocumentSupplements		CADocumentSupplements
	LogicalSystem		LogicalSystem
	CAWorkflowCheckReason		CAWorkflowCheckReason
	CAWorkflowCheckProcess		CAWorkflowCheckProcess
	CADocumentTransactionClass		CADocumentTransactionClass
	CADocContainsCashFlowItems		CADocContainsCashFlowItems
	CADocumentClass		CADocumentClass
	CADocumentVersion		CADocumentVersion
	IsIndividualPosting		IsIndividualPosting
	CADocumentIsAged		CADocumentIsAged
	CADocumentType		CADocumentType
	CADocumentTypeName
	CAOpenAmountInTransactionCrcy	_DocUI	CAOpenAmountInTransactionCrcy
	CADueAmountInTransactionCrcy	_DocUI	CADueAmountInTransactionCrcy
	CAClrdAmountInTransactionCrcy	_DocUI	CAClrdAmountInTransactionCrcy
	NumberOfCADocumentBPItems	_DocUI	NumberOfCADocumentBPItems
	NumberOfCADocumentGLItems	_DocUI	NumberOfCADocumentGLItems
	HouseBank	_DocUI	HouseBank
	HouseBankAccount	_DocUI	HouseBankAccount
	CAMassRunDate	_DocUI	CAMassRunDate
	CAMassRunID	_DocUI	CAMassRunID
	CAPaymentDocument	_DocUI	CAPaymentDocument
	CAPaymentMethod	_DocUI	CAPaymentMethod
	CABankClearingAccount	_DocUI	CABankClearingAccount
	CompanyCode	_DocUI	CompanyCode
	CABankAccountHolderName	_DocUI	CABankAccountHolderName
	CAPaymentLot	_DocUI	CAPaymentLot
	CAPaymentLotItem	_DocUI	CAPaymentLotItem
	BankNumber	_DocUI	BankNumber
	BankAccount	_DocUI	BankAccount
	BankCountry	_DocUI	BankCountry
	BankDetailReference	_DocUI	BankDetailReference
	CANoteToPayeeInPayment	_DocUI	CANoteToPayeeInPayment
	LastName	_DocUI	LastName
	FirstName	_DocUI	FirstName
	CAPaymentDocumentReference	_DocUI	CAPaymentDocumentReference
	CAPaymentOrder	_DocUI	CAPaymentOrder
	CAPaymentOrderExternalRef	_DocUI	CAPaymentOrderExternalRef
	CAPaymentOrderStatus	_DocUI	CAPaymentOrderStatus
	CANetAmountInTransCurrency	_DocUI	CANetAmountInTransCurrency
	PaidItemDueDate	_DocUI	PaidItemDueDate
	ValueDate	_DocUI	ValueDate
	CAPaymentOrderExpirationDate	_DocUI	CAPaymentOrderExpirationDate
	BusinessPartner	_DocUI	BusinessPartner
	CAReturnLot	_DocUI	CAReturnLot
	CAItemNumberInReturnLot	_DocUI	CAItemNumberInReturnLot
	CAReturnReasonOfHouseBank	_DocUI	CAReturnReasonOfHouseBank
	CAReturnCharge1	_DocUI	CAReturnCharge1
	TaxCodeForFirstReturnCharge	_DocUI	TaxCodeForFirstReturnCharge
	CATaxAmountForReturnCharge1	_DocUI	CATaxAmountForReturnCharge1
	CAChargeAmountFromBank1	_DocUI	CAChargeAmountFromBank1
	TaxCodeForFirstBankCharge	_DocUI	TaxCodeForFirstBankCharge
	CATaxAmountOfBankCharge1	_DocUI	CATaxAmountOfBankCharge1
	CARepaymentRequest	_DocUI	CARepaymentRequest
	CAAmountInTransactionCurrency	_DocUI	CAAmountInTransactionCurrency
	CANetDueDate	_DocUI	CANetDueDate
	CAPaymentCompanyCode	_DocUI	CAPaymentCompanyCode
	ProfitCenter	_DocUI	ProfitCenter
	CARepaymentRequestDocument	_DocUI	CARepaymentRequestDocument
	PayeeBankNumber	_DocUI	PayeeBankNumber
	PayeeBankCountry	_DocUI	PayeeBankCountry
	PayeeBankAccount	_DocUI	PayeeBankAccount
	PayeeIBAN	_DocUI	PayeeIBAN
	PayeeSWIFTCode	_DocUI	PayeeSWIFTCode
	virtualUICT_PaymentLotOriginboole_d
	virtualUICT_PaymentRunOriginboole_d
	virtualUICT_PaymentOrderOriginboole_d
	virtualUICT_ReturnOriginboole_d
	virtualUICT_CADueAmountCriticalityint1
	virtualUICT_HideClearedItemsboole_d
	virtualUICT_HideBPItemsboole_d
	virtualUICT_HideGLItemsboole_d
	virtualUICT_HideReverseButtonboole_d
	virtualUICT_WriteOffButtonboole_d
	virtualUICT_UserIsAuthorizedboole_d
	_ApplArea		_ApplArea
	_BPItemPaytData		_BPItemPaytData
	_CAClearingInformation		_CAClearingInformation
	_CADocTransactionClass		_CADocTransactionClass
	_CADocumentClass		_CADocumentClass
	_CADocumentSupplement		_CADocumentSupplement
	_CADocumentVersion		_CADocumentVersion
	_CAPostingReason		_CAPostingReason
	_CARequestedSpecialPeriod		_CARequestedSpecialPeriod
	_CATaxSupplementStorageLoc		_CATaxSupplementStorageLoc
	_CompCode		_CompCode
	_Currency		_Currency
	_DocOriginCode		_DocOriginCode
	_GLItemPaytData		_GLItemPaytData
	_LogicalBPItem		_LogicalBPItem
	_WorkflowCheckProcess		_WorkflowCheckProcess
	_WorkflowCheckReason		_WorkflowCheckReason
	_DocType		_DocType
	_SumBPItem		_SumBPItem
	_SumGLItem		_SumGLItem
	_SumClearedItem		_SumClearedItem
	_DocIssue		_DocIssue
	_TaxItem		_TaxItem
	_ClearedItem		_ClearedItem
	_LinkedObject		_LinkedObject

@EndUserText.label: 'Document'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.representativeKey: 'CADocumentNumber'
@ObjectModel.semanticKey: ['CADocumentNumber']

@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]

@Metadata.allowExtensions: true
@Search.searchable: true
define root view entity C_CADocumentTP
  as projection on R_CADocumentTP

  association [0..*] to C_CADocumentSumBPItem      as _SumBPItem      on $projection.CADocumentNumber = _SumBPItem.CADocumentNumber
  association [0..*] to C_CADocumentSumGLItem      as _SumGLItem      on $projection.CADocumentNumber = _SumGLItem.CADocumentNumber
  association [0..*] to C_CADocumentSumClearedItem as _SumClearedItem on $projection.CADocumentNumber = _SumClearedItem.CAClearingDocumentNumber
  association [0..*] to C_CADocumentIssue          as _DocIssue       on $projection.CADocumentNumber = _DocIssue.CADocumentNumber
  association [0..*] to C_CADocumentTaxGLItem      as _TaxItem        on $projection.CADocumentNumber = _TaxItem.CADocumentNumber
  association [0..*] to C_CADocumentClearedItem    as _ClearedItem    on $projection.CADocumentNumber = _ClearedItem.CAClearingDocumentNumber
  association [0..*] to C_CADocumentLinkedObject   as _LinkedObject   on $projection.CADocumentNumber = _LinkedObject.CADocumentNumber


{
  key     cast ( CADocumentNumber as opbel_gfn_kk preserving type ) as CADocumentNumber,
          CreatedByUser,
          CreationDate,
          CreationTime,
          CreationDateTime,
          LastChangeDate,
          LastChangeTime,
          LastChangeDateTime,
          CATaxCompanyCode,
          CAStorageLocationOfTaxSuplmnt,
          CATaxCodeWasExchanged,
          TaxReportingDate,
          CAReconciliationKey,
          CASeparateDocIsCreatedInGL,
          CARequestedPeriodForGLTransfer,
          @ObjectModel.sort.enabled: false
          CAApplicationArea,
          @ObjectModel.foreignKey.association: '_DocOriginCode'
          @ObjectModel.text.element: ['CADocumentOriginCodeName']
          CADocumentOriginCode,
          @ObjectModel.sort.enabled: false
          _DocOriginCode._Text[1:Language=$session.system_language].CADocumentOriginCodeName,
          @ObjectModel.foreignKey.association: '_Currency'
          @Consumption.valueHelpDefinition: [{entity: { name: 'C_CurrencyValueHelp', element: 'Currency'}}]
          TransactionCurrency,
          DocumentDate,
          CAPostingDate,
          ExchangeRateDate,
          CAReferenceDocument,
          @ObjectModel.text.element: ['CAReturnReasonName']
          CAReturnReason,
          @ObjectModel.sort.enabled: false
          _CAReturnReason[1:HouseBank=HouseBank]._Text[1:Language=$session.system_language].CAReturnReasonName,
          CAPostingReason,
          ReferenceDocumentType,
          OriginalReferenceDocument,
          CAReversedDocumentNumber,
          CAClearingInformation,
          CAReversalDocumentNumber,
          CADocumentSupplements,
          LogicalSystem,
          CAWorkflowCheckReason,
          CAWorkflowCheckProcess,
          @ObjectModel.sort.enabled: false
          CADocumentTransactionClass,
          CADocContainsCashFlowItems,
          @ObjectModel.sort.enabled: false
          CADocumentClass,
          CADocumentVersion,
          IsIndividualPosting,
          CADocumentIsAged,
          @ObjectModel.foreignKey.association: '_DocType'
          CADocumentType,
          
          @ObjectModel.sort.enabled: false
          _DocType._Text[1:Language=$session.system_language].CADocumentTypeName,
          
          @ObjectModel.sort.enabled: false
          @Semantics.amount.currencyCode: 'TransactionCurrency'
          _DocUI.CAOpenAmountInTransactionCrcy,
          @ObjectModel.sort.enabled: false
          @Semantics.amount.currencyCode: 'TransactionCurrency'
          _DocUI.CADueAmountInTransactionCrcy,
          @ObjectModel.sort.enabled: false
          @Semantics.amount.currencyCode: 'TransactionCurrency'
          _DocUI.CAClrdAmountInTransactionCrcy,
          
          @UI.hidden: true
          _DocUI.NumberOfCADocumentBPItems,
          @UI.hidden: true
          _DocUI.NumberOfCADocumentGLItems,
          
          





          //Payment Info Common fields

          @ObjectModel.sort.enabled: false
          _DocUI.HouseBank,
          @ObjectModel.sort.enabled: false
          _DocUI.HouseBankAccount,
          @ObjectModel.sort.enabled: false
          _DocUI.CAMassRunDate,
          @ObjectModel.sort.enabled: false
          _DocUI.CAMassRunID,
          //_DocUI.CAMassRunDateAndID,

          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentDocument,
          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentMethod,
          @ObjectModel.sort.enabled: false
          _DocUI.CABankClearingAccount,
          @ObjectModel.sort.enabled: false
          _DocUI.CompanyCode,
          @ObjectModel.sort.enabled: false
          _DocUI.CABankAccountHolderName,

          //Payment Info Payment Lot

          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentLot,
          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentLotItem,
          @ObjectModel.sort.enabled: false
          _DocUI.BankNumber,
          @ObjectModel.sort.enabled: false
          _DocUI.BankAccount,
          @ObjectModel.sort.enabled: false
          _DocUI.BankCountry,
          @ObjectModel.sort.enabled: false
          _DocUI.BankDetailReference,
          @ObjectModel.sort.enabled: false
          _DocUI.CANoteToPayeeInPayment,

          //Payment Info Payment Run

          @ObjectModel.sort.enabled: false
          _DocUI.LastName,
          @ObjectModel.sort.enabled: false
          _DocUI.FirstName,
          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentDocumentReference,

          //Payment Info Payment Order

          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentOrder,
          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentOrderExternalRef,
          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentOrderStatus,
          @ObjectModel.sort.enabled: false
          _DocUI.CANetAmountInTransCurrency,
          @ObjectModel.sort.enabled: false
          _DocUI.PaidItemDueDate,
          @ObjectModel.sort.enabled: false
          _DocUI.ValueDate,
          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentOrderExpirationDate,
          @ObjectModel.sort.enabled: false
          _DocUI.BusinessPartner,

          //Payment Info Return

          @ObjectModel.sort.enabled: false
          _DocUI.CAReturnLot,
          @ObjectModel.sort.enabled: false
          _DocUI.CAItemNumberInReturnLot,
          @ObjectModel.sort.enabled: false
          _DocUI.CAReturnReasonOfHouseBank,
          @ObjectModel.sort.enabled: false
          _DocUI.CAReturnCharge1,
          @ObjectModel.sort.enabled: false
          _DocUI.TaxCodeForFirstReturnCharge,
          @ObjectModel.sort.enabled: false
          _DocUI.CATaxAmountForReturnCharge1,
          @ObjectModel.sort.enabled: false
          _DocUI.CAChargeAmountFromBank1,
          @ObjectModel.sort.enabled: false
          _DocUI.TaxCodeForFirstBankCharge,
          @ObjectModel.sort.enabled: false
          _DocUI.CATaxAmountOfBankCharge1,

          //Payment Info Repayment Request

          @ObjectModel.sort.enabled: false
          _DocUI.CARepaymentRequest,
          @ObjectModel.sort.enabled: false
          _DocUI.CAStatusOfRepaymentRequest,
          @ObjectModel.sort.enabled: false
          _DocUI.CAAmountInTransactionCurrency,
          @ObjectModel.sort.enabled: false
          _DocUI.CANetDueDate,
          @ObjectModel.sort.enabled: false
          _DocUI.CAPaymentCompanyCode,
          @ObjectModel.sort.enabled: false
          _DocUI.ProfitCenter,
          @ObjectModel.sort.enabled: false
          _DocUI.CARepaymentRequestDocument,
          //As the posting date here is the same as above, this one can be outlined

          //_DocUI.CAPostingDate,

          @ObjectModel.sort.enabled: false
          _DocUI.PayeeBankNumber,
          @ObjectModel.sort.enabled: false
          _DocUI.PayeeBankCountry,
          @ObjectModel.sort.enabled: false
          _DocUI.PayeeBankAccount,
          @ObjectModel.sort.enabled: false
          _DocUI.PayeeIBAN,
          @ObjectModel.sort.enabled: false
          _DocUI.PayeeSWIFTCode,



          //UI control fields

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_PaymentLotOrigin       : boole_d,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_PaymentRunOrigin       : boole_d,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_PaymentOrderOrigin     : boole_d,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_ReturnOrigin           : boole_d,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_RepaymentRequestOrigin : boole_d,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_CADueAmountCriticality : int1,
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_HideClearedItems : boole_d,
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_HideBPItems : boole_d,
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_HideGLItems : boole_d,
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_HideReverseButton : boole_d,
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual UICT_WriteOffButton : boole_d,
  

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'
          @UI.hidden: true
  virtual CAMassRunDateAndID          : mass_run_date_and_id_kk,
  
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'    
          @UI.hidden: true     
  virtual UICT_UserIsAuthorized : boole_d,
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'    
          @UI.hidden: true     
  virtual UICT_HideDisputeCreationButton : boole_d,

          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'    
          @UI.hidden: true     
  virtual CADisputeCaseBusinessPartner : fica_gpart,
  
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_FKK_CADOCUMENT_EXIT'    
          @UI.hidden: true     
  virtual CADisputeCaseContractAccount : fica_vkont,

          /* Associations */
          _ApplArea,
          _BPItem : redirected to composition child C_CADocumentBPItemTP,
          _BPItemPaytData,
          @ObjectModel.sort.enabled: false
          _CAClearingInformation,
          _CADocTransactionClass,
          _CADocumentClass,
          _CADocumentSupplement,
          _CADocumentVersion,
          @ObjectModel.sort.enabled: false
          _CAPostingReason,
          _CARequestedSpecialPeriod,
          _CATaxSupplementStorageLoc,
          _CompCode,
          @ObjectModel.sort.enabled: false
          _Currency,
          _DocOriginCode,
          _GLItem : redirected to composition child C_CADocumentGLItemTP,
          _GLItemPaytData,
          _LogicalBPItem,
          _WorkflowCheckProcess,
          _WorkflowCheckReason,
          @ObjectModel.sort.enabled: false
          _DocType,
          //,

          _SumBPItem,
          _SumGLItem,
          _SumClearedItem,
          _DocIssue,
          _TaxItem,
          _ClearedItem,
          _LinkedObject


}

Depth:

C_CADocumentTP view_entity

R_CADocumentTP view_entity