P_CAINVCGDOCITEM

CDS View

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.

Used by 4 CDS view(s) 86 fields

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 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
  usageType:{
    serviceQuality: #D,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
  },
  representativeKey: 'CAInvcgDocItem'
}

define view entity P_CAInvcgDocItem
  as select from I_CAInvcgDocItem as _CAInvcgDocItem

  -- further associations (not on I-level due to view complexity)
  association [0..1] to I_CAMainTransaction  as _CAMainTransaction  on  $projection.CAApplicationArea = _CAMainTransaction.CAApplicationArea
                                                                    and $projection.CAMainTransaction = _CAMainTransaction.CAMainTransaction
  association [0..1] to I_CASubTransaction   as _CASubTransaction   on  $projection.CAApplicationArea = _CASubTransaction.CAApplicationArea
                                                                    and $projection.CAMainTransaction = _CASubTransaction.CAMainTransaction
                                                                    and $projection.CASubTransaction  = _CASubTransaction.CASubTransaction
  association [0..1] to I_CAOtherTaxCode     as _CAOtherTaxCode     on  $projection.CompanyCodeCountry = _CAOtherTaxCode.Country
                                                                    and $projection.CAOtherTaxCode     = _CAOtherTaxCode.CAOtherTaxCode
  association [0..1] to I_TaxCode            as _TaxCode            on  $projection.TaxCalculationProcedure = _TaxCode.TaxCalculationProcedure
                                                                    and $projection.TaxCode                 = _TaxCode.TaxCode
  association [0..1] to I_TaxJurisdiction    as _TaxJurisdiction    on  $projection.TaxCalculationProcedure = _TaxJurisdiction.TaxJurisdictionCalcProcedure
                                                                    and $projection.TaxJurisdiction         = _TaxJurisdiction.TaxJurisdiction
  association [0..1] to I_WithholdingTaxCode as _WithholdingTaxCode on  $projection.WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode
                                                                    and $projection.CompanyCodeCountry = _WithholdingTaxCode.Country
                                                                    
{
  key CAInvoicingDocument,
  key CAInvcgDocItem,
      CAInvcgDocumentItemType,
      CompanyCode,
      Division,
      CAContract,
      CAProviderContractItemNumber,
      CASubApplication,
      CAInvcgItmAltvBusinessPartner,
      CAInvcgItmAltvContractAccount,
      CAInvcgDocItmAltvMDCat,
      @ObjectModel.foreignKey.association: '_CAMainTransaction'
      CAMainTransaction,
      @ObjectModel.foreignKey.association: '_CASubTransaction'
      CASubTransaction,
      CAIsDocItemSimulated,
      CAInvcgDocItemIsReversal,
      CAInvcgIsInFinalAmt,
      CAInvcgIsItemPostingRelevant,
      CAInvcgIsNotBPRelevant,
      CAInvcgIsItemPrintingRelevant,
      CAInvcgSubstituteGroupPrinting,
      TransactionCurrency,
      CAAmountInTransactionCurrency,
      CAInvcgDocItmLoclCurrency,
      CAInvcgDocItmAmtInLoclCurrency,
      CAInvcgDocItmTaxBaseAmtInLCrcy,
      CACurrencySourceDocument,
      CAInvcgSourceDocumentAmount,
      CAGroupingCurrencyTranslation,
      CAAccountDeterminationCode,
      BusinessPlace,
      BusinessArea,
      CATaxIsIncluded,
      CATaxDetnType,
      CAInvcgTaxGroupingKey,
      @ObjectModel.foreignKey.association: '_CAOtherTaxCode'
      CAOtherTaxCode,
      @ObjectModel.foreignKey.association: '_TaxCode'
      TaxCode,
      CATaxDeterminationCode,
      @ObjectModel.foreignKey.association: '_TaxJurisdiction'
      TaxJurisdiction,
      CATransactionKeyAccountDetn,
      CAConditionType,
      CATaxRateInPercent,
      TaxCountry,
      TransToTaxCntryCrcyCnvrsnFctr,
      CAInvcgOffsettingCategory,
      CAInvcgOffsettingProcedure,
      CAInvcgOffsettingAction,
      CATaxDate,
      CATaxBaseAmount,
      CATaxAmountInTransCurrency,
      CATaxPortionInTransCurrency,
      @ObjectModel.foreignKey.association: '_WithholdingTaxCode'
      WithholdingTaxCode,
      CAIsDownPaymentRequest,
      CAStatisticalItemCode,
      CAInvcgOffsettingGroup,
      CAInvcgDfrrdRevenueStatus,
      CAIsRevenueAccountingRelevant,
      CAInvcgRevenueGrouping,
      CARevenueAccountingServiceType,
      CAInvcgAccrualPostingType,
      CAIsPrepaid,
      UnitOfMeasure,
      Quantity,
      CANetDueDate,
      CACashDiscountDueDate,
      CACashDiscountRate,
      CAInvcgDocItemDefStatus,
      CAItemPeriodStartDate,
      CAItemPeriodEndDate,
      CAInvcgRefPostingDocType,
      CADocumentNumber,
      CAGroupingKeyDocumentItems,
      CAInvcgGroupingKey,
      CAClearingDocumentNumber,
      CAClearingAmountInTransCrcy,
      CAInvcgDocItemCrtnMethod,
      CAInvcgFunction,
      CAInvcgSourceDocumentCat,
      CAInvcgSourceDocumentNumber,
      CAInvcgDocItemSourceItmCat,
      CAInvcgSourceDocumentItem,
      CABllbleItmDiscountKey,
      CABllbleItmDiscountVersion,
      CAInvcgCorrectionCategory,

      //applk

      _CAInvcgDocItem._CAInvcgDocHeader.CAApplicationArea as CAApplicationArea,

      case when TaxCountry is initial
        then _CAInvcgDocItem._CompCode._Country.TaxCalculationProcedure
        else _CAInvcgDocItem._TaxCountry.TaxCalculationProcedure
      end                                                 as TaxCalculationProcedure,

      _CAInvcgDocItem._CompCode.Country                   as CompanyCodeCountry,

      /* Associations */
      _CAMainTransaction,
      _CASubTransaction,
      _CAOtherTaxCode,
      _TaxCode,
      _WithholdingTaxCode,
      _TaxJurisdiction,

      _BusinessArea,
      _CAAccountDetnCode,
      _CABllbleItmDiscountKey,
      _CAConditionType,
      _CACurrencySourceDocument,
      _CADeferredRevenueStatus,
      _CADocument,
      _CAInvcgDocHeader,
      _CAInvcgDocItemType,
      _CAInvcgDocItmAltvMDCat,
      _CAInvcgDocItmCrtnMethod,
      _CAInvcgDocItmDefStatus,
      _CAInvcgDocItmSrceItmCat,
      _CAInvcgFunction,
      _CAInvcgItmAltvBusinessPartner,
      _CAInvcgItmAltvContractAccount,
      _CAInvcgRefPostgDocTyp,
      _CAInvcgSourceDocCat,
      _CARevnAcctgServiceType,
      _CAInvcgAccrualPostingType,
      _CAStatisticalItemCode,
      _CASubApplication,
      _CATaxDetnType,
      _CATransactionKeyAcctDetn,
      _CompCode,
      _Division,
      _TaxCountry,
      _TransactionCurrency,
      _UnitOfMeasure,
      _CAInvcgCorrectionCat,
      _CAInvcgOffsettingAction,
      _CAInvcgOffsettingCategory,
      _CAInvcgOffsettingProcedure,

      // Moved from Extension View X_S4C_P_CAINVCGDOCITEM

      _CAInvcgDocItem.CABillToParty,
      _CAInvcgDocItem.CABillToRegion,
      _CAInvcgDocItem.CABillFromRegion,
      _CAInvcgDocItem.CAControlCode,
      _CAInvcgDocItem.CASupplyRegion,
      _CAInvcgDocItem.CABillToCountry,
      _CAInvcgDocItem.WBSElementInternalID,
      _WBSElementBasicData
}

Learn More