- 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_ActualPlanLineItemSemTag
Actual and Plan Line Item with Semantic Tag Including FA
| view: IFIAPGLACCTLITST | TRAN
| Extraction:
Not supported
| Component: Information System
Tables used:
SCAL_TT_DATE, PRTE, ACDOCA, ACDOCP, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, T004, T001, TKA02, SKA1, PROJ, HRRP_FSV_DIR, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
- 🔑 Keys (13)
- 💰 Amounts (153)
- ∑ Quantities (7)
- 📅 Dates (9)
- ☰ Categorical (30)
- Other (191)
- 🔗 Relations (1)
| Column Name | Description | |
|---|---|---|
| Ledger FK | Ledger in General Ledger Accounting | |
| SourceLedger | Source Ledger | |
| CompanyCode | Company Code | |
| FiscalYear | Fiscal Year | |
| AccountingDocument | Journal Entry | |
| LedgerGLLineItem | Ledger Journal Entry Item | |
| FinancialPlanningReqTransSqnc | Financial Planning Request Transaction Sequence Number | |
| FinancialPlanningDataPacket | Financial Planning Data Packet Number | |
| FinancialPlanningEntryItem | Financial Planning Entry Item | |
| GLAccountHierarchy | Financial Statement Version | |
| SemanticTag | Semantic Tag of a Hierarchy Node | |
| ValidityStartDate | Valid-From Date | |
| ValidityEndDate | Valid To Date |
| Column Name | Description | |
|---|---|---|
| 💲 Balance Transaction Currency (BalanceTransactionCurrency): | ||
| AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | |
| DebitAmountInBalanceTransCrcy | Debit Amount in Balance Transaction Currency | |
| CreditAmountInBalanceTransCrcy | Credit Amount in Balance Transaction Currency | |
| 💲 Transaction Currency (TransactionCurrency): | ||
| AmountInTransactionCurrency | Amount in Transaction Currency | |
| DebitAmountInTransCrcy | Debit Amount in Transaction Currency | |
| CreditAmountInTransCrcy | Credit Amount in Transaction Currency | |
| 💲 Company Code Currency (CompanyCodeCurrency): | ||
| AmountInCompanyCodeCurrency | Amount in Company Code Currency | |
| InvertedAmtInCoCodeCurrency | Inverted Amount in Company Code Currency | |
| DebitAmountInCoCodeCrcy | Debit Amount in Company Code Currency | |
| CreditAmountInCoCodeCrcy | Credit Amount in Company Code Currency | |
| ActualRevenueAmtInCCCrcy | Actual Revenue Amount in Company Code Currency | |
| ActlGrossRevenueAmtInCCCrcy | Actual Gross Revenue Amount in Company Code Currency | |
| ActlRecognizedRevnAmtInCCCrcy | Actual Recognized Revenue Amount in Company Code Currency | |
| ActlRevnAdjustmentAmtInCCCrcy | Actual Revenue Adjustment Amount in Company Code Currency | |
| ActlDeferredRevenueAmtInCCCrcy | Actual Deferred Revenue Amount in Company Code Currency | |
| ActlAccruedRevenueAmtInCCCrcy | Actual Accrued Revenue Amount in Company Code Currency | |
| ActlBilledRevenueAmtInCCCrcy | Actual Billed Revenue Amount In Company Code Currency | |
| ActlRecognizedMargAmtInCCCrcy | Actual Recognized Margin Amount in Company Code Currency | |
| ActualCostAmtInCCCrcy | Actual Cost Amount in Company Code Currency | |
| ActlRecognizedCOGSAmtInCCCrcy | Actual Recognized Cost Of Goods Sold Amount In CC Currency | |
| ActlCOGSAdjustmentAmtInCCCrcy | Actual Cost Of Goods Sold Adjustment Amount In CC Currency | |
| ActlDeferredCOGSAmtInCCCrcy | Actual Defferred Cost Of Goods Sold Amount In CC Currency | |
| ActlAccruedCOGSAmtInCCCrcy | Actual Accrued Cost Of Sold Goods Amount in CC currency | |
| ActlRecgblCostAmtInCCCrcy | Actual Recognizable Cost Amount in Company Code Currency | |
| ActlImmntLossRsrvAmtInCCCrcy | Actual Reserves for Imminent Loss Amount in CC Currency | |
| ActlSalesDeductRsrvAmtInCCCrcy | Actual Reserve for Anticipated Sales Deductions Amt InCCCrcy | |
| ActlUnrlzdCostsRsrvAmtInCCCrcy | Actual Reserves for Unrealized Costs Amt in CompanyCode Crcy | |
| ActlSlsDeductionAmtInCCCrcy | Actual Sales Deduction Amount In Company Currency | |
| ActlLongTermInvmtAmtInCCCrcy | Actual Long-term Investments Amount in Company Code Currency | |
| ActlAcctsRblAmtInCCCrcy | Actual Accounts Receivable Amount in Company Code currency | |
| ActlAcctsOthRblAmtInCCCrcy | Actual Accounts Other Receivable Amt In CompanyCode Currency | |
| ActlAcctsPyblAmtInCCCrcy | Actual Accounts Payable Amount InCompanyCodeCurrency | |
| ActlAcctsOthPyblAmtInCCCrcy | Actual Accounts Other Payable Amount In CompanyCode Currency | |
| ActlProvisionAmtInCCCrcy | Actual Provision Amount In CompanyCode Currency | |
| ActlNotesReceivableAmtInCCCrcy | Actual Notes Receivable Amount In CompanyCode Currency | |
| ActlTangibleAstDeprAmtInCCCrcy | Actual Depreciation of Tangible Assets Amount In CC Currency | |
| ActlIntngblAstAmtznAmtInCCCrcy | Actual Intangible Assets Amortization Amt in Co Code Crcy | |
| ActlTangibleAstAmtInCCCrcy | Actual Tangible Asset Amount InCompanyCodeCurrency | |
| ActlIntangibleAstAmtInCCCrcy | Actual Intangible Asset Amount InCompanyCodeCurrency | |
| ActlFxdAstRtrmtAmtInCCCrcy | Actual Investing Fixed Asset Retirement Amt In CC Currency | |
| ActlInventoryAmtInCCCrcy | Actual Inventory Amount In CompanyCode Currency | |
| ActlCommonStockAmtInCCCrcy | Actual Common Stocks Amount in Company Code Currency | |
| ActlCshAndCshEqvlntAmtInCCCrcy | Actual Cash And Cash Equivalent Amount InCompanyCodeCurrency | |
| ActlAssetAmtInCCCrcy | Actual Asset Amount In Company Code Currency | |
| ActlLbltyEquityAmtInCCCrcy | Actual Liabilities and Equity Amount In CompanyCode Currency | |
| ActlNotAssignedAmtInCCCrcy | Actual Not Assigned Amount In Company Code Currency | |
| ActlNetRsltAmtInCCCrcy | Actual Net Result Amount In CompanyCodeCurrency | |
| ActlPnLResultAmtInCCCrcy | Actual P&L Result Amount In company code currency | |
| ActlGLAcctNetIncAmtInCCCrcy | Actual Net Income Amount In Company Code Currency | |
| ActlOpgActyCashAmtInCCCrcy | Actual Operating Activity Cash Amount InCompanyCodeCurrency | |
| ActlInvstgActyCashAmtInCCCrcy | Actual Investing Activity Cash Amount In CompanyCodeCurrency | |
| ActlFinActyCashAmtInCCCrcy | Actual Financing Activity Cash Amount InCompanyCodeCurrency | |
| ActlNetCashAmtInCCCrcy | Actual Net Cash Amount In CompanyCode Currency | |
| PlnRevenueAmountInCCCrcy | Plan Revenue Amount in Company Code Currency | |
| PlnGrossRevenueAmtInCCCrcy | Plan Gross Revenue Amount in Company Code Currency | |
| PlnRecognizedRevnAmtInCCCrcy | Plan Recognized Revenue Amount in Company Code Currency | |
| PlnRevnAdjustmentAmtInCCCrcy | Plan Revenue Adjustment Amount in Company Code Currency | |
| PlnDeferredRevenueAmtInCCCrcy | Plan Deferred Revenue Amount in Company Code Currency | |
| PlnAccruedRevenueAmtInCCCrcy | Plan Accrued Revenue Amount in Company Code Currency | |
| PlnBilledRevenueAmtInCCCrcy | Plan Billed Revenue Amount In Company Code Currency | |
| PlnRecognizedMargAmtInCCCrcy | Plan Recognized Margin Amount in Company Code Currency | |
| PlnCostAmtInCompanyCodeCrcy | Plan Cost Amount in Company Code Currency | |
| PlnRecognizedCOGSAmtInCCCrcy | Plan Recognized Cost Of Goods Sold Amount In CC Currency | |
| PlnCOGSAdjustmentAmtInCCCrcy | Plan Cost Of Goods Sold Adjustment Amount In CC Currency | |
| PlnDeferredCOGSAmtInCCCrcy | Plan Defferred Cost Of Goods Sold Amount In CC Currency | |
| PlnAccruedCOGSAmtInCCCrcy | Plan Accrued Cost Of Sold Goods Amount in CC currency | |
| PlnImmntLossRsrvAmtInCCCrcy | Plan Reserves for Imminent Loss Amount in CC Currency | |
| PlnSalesDeductRsrvAmtInCCCrcy | Plan Reserve for Anticipated Sales Deductions Amt InCCCrcy | |
| PlnUnrlzdCostsRsrvAmtInCCCrcy | Plan Reserves for Unrealized Costs Amt in CompanyCode Crcy | |
| PlnSlsDeductionAmtInCCCrcy | Planned Sales Deduction Amount In Company Currency | |
| PlnLongTermInvmtAmtInCCCrcy | Pln Payts Amt Reltd to Gr Liabilities&Investments In CCCrcy | |
| PlnAcctsRblAmtInCCCrcy | Plan Accounts Receivable Amount in Company Code currency | |
| PlnAcctsOthRblAmtInCCCrcy | Plan Accounts Other Receivable Amt In CompanyCode Currency | |
| PlnAcctsPyblAmtInCCCrcy | Plan Accounts Payable Amount InCompanyCodeCurrency | |
| PlnAcctsOthPyblAmtInCCCrcy | Plan Accounts Other Payable Amount In CompanyCode Currency | |
| PlnProvisionAmtInCCCrcy | Plan Provision Amount In CompanyCode Currency | |
| PlnNotesReceivableAmtInCCCrcy | Plan Notes Receivable Amount In CompanyCode Currency | |
| PlnTangibleAstDeprAmtInCCCrcy | Plan Depreciation of Tangible Assets Amount In CC Currency | |
| PlnIntngblAstAmtznAmtInCCCrcy | Plan Depreciation of Intangible Assets Amt In CC Currency | |
| PlnTangibleAstAmtInCCCrcy | Plan Tangible Asset Amount InCompanyCodeCurrency | |
| PlnIntangibleAstAmtInCCCrcy | Plan Intangible Asset Amount InCompanyCodeCurrency | |
| PlnFxdAstRtrmtAmtInCCCrcy | Plan Investing Fixed Asset Retirement Amt In CC Currency | |
| PlnInventoryAmtInCCCrcy | Plan Inventory Amount In CompanyCode Currency | |
| PlnCommonStockAmtInCCCrcy | Plan Stock Share Amount In CompanyCode Currency | |
| PlnCshAndCshEqvlntAmtInCCCrcy | Plan Cash And Cash Equivalent Amount InCompanyCodeCurrency | |
| PlnAssetAmtInCCCrcy | Plan Asset Amount In CompanyCode Currency | |
| PlnLbltyEquityAmtInCCCrcy | Plan Liabilities and Equity Amount In Company Code Currency | |
| PlnNotAssignedAmtInCCCrcy | Plan Not Assigned Amount In Company Code Currency | |
| PlnNetRsltAmtInCCCrcy | Plan Net Result Amount In Company Code Currency | |
| PlnPnLResultAmtInCCCrcy | Plan P&L Result Amount In company code currency | |
| PlnGLAcctNetIncAmtInCCCrcy | Plan Net Income Amount In CompanyCode Currency | |
| PlnOpgActyCashAmtInCCCrcy | Plan Operating Activity Cash Amount InCompanyCodeCurrency | |
| PlnInvstgActyCashAmtInCCCrcy | Plan Investing Activity Cash Amount In CompanyCodeCurrency | |
| PlnFinActyCashAmtInCCCrcy | Plan Financing Activity Cash Amount InCompanyCodeCurrency | |
| PlnNetCashAmtInCCCrcy | Plan Net Cash Amount In CompanyCode Currency | |
| 💲 Global Currency (GlobalCurrency): | ||
| AmountInGlobalCurrency | Amount in Global Currency | |
| InvertedAmountInGlobalCurrency | Inverted Amount in Global Currency | |
| FixedAmountInGlobalCrcy | Fixed Amount in Global Currency | |
| GrpValnFixedAmtInGlobCrcy | Group Valuation Fixed Amount in Global Currency | |
| PrftCtrValnFxdAmtInGlobCrcy | Profit Center Valuation Fixed Amount in Global Currency | |
| TotalPriceVarcInGlobalCrcy | Total Price Variance in Global Currency | |
| GrpValnTotPrcVarcInGlobCrcy | Group Valuation Total Price Variance in Global Currency | |
| PrftCtrValnTotPrcVarcInGlbCrcy | Profit Center Valuation Total Price Variance in Global Cur. | |
| FixedPriceVarcInGlobalCrcy | Fixed Price Variance in Global Currency | |
| GrpValnFixedPrcVarcInGlobCrcy | Group Valuation Fixed Price Variance in Global Currency | |
| PrftCtrValnFxdPrcVarcInGlbCrcy | Profit Center Valuation Fixed Price Variance in Global Cur. | |
| DebitAmountInGlobalCrcy | Debit Amount in Global Currency | |
| CreditAmountInGlobalCrcy | Credit Amount in Global Currency | |
| ActlRecgdRevenueAmtInGlobCrcy | Actual Recognized Revenue Amount In Global Currency | |
| ActlBilledRevenueAmtInGlobCrcy | Actual Billed Revenue Amt In Global Currency | |
| ActlCostOfGdsSoldAmtInGlobCrcy | Actual Cost Of Goods Sold Amount In Global Currency | |
| ActlSlsDeductionAmtInGlobCrcy | Actual Sales Deduction Amount In Global Currency | |
| ActlPrcDifferenceAmtInGlobCrcy | Actual Price Differences Amount In Global Currency | |
| ActlAdminOverheadAmtInGlobCrcy | Actual Administration Overhead Amount in Global Currency | |
| ActlSalesOverheadAmtInGlobCrcy | Actual Sales Overhead Amount in Global Currency | |
| ActlMarketingOvhdAmtInGlobCrcy | Actual Marketing Overhead Amount in Global Currency | |
| ActlRnDOverheadAmtInGlobCrcy | Actual Research and Development Overhead Amt in Global Crcy | |
| PlnRecgdRevenueAmtInGlobCrcy | Planned Recognized Revenue Amount In Global Currency | |
| PlnBilledRevenueAmtInGlobCrcy | Plan Billed Revenue Amount In Global Currency | |
| PlnCostOfGdsSoldAmtInGlobCrcy | Planned Cost of Goods Sold Amount In Global Currency | |
| PlnSlsDeductionAmtInGlobCrcy | Plan Sales Deduction Amount In Global Currency | |
| PlnPrcDifferenceAmtInGlobCrcy | Plan Price Differences Amount In Global Currency | |
| PlnAdminOverheadAmtInGlobCrcy | Plan Administration Overhead Amount in Global Currency | |
| PlnSalesOverheadAmtInGlobCrcy | Plan Sales Overhead Amount in Global Currency | |
| PlnMarketingOvhdAmtInGlobCrcy | Plan Marketing Overhead Amount in Global Currency | |
| PlnRnDOverheadAmtInGlobCrcy | Plan Research and Development Overhead Amt in Global Crcy | |
| PlnContrbnMarg2AmtInGlobCrcy | Plan Contribution Margin II In Global Currency | |
| 💲 Freely Defined Currency 1 (FreeDefinedCurrency1): | ||
| AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | |
| InvertedAmtInFreeDefinedCrcy1 | Inverted Amount in Free Defined Currency | |
| DebitAmountInFreeDefinedCrcy1 | Debit Amount in Free Defined Currency 1 | |
| CreditAmountInFreeDefinedCrcy1 | Credit Amount in Free Defined Currency 1 | |
| 💲 Freely Defined Currency 2 (FreeDefinedCurrency2): | ||
| AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | |
| DebitAmountInFreeDefinedCrcy2 | Debit Amount in Free Defined Currency 2 | |
| CreditAmountInFreeDefinedCrcy2 | Credit Amount in Free Defined Currency 2 | |
| 💲 Freely Defined Currency 3 (FreeDefinedCurrency3): | ||
| AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | |
| DebitAmountInFreeDefinedCrcy3 | Debit Amount in Free Defined Currency 3 | |
| CreditAmountInFreeDefinedCrcy3 | Credit Amount in Free Defined Currency 3 | |
| 💲 Freely Defined Currency 4 (FreeDefinedCurrency4): | ||
| AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | |
| DebitAmountInFreeDefinedCrcy4 | Debit Amount in Free Defined Currency 4 | |
| CreditAmountInFreeDefinedCrcy4 | Credit Amount in Free Defined Currency 4 | |
| 💲 Freely Defined Currency 5 (FreeDefinedCurrency5): | ||
| AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | |
| DebitAmountInFreeDefinedCrcy5 | Debit Amount in Free Defined Currency 5 | |
| CreditAmountInFreeDefinedCrcy5 | Credit Amount in Free Defined Currency 5 | |
| 💲 Freely Defined Currency 6 (FreeDefinedCurrency6): | ||
| AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | |
| DebitAmountInFreeDefinedCrcy6 | Debit Amount in Free Defined Currency 6 | |
| CreditAmountInFreeDefinedCrcy6 | Credit Amount in Free Defined Currency 6 | |
| 💲 Freely Defined Currency 7 (FreeDefinedCurrency7): | ||
| AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | |
| DebitAmountInFreeDefinedCrcy7 | Debit Amount in Free Defined Currency 7 | |
| CreditAmountInFreeDefinedCrcy7 | Credit Amount in Free Defined Currency 7 | |
| 💲 Freely Defined Currency 8 (FreeDefinedCurrency8): | ||
| AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | |
| DebitAmountInFreeDefinedCrcy8 | Debit Amount in Free Defined Currency 8 | |
| CreditAmountInFreeDefinedCrcy8 | Credit Amount in Free Defined Currency 8 | |
| 💲 CO Object Currency (ControllingObjectCurrency): | ||
| AmountInObjectCurrency | Amount in Object Currency | |
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (BaseUnit): | ||
| Quantity | Quantity | |
| FixedQuantity | Fixed Quantity | |
| 📏 Cost Source Unit (CostSourceUnit): | ||
| ValuationQuantity | Valuation Quantity | |
| ValuationFixedQuantity | Valuation Fixed Quantity | |
| 📏 Additional Quantity 1 Unit (AdditionalQuantity1Unit): | ||
| AdditionalQuantity1 | Additional Quantity 1 | |
| 📏 Additional Quantity 2 Unit (AdditionalQuantity2Unit): | ||
| AdditionalQuantity2 | Additional Quantity 2 | |
| 📏 Additional Quantity 3 Unit (AdditionalQuantity3Unit): | ||
| AdditionalQuantity3 | Additional Quantity 3 | |
| Column Name | Description | |
|---|---|---|
| ValidityStartDate | Valid-From Date | |
| ValidityEndDate | Valid To Date | |
| PostingDate | Posting Date | |
| DocumentDate | Journal Entry Date | |
| CreationDate | Creation Date | |
| ServicesRenderedDate | Date on which services are rendered | |
| ClearingDate | Clearing Date | |
| AssetValueDate | Asset Value Date | |
| SettlementReferenceDate | Settlement Reference Date |
| Column Name | Description | |
|---|---|---|
| ActualPlanCode | Actual Plan Code | Show values |
| IsReversal | Indicator: Item is Reversing Another Item | Show values |
| IsReversed | Indicator: Item is Reversed | Show values |
| IsSettlement | Indicator: Item is Settling or Transferring Another Item | Show values |
| IsSettled | Indicator: Line Item is Settled or Transferred | Show values |
| IsCommitment | Indicator: Is Commitment | Show values |
| PartnerControllingObjectClass | Partner object class | Show values |
| DebitCreditCode | Debit/Credit Code | Show values |
| AccountingDocumentCategory | Journal Entry Category | Show values |
| OriginObjectType | Type of Origin Object | Show values |
| GLAccountType | Type of a General Ledger Account | Show values |
| ReferencePurchaseOrderCategory | Category of Reference Purchase Order | Show values |
| ControllingDebitCreditCode | Controlling Debit Credit Code | Show values |
| FinancialAccountType | Account Type | Show values |
| IsOpenItemManaged | Managed on an Open Item Basis | Show values |
| DepreciationFiscalPeriod | Fiscal Period of Depreciation | Show values |
| InventorySpecialStockValnType | Inventory Special Stock Valuation Type | Show values |
| ControllingObjectDebitType | Controlling Object Debit Type | Show values |
| QuantityIsIncomplete | Indicator: Quantity Is Incomplete | Show values |
| OffsettingAccountType | Offsetting Account Type | Show values |
| LineItemIsCompleted | Indicator: Line Item is Completed | Show values |
| ControllingObjectClass | Object Class | Show values |
| OrderCategory | Order category | Show values |
| PartnerOrderCategory | Partner Order Category | Show values |
| MaintenanceOrderPlanningCode | Maintenance order planning indicator | Show values |
| MaintenanceOrderIsPlanned | Planned Parts/Work | Show values |
| IsStatisticalOrder | Indicator: Internal Order is Statistical Account Assignment | Show values |
| IsStatisticalCostCenter | Indicator: Cost Center is Statistical Account Assignment | Show values |
| IsStatisticalSalesDocument | Sales Document is statistical | Show values |
| WBSIsStatisticalWBSElement | Indicator: WBS Element is Statistical Account Assignment | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| LedgerFiscalYear | Ledger Fiscal Year | GJAHR | |
| FiscalQuarter | Fiscal Quarter | FINS_FSCALQUARTER | |
| ChartOfAccounts | Chart of Accounts | KTOPL | |
| ControllingArea | Controlling Area | CACCD | |
| FinancialTransactionType | Financial Transaction Type | RMVCT | |
| BusinessTransactionType | Business Transaction Type | FINS_CUSTBTTYPE | |
| ReferenceDocumentType | Reference Document Type | AWTYP | |
| LogicalSystem | Logical System | LOGSYS | |
| ReferenceDocumentContext | Reference Document Context | AWORG | |
| ReferenceDocument | Reference document number | AWREF | |
| ReferenceDocumentItem | Reference Document Item | NUMC6 | |
| ReferenceDocumentItemGroup | Reference Document Item Group | NUMC6 | |
| ReversalReferenceDocumentCntxt | Reversal Reference Document Context | AWORG | |
| ReversalReferenceDocument | Reversal Reference Document | AWREF | |
| PredecessorReferenceDocType | Predecessor Reference Document Type | AWTYP | |
| PredecessorReferenceDocCntxt | Predecessor Reference Document Context | AWORG | |
| PredecessorReferenceDocument | Predecessor Reference Document | AWREF | |
| PredecessorReferenceDocItem | Predecessor Reference Document Item | NUMC6 | |
| SourceReferenceDocumentType | Source Reference Document Type | AWTYP | |
| SourceLogicalSystem | Source Logical System | LOGSYS | |
| SourceReferenceDocumentCntxt | Source Reference Document Context | AWORG | |
| SourceReferenceDocument | Source Reference Document | AWREF | |
| SourceReferenceDocumentItem | Source Reference Document Item | NUMC6 | |
| SourceReferenceDocSubitem | Source Reference Document Subitem | NUMC6 | |
| GLAccount | G/L Account | SAKNR | |
| WorkPackage | Plan Item | /CPD/PLAN_ITEM_ID | |
| WorkItem | Work Item ID | /CPD/PFP_WORKITEM_ID | |
| BillableControl | Billable Control | BEMOT | |
| IsLotSizeIndependent | Lot-Size-Independent Indicator | CHAR1 | |
| CostCenter | Cost Center | KOSTL | |
| ProfitCenter | Profit Center | PRCTR | |
| FunctionalArea | Functional Area | FKBER | |
| BusinessArea | Business Area | GSBER | |
| Segment | Segment for Segmental Reporting | FB_SEGMENT | |
| PartnerCostCenter | Partner Cost Center | KOSTL | |
| PartnerProfitCenter | Partner Profit Center | PRCTR | |
| PartnerFunctionalArea | Partner Functional Area | FKBER | |
| PartnerBusinessArea | Partner Business Area | GSBER | |
| PartnerCompany | Company ID of Trading Partner | RCOMP | |
| PartnerSegment | Partner Segment for Segmental Reporting | FB_SEGMENT | |
| PartnerCompanyCode | Partner Company Code | BUKRS | |
| FiscalPeriod | Fiscal Period | POPER | |
| FiscalYearVariant | Fiscal Year Variant | PERIV | |
| FiscalYearPeriod | Fiscal Year Period | FIS_JAHRPER_CONV | |
| AccountingDocumentType | Journal Entry Type | BLART | |
| AccountingDocumentItem | Journal Entry Posting View Item | BUZEI | |
| AssignmentReference | Assignment Reference | ZUONR | |
| PostingKey | Posting Key | BSCHL | |
| TransactionTypeDetermination | Transaction Key | CHAR3 | |
| AccountingDocCreatedByUser | User that created the journal entry | ||
| LastChangeDateTime | Time Stamp of Last Change | TZNTSTMPS | |
| EliminationProfitCenter | Elimination Profit Center | PRCTR | |
| AlternativeGLAccount | Alternative G/L Account Number In Company Code | SAKNR | |
| CountryChartOfAccounts | Alternative Chart of Accounts for Country/Region | KTOPL | |
| InvoiceReference | Invoice Reference | BELNR | |
| InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | GJAHR | |
| FollowOnDocumentType | Follow-On Document Type | REBZT | |
| InvoiceItemReference | Invoice Item Reference | BUZEI | |
| PurchasingDocument | Purchasing Document | EBELN | |
| PurchasingDocumentItem | Purchasing Document Item | EBELP | |
| AccountAssignmentNumber | Account Assignment Number | NUM02 | |
| DocumentItemText | Item Text | TEXT50 | |
| SalesOrder | Sales Order | VBELN | |
| SalesOrderItem | Sales Order Item | POSNR | |
| SalesDocument | Sales Document | VBELN | |
| Material | Material Number | MATNR | |
| Plant | Plant | WERKS | |
| Supplier | Supplier | LIFNR | |
| Customer | Customer Number | KUNNR | |
| ConditionContract | Condition Contract | WCB_COCO_NUM | |
| PlanningCategory | Plan Category | FCOM_CATEGORY | |
| SpecialGLCode | Special G/L Indicator | UMSKZ | |
| TaxCode | Tax on Sales/Purchases Code | MWSKZ | |
| HouseBank | House Bank Key | HBKID | |
| HouseBankAccount | House Bank Account | HKTID | |
| ClearingAccountingDocument | Clearing Journal Entry | BELNR | |
| ClearingDocFiscalYear | Fiscal Year of Clearing Journal Entry | GJAHR | |
| AssetDepreciationArea | Asset Depreciation Area (Real or Derived) | AFABE | |
| MasterFixedAsset | Fixed Asset | ANLN1 | |
| FixedAsset | Asset Subnumber | ANLN2 | |
| AssetTransactionType | Asset Transaction Type | BWASL | |
| AssetAcctTransClassfctn | Transaction Type Category | FAA_MOVCAT | |
| GroupMasterFixedAsset | Group Asset | ANLN1 | |
| GroupFixedAsset | Group Asset Subnumber | ANLN2 | |
| CostEstimate | Cost Estimate | CK_KALNR | |
| InventorySpecialStockType | Inventory Special Stock Type | SOBKZ | |
| InventorySpclStkSalesDocument | Inventory Special Stock Sales Document | VBELN | |
| InventorySpclStkSalesDocItm | Inventory Special Stock Sales Document Item | POSNR | |
| InvtrySpclStockWBSElmntIntID | Inventory Special Stock WBS Element Internal ID | FIS_WBSINT_NO_CONV | |
| InvtrySpclStockWBSElmntExtID | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | |
| InventorySpclStockWBSElement | Inventory Special Stock WBS Element | FIS_WBS | |
| InventorySpecialStockSupplier | Supplier of Inventory Special Stock | LIFNR | |
| InventoryValuationType | Inventory Valuation Type | BWTAR | |
| ValuationArea | Valuation area | BWKEY | |
| SenderGLAccount | Sender G/L Account | CHAR10 | |
| SenderAccountAssignment | Sender Account Assignment | ACCAS | |
| SenderAccountAssignmentType | Account Assignment Type in Sender System | J_OBART | |
| CostOriginGroup | Origin Group as Subdivision of Cost Element | HRKFT | |
| OriginSenderObject | Origin Sender Object | J_OBJNR | |
| OffsettingAccount | Offsetting Account | GKONT | |
| PersonnelNumber | Personnel Number | PERNR | |
| OriginCostCenter | Origin Cost Center | KOSTL | |
| OriginCostCtrActivityType | Origin Cost Center Activity Type | LSTAR | |
| AccountAssignment | Account Assignment | ACCAS | |
| AccountAssignmentType | Account Assignment Type | J_OBART | |
| CostCtrActivityType | Activity Type | LSTAR | |
| OrderID | Order ID | AUFNR | |
| WBSElementInternalID | WBS Element Internal ID | FIS_WBSINT_NO_CONV | |
| WBSElementExternalID | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | |
| PartnerWBSElementInternalID | WBS Element Internal ID | FIS_WBSINT_NO_CONV | |
| PartnerWBSElementExternalID | Work Breakdown Structure Element (WBS Element) Edited | PS_POSID_EDIT | |
| WBSElement | Work Breakdown Structure Element (WBS Element) | PS_POSID | |
| ProjectInternalID | Project Internal ID | FIS_PROJECTINT_NO_CONV | |
| ProjectExternalID | Project Number (External) Edited | PS_PSPID_EDIT | |
| PartnerProjectInternalID | Project Internal ID | FIS_PROJECTINT_NO_CONV | |
| PartnerProjectExternalID | Project Number (External) Edited | PS_PSPID_EDIT | |
| Project | Project | FIS_PROJECT | |
| OperatingConcern | Operating concern | ERKRS | |
| ProjectNetwork | Network Number for Account Assignment | AUFNR | |
| RelatedNetworkActivity | Network activity | VORNR | |
| BusinessProcess | Business Process | CO_PRZNR | |
| CostObject | Cost Object | KSTRG | |
| CostAnalysisResource | Cost Analysis Resource | CO_RESSOURCE | |
| CustomerServiceNotification | Customer Service Notification | QMNUM | |
| ServiceDocumentType | Service Document Type | CRM_PROCESS_TYPE | |
| ServiceDocument | Service Document ID | CRM_OBJECT_ID | |
| ServiceDocumentItem | Service Document Item ID | FCO_SRVDOC_ITEM_ID | |
| ServiceContractType | Service Contract Type | CRM_PROCESS_TYPE | |
| ServiceContract | Service Contract ID | CRM_OBJECT_ID | |
| ServiceContractItem | Service Contract Item ID | FCO_SRVDOC_ITEM_ID | |
| BusinessSolutionOrder | Solution Order | CRM_OBJECT_ID | |
| BusinessSolutionOrderItem | Solution Order Item | CRMS4_NUMBER_INT | |
| PartnerAccountAssignment | Partner Account Assignment | ACCAS | |
| PartnerAccountAssignmentType | Partner Account Assignment Type | J_OBART | |
| PartnerCostCtrActivityType | Partner Cost Center Activity Type | LSTAR | |
| PartnerOrder | Partner Order | AUFNR | |
| PartnerWBSElement | Partner WBS Element | FIS_WBS | |
| PartnerProject | Partner Project | FIS_PROJECT | |
| PartnerSalesDocument | Partner Sales Document | VBELN | |
| PartnerSalesDocumentItem | Partner Sales Document Item | POSNR | |
| PartnerProjectNetwork | Partner Project Network | AUFNR | |
| PartnerProjectNetworkActivity | Partner Project Network Activity | VORNR | |
| PartnerBusinessProcess | Partner Business Process | CO_PRZNR | |
| PartnerCostObject | Partner Cost Object | KSTRG | |
| BillingDocumentType | Billing Type | FKART | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| Division | Division | SPART | |
| OrganizationDivision | Division | SPART | |
| SoldMaterial | Sold Material | MATNR | |
| MaterialGroup | Product Sold Group | MATKL | |
| SoldProductGroup | Product Sold Group | MATKL | |
| ProductGroup | Product Group | MATKL | |
| CustomerGroup | Customer Group | KDGRP | |
| CustomerSupplierCountry | Customer or Supplier Country/Region | LAND1 | |
| CustomerSupplierIndustry | Customer Supplier Industry | BRSCH | |
| SalesDistrict | Sales District | BZIRK | |
| BillToParty | Bill-to Party | KUNNR | |
| ShipToParty | Ship-to Party | KUNNR | |
| CustomerSupplierCorporateGroup | Customer Supplier Corporate Group | KONZS | |
| FinancialManagementArea | Financial Management Area | FIKRS | |
| Fund | Fund | BP_GEBER | |
| GrantID | Grant | GM_GRANT_NBR | |
| BudgetPeriod | Budget Period | FM_BUDGET_PERIOD | |
| PartnerFund | Partner Fund | BP_GEBER | |
| PartnerGrant | Partner Grant | GM_GRANT_NBR | |
| PartnerBudgetPeriod | FM: Partner Budget Period | FM_BUDGET_PERIOD | |
| FundsCenter | Funds Management Center | FISTL | |
| FundedProgram | Funded Program | FM_MEASURE | |
| JointVenture | Joint venture | JV_NAME | |
| JointVentureEquityGroup | Joint Venture Equity Group | JV_EGROUP | |
| JointVentureCostRecoveryCode | Joint Venture Cost Recovery Code | JV_RECIND | |
| JointVentureEquityType | Joint Venture Equity Type | JV_ETYPE | |
| WorkCenterInternalID | Object ID of the resource | CR_OBJID | |
| OrderOperation | Operation/Activity Number | VORNR | |
| OrderItem | Order item number | CO_POSNR | |
| OrderSuboperation | Suboperation | VORNR | |
| Equipment | Equipment Number | EQUNR | |
| FunctionalLocation | Functional Location | TPLNR | |
| Assembly | Assembly | MATNR | |
| MaintenanceActivityType | Maintenance activity type | ILART | |
| MaintPriorityType | Priority Type | ARTPR | |
| MaintPriority | Priority | PRIOK | |
| SuperiorOrder | Number of Superior Order | AUFNR | |
| GLAccountAuthorizationGroup | Authorization Group | BRGRU | |
| SupplierBasicAuthorizationGrp | Authorization Group | BRGRU | |
| CustomerBasicAuthorizationGrp | Authorization Group | BRGRU | |
| AcctgDocTypeAuthorizationGroup | Authorization Group | BRGRU | |
| OrderType | Order Type | AUFART | |
| SalesOrderType | Sales Document Type | AUART | |
| AssetClass | Asset Class | ANLKL |
| Master Data Relations | Join Conditions |
|---|---|
Ledger in General Ledger Accounting
|
|