Which tables does C_CANotDisputedInvcgDocItem use?

C_CANotDisputedInvcgDocItem reads from 1 data source(s): P_CAInvcgDocItem.

How many fields does C_CANotDisputedInvcgDocItem have?

C_CANotDisputedInvcgDocItem has 109 fields. Key fields: CAInvoicingDocument, CAInvcgDocItem.

C_CANotDisputedInvcgDocItem

DDL: C_CANOTDISPUTEDINVCGDOCITEM Type: view_entity CONSUMPTION

Not disputed invoicing item

C_CANotDisputedInvcgDocItem is a Consumption CDS View that provides data about "Not disputed invoicing item" in SAP S/4HANA. It reads from 1 data source (P_CAInvcgDocItem) and exposes 109 fields with key fields CAInvoicingDocument, CAInvcgDocItem.

Data Sources (1)

Source	Alias	Join Type
P_CAInvcgDocItem	P_CAInvcgDocItem	from

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Not disputed invoicing item	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.query.implementedBy	ABAP:CL_FICA_DM_QRY_NOT_DIS_INV_ITM	view
VDM.viewType	#CONSUMPTION	view

Fields (109)

Key	Field	Source Table	Source Field
KEY	CAInvoicingDocument		CAInvoicingDocument
KEY	CAInvcgDocItem		CAInvcgDocItem
	CaseUUID
	CAIsDocItemSimulated		CAIsDocItemSimulated
	CAInvcgDocumentItemType		CAInvcgDocumentItemType
	CAContract		CAContract
	CompanyCode		CompanyCode
	CAMainTransaction		CAMainTransaction
	CASubTransaction		CASubTransaction
	CAInvcgIsItemPostingRelevant		CAInvcgIsItemPostingRelevant
	CAInvcgIsItemPrintingRelevant		CAInvcgIsItemPrintingRelevant
	CAInvcgIsInFinalAmt		CAInvcgIsInFinalAmt
	TransactionCurrency		TransactionCurrency
	CAAmountInTransactionCurrency		CAAmountInTransactionCurrency
	CATaxIsIncluded		CATaxIsIncluded
	CAInvcgTaxGroupingKey		CAInvcgTaxGroupingKey
	TaxCode		TaxCode
	CATaxRateInPercent		CATaxRateInPercent
	TaxCountry		TaxCountry
	Quantity		Quantity
	CANetDueDate		CANetDueDate
	Division		Division
	CAProviderContractItemNumber		CAProviderContractItemNumber
	CASubApplication		CASubApplication
	CAInvcgItmAltvBusinessPartner		CAInvcgItmAltvBusinessPartner
	CAInvcgItmAltvContractAccount		CAInvcgItmAltvContractAccount
	CAInvcgDocItmAltvMDCat		CAInvcgDocItmAltvMDCat
	CAInvcgDocItemIsReversal		CAInvcgDocItemIsReversal
	CAInvcgIsNotBPRelevant		CAInvcgIsNotBPRelevant
	CAInvcgSubstituteGroupPrinting		CAInvcgSubstituteGroupPrinting
	CACurrencySourceDocument		CACurrencySourceDocument
	CAInvcgSourceDocumentAmount		CAInvcgSourceDocumentAmount
	CAGroupingCurrencyTranslation		CAGroupingCurrencyTranslation
	CAAccountDeterminationCode		CAAccountDeterminationCode
	BusinessPlace		BusinessPlace
	BusinessArea		BusinessArea
	CATaxDetnType		CATaxDetnType
	CAOtherTaxCode		CAOtherTaxCode
	CATaxDeterminationCode		CATaxDeterminationCode
	TaxJurisdiction		TaxJurisdiction
	CATransactionKeyAccountDetn		CATransactionKeyAccountDetn
	CAConditionType		CAConditionType
	CATaxDate		CATaxDate
	CATaxBaseAmount		CATaxBaseAmount
	CATaxAmountInTransCurrency		CATaxAmountInTransCurrency
	CATaxPortionInTransCurrency		CATaxPortionInTransCurrency
	WithholdingTaxCode		WithholdingTaxCode
	CAIsDownPaymentRequest		CAIsDownPaymentRequest
	CAInvcgOffsettingGroup		CAInvcgOffsettingGroup
	CAInvcgDfrrdRevenueStatus		CAInvcgDfrrdRevenueStatus
	CAIsRevenueAccountingRelevant		CAIsRevenueAccountingRelevant
	CAInvcgRevenueGrouping		CAInvcgRevenueGrouping
	CARevenueAccountingServiceType		CARevenueAccountingServiceType
	CAInvcgAccrualPostingType		CAInvcgAccrualPostingType
	CAIsPrepaid		CAIsPrepaid
	UnitOfMeasure		UnitOfMeasure
	CACashDiscountDueDate		CACashDiscountDueDate
	CACashDiscountRate		CACashDiscountRate
	CAInvcgDocItemDefStatus		CAInvcgDocItemDefStatus
	CAItemPeriodStartDate		CAItemPeriodStartDate
	CAItemPeriodEndDate		CAItemPeriodEndDate
	CAInvcgRefPostingDocType		CAInvcgRefPostingDocType
	CADocumentNumber		CADocumentNumber
	CAGroupingKeyDocumentItems		CAGroupingKeyDocumentItems
	CAInvcgGroupingKey		CAInvcgGroupingKey
	CAClearingDocumentNumber		CAClearingDocumentNumber
	CAClearingAmountInTransCrcy		CAClearingAmountInTransCrcy
	CAInvcgDocItemCrtnMethod		CAInvcgDocItemCrtnMethod
	CAInvcgFunction		CAInvcgFunction
	CAInvcgSourceDocumentCat		CAInvcgSourceDocumentCat
	CAInvcgSourceDocumentNumber		CAInvcgSourceDocumentNumber
	CAInvcgDocItemSourceItmCat		CAInvcgDocItemSourceItmCat
	CAInvcgSourceDocumentItem		CAInvcgSourceDocumentItem
	CABllbleItmDiscountKey		CABllbleItmDiscountKey
	CABllbleItmDiscountVersion		CABllbleItmDiscountVersion
	CAApplicationArea		CAApplicationArea
	CompanyCodeCountry		CompanyCodeCountry
	CAInvcgCorrectionCategory		CAInvcgCorrectionCategory
	CompanyCodeName	_CompCode	CompanyCodeName
	CAMainTransactionName
	CASubTransactionName
	CAInvcgDocItemTypeText
	CASubApplicationText
	DivisionName
	CAInvcgDocItmAltvMDCatText
	BusinessAreaName
	TaxCountryName
	CATaxDetnTypeText
	CAOtherTaxCodeName
	TaxCodeName
	TaxJurisdictionName
	ConditionTypeName
	CATransactionKeyAcctDetnText
	CADeferredRevenueStatusText
	CAInvcgDocItmDefStatusText
	CARevnAcctgServiceTypeText
	CAInvcgAccrualPostingTypeTxt
	CAInvcgRefPostgDocTypeTxt
	CAInvcgDocItmCrtnMethodText
	CAInvcgFunctionText
	CAInvcgSourceDocCatText
	CAInvcgDocItmSrceItmCatText
	CABllbleItmDiscountKeyText
	UnitOfMeasureName
	BusinessPartner	_CAInvcgDocHeader	BusinessPartner
	BusinessPartnerFullName
	ContractAccount	_CAInvcgDocHeader	ContractAccount
	ContractAccountName
	_CAInvcgDocHeader		_CAInvcgDocHeader

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Not disputed invoicing item'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { usageType:         { dataClass: #TRANSACTIONAL,
                                     sizeCategory: #L,
                                     serviceQuality: #C },
                    query: { implementedBy: 'ABAP:CL_FICA_DM_QRY_NOT_DIS_INV_ITM' }
              }       
@VDM.viewType: #CONSUMPTION
define view entity C_CANotDisputedInvcgDocItem as select from P_CAInvcgDocItem
{
      //INVDOCNO

      @UI.lineItem:       [{ position: 10, importance: #HIGH }]
  key CAInvoicingDocument,

      //INVDOCITEM

      @UI.lineItem:       [{ position: 20, importance: #HIGH }]
  key CAInvcgDocItem,
      @UI.hidden: true
      cast('' as sysuuid_c ) as CaseUUID, 
      //ITEM_SIMULATED

      CAIsDocItemSimulated,

      //ITEMTYPTE

      @UI.lineItem:       [{ position: 30, importance: #HIGH }]
      @ObjectModel.text.element: ['CAInvcgDocItemTypeText']
      CAInvcgDocumentItemType,

      //VTREF

      CAContract,

      //BUKRS

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

      //HVORG

      @UI.lineItem:       [{ position: 40, importance: #HIGH }]
      @ObjectModel.text.element: ['CAMainTransactionName']
      CAMainTransaction,

      //TVORG

      @UI.lineItem:       [{ position: 50, importance: #HIGH }]
      @ObjectModel.text.element: ['CASubTransactionName']
      CASubTransaction,

      //POSTREL

      @Semantics.booleanIndicator 
      CAInvcgIsItemPostingRelevant,

      //PRINTREL

      CAInvcgIsItemPrintingRelevant,

      //TOTALREL

      CAInvcgIsInFinalAmt,

      //Amount and Currency

      TransactionCurrency,

      @UI.lineItem:       [{ position: 60, importance: #HIGH }]
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,

      //TAX_INCLUDED

      CATaxIsIncluded,

      //TAXGR

      CAInvcgTaxGroupingKey,

      //MWSKZ

      @ObjectModel.text.element: ['TaxCodeName']
      TaxCode,

      //TAX_PERC

      CATaxRateInPercent,

      //TAX_COUNTRY

      @ObjectModel.text.element: ['TaxCountryName']
      TaxCountry,

      //MENGE

      @Semantics.quantity.unitOfMeasure: 'UnitOfMeasure'
      Quantity,

      //FAEDN

      @Consumption.filter.selectionType: #INTERVAL
      CANetDueDate,

      //SPART

      @ObjectModel.text.element: ['DivisionName']
      Division,

      //VTPOS

      CAProviderContractItemNumber,

      //SUBAP

      @ObjectModel.text.element: ['CASubApplicationText']
      CASubApplication,

      //GPART_A

      @Consumption.semanticObject: 'CAContractPartner'
      CAInvcgItmAltvBusinessPartner,

      //VKONT_A

      @Consumption.semanticObject: 'ContractAccount'
      CAInvcgItmAltvContractAccount,

      //GPVKT_A_CAT

      @ObjectModel.text.element: ['CAInvcgDocItmAltvMDCatText']
      CAInvcgDocItmAltvMDCat,

      //REVERSALITEM

      CAInvcgDocItemIsReversal,

      //NOT_BPREL

      CAInvcgIsNotBPRelevant,

      //PRINT_SUBSTITUTE

      CAInvcgSubstituteGroupPrinting,

      //SRCOC_CURR

      CACurrencySourceDocument,

      @Semantics.amount.currencyCode: 'CACurrencySourceDocument'
      CAInvcgSourceDocumentAmount,

      //CURR_GROUP

      CAGroupingCurrencyTranslation,

      //KOFIZ

      CAAccountDeterminationCode,

      //BUPLA

      BusinessPlace,

      //GSBER

      @ObjectModel.text.element: ['BusinessAreaName']
      BusinessArea,

      //TAX_DET_TYPE

      @ObjectModel.text.element: ['CATaxDetnTypeText']
      CATaxDetnType,

      // STRKZ

      @ObjectModel.text.element: ['CAOtherTaxCodeName']
      CAOtherTaxCode,

      //ERMWSKZ

      CATaxDeterminationCode,

      //TXJCD

      @ObjectModel.text.element: ['TaxJurisdictionName']
      TaxJurisdiction,

      //KTOSL

      @ObjectModel.text.element: ['CATransactionKeyAcctDetnText']
      CATransactionKeyAccountDetn,

      //KSCHL

      @ObjectModel.text.element: ['ConditionTypeName']
      CAConditionType,

      //TXCAT

      @Consumption.filter.selectionType: #INTERVAL
      CATaxDate,

      //SBASW

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxBaseAmount,

      //SBETW

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxAmountInTransCurrency,

      //STTAX

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxPortionInTransCurrency,

      //QSSKZ

      WithholdingTaxCode,

      //XANZA

      CAIsDownPaymentRequest,

      //STAKZ

      CAStatisticalItemCode,

      //OFFSET_INV_GR

      CAInvcgOffsettingGroup,

      //DEFREV_STAT

      @ObjectModel.text.element: ['CADeferredRevenueStatusText']
      CAInvcgDfrrdRevenueStatus,

      //RAREL

      @Semantics.booleanIndicator 
      CAIsRevenueAccountingRelevant,

      //RA_INVGR

      CAInvcgRevenueGrouping,

      //SERVICE_TYPE

      @ObjectModel.text.element: ['CARevnAcctgServiceTypeText']
      CARevenueAccountingServiceType,

      //BILLAC_TYPE

      @ObjectModel.text.element: ['CAInvcgAccrualPostingTypeTxt']
      CAInvcgAccrualPostingType,

      //PREPAID

      CAIsPrepaid,

      //MEINS

      @ObjectModel.text.element: ['UnitOfMeasureName']
      UnitOfMeasure,

      //FAEDS

      @Consumption.filter.selectionType: #INTERVAL
      CACashDiscountDueDate,

      //SKTPZ

      CACashDiscountRate,

      //XSTUND

      @ObjectModel.text.element: ['CAInvcgDocItmDefStatusText']
      CAInvcgDocItemDefStatus,

      //DATE_FROM

      @Consumption.filter.selectionType: #INTERVAL
      CAItemPeriodStartDate,

      //DATE_TO

      @Consumption.filter.selectionType: #INTERVAL
      CAItemPeriodEndDate,

      //CADOCTYPE

      @ObjectModel.text.element: ['CAInvcgRefPostgDocTypeTxt']
      CAInvcgRefPostingDocType,

      //OPBEL

      @Consumption.semanticObject: 'CADocument'
      CADocumentNumber,

      //PSGRP

      CAGroupingKeyDocumentItems,

      //INVGR

      CAInvcgGroupingKey,

      //AUGBL

      CAClearingDocumentNumber,

      //AUGBW

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAClearingAmountInTransCrcy,

      //CRMET

      @ObjectModel.text.element: ['CAInvcgDocItmCrtnMethodText']
      CAInvcgDocItemCrtnMethod,

      //INV_FUNCTION

      @ObjectModel.text.element: ['CAInvcgFunctionText']
      CAInvcgFunction,

      //SRCDOCCAT

      @ObjectModel.text.element: ['CAInvcgSourceDocCatText']
      CAInvcgSourceDocumentCat,

      //SRCDOCNO

      CAInvcgSourceDocumentNumber,

//      @UI.hidden: true

//      CAInvcgSourceDocumentSemObj,


      //SRCITEMCAT

      @ObjectModel.text.element: ['CAInvcgDocItmSrceItmCatText']
      CAInvcgDocItemSourceItmCat,

      //SRDOCITEM

      CAInvcgSourceDocumentItem,

      //DISCKEY

      @ObjectModel.text.element: ['CABllbleItmDiscountKeyText']
      CABllbleItmDiscountKey,

      //DISCKEY_VERSNO

      CABllbleItmDiscountVersion,

      //applk

      @Consumption.hidden: true
      CAApplicationArea,

      @Consumption.hidden: true
      CompanyCodeCountry,

      //CORRCAT

      CAInvcgCorrectionCategory,

      @UI.hidden: true
      _CompCode.CompanyCodeName,
      @UI.hidden: true
      _CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName,
      @UI.hidden: true
      _CASubTransaction._Text[1: Language=$session.system_language].CASubTransactionName,
      @UI.hidden: true
      _CAInvcgDocItemType._CAInvcgDocItemTypeText[1: Language=$session.system_language].CAInvcgDocItemTypeText,
      @UI.hidden: true
      _CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText,
      @UI.hidden: true
      _Division._Text[1: Language=$session.system_language].DivisionName,
      @UI.hidden: true
      _CAInvcgDocItmAltvMDCat._CAInvcgDocItmAltvMDCatText[1: Language=$session.system_language].CAInvcgDocItmAltvMDCatText,
      @UI.hidden: true
      _BusinessArea._Text[1: Language=$session.system_language].BusinessAreaName,
      @UI.hidden: true
      _TaxCountry._Text[1: Language=$session.system_language].CountryName as TaxCountryName,
      @UI.hidden: true
      _CATaxDetnType._CATaxDetnTypeText[1: Language=$session.system_language].CATaxDetnTypeText,
      @UI.hidden: true
      _CAOtherTaxCode._Text[1: Language=$session.system_language].CAOtherTaxCodeName,
      @UI.hidden: true
      _TaxCode._Text[1: Language=$session.system_language].TaxCodeName,
      @UI.hidden: true
      _TaxJurisdiction._Text[1: Language=$session.system_language].TaxJurisdictionName,
      @UI.hidden: true
      _CAConditionType._Text[1: Language=$session.system_language].ConditionTypeName,
      @UI.hidden: true
      _CATransactionKeyAcctDetn._CATransactionKeyAcctDetnText[1: Language=$session.system_language].CATransactionKeyAcctDetnText,
      @UI.hidden: true
      _CADeferredRevenueStatus._CADeferredRevenueStatusText[1: Language=$session.system_language].CADeferredRevenueStatusText,
      @UI.hidden: true
      _CAInvcgDocItmDefStatus._CAInvcgDocItmDefStatusText[1: Language=$session.system_language].CAInvcgDocItmDefStatusText,
      @UI.hidden: true
      _CARevnAcctgServiceType._CARevnAcctgServiceTypeText[1: Language=$session.system_language].CARevnAcctgServiceTypeText,
      @UI.hidden: true
      _CAInvcgAccrualPostingType._Text[1: Language=$session.system_language].CAInvcgAccrualPostingTypeTxt,
      @UI.hidden: true
      _CAInvcgRefPostgDocTyp._CAInvcgRefPostgDocTypTxt[1: Language=$session.system_language].CAInvcgRefPostgDocTypeTxt,
      @UI.hidden: true
      _CAInvcgDocItmCrtnMethod._CAInvcgDocItmCrtnMethodText[1: Language=$session.system_language].CAInvcgDocItmCrtnMethodText,
      @UI.hidden: true
      _CAInvcgFunction._CAInvcgFunctionText[1: Language=$session.system_language].CAInvcgFunctionText,
      @UI.hidden: true
      _CAInvcgSourceDocCat._CAInvcgSourceDocCatText[1: Language=$session.system_language].CAInvcgSourceDocCatText,
      @UI.hidden: true
      _CAInvcgDocItmSrceItmCat._CAInvcgDocItmSrceItmCatText[1: Language=$session.system_language].CAInvcgDocItmSrceItmCatText,
      @UI.hidden: true
      _CABllbleItmDiscountKey._CABllbleItmDiscountKeyText[1: Language=$session.system_language].CABllbleItmDiscountKeyText,
      @UI.hidden: true
      _UnitOfMeasure._Text[1: Language=$session.system_language].UnitOfMeasureName,
      @ObjectModel.text.element: ['BusinessPartnerFullName']
      _CAInvcgDocHeader.BusinessPartner,
      @UI.hidden: true
      _CAInvcgDocHeader._BusinessPartner.BusinessPartnerFullName,
      @ObjectModel.text.element: ['ContractAccountName']
      _CAInvcgDocHeader.ContractAccount,
      @UI.hidden: true
      _CAInvcgDocHeader._ContractAccountHeader.ContractAccountName,
      @ObjectModel.filter.enabled: false
      @ObjectModel.sort.enabled: false         
      _CAInvcgDocHeader      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSAREA",
"I_BUSINESSAREATEXT",
"I_BUSINESSPARTNER",
"I_CABLLBLEITMDISCOUNTKEY",
"I_CABLLBLEITMDISCOUNTKEYTEXT",
"I_CADEFERREDREVENUESTATUS",
"I_CADEFERREDREVENUESTATUSTEXT",
"I_CAINVCGACCRUALPOSTINGTYPE",
"I_CAINVCGACCRUALPOSTINGTYPETXT",
"I_CAINVCGDOCHEADER",
"I_CAINVCGDOCITEMTYPE",
"I_CAINVCGDOCITEMTYPETEXT",
"I_CAINVCGDOCITMALTVMDCAT",
"I_CAINVCGDOCITMALTVMDCATTEXT",
"I_CAINVCGDOCITMCRTNMETHOD",
"I_CAINVCGDOCITMCRTNMETHODTEXT",
"I_CAINVCGDOCITMDEFSTATUS",
"I_CAINVCGDOCITMDEFSTATUSTEXT",
"I_CAINVCGDOCITMSRCEITMCAT",
"I_CAINVCGDOCITMSRCEITMCATTEXT",
"I_CAINVCGFUNCTION",
"I_CAINVCGFUNCTIONTEXT",
"I_CAINVCGREFPOSTGDOCTYP",
"I_CAINVCGREFPOSTGDOCTYPTXT",
"I_CAINVCGSOURCEDOCCAT",
"I_CAINVCGSOURCEDOCCATTEXT",
"I_CAMAINTRANSACTION",
"I_CAMAINTRANSACTIONTEXT",
"I_CAOTHERTAXCODE",
"I_CAOTHERTAXCODETEXT",
"I_CAREVNACCTGSERVICETYPE",
"I_CAREVNACCTGSERVICETYPETEXT",
"I_CASUBAPPLICATION",
"I_CASUBAPPLICATIONTEXT",
"I_CASUBTRANSACTION",
"I_CASUBTRANSACTIONTEXT",
"I_CATAXDETNTYPE",
"I_CATAXDETNTYPETEXT",
"I_CATRANSACTIONKEYACCTDETN",
"I_CATRANSACTIONKEYACCTDETNTEXT",
"I_COMPANYCODE",
"I_CONDITIONTYPE",
"I_CONDITIONTYPETEXT",
"I_CONTRACTACCOUNTHEADER",
"I_COUNTRY",
"I_COUNTRYTEXT",
"I_DIVISION",
"I_DIVISIONTEXT",
"I_TAXCODE",
"I_TAXCODETEXT",
"I_TAXJURISDICTION",
"I_TAXJURISDICTIONTEXT",
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT",
"P_CAINVCGDOCITEM"
],
"ASSOCIATED":
[
"I_CAINVCGDOCHEADER"
],
"BASE":
[
"P_CAINVCGDOCITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_CANotDisputedInvcgDocItem view_entity

P_CAInvcgDocItem view