- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
I_ActualPlanStatKeyFigSemTag
Semantic Tag with Statistical Key Figure
| view: IFIACTPLNSEMTAG | TRAN
| Extraction:
Not supported
| Component: Information System
Tables used:
SCAL_TT_DATE, ACDOCA, ACDOCP, BKPF, FINSSKF, FAAC_KFCSET_SPEC, FAAC_KFCT, T004, T001, TKA02, TKA01, SKA1, FINSC_LEDGER, PROJ, T000, FINSC_SEM_TAG, HRRP_FSV_DIR, PRPS, TKA03, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LD_CMP, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
- 🔑 Keys (16)
- 💰 Amounts (5)
- ∑ Quantities (1)
- 📅 Dates (5)
- ☰ Categorical (2)
- Other (28)
- 🔗 Relations (12)
| Column Name | Description | |
|---|---|---|
| Ledger FK | Ledger | |
| CompanyCode FK | Company Code | |
| FiscalYear | Fiscal Year | |
| FiscalPeriod | Fiscal Period | |
| StatisticalKeyFigure FK | Statistical Key Figure | |
| SemanticTag | Semantic Tag of a Hierarchy Node | |
| StatisticalKeyFigureItem | Statistical Key Figure Item | |
| ValidityStartDate | Valid-From Date | |
| ValidityEndDate | Valid-From Date | |
| GLAccountHierarchy | Financial Statement Version | |
| LedgerGLLineItem | Ledger Journal Entry Item | |
| FinancialPlanningReqTransSqnc | Financial Planning Request Transaction Sequence Number | |
| FinancialPlanningDataPacket | Financial Planning Data Packet Number | |
| FinancialPlanningEntryItem | Financial Planning Entry Item | |
| SourceLedger | Source Ledger | |
| AccountingDocument | Journal Entry |
| Column Name | Description | |
|---|---|---|
| 💲 Company Code Currency (CompanyCodeCurrency): | ||
| AmountInCompanyCodeCurrency | Amount in Company Code Currency | |
| InvertedAmtInCoCodeCurrency | Inverted Amount in Company Code Currency | |
| 💲 Global Currency (GlobalCurrency): | ||
| AmountInGlobalCurrency | Amount in Global Currency | |
| InvertedAmountInGlobalCurrency | Inverted Amount in Global Currency | |
| 💲 Freely Defined Currency 1 (FreeDefinedCurrency1): | ||
| AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | |
| Column Name | Description | |
|---|---|---|
| 📏 Statistical Key Figure Quantity Unit (StatisticalKeyFigQtyUnit): | ||
| StatisticalKeyFigureQuantity | Statistical Key Figure Quantity | |
| Column Name | Description | |
|---|---|---|
| ValidityStartDate | Valid-From Date | |
| ValidityEndDate | Valid-From Date | |
| PostingDate | Posting Date | |
| CreationTime | Creation Time | |
| CreationDate | Creation Date |
| Column Name | Description | |
|---|---|---|
| ActualPlanCode | Actual Plan Code | Show values |
| FinancialAccountType | Account Type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| PartnerFunctionalArea | Partner Functional Area | FKBER | |
| StatKeyFigurePlanningCategory | Statistical Key Figure Plan Category | FCOM_CATEGORY | |
| FiscalYearPeriod | Fiscal Year + Fiscal Period | FINS_FYEARPERIOD | |
| PlanningCategory | Plan Category | FCOM_CATEGORY | |
| ActualPlanStatKeyFigureCode | Actual Plan Code | FIS_ACTLPLN_SKF_CODE | |
| ProjectProfileCode | Project Profile | PROFIDPROJ | |
| PartnerProjectProfileCode | Project Profile | PROFIDPROJ | |
| AccountingDocumentHeaderText | Document Header Text | TEXT25 | |
| SemanticTagGroup | Semantic Tag Group | FINS_SEM_TAG_GROUP | |
| AccountingDocCreatedByUser | User that created the journal entry | ||
| PersonnelNumber | Personnel Number | PERNR | |
| ChartOfAccounts | Chart of Accounts | KTOPL | |
| GLAccount | G/L Account | SAKNR | |
| AccountAssignment | Account Assignment | ACCAS | |
| PartnerAccountAssignment | Partner Account Assignment | ACCAS | |
| PartnerAccountAssignmentType | Partner Account Assignment Type | J_OBART | |
| SalesDocument | Sales Order Number | VBELN | |
| ServiceDocument | Service Document ID | CRM_OBJECT_ID | |
| ServiceDocumentType | Service Document Type | CRM_PROCESS_TYPE | |
| Supplier | Supplier | LIFNR | |
| Customer | Customer Number | KUNNR | |
| AccountingDocumentType | Journal Entry Type | BLART | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| OrganizationDivision | Organization Division | SPART | |
| Plant | Plant | WERKS | |
| AssetClass | Asset Class | ANLKL | |
| ValuationArea | Valuation area | BWKEY |
| Master Data Relations | Join Conditions |
|---|---|
Business Area
| |
Company Code
| |
Controlling Area
| |
| FI-SL Business Transaction | I_ACTUALPLANSTATKEYFIGSEMTAG.CONTROLLINGBUSTRANSACTYPE == T022.ACTIVITY |
Cost Center
| |
Fiscal Year Variant
| |
Functional Area
| |
Ledger
|
|
Order ID
| |
Profit Center
| |
Segment for Segmental Reporting
| |
Statistical Key Figure
|