I_CADisputedInvcgDocItem

DDL: I_CADISPUTEDINVCGDOCITEM Type: view_entity COMPOSITE Package: ODATA_O2C_FICA_DISPUTE_MANAGE
104 Fields 2 Data Sources

Disputed invoicing document item

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

Data Sources (2)

SourceAliasJoin Type
P_CAInvcgDocItem _CAInvcgDocItem inner
P_CADisputedInvcgDocItem _DisputedInvcgDocItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Disputed invoicing document item view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (104)

KeyFieldSource TableSource FieldDescription
KEY CaseUUID P_CADisputedInvcgDocItem CaseUUID UUID
KEY CAInvoicingDocument P_CAInvcgDocItem CAInvoicingDocument Invoic. Doc.
KEY CAInvcgDocItem P_CAInvcgDocItem CAInvcgDocItem Item
CAIsDocItemSimulated P_CAInvcgDocItem CAIsDocItemSimulated Item Simulated
CAInvcgDocumentItemType P_CAInvcgDocItem CAInvcgDocumentItemType Item Type
CAContract P_CAInvcgDocItem CAContract Contract
CompanyCode P_CAInvcgDocItem CompanyCode Receiver Company Code
CAMainTransaction P_CAInvcgDocItem CAMainTransaction Main Trans.
CASubTransaction P_CAInvcgDocItem CASubTransaction Subtransaction
CAInvcgIsItemPostingRelevant P_CAInvcgDocItem CAInvcgIsItemPostingRelevant Posting-Relevt
CAInvcgIsItemPrintingRelevant P_CAInvcgDocItem CAInvcgIsItemPrintingRelevant Print Relevant
CAInvcgIsInFinalAmt P_CAInvcgDocItem CAInvcgIsInFinalAmt Rlvt for Invoice Total
TransactionCurrency P_CAInvcgDocItem TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency P_CAInvcgDocItem CAAmountInTransactionCurrency Amount
CATaxIsIncluded P_CAInvcgDocItem CATaxIsIncluded Gross
CAInvcgTaxGroupingKey P_CAInvcgDocItem CAInvcgTaxGroupingKey Tax Grpng Key
TaxCode P_CAInvcgDocItem TaxCode Tax Code
CATaxRateInPercent P_CAInvcgDocItem CATaxRateInPercent Tax Percentage
TaxCountry P_CAInvcgDocItem TaxCountry Tax Ctry/Reg.
Quantity P_CAInvcgDocItem Quantity Value
CANetDueDate P_CAInvcgDocItem CANetDueDate Net Due Date
Division P_CAInvcgDocItem Division Internal Division ID
CAProviderContractItemNumber P_CAInvcgDocItem CAProviderContractItemNumber Contract Item
CASubApplication P_CAInvcgDocItem CASubApplication Subapplication
CAInvcgItmAltvBusinessPartner P_CAInvcgDocItem CAInvcgItmAltvBusinessPartner Altv Business Partner
CAInvcgItmAltvContractAccount P_CAInvcgDocItem CAInvcgItmAltvContractAccount Altv Contract Account
CAInvcgDocItmAltvMDCat P_CAInvcgDocItem CAInvcgDocItmAltvMDCat Cat Altv Master Data
CAInvcgDocItemIsReversal P_CAInvcgDocItem CAInvcgDocItemIsReversal Reversal Item
CAInvcgIsNotBPRelevant P_CAInvcgDocItem CAInvcgIsNotBPRelevant No BP Item
CAInvcgSubstituteGroupPrinting P_CAInvcgDocItem CAInvcgSubstituteGroupPrinting Substitute Group
CACurrencySourceDocument P_CAInvcgDocItem CACurrencySourceDocument Source Document Currency
CAInvcgSourceDocumentAmount P_CAInvcgDocItem CAInvcgSourceDocumentAmount Amount in SrcDoc Crcy
CAGroupingCurrencyTranslation P_CAInvcgDocItem CAGroupingCurrencyTranslation Crcy Translation Group
CAAccountDeterminationCode P_CAInvcgDocItem CAAccountDeterminationCode Acct Determ. ID
BusinessPlace P_CAInvcgDocItem BusinessPlace Business place
BusinessArea P_CAInvcgDocItem BusinessArea Business Area
CATaxDetnType P_CAInvcgDocItem CATaxDetnType Tax Calculation
CAOtherTaxCode P_CAInvcgDocItem CAOtherTaxCode TxCde:Oth.Taxes
CATaxDeterminationCode P_CAInvcgDocItem CATaxDeterminationCode Tax Determination
TaxJurisdiction P_CAInvcgDocItem TaxJurisdiction Tax Jurisdiction
CATransactionKeyAccountDetn P_CAInvcgDocItem CATransactionKeyAccountDetn Autom. Posting
CAConditionType P_CAInvcgDocItem CAConditionType Condition Type
CATaxDate P_CAInvcgDocItem CATaxDate Tax Date
CATaxBaseAmount P_CAInvcgDocItem CATaxBaseAmount Tax Base Amount
CATaxAmountInTransCurrency P_CAInvcgDocItem CATaxAmountInTransCurrency Tax Amount
CATaxPortionInTransCurrency P_CAInvcgDocItem CATaxPortionInTransCurrency Tax Portion
WithholdingTaxCode P_CAInvcgDocItem WithholdingTaxCode WTax Code
CAIsDownPaymentRequest P_CAInvcgDocItem CAIsDownPaymentRequest Down Payment
CAInvcgOffsettingGroup P_CAInvcgDocItem CAInvcgOffsettingGroup Offsetting Grp
CAInvcgDfrrdRevenueStatus P_CAInvcgDocItem CAInvcgDfrrdRevenueStatus Deferred Revenues Status
CAInvcgRevenueGrouping P_CAInvcgDocItem CAInvcgRevenueGrouping Revenue Group
CARevenueAccountingServiceType P_CAInvcgDocItem CARevenueAccountingServiceType Service Type
CAInvcgAccrualPostingType P_CAInvcgDocItem CAInvcgAccrualPostingType Accr/Defrl Postg Type
CAIsPrepaid P_CAInvcgDocItem CAIsPrepaid Prepaid
UnitOfMeasure P_CAInvcgDocItem UnitOfMeasure Unit Protected Qty
CACashDiscountDueDate P_CAInvcgDocItem CACashDiscountDueDate Disct Due Date
CACashDiscountRate P_CAInvcgDocItem CACashDiscountRate Discount rate
CAInvcgDocItemDefStatus P_CAInvcgDocItem CAInvcgDocItemDefStatus Item(s) Deferrd
CAItemPeriodStartDate P_CAInvcgDocItem CAItemPeriodStartDate Start Item Per.
CAItemPeriodEndDate P_CAInvcgDocItem CAItemPeriodEndDate End of Item Per
CAInvcgRefPostingDocType P_CAInvcgDocItem CAInvcgRefPostingDocType Ref. Doc. Type
CADocumentNumber P_CAInvcgDocItem CADocumentNumber Document Number
CAGroupingKeyDocumentItems P_CAInvcgDocItem CAGroupingKeyDocumentItems Item Grouping
CAInvcgGroupingKey P_CAInvcgDocItem CAInvcgGroupingKey Inv. Grouping
CAClearingDocumentNumber P_CAInvcgDocItem CAClearingDocumentNumber Clearing Doc.
CAClearingAmountInTransCrcy P_CAInvcgDocItem CAClearingAmountInTransCrcy TC Clearing Amt
CAInvcgDocItemCrtnMethod P_CAInvcgDocItem CAInvcgDocItemCrtnMethod Creation Method
CAInvcgFunction P_CAInvcgDocItem CAInvcgFunction Function
CAInvcgSourceDocumentCat P_CAInvcgDocItem CAInvcgSourceDocumentCat Source Document Category
CAInvcgSourceDocumentNumber P_CAInvcgDocItem CAInvcgSourceDocumentNumber Source Document Number
CAInvcgSourceDocumentSemObj
CAInvcgDocItemSourceItmCat P_CAInvcgDocItem CAInvcgDocItemSourceItmCat Srce Itm Categy
CAInvcgSourceDocumentItem P_CAInvcgDocItem CAInvcgSourceDocumentItem Source Doc.Item
CABllbleItmDiscountKey P_CAInvcgDocItem CABllbleItmDiscountKey Disc./Chg. Key
CABllbleItmDiscountVersion P_CAInvcgDocItem CABllbleItmDiscountVersion Version No.
CAApplicationArea
CompanyCodeCountry
CAInvcgCorrectionCategory P_CAInvcgDocItem CAInvcgCorrectionCategory Invcg Correction Category
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

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 I_CADisputedInvcgDocItem.
-- 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 I_CADisputedInvcgDocItem AS
SELECT
  _DisputedInvcgDocItem.CaseUUID AS CaseUUID,
  _CAInvcgDocItem.CAInvoicingDocument AS CAInvoicingDocument,
  _CAInvcgDocItem.CAInvcgDocItem AS CAInvcgDocItem,
  _CAInvcgDocItem.CAIsDocItemSimulated AS CAIsDocItemSimulated,
  _CAInvcgDocItem.CAInvcgDocumentItemType AS CAInvcgDocumentItemType,
  _CAInvcgDocItem.CAContract AS CAContract,
  _CAInvcgDocItem.CompanyCode AS CompanyCode,
  _CAInvcgDocItem.CAMainTransaction AS CAMainTransaction,
  _CAInvcgDocItem.CASubTransaction AS CASubTransaction,
  _CAInvcgDocItem.CAInvcgIsItemPostingRelevant AS CAInvcgIsItemPostingRelevant,
  _CAInvcgDocItem.CAInvcgIsItemPrintingRelevant AS CAInvcgIsItemPrintingRelevant,
  _CAInvcgDocItem.CAInvcgIsInFinalAmt AS CAInvcgIsInFinalAmt,
  _CAInvcgDocItem.TransactionCurrency AS TransactionCurrency,
  _CAInvcgDocItem.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _CAInvcgDocItem.CATaxIsIncluded AS CATaxIsIncluded,
  _CAInvcgDocItem.CAInvcgTaxGroupingKey AS CAInvcgTaxGroupingKey,
  _CAInvcgDocItem.TaxCode AS TaxCode,
  _CAInvcgDocItem.CATaxRateInPercent AS CATaxRateInPercent,
  _CAInvcgDocItem.TaxCountry AS TaxCountry,
  _CAInvcgDocItem.Quantity AS Quantity,
  _CAInvcgDocItem.CANetDueDate AS CANetDueDate,
  _CAInvcgDocItem.Division AS Division,
  _CAInvcgDocItem.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  _CAInvcgDocItem.CASubApplication AS CASubApplication,
  _CAInvcgDocItem.CAInvcgItmAltvBusinessPartner AS CAInvcgItmAltvBusinessPartner,
  _CAInvcgDocItem.CAInvcgItmAltvContractAccount AS CAInvcgItmAltvContractAccount,
  _CAInvcgDocItem.CAInvcgDocItmAltvMDCat AS CAInvcgDocItmAltvMDCat,
  _CAInvcgDocItem.CAInvcgDocItemIsReversal AS CAInvcgDocItemIsReversal,
  _CAInvcgDocItem.CAInvcgIsNotBPRelevant AS CAInvcgIsNotBPRelevant,
  _CAInvcgDocItem.CAInvcgSubstituteGroupPrinting AS CAInvcgSubstituteGroupPrinting,
  _CAInvcgDocItem.CACurrencySourceDocument AS CACurrencySourceDocument,
  _CAInvcgDocItem.CAInvcgSourceDocumentAmount AS CAInvcgSourceDocumentAmount,
  _CAInvcgDocItem.CAGroupingCurrencyTranslation AS CAGroupingCurrencyTranslation,
  _CAInvcgDocItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _CAInvcgDocItem.BusinessPlace AS BusinessPlace,
  _CAInvcgDocItem.BusinessArea AS BusinessArea,
  _CAInvcgDocItem.CATaxDetnType AS CATaxDetnType,
  _CAInvcgDocItem.CAOtherTaxCode AS CAOtherTaxCode,
  _CAInvcgDocItem.CATaxDeterminationCode AS CATaxDeterminationCode,
  _CAInvcgDocItem.TaxJurisdiction AS TaxJurisdiction,
  _CAInvcgDocItem.CATransactionKeyAccountDetn AS CATransactionKeyAccountDetn,
  _CAInvcgDocItem.CAConditionType AS CAConditionType,
  _CAInvcgDocItem.CATaxDate AS CATaxDate,
  _CAInvcgDocItem.CATaxBaseAmount AS CATaxBaseAmount,
  _CAInvcgDocItem.CATaxAmountInTransCurrency AS CATaxAmountInTransCurrency,
  _CAInvcgDocItem.CATaxPortionInTransCurrency AS CATaxPortionInTransCurrency,
  _CAInvcgDocItem.WithholdingTaxCode AS WithholdingTaxCode,
  _CAInvcgDocItem.CAIsDownPaymentRequest AS CAIsDownPaymentRequest,
  _CAInvcgDocItem.CAInvcgOffsettingGroup AS CAInvcgOffsettingGroup,
  _CAInvcgDocItem.CAInvcgDfrrdRevenueStatus AS CAInvcgDfrrdRevenueStatus,
  _CAInvcgDocItem.CAInvcgRevenueGrouping AS CAInvcgRevenueGrouping,
  _CAInvcgDocItem.CARevenueAccountingServiceType AS CARevenueAccountingServiceType,
  _CAInvcgDocItem.CAInvcgAccrualPostingType AS CAInvcgAccrualPostingType,
  _CAInvcgDocItem.CAIsPrepaid AS CAIsPrepaid,
  _CAInvcgDocItem.UnitOfMeasure AS UnitOfMeasure,
  _CAInvcgDocItem.CACashDiscountDueDate AS CACashDiscountDueDate,
  _CAInvcgDocItem.CACashDiscountRate AS CACashDiscountRate,
  _CAInvcgDocItem.CAInvcgDocItemDefStatus AS CAInvcgDocItemDefStatus,
  _CAInvcgDocItem.CAItemPeriodStartDate AS CAItemPeriodStartDate,
  _CAInvcgDocItem.CAItemPeriodEndDate AS CAItemPeriodEndDate,
  _CAInvcgDocItem.CAInvcgRefPostingDocType AS CAInvcgRefPostingDocType,
  _CAInvcgDocItem.CADocumentNumber AS CADocumentNumber,
  _CAInvcgDocItem.CAGroupingKeyDocumentItems AS CAGroupingKeyDocumentItems,
  _CAInvcgDocItem.CAInvcgGroupingKey AS CAInvcgGroupingKey,
  _CAInvcgDocItem.CAClearingDocumentNumber AS CAClearingDocumentNumber,
  _CAInvcgDocItem.CAClearingAmountInTransCrcy AS CAClearingAmountInTransCrcy,
  _CAInvcgDocItem.CAInvcgDocItemCrtnMethod AS CAInvcgDocItemCrtnMethod,
  _CAInvcgDocItem.CAInvcgFunction AS CAInvcgFunction,
  _CAInvcgDocItem.CAInvcgSourceDocumentCat AS CAInvcgSourceDocumentCat,
  _CAInvcgDocItem.CAInvcgSourceDocumentNumber AS CAInvcgSourceDocumentNumber,
  _CAInvcgDocItem._CAInvcgSourceDocCat.CAInvcgSourceDocumentSemObj AS CAInvcgSourceDocumentSemObj,
  _CAInvcgDocItem.CAInvcgDocItemSourceItmCat AS CAInvcgDocItemSourceItmCat,
  _CAInvcgDocItem.CAInvcgSourceDocumentItem AS CAInvcgSourceDocumentItem,
  _CAInvcgDocItem.CABllbleItmDiscountKey AS CABllbleItmDiscountKey,
  _CAInvcgDocItem.CABllbleItmDiscountVersion AS CABllbleItmDiscountVersion,
  _CAInvcgDocItem._CAInvcgDocHeader.CAApplicationArea AS CAApplicationArea,
  _CAInvcgDocItem._CompCode.Country AS CompanyCodeCountry,
  _CAInvcgDocItem.CAInvcgCorrectionCategory AS CAInvcgCorrectionCategory,
  _CAInvcgDocItem._CompCode.CompanyCodeName AS CompanyCodeName,
  _CAInvcgDocItem._CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  _CAInvcgDocItem._CASubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
  _CAInvcgDocItem._CAInvcgDocItemType._CAInvcgDocItemTypeText[1: Language=$session.system_language].CAInvcgDocItemTypeText AS CAInvcgDocItemTypeText,
  _CAInvcgDocItem._CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  _CAInvcgDocItem._Division._Text[1: Language=$session.system_language].DivisionName AS DivisionName,
  cast(_CAInvcgDocItem._CAInvcgDocItmAltvMDCat._CAInvcgDocItmAltvMDCatText[1: Language=$session.system_language].CAInvcgDocItmAltvMDCatText as description_kk) AS CAInvcgDocItmAltvMDCatText,
  _CAInvcgDocItem._BusinessArea._Text[1: Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  _CAInvcgDocItem._TaxCountry._Text[1: Language=$session.system_language].CountryName AS TaxCountryName,
  cast(_CAInvcgDocItem._CATaxDetnType._CATaxDetnTypeText[1: Language=$session.system_language].CATaxDetnTypeText as description_kk) AS CATaxDetnTypeText,
  _CAInvcgDocItem._CAOtherTaxCode._Text[1: Language=$session.system_language].CAOtherTaxCodeName AS CAOtherTaxCodeName,
  _CAInvcgDocItem._TaxCode._Text[1: Language=$session.system_language].TaxCodeName AS TaxCodeName,
  _CAInvcgDocItem._TaxJurisdiction._Text[1: Language=$session.system_language].TaxJurisdictionName AS TaxJurisdictionName,
  _CAInvcgDocItem._CAConditionType._Text[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
  cast(_CAInvcgDocItem._CATransactionKeyAcctDetn._CATransactionKeyAcctDetnText[1: Language=$session.system_language].CATransactionKeyAcctDetnText as description_kk) AS CATransactionKeyAcctDetnText,
  cast(_CAInvcgDocItem._CADeferredRevenueStatus._CADeferredRevenueStatusText[1: Language=$session.system_language].CADeferredRevenueStatusText as description_kk) AS CADeferredRevenueStatusText,
  cast(_CAInvcgDocItem._CAInvcgDocItmDefStatus._CAInvcgDocItmDefStatusText[1: Language=$session.system_language].CAInvcgDocItmDefStatusText as description_kk) AS CAInvcgDocItmDefStatusText,
  _CAInvcgDocItem._CARevnAcctgServiceType._CARevnAcctgServiceTypeText[1: Language=$session.system_language].CARevnAcctgServiceTypeText AS CARevnAcctgServiceTypeText,
  _CAInvcgDocItem._CAInvcgAccrualPostingType._Text[1: Language=$session.system_language].CAInvcgAccrualPostingTypeTxt AS CAInvcgAccrualPostingTypeTxt,
  _CAInvcgDocItem._CAInvcgRefPostgDocTyp._CAInvcgRefPostgDocTypTxt[1: Language=$session.system_language].CAInvcgRefPostgDocTypeTxt AS CAInvcgRefPostgDocTypeTxt,
  cast(_CAInvcgDocItem._CAInvcgDocItmCrtnMethod._CAInvcgDocItmCrtnMethodText[1: Language=$session.system_language].CAInvcgDocItmCrtnMethodText as description_kk) AS CAInvcgDocItmCrtnMethodText,
  _CAInvcgDocItem._CAInvcgFunction._CAInvcgFunctionText[1: Language=$session.system_language].CAInvcgFunctionText AS CAInvcgFunctionText,
  _CAInvcgDocItem._CAInvcgSourceDocCat._CAInvcgSourceDocCatText[1: Language=$session.system_language].CAInvcgSourceDocCatText AS CAInvcgSourceDocCatText,
  cast(_CAInvcgDocItem._CAInvcgDocItmSrceItmCat._CAInvcgDocItmSrceItmCatText[1: Language=$session.system_language].CAInvcgDocItmSrceItmCatText as description_kk) AS CAInvcgDocItmSrceItmCatText,
  _CAInvcgDocItem._CABllbleItmDiscountKey._CABllbleItmDiscountKeyText[1: Language=$session.system_language].CABllbleItmDiscountKeyText AS CABllbleItmDiscountKeyText,
  _CAInvcgDocItem._UnitOfMeasure._Text[1: Language=$session.system_language].UnitOfMeasureName AS UnitOfMeasureName
FROM P_CADisputedInvcgDocItem AS _DisputedInvcgDocItem
INNER JOIN P_CAInvcgDocItem AS _CAInvcgDocItem ON /* join condition not captured in parsed metadata */
;

Learn More