R_CADisputedInvcgDocItemTP

DDL: R_CADISPUTEDINVCGDOCITEMTP Type: view_entity TRANSACTIONAL Package: RAP_FICA_CADSPUTCASE
105 Fields 1 Data Sources 1 Associations

Disputed invoicing document item

R_CADisputedInvcgDocItemTP is a Transactional CDS View that provides data about "Disputed invoicing document item" in SAP S/4HANA. It reads from 1 data source (I_CADisputedInvcgDocItem) and exposes 105 fields with key fields CaseUUID, CAInvoicingDocument, CAInvcgDocItem. It has 1 association to related views. Part of development package RAP_FICA_CADSPUTCASE.

Data Sources (1)

SourceAliasJoin Type
I_CADisputedInvcgDocItem I_CADisputedInvcgDocItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAProviderContractHeader _ProviderContract $projection.CASubApplication = 'P' and $projection.CAContract = _ProviderContract.CAProviderContract

Annotations (8)

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

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY CaseUUID CaseUUID UUID
KEY CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
KEY CAInvcgDocItem CAInvcgDocItem Item
CAIsDocItemSimulated CAIsDocItemSimulated Item Simulated
CAInvcgDocumentItemType CAInvcgDocumentItemType Item Type
CAContract CAContract Contract
CompanyCode CompanyCode Receiver Company Code
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAInvcgIsItemPostingRelevant CAInvcgIsItemPostingRelevant Posting-Relevt
CAInvcgIsItemPrintingRelevant CAInvcgIsItemPrintingRelevant Print Relevant
CAInvcgIsInFinalAmt CAInvcgIsInFinalAmt Rlvt for Invoice Total
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CATaxIsIncluded CATaxIsIncluded Gross
CAInvcgTaxGroupingKey CAInvcgTaxGroupingKey Tax Grpng Key
TaxCode TaxCode Tax Code
CATaxRateInPercent CATaxRateInPercent Tax Percentage
TaxCountry TaxCountry Tax Ctry/Reg.
Quantity Quantity Value
CANetDueDate CANetDueDate Net Due Date
Division Division Internal Division ID
CAProviderContractItemNumber CAProviderContractItemNumber Contract Item
CASubApplication CASubApplication Subapplication
CAInvcgItmAltvBusinessPartner CAInvcgItmAltvBusinessPartner Altv Business Partner
CAInvcgItmAltvContractAccount CAInvcgItmAltvContractAccount Altv Contract Account
CAInvcgDocItmAltvMDCat CAInvcgDocItmAltvMDCat Cat Altv Master Data
CAInvcgDocItemIsReversal CAInvcgDocItemIsReversal Reversal Item
CAInvcgIsNotBPRelevant CAInvcgIsNotBPRelevant No BP Item
CAInvcgSubstituteGroupPrinting CAInvcgSubstituteGroupPrinting Substitute Group
CACurrencySourceDocument CACurrencySourceDocument Source Document Currency
CAInvcgSourceDocumentAmount CAInvcgSourceDocumentAmount Amount in SrcDoc Crcy
CAGroupingCurrencyTranslation CAGroupingCurrencyTranslation Crcy Translation Group
CAAccountDeterminationCode CAAccountDeterminationCode Acct Determ. ID
BusinessPlace BusinessPlace Business place
BusinessArea BusinessArea Business Area
CATaxDetnType CATaxDetnType Tax Calculation
CAOtherTaxCode CAOtherTaxCode TxCde:Oth.Taxes
CATaxDeterminationCode CATaxDeterminationCode Tax Determination
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
CATransactionKeyAccountDetn CATransactionKeyAccountDetn Autom. Posting
CAConditionType CAConditionType Condition Type
CATaxDate CATaxDate Tax Date
CATaxBaseAmount CATaxBaseAmount Tax Base Amount
CATaxAmountInTransCurrency CATaxAmountInTransCurrency Tax Amount
CATaxPortionInTransCurrency CATaxPortionInTransCurrency Tax Portion
WithholdingTaxCode WithholdingTaxCode WTax Code
CAIsDownPaymentRequest CAIsDownPaymentRequest Down Payment
CAInvcgOffsettingGroup CAInvcgOffsettingGroup Offsetting Grp
CAInvcgDfrrdRevenueStatus CAInvcgDfrrdRevenueStatus Deferred Revenues Status
CAInvcgRevenueGrouping CAInvcgRevenueGrouping Revenue Group
CARevenueAccountingServiceType CARevenueAccountingServiceType Service Type
CAInvcgAccrualPostingType CAInvcgAccrualPostingType Accr/Defrl Postg Type
CAIsPrepaid CAIsPrepaid Prepaid
UnitOfMeasure UnitOfMeasure Unit Protected Qty
CACashDiscountDueDate CACashDiscountDueDate Disct Due Date
CACashDiscountRate CACashDiscountRate Discount rate
CAInvcgDocItemDefStatus CAInvcgDocItemDefStatus Item(s) Deferrd
CAItemPeriodStartDate CAItemPeriodStartDate Start Item Per.
CAItemPeriodEndDate CAItemPeriodEndDate End of Item Per
CAInvcgRefPostingDocType CAInvcgRefPostingDocType Ref. Doc. Type
CADocumentNumber CADocumentNumber Document Number
CAGroupingKeyDocumentItems CAGroupingKeyDocumentItems Item Grouping
CAInvcgGroupingKey CAInvcgGroupingKey Inv. Grouping
CAClearingDocumentNumber CAClearingDocumentNumber Clearing Doc.
CAClearingAmountInTransCrcy CAClearingAmountInTransCrcy TC Clearing Amt
CAInvcgDocItemCrtnMethod CAInvcgDocItemCrtnMethod Creation Method
CAInvcgFunction CAInvcgFunction Function
CAInvcgSourceDocumentCat CAInvcgSourceDocumentCat Source Document Category
CAInvcgSourceDocumentNumber CAInvcgSourceDocumentNumber Source Document Number
CAInvcgDocItemSourceItmCat CAInvcgDocItemSourceItmCat Srce Itm Categy
CAInvcgSourceDocumentItem CAInvcgSourceDocumentItem Source Doc.Item
CABllbleItmDiscountKey CABllbleItmDiscountKey Disc./Chg. Key
CABllbleItmDiscountVersion CABllbleItmDiscountVersion Version No.
CAApplicationArea CAApplicationArea ApplicationArea
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CompanyCodeName CompanyCodeName Company Name
CAMainTransactionName CAMainTransactionName Main Transactn
CASubTransactionName CASubTransactionName Subtransaction
CAInvcgDocItemTypeText CAInvcgDocItemTypeText ItmTypText
CASubApplicationText CASubApplicationText Subapplication
DivisionName DivisionName Division Description
CAInvcgDocItmAltvMDCatText CAInvcgDocItmAltvMDCatText Description
BusinessAreaName BusinessAreaName Business Area Name
TaxCountryName TaxCountryName Country/Region
CATaxDetnTypeText CATaxDetnTypeText Description
CAOtherTaxCodeName CAOtherTaxCodeName Name
TaxCodeName TaxCodeName Tax Code Name
TaxJurisdictionName TaxJurisdictionName Description
ConditionTypeName ConditionTypeName Name
CATransactionKeyAcctDetnText CATransactionKeyAcctDetnText Description
CADeferredRevenueStatusText CADeferredRevenueStatusText Description
CAInvcgDocItmDefStatusText CAInvcgDocItmDefStatusText Description
CARevnAcctgServiceTypeText CARevnAcctgServiceTypeText Service Type
CAInvcgAccrualPostingTypeTxt CAInvcgAccrualPostingTypeTxt A/D Type Text
CAInvcgRefPostgDocTypeTxt CAInvcgRefPostgDocTypeTxt RefDocTypeText
CAInvcgDocItmCrtnMethodText CAInvcgDocItmCrtnMethodText Description
CAInvcgFunctionText CAInvcgFunctionText Function Text
CAInvcgSourceDocCatText CAInvcgSourceDocCatText Explanation
CAInvcgDocItmSrceItmCatText CAInvcgDocItmSrceItmCatText Description
CABllbleItmDiscountKeyText CABllbleItmDiscountKeyText Name
UnitOfMeasureName UnitOfMeasureName Meas. Unit Text
_CADisputeCase _CADisputeCase
_ProviderContract _ProviderContract

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 R_CADisputedInvcgDocItemTP.
-- 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 R_CADisputedInvcgDocItemTP AS
SELECT
  CaseUUID,
  CAInvoicingDocument,
  CAInvcgDocItem,
  CAIsDocItemSimulated,
  CAInvcgDocumentItemType,
  CAContract,
  CompanyCode,
  CAMainTransaction,
  CASubTransaction,
  CAInvcgIsItemPostingRelevant,
  CAInvcgIsItemPrintingRelevant,
  CAInvcgIsInFinalAmt,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CATaxIsIncluded,
  CAInvcgTaxGroupingKey,
  TaxCode,
  CATaxRateInPercent,
  TaxCountry,
  Quantity,
  CANetDueDate,
  Division,
  CAProviderContractItemNumber,
  CASubApplication,
  CAInvcgItmAltvBusinessPartner,
  CAInvcgItmAltvContractAccount,
  CAInvcgDocItmAltvMDCat,
  CAInvcgDocItemIsReversal,
  CAInvcgIsNotBPRelevant,
  CAInvcgSubstituteGroupPrinting,
  CACurrencySourceDocument,
  CAInvcgSourceDocumentAmount,
  CAGroupingCurrencyTranslation,
  CAAccountDeterminationCode,
  BusinessPlace,
  BusinessArea,
  CATaxDetnType,
  CAOtherTaxCode,
  CATaxDeterminationCode,
  TaxJurisdiction,
  CATransactionKeyAccountDetn,
  CAConditionType,
  CATaxDate,
  CATaxBaseAmount,
  CATaxAmountInTransCurrency,
  CATaxPortionInTransCurrency,
  WithholdingTaxCode,
  CAIsDownPaymentRequest,
  CAInvcgOffsettingGroup,
  CAInvcgDfrrdRevenueStatus,
  CAInvcgRevenueGrouping,
  CARevenueAccountingServiceType,
  CAInvcgAccrualPostingType,
  CAIsPrepaid,
  UnitOfMeasure,
  CACashDiscountDueDate,
  CACashDiscountRate,
  CAInvcgDocItemDefStatus,
  CAItemPeriodStartDate,
  CAItemPeriodEndDate,
  CAInvcgRefPostingDocType,
  CADocumentNumber,
  CAGroupingKeyDocumentItems,
  CAInvcgGroupingKey,
  CAClearingDocumentNumber,
  CAClearingAmountInTransCrcy,
  CAInvcgDocItemCrtnMethod,
  CAInvcgFunction,
  CAInvcgSourceDocumentCat,
  CAInvcgSourceDocumentNumber,
  CAInvcgDocItemSourceItmCat,
  CAInvcgSourceDocumentItem,
  CABllbleItmDiscountKey,
  CABllbleItmDiscountVersion,
  CAApplicationArea,
  CompanyCodeCountry,
  CAInvcgCorrectionCategory,
  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
FROM I_CADisputedInvcgDocItem
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
;

Learn More