Which tables does I_CADisputedInvcgDoc use?

I_CADisputedInvcgDoc reads from 2 data source(s): I_CAInvcgDocHeader, P_CADisputedInvcgDoc.

How many fields does I_CADisputedInvcgDoc have?

I_CADisputedInvcgDoc has 83 fields. Key fields: CaseUUID, CAInvoicingDocument.

I_CADisputedInvcgDoc

DDL: I_CADISPUTEDINVCGDOC Type: view_entity COMPOSITE Package: ODATA_O2C_FICA_DISPUTE_MANAGE

Disputed invoicing document

I_CADisputedInvcgDoc is a Composite CDS View that provides data about "Disputed invoicing document" in SAP S/4HANA. It reads from 2 data sources (I_CAInvcgDocHeader, P_CADisputedInvcgDoc) and exposes 83 fields with key fields CaseUUID, CAInvoicingDocument. Part of development package ODATA_O2C_FICA_DISPUTE_MANAGE.

Data Sources (2)

Source	Alias	Join Type
I_CAInvcgDocHeader	_CAInvcgDocHeader	inner
P_CADisputedInvcgDoc	_DisputedInvcgDoc	from

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Disputed invoicing document	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (83)

Key	Field	Source Table	Source Field
KEY	CaseUUID	P_CADisputedInvcgDoc	CaseUUID
KEY	CAInvoicingDocument	P_CADisputedInvcgDoc	CAInvoicingDocument
	CAOfficialDocumentNumber	I_CAInvcgDocHeader	CAOfficialDocumentNumber
	BusinessPartner	I_CAInvcgDocHeader	BusinessPartner
	ContractAccount	I_CAInvcgDocHeader	ContractAccount
	CAInvcgType	I_CAInvcgDocHeader	CAInvcgType
	CAInvcgDocPeriodDate	I_CAInvcgDocHeader	CAInvcgDocPeriodDate
	DocumentDate	I_CAInvcgDocHeader	DocumentDate
	TransactionCurrency	I_CAInvcgDocHeader	TransactionCurrency
	CAAmountInTransactionCurrency	I_CAInvcgDocHeader	CAAmountInTransactionCurrency
	CAInvcgProcess	I_CAInvcgDocHeader	CAInvcgProcess
	CAInvcgDocumentType	I_CAInvcgDocHeader	CAInvcgDocumentType
	CADunningCounter	I_CAInvcgDocHeader	CADunningCounter
	CAInvcgDocHasControlDoc	I_CAInvcgDocHeader	CAInvcgDocHasControlDoc
	ApplicationForm	I_CAInvcgDocHeader	ApplicationForm
	CAInvcgDocumentPrintDate	I_CAInvcgDocHeader	CAInvcgDocumentPrintDate
	CAInvcgDocIsLockedForPrinting	I_CAInvcgDocHeader	CAInvcgDocIsLockedForPrinting
	CANetDueDate	I_CAInvcgDocHeader	CANetDueDate
	CAInvcgDocumentReversalReason	I_CAInvcgDocHeader	CAInvcgDocumentReversalReason
	CAInvcgIsDocumentPosted	I_CAInvcgDocHeader	CAInvcgIsDocumentPosted
	CAInvcgIsDocumentPreliminary	I_CAInvcgDocHeader	CAInvcgIsDocumentPreliminary
	CAInvcgIsDocumentSimulated	I_CAInvcgDocHeader	CAInvcgIsDocumentSimulated
	CAPostingDate	I_CAInvcgDocHeader	CAPostingDate
	CAApplicationArea	I_CAInvcgDocHeader	CAApplicationArea
	CAInvcgTechnicalDocumentType	I_CAInvcgDocHeader	CAInvcgTechnicalDocumentType
	CAInvcgTargetProcess	I_CAInvcgDocHeader	CAInvcgTargetProcess
	CAInvcgMasterDataType	I_CAInvcgDocHeader	CAInvcgMasterDataType
	AltvContractAcctForCollvBills	I_CAInvcgDocHeader	AltvContractAcctForCollvBills
	CASubstituteDocumentNumber	I_CAInvcgDocHeader	CASubstituteDocumentNumber
	CreatedByUser	I_CAInvcgDocHeader	CreatedByUser
	CAInvcgCreationDate	I_CAInvcgDocHeader	CAInvcgCreationDate
	CAInvcgCreationTime	I_CAInvcgDocHeader	CAInvcgCreationTime
	CAInvcgDocCreationMode	I_CAInvcgDocHeader	CAInvcgDocCreationMode
	CAInvcgNmbrOfInvoicingDocItems	I_CAInvcgDocHeader	CAInvcgNmbrOfInvoicingDocItems
	CAInvcgDocInternalNumber	I_CAInvcgDocHeader	CAInvcgDocInternalNumber
	CAReconciliationKey	I_CAInvcgDocHeader	CAReconciliationKey
	CACashDiscountDueDate	I_CAInvcgDocHeader	CACashDiscountDueDate
	CACashDiscountRate	I_CAInvcgDocHeader	CACashDiscountRate
	CAInvcgPreliminaryCategory	I_CAInvcgDocHeader	CAInvcgPreliminaryCategory
	CAPrelimInvcgDocValue	I_CAInvcgDocHeader	CAPrelimInvcgDocValue
	CAPreliminaryInvcgDocStatus	I_CAInvcgDocHeader	CAPreliminaryInvcgDocStatus
	CAInvcgCategory	I_CAInvcgDocHeader	CAInvcgCategory
	CAInvcgReversalDocument	I_CAInvcgDocHeader	CAInvcgReversalDocument
	CAInvcgReversedDocument	I_CAInvcgDocHeader	CAInvcgReversedDocument
	CAInvcgCorrectionCategory	I_CAInvcgDocHeader	CAInvcgCorrectionCategory
	CAPaymentMethod	I_CAInvcgDocHeader	CAPaymentMethod
	CAPaymentFormNumber	I_CAInvcgDocHeader	CAPaymentFormNumber
	FormIDForAttachedPaymentMedium	I_CAInvcgDocHeader	FormIDForAttachedPaymentMedium
	CAKeyIdentification	I_CAInvcgDocHeader	CAKeyIdentification
	CAPartnerSettlementRule	I_CAInvcgDocHeader	CAPartnerSettlementRule
	CompanyCode	I_CAInvcgDocHeader	CompanyCode
	BusinessPlace	I_CAInvcgDocHeader	BusinessPlace
	CAContract	I_CAInvcgDocHeader	CAContract
	CASubApplication	I_CAInvcgDocHeader	CASubApplication
	CAInvcgBaseDate	I_CAInvcgDocHeader	CAInvcgBaseDate
	CAInvcgDocPeriodCategory	I_CAInvcgDocHeader	CAInvcgDocPeriodCategory
	CAInvcgDocPeriodStartDate	I_CAInvcgDocHeader	CAInvcgDocPeriodStartDate
	CAInvcgDocHasChargeOrDiscItems	I_CAInvcgDocHeader	CAInvcgDocHasChargeOrDiscItems
	CAInvcgBolloTaxPostStatus	I_CAInvcgDocHeader	CAInvcgBolloTaxPostStatus
	CAInvcgDocIsPartOfList	I_CAInvcgDocHeader	CAInvcgDocIsPartOfList
	CAInvcgDocHasObjectRelation	I_CAInvcgDocHeader	CAInvcgDocHasObjectRelation
	CAInvcgDocHasSEPAPreNotif	I_CAInvcgDocHeader	CAInvcgDocHasSEPAPreNotif
	CAInvcgDocExternal	I_CAInvcgDocHeader	CAInvcgDocExternal
	CAInvcgDocumentTypeText
	CAInvcgProcessText
	CAInvcgTypeText
	CAInvcgCategoryText
	CAInvcgDocTechDocTypeText
	CAInvcgTargetProcText
	CAInvcgMasterDataTypeText
	CAInvcgDocCreationModeText
	CAInvcgPreliminaryCategoryTxt
	CAPreliminaryInvcgDocStatusTxt
	CAInvcgDocReversalReasonText
	CAInvcgCorrectionCatText
	CAInvcgDocLockedForPrintText
	CAInvcgPeriodCatText
	CAInvcgDocChrgDiscItemsText
	CAInvcgBolloTaxPostStatText
	CAInvcgDocPartOfListText
	CompanyCodeName
	_BusinessPartner	I_CAInvcgDocHeader	_BusinessPartner
	_ContractAccountHeader	I_CAInvcgDocHeader	_ContractAccountHeader

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Disputed invoicing document'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
define view entity I_CADisputedInvcgDoc as select from P_CADisputedInvcgDoc as _DisputedInvcgDoc
  inner join I_CAInvcgDocHeader as _CAInvcgDocHeader on _DisputedInvcgDoc.CAInvoicingDocument = _CAInvcgDocHeader.CAInvoicingDocument
{
      key _DisputedInvcgDoc.CaseUUID,
      key _DisputedInvcgDoc.CAInvoicingDocument,

      //EXBEL

      _CAInvcgDocHeader.CAOfficialDocumentNumber,

      _CAInvcgDocHeader.BusinessPartner,

      //VKONT

      _CAInvcgDocHeader.ContractAccount,


      //INV_TYPE

      _CAInvcgDocHeader.CAInvcgType,

      //INVPERIOD

      _CAInvcgDocHeader.CAInvcgDocPeriodDate,

      //BLDAT

      _CAInvcgDocHeader.DocumentDate,

      //Amount and Currency

      _CAInvcgDocHeader.TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      _CAInvcgDocHeader.CAAmountInTransactionCurrency,

      //INV_PROCESS

      _CAInvcgDocHeader.CAInvcgProcess,

      //DOCTYPE

      _CAInvcgDocHeader.CAInvcgDocumentType,

      //MAZAE

      _CAInvcgDocHeader.CADunningCounter,

      //CFCSIMULATED

      _CAInvcgDocHeader.CAInvcgDocHasControlDoc,

      //FORMKEY

      _CAInvcgDocHeader.ApplicationForm,

      //PRINTDATE

      _CAInvcgDocHeader.CAInvcgDocumentPrintDate,

      //PRINTLOCK

      _CAInvcgDocHeader.CAInvcgDocIsLockedForPrinting,

      //FAEDN - Due date for net payment

      _CAInvcgDocHeader.CANetDueDate,

      //REVREASON - Reversal Reason

      _CAInvcgDocHeader.CAInvcgDocumentReversalReason,

      //INVOICED

      _CAInvcgDocHeader.CAInvcgIsDocumentPosted,

      //PRELIMINARY

      _CAInvcgDocHeader.CAInvcgIsDocumentPreliminary,

      //SIMULATED

      _CAInvcgDocHeader.CAInvcgIsDocumentSimulated,

      //BUDAT

      _CAInvcgDocHeader.CAPostingDate,

      //APPLK

      _CAInvcgDocHeader.CAApplicationArea,

      //TECHDOCTYPE

      _CAInvcgDocHeader.CAInvcgTechnicalDocumentType,

      //TARGPROCESS

      _CAInvcgDocHeader.CAInvcgTargetProcess,

      //MDCAT


      _CAInvcgDocHeader.CAInvcgMasterDataType,

      //ABWVK

      @Consumption.semanticObject: 'ContractAccount'
      _CAInvcgDocHeader.AltvContractAcctForCollvBills,

      //ABWBL

      _CAInvcgDocHeader.CASubstituteDocumentNumber,

      //CRNAME

      @UI.hidden: true
      _CAInvcgDocHeader.CreatedByUser,

      //CRDATE

      @Consumption.filter.selectionType: #INTERVAL
      _CAInvcgDocHeader.CAInvcgCreationDate,

      //CRTIME

      _CAInvcgDocHeader.CAInvcgCreationTime,

      //CRMODE

      _CAInvcgDocHeader.CAInvcgDocCreationMode,

      //RECNUM

      _CAInvcgDocHeader.CAInvcgNmbrOfInvoicingDocItems,

      //INVRUNNO

      _CAInvcgDocHeader.CAInvcgDocInternalNumber,

      //FIKEY

      _CAInvcgDocHeader.CAReconciliationKey,

      //FAEDS

      _CAInvcgDocHeader.CACashDiscountDueDate,

      //SKTPZ

      _CAInvcgDocHeader.CACashDiscountRate,

      //PRLINV_CAT

      _CAInvcgDocHeader.CAInvcgPreliminaryCategory,
      
      //PRLINV_CNT

      _CAInvcgDocHeader.CAPrelimInvcgDocValue,
      
      //PRLINV_STATUS

      _CAInvcgDocHeader.CAPreliminaryInvcgDocStatus,

      //INV_CATEGORY

      _CAInvcgDocHeader.CAInvcgCategory,

      //REVERSALDOC

      _CAInvcgDocHeader.CAInvcgReversalDocument,

      //REVERSEDDOC

      _CAInvcgDocHeader.CAInvcgReversedDocument,

      //CORRCAT

      _CAInvcgDocHeader.CAInvcgCorrectionCategory,

      //PYMET

      _CAInvcgDocHeader.CAPaymentMethod,

      //NRZAS

      _CAInvcgDocHeader.CAPaymentFormNumber,

      //ZLSCH

      _CAInvcgDocHeader.FormIDForAttachedPaymentMedium,

      //EXKID

      _CAInvcgDocHeader.CAKeyIdentification,

      //PTSRL

      _CAInvcgDocHeader.CAPartnerSettlementRule,

      //BUKRS

      _CAInvcgDocHeader.CompanyCode,

      //BUPLA

      _CAInvcgDocHeader.BusinessPlace,

      //VTREF

      _CAInvcgDocHeader.CAContract,

      //SUBAP

      _CAInvcgDocHeader.CASubApplication,

      //INVOICE_BASEDATE

      _CAInvcgDocHeader.CAInvcgBaseDate,

      //INVPERCAT

      _CAInvcgDocHeader.CAInvcgDocPeriodCategory,

      //INVPERIOD

      _CAInvcgDocHeader.CAInvcgDocPeriodStartDate,

      //CHGDOC_EX

      _CAInvcgDocHeader.CAInvcgDocHasChargeOrDiscItems,

      //BOLLOTAX

      _CAInvcgDocHeader.CAInvcgBolloTaxPostStatus,

      //XSUBINV

      _CAInvcgDocHeader.CAInvcgDocIsPartOfList,

      //XINVDOC_X

      _CAInvcgDocHeader.CAInvcgDocHasObjectRelation,

      //SEPA_PRENOT

      _CAInvcgDocHeader.CAInvcgDocHasSEPAPreNotif,

      //EXT_INVDOCNO

      _CAInvcgDocHeader.CAInvcgDocExternal,

      _CAInvcgDocHeader._CAInvcgDocumentType._CAInvcgDocumentTypeText[1: Language=$session.system_language].CAInvcgDocumentTypeText,
      _CAInvcgDocHeader._CAInvcgProcess._CAInvcgProcessText[1: Language=$session.system_language].CAInvcgProcessText,
      _CAInvcgDocHeader._CAInvcgType._CAInvcgTypeText[1: Language=$session.system_language].CAInvcgTypeText,
      _CAInvcgDocHeader._CAInvcgCategory._CAInvcgCategoryText[1: Language=$session.system_language].CAInvcgCategoryText,
      cast(_CAInvcgDocHeader._CAInvcgDocTechDocType._CAInvcgDocTechDocTypeText[1: Language=$session.system_language].CAInvcgDocTechDocTypeText as description_kk) as CAInvcgDocTechDocTypeText,
      _CAInvcgDocHeader._CAInvcgTargetProc._CAInvcgTargetProcText[1: Language=$session.system_language].CAInvcgTargetProcText,
      cast(_CAInvcgDocHeader._CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText as description_kk) as CAInvcgMasterDataTypeText,
      cast(_CAInvcgDocHeader._CAInvcgDocCreationMode._CAInvcgDocCreationModeText[1: Language=$session.system_language].CAInvcgDocCreationModeText as description_kk) as CAInvcgDocCreationModeText,
      _CAInvcgDocHeader._CAInvcgPreliminaryCategory._Text[1: Language=$session.system_language].CAInvcgPreliminaryCategoryTxt,
      _CAInvcgDocHeader._CAPreliminaryInvcgDocStatus._Text[1: Language=$session.system_language].CAPreliminaryInvcgDocStatusTxt,
      _CAInvcgDocHeader._CAInvcgDocReversalReason._CAInvcgDocReversalReasonText[1: Language=$session.system_language].CAInvcgDocReversalReasonText,
      cast(_CAInvcgDocHeader._CAInvcgCorrectionCat._CAInvcgCorrectionCatText[1: Language=$session.system_language].CAInvcgCorrectionCatText as description_kk) as CAInvcgCorrectionCatText,
      cast(_CAInvcgDocHeader._CAInvcgDocLockedforPrint._CAInvcgDocLockedForPrintText[1: Language=$session.system_language].CAInvcgDocLockedForPrintText as description_kk) as CAInvcgDocLockedForPrintText,
      _CAInvcgDocHeader._CAInvcgPeriodCat._CAInvcgPeriodCatText[1: Language=$session.system_language].CAInvcgPeriodCatText,
      cast(_CAInvcgDocHeader._CAInvcgDocChrgDiscItems._CAInvcgDocChrgDiscItemsText[1: Language=$session.system_language].CAInvcgDocChrgDiscItemsText as description_kk) as CAInvcgDocChrgDiscItemsText,
      cast(_CAInvcgDocHeader._CAInvcgBolloTaxPostStatus._CAInvcgBolloTaxPostStatText[1: Language=$session.system_language].CAInvcgBolloTaxPostStatText as description_kk) as CAInvcgBolloTaxPostStatText,
      cast(_CAInvcgDocHeader._CAInvcgDocPartOfList._CAInvcgDocPartOfListText[1: Language=$session.system_language].CAInvcgDocPartOfListText as description_kk) as CAInvcgDocPartOfListText,
      _CAInvcgDocHeader._CompanyCode.CompanyCodeName,
      
      _CAInvcgDocHeader._BusinessPartner,
      _CAInvcgDocHeader._ContractAccountHeader
}

Depth:

I_CADisputedInvcgDoc view_entity

P_CADisputedInvcgDoc view_entity
I_CAInvcgDocHeader view_entity

R_CADisputedInvcgDocTP view_entity