C_CADocumentTaxGLItem

DDL: C_CADOCUMENTTAXGLITEM Type: view_entity CONSUMPTION
102 Fields 1 Data Sources

Tax Item

C_CADocumentTaxGLItem is a Consumption CDS View that provides data about "Tax Item" in SAP S/4HANA. It reads from 1 data source (R_CADocumentGLItemTP) and exposes 102 fields with key fields CADocumentNumber, CAGLItemNumber.

Data Sources (1)

SourceAliasJoin Type
R_CADocumentGLItemTP R_CADocumentGLItemTP from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Tax Item view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
Metadata.allowExtensions true view

Fields (102)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY CAGLItemNumber CAGLItemNumber Item
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
BusinessPlace BusinessPlace Business place
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
PartnerCompany PartnerCompany Trading Partner
GLAccount GLAccount General Ledger
ValueDate ValueDate Value Date
CAExchangeRate CAExchangeRate Absolute Exchange Rate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation
TransactionCurrency TransactionCurrency Transaction Currency
Currency Currency Valuation Crcy
CAAccountAssignmentCategory CAAccountAssignmentCategory Acct Assgt Cat.
CAAccountAssignment CAAccountAssignment Acct assignment
CostCenter CostCenter Cost Center
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
CAReconciliationKey CAReconciliationKey Reconcil. Key
CAInternalPostingReasonCode CAInternalPostingReasonCode Posting Reason
CANegativePostingControlCode CANegativePostingControlCode Negative Pstng
CAGLPostingCurrency CAGLPostingCurrency G/L Currency
LedgerGroup LedgerGroup Ledger Group
ProfitabilitySegment_2 ProfitabilitySegment_2 Profit. segment
ProfitabilitySegmentChanges ProfitabilitySegmentChanges Subnumber
PlanningLevel PlanningLevel Planning Level
CARepetitionGroup CARepetitionGroup Repetition grp
CATransactionKeyAccountDetn CATransactionKeyAccountDetn Autom. Posting
ConditionType ConditionType Condition type
CAIsSeparateLineItemInGL CAIsSeparateLineItemInGL Line item
BaseUnit BaseUnit Unit of Measure
TaxCode TaxCode Tax Code
CASupplementaryTaxCode CASupplementaryTaxCode Supplem. Tax
CAWithholdingTaxSupplement CAWithholdingTaxSupplement WT supplmt
CAOtherTaxCode CAOtherTaxCode TxCde:Oth.Taxes
CAGroupingCodeForTaxItems CAGroupingCodeForTaxItems Tax Group
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
CAEnteredTaxJurisdictionCode CAEnteredTaxJurisdictionCode Orig.jurisdict.
CATaxJurisdictionLevelCounter CATaxJurisdictionLevelCounter Tax level
CATaxExceptionID CATaxExceptionID Tax exception
CATaxDate CATaxDate Tax Date
CAContainsNonDeductibleInptTax CAContainsNonDeductibleInptTax Non-Ded. Input Tax
CATaxRate CATaxRate Tax rate
GrossIncomeTaxActivityCode GrossIncomeTaxActivityCode Activity Code
EmploymentTaxDistributionType EmploymentTaxDistributionType Distr. Type
CATaxIsCalculatedExternally CATaxIsCalculatedExternally Tax by Document
CAAltvExchangeRateSetCode CAAltvExchangeRateSetCode Alt.Exch.Rate
CAIsCashFlowItem CAIsCashFlowItem Cash Flow
CACashFlowAccount CACashFlowAccount Cash Flow Acct
CACashFlowCompanyCode CACashFlowCompanyCode Cash Flow CoCd
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
QuantitySignCode QuantitySignCode Qty +/- Sign
BankStatementShortID BankStatementShortID Statement Short Key
BankStatementItem BankStatementItem Memo Record No.
CashManagementLinkType CashManagementLinkType Link Type
CashManagementLink CashManagementLink Link ID
CAItmIsCreatedByPostgInterface CAItmIsCreatedByPostgInterface Created Int.
CAProfitAnalysisUpdtIsDirect CAProfitAnalysisUpdtIsDirect CO-PA updated
CAInvcgGroupingKey CAInvcgGroupingKey Inv. Grouping
CACtrlFieldForAcctAssgmtDistr CACtrlFieldForAcctAssgmtDistr Distribution Status
CAUpdateMethodForFundsMgmt CAUpdateMethodForFundsMgmt FM Type
OriginalFinancialMgmtArea OriginalFinancialMgmtArea Original FMArea
OriglYearForFinMgmtAcctAssgmt OriglYearForFinMgmtAcctAssgmt Original Year
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
ChartOfAccounts ChartOfAccounts Node Class
Country Country Venue: Ctry/Reg
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
CAAmountInLocalCurrency CAAmountInLocalCurrency Local Crcy Amt
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAAmountInSecondCurrency CAAmountInSecondCurrency Amount in LC 2
CAAmountInThirdCurrency CAAmountInThirdCurrency Amount in LC3
CATaxPortionInLocalCurrency CATaxPortionInLocalCurrency FI-CA Tax Portion
CATaxPortionInTransCurrency CATaxPortionInTransCurrency Tax Portion
CATaxBaseAmountInLocalCurrency CATaxBaseAmountInLocalCurrency Tax base in LC
CATaxBaseAmount CATaxBaseAmount Tax Base Amount
CANonDeductibleTxAmtInDocCrcy CANonDeductibleTxAmtInDocCrcy Non-Ded. Tax
CANonDeductibleTxAmtInLoclCrcy CANonDeductibleTxAmtInLoclCrcy Non-Ded.Tax LC
_AcctAssgmtCat _AcctAssgmtCat
_BusinessArea _BusinessArea
_CAAcctAssgmtDistrCode _CAAcctAssgmtDistrCode
_CAAcctDetnTransKey _CAAcctDetnTransKey
_CAAltvExchangeRateSetCode _CAAltvExchangeRateSetCode
_CAEuroConversionStatus _CAEuroConversionStatus
_CAIntPostingReasonCode _CAIntPostingReasonCode
_CANegativePostingCtrlCode _CANegativePostingCtrlCode
_CANonDcblInputTaxCode _CANonDcblInputTaxCode
_CashFlowAccount _CashFlowAccount
_ChartOfAccounts _ChartOfAccounts
_CompCode _CompCode
_CompCodeCashFlow _CompCodeCashFlow
_Country _Country
_DocHeader _DocHeader
_GLAccount _GLAccount
_GLAccountInCompanyCode _GLAccountInCompanyCode
_GLPostingCurrency _GLPostingCurrency
_OtherTaxCode _OtherTaxCode
_PartnerCompany _PartnerCompany
_ProfitCenter _ProfitCenter
_Segment _Segment
_WhldgTaxSuplmnt _WhldgTaxSuplmnt

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_CADocumentTaxGLItem.
-- 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_CADocumentTaxGLItem AS
SELECT
  CADocumentNumber,
  CAGLItemNumber,
  CompanyCode,
  BusinessArea,
  BusinessPlace,
  Segment,
  ProfitCenter,
  PartnerCompany,
  GLAccount,
  ValueDate,
  CAExchangeRate,
  ExchRateIsIndirectQuotation,
  TransactionCurrency,
  Currency,
  CAAccountAssignmentCategory,
  CAAccountAssignment,
  CostCenter,
  SalesOrder,
  SalesOrderItem,
  CAReconciliationKey,
  CAInternalPostingReasonCode,
  CANegativePostingControlCode,
  CAGLPostingCurrency,
  LedgerGroup,
  ProfitabilitySegment_2,
  ProfitabilitySegmentChanges,
  PlanningLevel,
  CARepetitionGroup,
  CATransactionKeyAccountDetn,
  ConditionType,
  CAIsSeparateLineItemInGL,
  BaseUnit,
  TaxCode,
  CASupplementaryTaxCode,
  CAWithholdingTaxSupplement,
  CAOtherTaxCode,
  CAGroupingCodeForTaxItems,
  TaxJurisdiction,
  CAEnteredTaxJurisdictionCode,
  CATaxJurisdictionLevelCounter,
  CATaxExceptionID,
  CATaxDate,
  CAContainsNonDeductibleInptTax,
  CATaxRate,
  GrossIncomeTaxActivityCode,
  EmploymentTaxDistributionType,
  CATaxIsCalculatedExternally,
  CAAltvExchangeRateSetCode,
  CAIsCashFlowItem,
  CACashFlowAccount,
  CACashFlowCompanyCode,
  HouseBank,
  HouseBankAccount,
  QuantitySignCode,
  BankStatementShortID,
  BankStatementItem,
  CashManagementLinkType,
  CashManagementLink,
  CAItmIsCreatedByPostgInterface,
  CAProfitAnalysisUpdtIsDirect,
  CAInvcgGroupingKey,
  CACtrlFieldForAcctAssgmtDistr,
  CAUpdateMethodForFundsMgmt,
  OriginalFinancialMgmtArea,
  OriglYearForFinMgmtAcctAssgmt,
  EarmarkedFundsDocument,
  ChartOfAccounts,
  Country,
  TaxCalculationProcedure,
  CAAmountInLocalCurrency,
  CAAmountInTransactionCurrency,
  CAAmountInSecondCurrency,
  CAAmountInThirdCurrency,
  CATaxPortionInLocalCurrency,
  CATaxPortionInTransCurrency,
  CATaxBaseAmountInLocalCurrency,
  CATaxBaseAmount,
  CANonDeductibleTxAmtInDocCrcy,
  CANonDeductibleTxAmtInLoclCrcy
FROM R_CADocumentGLItemTP
;

Learn More