P_CAINVCGDOCITEM

CDS View
86 Fields 4 CDS Views

Invoicing Document Item

P_CAINVCGDOCITEM is a CDS View in S/4HANA. Invoicing Document Item. It contains 86 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_CABillgReqInvcgDocItem view_entity from CONSUMPTION Abrechnungsauftrag Positionen
C_CAInvcgDocItem view_entity from CONSUMPTION Fakturierungsbelegposition
C_CANotDisputedInvcgDocItem view_entity from CONSUMPTION Not disputed invoicing item
I_CADisputedInvcgDocItem view_entity inner COMPOSITE Disputed invoicing document item

Fields (86)

KeyField CDS FieldsUsed in Views
KEY CAInvcgDocItem CAInvcgDocItem 3
KEY CAInvoicingDocument CAInvoicingDocument 3
BusinessArea BusinessArea 2
BusinessPlace BusinessPlace 2
CAAccountDeterminationCode CAAccountDeterminationCode 2
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 3
CABillFromRegion CABillFromRegion 1
CABillToCountry CABillToCountry 1
CABillToParty CABillToParty 1
CABillToRegion CABillToRegion 1
CABllbleItmDiscountKey CABllbleItmDiscountKey 2
CABllbleItmDiscountVersion CABllbleItmDiscountVersion 2
CACashDiscountDueDate CACashDiscountDueDate 2
CACashDiscountRate CACashDiscountRate 2
CAClearingAmountInTransCrcy CAClearingAmountInTransCrcy 2
CAClearingDocumentNumber CAClearingDocumentNumber 2
CAConditionType CAConditionType 2
CAContract CAContract 3
CAControlCode CAControlCode 1
CACurrencySourceDocument CACurrencySourceDocument 2
CADocumentNumber CADocumentNumber 2
CAGroupingCurrencyTranslation CAGroupingCurrencyTranslation 2
CAGroupingKeyDocumentItems CAGroupingKeyDocumentItems 2
CAInvcgAccrualPostingType CAInvcgAccrualPostingType 2
CAInvcgCorrectionCategory CAInvcgCorrectionCategory 2
CAInvcgDfrrdRevenueStatus CAInvcgDfrrdRevenueStatus 2
CAInvcgDocItemCrtnMethod CAInvcgDocItemCrtnMethod 2
CAInvcgDocItemDefStatus CAInvcgDocItemDefStatus 2
CAInvcgDocItemIsReversal CAInvcgDocItemIsReversal 2
CAInvcgDocItemSourceItmCat CAInvcgDocItemSourceItmCat 2
CAInvcgDocItmAltvMDCat CAInvcgDocItmAltvMDCat 2
CAInvcgDocItmAmtInLoclCurrency CAInvcgDocItmAmtInLoclCurrency 1
CAInvcgDocItmLoclCurrency CAInvcgDocItmLoclCurrency 1
CAInvcgDocItmTaxBaseAmtInLCrcy CAInvcgDocItmTaxBaseAmtInLCrcy 1
CAInvcgDocumentItemType CAInvcgDocumentItemType 3
CAInvcgFunction CAInvcgFunction 2
CAInvcgGroupingKey CAInvcgGroupingKey 2
CAInvcgIsInFinalAmt CAInvcgIsInFinalAmt 2
CAInvcgIsItemPostingRelevant CAInvcgIsItemPostingRelevant 2
CAInvcgIsItemPrintingRelevant CAInvcgIsItemPrintingRelevant 2
CAInvcgIsNotBPRelevant CAInvcgIsNotBPRelevant 2
CAInvcgItmAltvBusinessPartner CAInvcgItmAltvBusinessPartner 2
CAInvcgItmAltvContractAccount CAInvcgItmAltvContractAccount 2
CAInvcgOffsettingGroup CAInvcgOffsettingGroup 2
CAInvcgRefPostingDocType CAInvcgRefPostingDocType 2
CAInvcgRevenueGrouping CAInvcgRevenueGrouping 2
CAInvcgSourceDocumentAmount CAInvcgSourceDocumentAmount 2
CAInvcgSourceDocumentCat CAInvcgSourceDocumentCat 2
CAInvcgSourceDocumentItem CAInvcgSourceDocumentItem 2
CAInvcgSourceDocumentNumber CAInvcgSourceDocumentNumber 2
CAInvcgSubstituteGroupPrinting CAInvcgSubstituteGroupPrinting 2
CAInvcgTaxGroupingKey CAInvcgTaxGroupingKey 3
CAIsDocItemSimulated CAIsDocItemSimulated 3
CAIsDownPaymentRequest CAIsDownPaymentRequest 2
CAIsPrepaid CAIsPrepaid 2
CAIsRevenueAccountingRelevant CAIsRevenueAccountingRelevant 1
CAItemPeriodEndDate CAItemPeriodEndDate 2
CAItemPeriodStartDate CAItemPeriodStartDate 2
CAMainTransaction CAMainTransaction 3
CANetDueDate CANetDueDate 2
CAOtherTaxCode CAOtherTaxCode 2
CAProviderContractItemNumber CAProviderContractItemNumber 2
CARevenueAccountingServiceType CARevenueAccountingServiceType 2
CAStatisticalItemCode CAStatisticalItemCode 2
CASubApplication CASubApplication 3
CASubTransaction CASubTransaction 3
CASupplyRegion CASupplyRegion 1
CATaxAmountInTransCurrency CATaxAmountInTransCurrency 2
CATaxBaseAmount CATaxBaseAmount 2
CATaxDate CATaxDate 2
CATaxDeterminationCode CATaxDeterminationCode 2
CATaxDetnType CATaxDetnType 2
CATaxIsIncluded CATaxIsIncluded 3
CATaxPortionInTransCurrency CATaxPortionInTransCurrency 2
CATaxRateInPercent CATaxRateInPercent 3
CATransactionKeyAccountDetn CATransactionKeyAccountDetn 2
CompanyCode CompanyCode 3
Division Division 2
Quantity Quantity 3
TaxCode TaxCode 3
TaxCountry TaxCountry 1
TaxJurisdiction TaxJurisdiction 2
TransactionCurrency TransactionCurrency 3
UnitOfMeasure UnitOfMeasure 3
WBSElementInternalID WBSElementInternalID 1
WithholdingTaxCode WithholdingTaxCode 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Invoicing Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CAINVCGDOCITEM (
    CAINVCGDOCITEM,
    CAINVOICINGDOCUMENT,
    BUSINESSAREA,
    BUSINESSPLACE,
    CAACCOUNTDETERMINATIONCODE,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CABILLFROMREGION,
    CABILLTOCOUNTRY,
    CABILLTOPARTY,
    CABILLTOREGION,
    CABLLBLEITMDISCOUNTKEY,
    CABLLBLEITMDISCOUNTVERSION,
    CACASHDISCOUNTDUEDATE,
    CACASHDISCOUNTRATE,
    CACLEARINGAMOUNTINTRANSCRCY,
    CACLEARINGDOCUMENTNUMBER,
    CACONDITIONTYPE,
    CACONTRACT,
    CACONTROLCODE,
    CACURRENCYSOURCEDOCUMENT,
    CADOCUMENTNUMBER,
    CAGROUPINGCURRENCYTRANSLATION,
    CAGROUPINGKEYDOCUMENTITEMS,
    CAINVCGACCRUALPOSTINGTYPE,
    CAINVCGCORRECTIONCATEGORY,
    CAINVCGDFRRDREVENUESTATUS,
    CAINVCGDOCITEMCRTNMETHOD,
    CAINVCGDOCITEMDEFSTATUS,
    CAINVCGDOCITEMISREVERSAL,
    CAINVCGDOCITEMSOURCEITMCAT,
    CAINVCGDOCITMALTVMDCAT,
    CAINVCGDOCITMAMTINLOCLCURRENCY,
    CAINVCGDOCITMLOCLCURRENCY,
    CAINVCGDOCITMTAXBASEAMTINLCRCY,
    CAINVCGDOCUMENTITEMTYPE,
    CAINVCGFUNCTION,
    CAINVCGGROUPINGKEY,
    CAINVCGISINFINALAMT,
    CAINVCGISITEMPOSTINGRELEVANT,
    CAINVCGISITEMPRINTINGRELEVANT,
    CAINVCGISNOTBPRELEVANT,
    CAINVCGITMALTVBUSINESSPARTNER,
    CAINVCGITMALTVCONTRACTACCOUNT,
    CAINVCGOFFSETTINGGROUP,
    CAINVCGREFPOSTINGDOCTYPE,
    CAINVCGREVENUEGROUPING,
    CAINVCGSOURCEDOCUMENTAMOUNT,
    CAINVCGSOURCEDOCUMENTCAT,
    CAINVCGSOURCEDOCUMENTITEM,
    CAINVCGSOURCEDOCUMENTNUMBER,
    CAINVCGSUBSTITUTEGROUPPRINTING,
    CAINVCGTAXGROUPINGKEY,
    CAISDOCITEMSIMULATED,
    CAISDOWNPAYMENTREQUEST,
    CAISPREPAID,
    CAISREVENUEACCOUNTINGRELEVANT,
    CAITEMPERIODENDDATE,
    CAITEMPERIODSTARTDATE,
    CAMAINTRANSACTION,
    CANETDUEDATE,
    CAOTHERTAXCODE,
    CAPROVIDERCONTRACTITEMNUMBER,
    CAREVENUEACCOUNTINGSERVICETYPE,
    CASTATISTICALITEMCODE,
    CASUBAPPLICATION,
    CASUBTRANSACTION,
    CASUPPLYREGION,
    CATAXAMOUNTINTRANSCURRENCY,
    CATAXBASEAMOUNT,
    CATAXDATE,
    CATAXDETERMINATIONCODE,
    CATAXDETNTYPE,
    CATAXISINCLUDED,
    CATAXPORTIONINTRANSCURRENCY,
    CATAXRATEINPERCENT,
    CATRANSACTIONKEYACCOUNTDETN,
    COMPANYCODE,
    DIVISION,
    QUANTITY,
    TAXCODE,
    TAXCOUNTRY,
    TAXJURISDICTION,
    TRANSACTIONCURRENCY,
    UNITOFMEASURE,
    WBSELEMENTINTERNALID,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (CAINVCGDOCITEM, CAINVOICINGDOCUMENT)
);

Learn More