C_CANotDisputedInvcgDocItem
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 | Field |
|---|---|---|---|
| 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 | Description |
|---|---|---|---|---|
| KEY | CAInvoicingDocument | CAInvoicingDocument | Invoic. Doc. | |
| KEY | CAInvcgDocItem | CAInvcgDocItem | Item | |
| CaseUUID | ||||
| 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 | ||
| CAIsRevenueAccountingRelevant | CAIsRevenueAccountingRelevant | Rev. Acctg Relevant | ||
| 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 | _CompCode | CompanyCodeName | Company Name | |
| 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 | Issuing Authority | |
| BusinessPartnerFullName | ||||
| ContractAccount | _CAInvcgDocHeader | ContractAccount | Contract Acct | |
| ContractAccountName | ||||
| _CAInvcgDocHeader | _CAInvcgDocHeader |
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 C_CANotDisputedInvcgDocItem.
-- 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 C_CANotDisputedInvcgDocItem AS
SELECT
CAInvoicingDocument,
CAInvcgDocItem,
cast('' as sysuuid_c ) AS CaseUUID,
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,
CAIsRevenueAccountingRelevant,
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,
_CompCode.CompanyCodeName AS CompanyCodeName,
_CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
_CASubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
_CAInvcgDocItemType._CAInvcgDocItemTypeText[1: Language=$session.system_language].CAInvcgDocItemTypeText AS CAInvcgDocItemTypeText,
_CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
_Division._Text[1: Language=$session.system_language].DivisionName AS DivisionName,
_CAInvcgDocItmAltvMDCat._CAInvcgDocItmAltvMDCatText[1: Language=$session.system_language].CAInvcgDocItmAltvMDCatText AS CAInvcgDocItmAltvMDCatText,
_BusinessArea._Text[1: Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
_TaxCountry._Text[1: Language=$session.system_language].CountryName AS TaxCountryName,
_CATaxDetnType._CATaxDetnTypeText[1: Language=$session.system_language].CATaxDetnTypeText AS CATaxDetnTypeText,
_CAOtherTaxCode._Text[1: Language=$session.system_language].CAOtherTaxCodeName AS CAOtherTaxCodeName,
_TaxCode._Text[1: Language=$session.system_language].TaxCodeName AS TaxCodeName,
_TaxJurisdiction._Text[1: Language=$session.system_language].TaxJurisdictionName AS TaxJurisdictionName,
_CAConditionType._Text[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
_CATransactionKeyAcctDetn._CATransactionKeyAcctDetnText[1: Language=$session.system_language].CATransactionKeyAcctDetnText AS CATransactionKeyAcctDetnText,
_CADeferredRevenueStatus._CADeferredRevenueStatusText[1: Language=$session.system_language].CADeferredRevenueStatusText AS CADeferredRevenueStatusText,
_CAInvcgDocItmDefStatus._CAInvcgDocItmDefStatusText[1: Language=$session.system_language].CAInvcgDocItmDefStatusText AS CAInvcgDocItmDefStatusText,
_CARevnAcctgServiceType._CARevnAcctgServiceTypeText[1: Language=$session.system_language].CARevnAcctgServiceTypeText AS CARevnAcctgServiceTypeText,
_CAInvcgAccrualPostingType._Text[1: Language=$session.system_language].CAInvcgAccrualPostingTypeTxt AS CAInvcgAccrualPostingTypeTxt,
_CAInvcgRefPostgDocTyp._CAInvcgRefPostgDocTypTxt[1: Language=$session.system_language].CAInvcgRefPostgDocTypeTxt AS CAInvcgRefPostgDocTypeTxt,
_CAInvcgDocItmCrtnMethod._CAInvcgDocItmCrtnMethodText[1: Language=$session.system_language].CAInvcgDocItmCrtnMethodText AS CAInvcgDocItmCrtnMethodText,
_CAInvcgFunction._CAInvcgFunctionText[1: Language=$session.system_language].CAInvcgFunctionText AS CAInvcgFunctionText,
_CAInvcgSourceDocCat._CAInvcgSourceDocCatText[1: Language=$session.system_language].CAInvcgSourceDocCatText AS CAInvcgSourceDocCatText,
_CAInvcgDocItmSrceItmCat._CAInvcgDocItmSrceItmCatText[1: Language=$session.system_language].CAInvcgDocItmSrceItmCatText AS CAInvcgDocItmSrceItmCatText,
_CABllbleItmDiscountKey._CABllbleItmDiscountKeyText[1: Language=$session.system_language].CABllbleItmDiscountKeyText AS CABllbleItmDiscountKeyText,
_UnitOfMeasure._Text[1: Language=$session.system_language].UnitOfMeasureName AS UnitOfMeasureName,
_CAInvcgDocHeader.BusinessPartner AS BusinessPartner,
_CAInvcgDocHeader._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
_CAInvcgDocHeader.ContractAccount AS ContractAccount,
_CAInvcgDocHeader._ContractAccountHeader.ContractAccountName AS ContractAccountName
FROM P_CAInvcgDocItem
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA