I_CADOCUMENTGLITEM

CDS View
26 Fields 15 CDS Views

Document General Ledger Item

I_CADOCUMENTGLITEM is a CDS View in S/4HANA. Document General Ledger Item. It contains 26 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
I_SAFTLineItemCA view inner COMPOSITE SAF-T FI-CA GL Line Item
P_BOPFICA_GL_ITEM view_entity inner COMPOSITE FI-CA GL Item
P_CADocPaytAmtCashFlowItem view from COMPOSITE
P_CADocumentGLItemCount view_entity from COMPOSITE Count of Document GL Items
P_CADocumentSumGLItem view_entity from COMPOSITE Summarized CA General Ledger Items
P_CAStRpGLTaxItem view_entity from COMPOSITE
P_ContrAcctgGLItem view_entity inner COMPOSITE
P_GR_DocJournalGLBasic view_entity from CONSUMPTION
P_IL_CADocumentGLItemAggrgn view_entity from COMPOSITE
P_PT_CAOpenItemSum view_entity inner COMPOSITE
P_RO_SAFTCActgJournalItemBase0 view_entity union CONSUMPTION
P_SAFTSumLineItemCA view from COMPOSITE
P_SG_CAInvoiceTaxItem view union_all COMPOSITE
P_SK_CAOPKItem view_entity from COMPOSITE
R_CADocumentGLItemTP view_entity from TRANSACTIONAL Document General Ledger Item - TP

Fields (26)

KeyField CDS FieldsUsed in Views
KEY CADocumentNumber CADocumentNumber 5
KEY CAGLItemNumber CAGLItemNumber 3
KEY CompanyCode CompanyCode 4
KEY GLAccount CAReconciliationAccount,GLAccount 6
KEY TaxCode TaxCode 5
KEY TransactionCurrency TransactionCurrency 4
_CompCode _CompanyCode,_CompCode 2
_DocHeader _DocHeader 2
CAAmountInLocalCurrency AmountInCompanyCodeCurrency,CAAmountInLocalCurrency,CATaxAmountInLocalCurrency 4
CAAmountInTransactionCurrency CAAmountInTransactionCurrency,CATaxAmount 4
CAExchangeRate CAExchangeRate 1
CAReconciliationKey ReconciliationKey 1
CATaxBaseAmount CATaxBaseAmount 2
CATaxBaseAmountInLocalCurrency CATaxBaseAmountInLocalCurrency 2
CATaxRate CATaxRate 3
CATransactionKeyAccountDetn CATransactionKeyAccountDetn,TransactionTypeDetermination 4
ChartOfAccounts ChartOfAccounts 3
CostCenter CostCenter 2
Currency CompanyCodeCurrency,Currency 2
LedgerGroup LedgerGroup 1
PartnerCompany PartnerCompany 1
SalesOrder SalesDocument 1
SalesOrderItem SalesDocumentItem 1
TaxCountry TaxCountry 1
TaxJurisdiction TaxJurisdiction 1
ValueDate ValueDate 1

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.

-- Document General Ledger Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CADOCUMENTGLITEM (
    CADOCUMENTNUMBER,
    CAGLITEMNUMBER,
    COMPANYCODE,
    GLACCOUNT,
    TAXCODE,
    TRANSACTIONCURRENCY,
    _COMPCODE,
    _DOCHEADER,
    CAAMOUNTINLOCALCURRENCY,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CAEXCHANGERATE,
    CARECONCILIATIONKEY,
    CATAXBASEAMOUNT,
    CATAXBASEAMOUNTINLOCALCURRENCY,
    CATAXRATE,
    CATRANSACTIONKEYACCOUNTDETN,
    CHARTOFACCOUNTS,
    COSTCENTER,
    CURRENCY,
    LEDGERGROUP,
    PARTNERCOMPANY,
    SALESORDER,
    SALESORDERITEM,
    TAXCOUNTRY,
    TAXJURISDICTION,
    VALUEDATE,
    PRIMARY KEY (CADOCUMENTNUMBER, CAGLITEMNUMBER, COMPANYCODE, GLACCOUNT, TAXCODE, TRANSACTIONCURRENCY)
);

Learn More