I_CAEXTRACTDOCUMENTGLITEM

CDS View

Offsetting Items for FICA Extracted Doc

I_CAEXTRACTDOCUMENTGLITEM is a CDS View in S/4HANA. Offsetting Items for FICA Extracted Doc. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CAC_AUDIT_Z3_CA_DOCGLITEM view from Audit Z3 FICA - G/L Account Items

Fields (18)

KeyField CDS FieldsUsed in Views
KEY CADocumentNumber CADocumentNumber 1
KEY CAExtractDocumentItem CAExtractDocumentItem 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
_BusinessArea _BusinessArea 1
_CompCode _CompCode 1
_DocHeader _DocHeader 1
_Segment _Segment 1
BusinessArea BusinessArea 1
CAAmountInLocalCurrency CAAmountInLocalCurrency 1
CAAmountInTransactionCurrency CAAmountInTransactionCurrency 1
CATaxRate CATaxRate 1
CompanyCodeCurrency CompanyCodeCurrency 1
GLAccount GLAccount 1
Segment Segment 1
TaxCode TaxCode 1
TransactionCurrency TransactionCurrency 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.

-- Offsetting Items for FICA Extracted Doc
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CAEXTRACTDOCUMENTGLITEM (
    CADOCUMENTNUMBER,
    CAEXTRACTDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    _BUSINESSAREA,
    _COMPCODE,
    _DOCHEADER,
    _SEGMENT,
    BUSINESSAREA,
    CAAMOUNTINLOCALCURRENCY,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CATAXRATE,
    COMPANYCODECURRENCY,
    GLACCOUNT,
    SEGMENT,
    TAXCODE,
    TRANSACTIONCURRENCY,
    VALUEDATE,
    PRIMARY KEY (CADOCUMENTNUMBER, CAEXTRACTDOCUMENTITEM, COMPANYCODE, FISCALYEAR)
);