I_ACTUALPLANLINEITEMSEMTAG

CDS View
19 Fields 8 CDS Views

Actual and Plan Line Item with Semantic Tag Including FA

I_ACTUALPLANLINEITEMSEMTAG is a CDS View in S/4HANA. Actual and Plan Line Item with Semantic Tag Including FA. It contains 19 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_FinancialStatementKPI view from CONSUMPTION KPIs based on Financial Statements
C_SlsAcctgOvwFilter view from CONSUMPTION Sales Accounting OVP filter
I_SlsAcctgGrssMargPerMatlOvw view from COMPOSITE Gross Margin per Material card data
P_PPM_ProjectCostsPerPeriod view from COMPOSITE Project Costs with period information (year/month)
P_RevenueVarianceCnstnt view from COMPOSITE Revenue Variance
P_SlsAcctgMonthlyDeductionsOvw view from COMPOSITE Sales Deductions Monthly Card Data
P_SlsAcctgSlsDdctdBenchmarkOvw view from COMPOSITE Sales Deductions Benchmark Card
P_SlsAcctgSlsDdeductionsOvw view from COMPOSITE Sales Deductions Overview Card Data

Fields (19)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FinancialPlanningDataPacket FinancialPlanningDataPacket 1
KEY FinancialPlanningEntryItem FinancialPlanningEntryItem 1
KEY FinancialPlanningReqTransSqnc FinancialPlanningReqTransSqnc 1
KEY FiscalYear FiscalYear 1
KEY GLAccountHierarchy GLAccountHierarchy 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SourceLedger SourceLedger 1
KEY ValidityEndDate ValidityEndDate 1
KEY ValidityStartDate ValidityStartDate 1
_CompanyCode _CompanyCode 1
_FiscalYear _FiscalYear 1
_GLAccountHierarchy _GLAccountHierarchy 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
_SourceLedger _SourceLedger 1
AccountingDocumentType AccountingDocumentType 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.

-- Actual and Plan Line Item with Semantic Tag Including FA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACTUALPLANLINEITEMSEMTAG (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    GLACCOUNTHIERARCHY,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    _COMPANYCODE,
    _FISCALYEAR,
    _GLACCOUNTHIERARCHY,
    _JOURNALENTRY,
    _LEDGER,
    _SOURCELEDGER,
    ACCOUNTINGDOCUMENTTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, GLACCOUNTHIERARCHY, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More