A_CAInvcgDocItem

DDL: A_CAINVCGDOCITEM Type: view_entity CONSUMPTION Package: FCI_ODATA_API_INVDOC
91 Fields 1 Data Sources 1 OData Services

Invoicing Document Item

A_CAInvcgDocItem is a Consumption CDS View that provides data about "Invoicing Document Item" in SAP S/4HANA. It reads from 1 data source (R_CAInvcgDocItemTP) and exposes 91 fields with key fields CAInvoicingDocument, CAInvcgDocItem. It is exposed through 1 OData service (API_CAINVOICINGDOCUMENT). Part of development package FCI_ODATA_API_INVDOC.

Data Sources (1)

SourceAliasJoin Type
R_CAInvcgDocItemTP R_CAInvcgDocItemTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Invoicing Document Item view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name CAInvcgDocItem_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_CAINVOICINGDOCUMENT API_CAINVOICINGDOCUMENT V4 C2 C1

Fields (91)

KeyFieldSource TableSource FieldDescription
KEY CAInvoicingDocument CAInvoicingDocument Invoic. Doc.
KEY CAInvcgDocItem CAInvcgDocItem Item
CAInvcgDocumentItemType CAInvcgDocumentItemType Item Type
CompanyCode CompanyCode Receiver Company Code
Division Division Internal Division ID
CAContract CAContract Contract
CAProviderContractItemNumber CAProviderContractItemNumber Contract Item
CASubApplication CASubApplication Subapplication
CAInvcgItmAltvBusinessPartner CAInvcgItmAltvBusinessPartner Altv Business Partner
CAInvcgItmAltvContractAccount CAInvcgItmAltvContractAccount Altv Contract Account
CAInvcgDocItmAltvMDCat CAInvcgDocItmAltvMDCat Cat Altv Master Data
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAIsDocItemSimulated CAIsDocItemSimulated Item Simulated
CAInvcgDocItemIsReversal CAInvcgDocItemIsReversal Reversal Item
CAInvcgIsInFinalAmt CAInvcgIsInFinalAmt Rlvt for Invoice Total
CAInvcgIsItemPostingRelevant CAInvcgIsItemPostingRelevant Posting-Relevt
CAInvcgIsNotBPRelevant CAInvcgIsNotBPRelevant No BP Item
CAInvcgIsItemPrintingRelevant CAInvcgIsItemPrintingRelevant Print Relevant
CAInvcgSubstituteGroupPrinting CAInvcgSubstituteGroupPrinting Substitute Group
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
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
CATaxIsIncluded CATaxIsIncluded Gross
CATaxDetnType CATaxDetnType Tax Calculation
CAInvcgTaxGroupingKey CAInvcgTaxGroupingKey Tax Grpng Key
CAOtherTaxCode CAOtherTaxCode TxCde:Oth.Taxes
TaxCode TaxCode Tax Code
CATaxDeterminationCode CATaxDeterminationCode Tax Determination
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
CATransactionKeyAccountDetn CATransactionKeyAccountDetn Autom. Posting
CAConditionType CAConditionType Condition Type
CATaxRateInPercent CATaxRateInPercent Tax Percentage
TaxCountry TaxCountry Tax Ctry/Reg.
TransToTaxCntryCrcyCnvrsnFctr TransToTaxCntryCrcyCnvrsnFctr Tax Factor C/R
CAInvcgOffsettingCategory CAInvcgOffsettingCategory Offsetting Cat.
CAInvcgOffsettingProcedure CAInvcgOffsettingProcedure Offsett. Proc.
CAInvcgOffsettingAction CAInvcgOffsettingAction Action Offsett.
CATaxDate CATaxDate Tax Date
CATaxBaseAmount CATaxBaseAmount Tax Base Amount
CATaxAmountInTransCurrency CATaxAmountInTransCurrency Tax Amount
CAInvcgDocItmLoclCurrency CAInvcgDocItmLoclCurrency
CAInvcgDocItmAmtInLoclCurrency CAInvcgDocItmAmtInLoclCurrency
CAInvcgDocItmTaxBaseAmtInLCrcy CAInvcgDocItmTaxBaseAmtInLCrcy
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
Quantity Quantity Value
UnitOfMeasure UnitOfMeasure Unit Protected Qty
UnitOfMeasureISOCode _UnitOfMeasure UnitOfMeasureISOCode
CANetDueDate CANetDueDate Net Due Date
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.
CAInvcgCorrectionCategory CAInvcgCorrectionCategory Invcg Correction Category
CABillToParty CABillToParty Bill-To Party
CABillToRegion CABillToRegion Bill-To Region
CABillFromRegion CABillFromRegion Region Dlv.Plnt
CAControlCode CAControlCode Control Code
CASupplyRegion CASupplyRegion Supply Regi
CABillToCountry CABillToCountry Bill-To Country
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID _WBSElementBasicData WBSElementExternalID WBS Element External ID

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 A_CAInvcgDocItem.
-- 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 A_CAInvcgDocItem AS
SELECT
  CAInvoicingDocument,
  CAInvcgDocItem,
  CAInvcgDocumentItemType,
  CompanyCode,
  Division,
  CAContract,
  CAProviderContractItemNumber,
  CASubApplication,
  CAInvcgItmAltvBusinessPartner,
  CAInvcgItmAltvContractAccount,
  CAInvcgDocItmAltvMDCat,
  CAMainTransaction,
  CASubTransaction,
  CAIsDocItemSimulated,
  CAInvcgDocItemIsReversal,
  CAInvcgIsInFinalAmt,
  CAInvcgIsItemPostingRelevant,
  CAInvcgIsNotBPRelevant,
  CAInvcgIsItemPrintingRelevant,
  CAInvcgSubstituteGroupPrinting,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CACurrencySourceDocument,
  CAInvcgSourceDocumentAmount,
  CAGroupingCurrencyTranslation,
  CAAccountDeterminationCode,
  BusinessPlace,
  BusinessArea,
  CATaxIsIncluded,
  CATaxDetnType,
  CAInvcgTaxGroupingKey,
  CAOtherTaxCode,
  TaxCode,
  CATaxDeterminationCode,
  TaxJurisdiction,
  CATransactionKeyAccountDetn,
  CAConditionType,
  CATaxRateInPercent,
  TaxCountry,
  TransToTaxCntryCrcyCnvrsnFctr,
  CAInvcgOffsettingCategory,
  CAInvcgOffsettingProcedure,
  CAInvcgOffsettingAction,
  CATaxDate,
  CATaxBaseAmount,
  CATaxAmountInTransCurrency,
  CAInvcgDocItmLoclCurrency,
  CAInvcgDocItmAmtInLoclCurrency,
  CAInvcgDocItmTaxBaseAmtInLCrcy,
  CATaxPortionInTransCurrency,
  WithholdingTaxCode,
  CAIsDownPaymentRequest,
  CAInvcgOffsettingGroup,
  CAInvcgDfrrdRevenueStatus,
  CAIsRevenueAccountingRelevant,
  CAInvcgRevenueGrouping,
  CARevenueAccountingServiceType,
  CAInvcgAccrualPostingType,
  CAIsPrepaid,
  Quantity,
  UnitOfMeasure,
  _UnitOfMeasure.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  CANetDueDate,
  CACashDiscountDueDate,
  CACashDiscountRate,
  CAInvcgDocItemDefStatus,
  CAItemPeriodStartDate,
  CAItemPeriodEndDate,
  CAInvcgRefPostingDocType,
  CADocumentNumber,
  CAGroupingKeyDocumentItems,
  CAInvcgGroupingKey,
  CAClearingDocumentNumber,
  CAClearingAmountInTransCrcy,
  CAInvcgDocItemCrtnMethod,
  CAInvcgFunction,
  CAInvcgSourceDocumentCat,
  CAInvcgSourceDocumentNumber,
  CAInvcgDocItemSourceItmCat,
  CAInvcgSourceDocumentItem,
  CABllbleItmDiscountKey,
  CABllbleItmDiscountVersion,
  CAInvcgCorrectionCategory,
  CABillToParty,
  CABillToRegion,
  CABillFromRegion,
  CAControlCode,
  CASupplyRegion,
  CABillToCountry,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID
FROM R_CAInvcgDocItemTP
;

Learn More