A_CADocumentGLItem

DDL: A_CADOCUMENTGLITEM Type: view_entity CONSUMPTION
76 Fields 1 Data Sources

Document General Ledger Item

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

Data Sources (1)

SourceAliasJoin Type
R_CADocumentGLItemTP R_CADocumentGLItemTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Document General Ledger Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
OData.entityType.name CADocGLItem_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

Fields (76)

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
CAAmountInLocalCurrency CAAmountInLocalCurrency Local Crcy Amt
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAAmountInSecondCurrency CAAmountInSecondCurrency Amount in LC 2
CAAmountInThirdCurrency CAAmountInThirdCurrency Amount in LC3
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
CATaxBaseAmountInLocalCurrency CATaxBaseAmountInLocalCurrency Tax base in LC
CATaxBaseAmount CATaxBaseAmount Tax Base Amount
CANonDeductibleTxAmtInDocCrcy CANonDeductibleTxAmtInDocCrcy Non-Ded. Tax
CANonDeductibleTxAmtInLoclCrcy CANonDeductibleTxAmtInLoclCrcy Non-Ded.Tax LC
CAContainsNonDeductibleInptTax CAContainsNonDeductibleInptTax Non-Ded. Input Tax
CATaxRate CATaxRate Tax rate
GrossIncomeTaxActivityCode GrossIncomeTaxActivityCode Activity Code
EmploymentTaxDistributionType EmploymentTaxDistributionType Distr. Type
CATaxPortionInLocalCurrency CATaxPortionInLocalCurrency FI-CA Tax Portion
CATaxPortionInTransCurrency CATaxPortionInTransCurrency Tax Portion
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

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_CADocumentGLItem.
-- 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_CADocumentGLItem AS
SELECT
  CADocumentNumber,
  CAGLItemNumber,
  CompanyCode,
  BusinessArea,
  BusinessPlace,
  Segment,
  ProfitCenter,
  PartnerCompany,
  GLAccount,
  ValueDate,
  CAExchangeRate,
  ExchRateIsIndirectQuotation,
  TransactionCurrency,
  Currency,
  CAAmountInLocalCurrency,
  CAAmountInTransactionCurrency,
  CAAmountInSecondCurrency,
  CAAmountInThirdCurrency,
  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,
  CATaxBaseAmountInLocalCurrency,
  CATaxBaseAmount,
  CANonDeductibleTxAmtInDocCrcy,
  CANonDeductibleTxAmtInLoclCrcy,
  CAContainsNonDeductibleInptTax,
  CATaxRate,
  GrossIncomeTaxActivityCode,
  EmploymentTaxDistributionType,
  CATaxPortionInLocalCurrency,
  CATaxPortionInTransCurrency,
  CATaxIsCalculatedExternally,
  CAAltvExchangeRateSetCode,
  CAIsCashFlowItem,
  CACashFlowAccount,
  CACashFlowCompanyCode,
  HouseBank,
  HouseBankAccount,
  QuantitySignCode,
  BankStatementShortID,
  BankStatementItem,
  CashManagementLinkType,
  CashManagementLink,
  CAItmIsCreatedByPostgInterface,
  CAProfitAnalysisUpdtIsDirect,
  CAInvcgGroupingKey,
  CACtrlFieldForAcctAssgmtDistr,
  CAUpdateMethodForFundsMgmt,
  OriginalFinancialMgmtArea,
  OriglYearForFinMgmtAcctAssgmt,
  EarmarkedFundsDocument
FROM R_CADocumentGLItemTP
;

Learn More