I_ACCRENGNACCRSIMLNENTRYITEM
Accrual Simulation Entry Item
I_ACCRENGNACCRSIMLNENTRYITEM is a CDS View in S/4HANA. Accrual Simulation Entry Item. It contains 114 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_AccrEngnAccrSimlnItemOnly | view_entity | from | BASIC | Simulation Entry Item Only |
| P_AccrEngnAccrSimlnItemOnly | view_entity | union_all | BASIC | Simulation Entry Item Only |
| P_AccrEngnRptgSimlnActlUnion | view_entity | union_all | COMPOSITE | Accrual Engine Simulation and Actual Cost Comparison - Union |
| P_AccrEngnRptgSmlteFutureUnion | view_entity | union_all | COMPOSITE | Simulate Future Posting - Union |
Fields (114)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | FinancialPlanningDataPacket | FinancialPlanningDataPacket | 1 |
| KEY | FinancialPlanningEntryItem | FinancialPlanningEntryItem | 1 |
| KEY | FinancialPlanningReqTransSqnc | FinancialPlanningReqTransSqnc | 1 |
| _AccrItemType | _AccrItemType | 1 | |
| _AccrLogicalSystem | _AccrLogicalSystem | 1 | |
| _AccrObjectType | _AccrObjectType | 1 | |
| _AccrTransactionType | _AccrTransactionType | 1 | |
| _BudgetPeriod | _BudgetPeriod | 1 | |
| _BusinessArea | _BusinessArea | 1 | |
| _BusinessTransactionCategory | _BusinessTransactionCategory | 1 | |
| _BusinessTransactionType | _BusinessTransactionType | 1 | |
| _CalendarDate | _CalendarDate | 1 | |
| _ChartOfAccounts | _ChartOfAccounts | 1 | |
| _CompanyCode | _CompanyCode | 1 | |
| _CompanyCodeCurrency | _CompanyCodeCurrency | 1 | |
| _ControllingArea | _ControllingArea | 1 | |
| _CostCenter | _CostCenter | 1 | |
| _CostCtrActivityType | _CostCtrActivityType | 1 | |
| _CurrentCostCenter | _CurrentCostCenter | 1 | |
| _CurrentProfitCenter | _CurrentProfitCenter | 1 | |
| _Customer | _Customer | 1 | |
| _FinancialManagementArea | _FinancialManagementArea | 1 | |
| _FinancialTransactionType | _FinancialTransactionType | 1 | |
| _FiscalCalendarDate | _FiscalCalendarDate | 1 | |
| _FiscalPeriodForVariant | _FiscalPeriodForVariant | 1 | |
| _FiscalYear | _FiscalYear | 1 | |
| _FiscalYearPeriodForVariant | _FiscalYearPeriodForVariant | 1 | |
| _FiscalYearVariant | _FiscalYearVariant | 1 | |
| _FunctionalArea | _FunctionalArea | 1 | |
| _Fund | _Fund | 1 | |
| _GLAccountInChartOfAccounts | _GLAccountInChartOfAccounts | 1 | |
| _GLAccountInCompanyCode | _GLAccountInCompanyCode | 1 | |
| _GlobalCurrency | _GlobalCurrency | 1 | |
| _Grant | _Grant | 1 | |
| _Ledger | _Ledger | 1 | |
| _LedgerFiscalYearForVariant | _LedgerFiscalYearForVariant | 1 | |
| _OffsettingChartOfAccounts | _OffsettingChartOfAccounts | 1 | |
| _OffstgGLAcctInChartOfAccounts | _OffstgGLAcctInChartOfAccounts | 1 | |
| _Order | _Order | 1 | |
| _ProfitCenter | _ProfitCenter | 1 | |
| _ProjectBasicData | _ProjectBasicData | 1 | |
| _ProjectByExternalID | _ProjectByExternalID | 1 | |
| _SalesDocument | _SalesDocument | 1 | |
| _SalesDocumentItem | _SalesDocumentItem | 1 | |
| _Segment | _Segment | 1 | |
| _SubLedgerAccLineItemType | _SubLedgerAccLineItemType | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| _WBSElementBasicData | _WBSElementBasicData | 1 | |
| _WBSElementByExternalID | _WBSElementByExternalID | 1 | |
| AccrualEngineAccrualObjectType | AccrualEngineAccrualObjectType | 1 | |
| AccrualItemType | AccrualItemType | 1 | |
| AccrualObject | AccrualObject | 1 | |
| AccrualObjectLogicalSystem | AccrualObjectLogicalSystem | 1 | |
| AccrualReferenceObject | AccrualReferenceObject | 1 | |
| AccrualSubobject | AccrualSubobject | 1 | |
| AccrualTransactionType | AccrualTransactionType | 1 | |
| AccrualValueDate | AccrualValueDate | 1 | |
| AssetClass | AssetClass | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessTransactionCategory | BusinessTransactionCategory | 1 | |
| BusinessTransactionType | BusinessTransactionType | 1 | |
| ChartOfAccounts | ChartOfAccounts | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCenter | CostCenter | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| Customer | Customer | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| DocumentItemText | DocumentItemText | 1 | |
| FinancialManagementArea | FinancialManagementArea | 1 | |
| FinancialTransactionType | FinancialTransactionType | 1 | |
| FinPlngEntryItemCreatedByUser | FinPlngEntryItemCreatedByUser | 1 | |
| FinPlngEntryItemCrtnDateTime | FinPlngEntryItemCrtnDateTime | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FiscalYear | FiscalYear | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| FiscalYearVariant | FiscalYearVariant | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| GLAccount | GLAccount | 1 | |
| GlobalCurrency | GlobalCurrency | 1 | |
| GrantID | GrantID | 1 | |
| Ledger | Ledger | 1 | |
| LedgerFiscalYear | LedgerFiscalYear | 1 | |
| OffsettingAccount | OffsettingAccount | 1 | |
| OffsettingAccountType | OffsettingAccountType | 1 | |
| OffsettingChartOfAccounts | OffsettingChartOfAccounts | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| PlanningCategory | PlanningCategory | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| Product | Product | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectExternalID | ProjectExternalID | 1 | |
| ProjectInternalID | ProjectInternalID | 1 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| ReferenceDocument | ReferenceDocument | 1 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| SalesDocument | SalesDocument | 1 | |
| SalesDocumentItem | SalesDocumentItem | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| Segment | Segment | 1 | |
| SmltdAccrAmtInCoCodeCrcy | SmltdAccrAmtInCoCodeCrcy | 1 | |
| SmltdAccrAmtInGlobCrcy | SmltdAccrAmtInGlobCrcy | 1 | |
| SmltdAccrAmtInTransCrcy | SmltdAccrAmtInTransCrcy | 1 | |
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| WBSElementExternalID | WBSElementExternalID | 1 | |
| WBSElementInternalID | WBSElementInternalID | 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.
-- Accrual Simulation Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ACCRENGNACCRSIMLNENTRYITEM (
FINANCIALPLANNINGDATAPACKET,
FINANCIALPLANNINGENTRYITEM,
FINANCIALPLANNINGREQTRANSSQNC,
_ACCRITEMTYPE,
_ACCRLOGICALSYSTEM,
_ACCROBJECTTYPE,
_ACCRTRANSACTIONTYPE,
_BUDGETPERIOD,
_BUSINESSAREA,
_BUSINESSTRANSACTIONCATEGORY,
_BUSINESSTRANSACTIONTYPE,
_CALENDARDATE,
_CHARTOFACCOUNTS,
_COMPANYCODE,
_COMPANYCODECURRENCY,
_CONTROLLINGAREA,
_COSTCENTER,
_COSTCTRACTIVITYTYPE,
_CURRENTCOSTCENTER,
_CURRENTPROFITCENTER,
_CUSTOMER,
_FINANCIALMANAGEMENTAREA,
_FINANCIALTRANSACTIONTYPE,
_FISCALCALENDARDATE,
_FISCALPERIODFORVARIANT,
_FISCALYEAR,
_FISCALYEARPERIODFORVARIANT,
_FISCALYEARVARIANT,
_FUNCTIONALAREA,
_FUND,
_GLACCOUNTINCHARTOFACCOUNTS,
_GLACCOUNTINCOMPANYCODE,
_GLOBALCURRENCY,
_GRANT,
_LEDGER,
_LEDGERFISCALYEARFORVARIANT,
_OFFSETTINGCHARTOFACCOUNTS,
_OFFSTGGLACCTINCHARTOFACCOUNTS,
_ORDER,
_PROFITCENTER,
_PROJECTBASICDATA,
_PROJECTBYEXTERNALID,
_SALESDOCUMENT,
_SALESDOCUMENTITEM,
_SEGMENT,
_SUBLEDGERACCLINEITEMTYPE,
_TRANSACTIONCURRENCY,
_WBSELEMENTBASICDATA,
_WBSELEMENTBYEXTERNALID,
ACCRUALENGINEACCRUALOBJECTTYPE,
ACCRUALITEMTYPE,
ACCRUALOBJECT,
ACCRUALOBJECTLOGICALSYSTEM,
ACCRUALREFERENCEOBJECT,
ACCRUALSUBOBJECT,
ACCRUALTRANSACTIONTYPE,
ACCRUALVALUEDATE,
ASSETCLASS,
ASSIGNMENTREFERENCE,
BUDGETPERIOD,
BUSINESSAREA,
BUSINESSTRANSACTIONCATEGORY,
BUSINESSTRANSACTIONTYPE,
CHARTOFACCOUNTS,
COMPANYCODE,
COMPANYCODECURRENCY,
CONTROLLINGAREA,
COSTCENTER,
COSTCTRACTIVITYTYPE,
CUSTOMER,
DISTRIBUTIONCHANNEL,
DOCUMENTITEMTEXT,
FINANCIALMANAGEMENTAREA,
FINANCIALTRANSACTIONTYPE,
FINPLNGENTRYITEMCREATEDBYUSER,
FINPLNGENTRYITEMCRTNDATETIME,
FISCALPERIOD,
FISCALYEAR,
FISCALYEARPERIOD,
FISCALYEARVARIANT,
FUNCTIONALAREA,
FUND,
GLACCOUNT,
GLOBALCURRENCY,
GRANTID,
LEDGER,
LEDGERFISCALYEAR,
OFFSETTINGACCOUNT,
OFFSETTINGACCOUNTTYPE,
OFFSETTINGCHARTOFACCOUNTS,
ORDERID,
ORGANIZATIONDIVISION,
PLANNINGCATEGORY,
PLANT,
POSTINGDATE,
PRODUCT,
PROFITCENTER,
PROJECTEXTERNALID,
PROJECTINTERNALID,
PROJECTNETWORK,
REFERENCEDOCUMENT,
REFERENCEDOCUMENTCONTEXT,
REFERENCEDOCUMENTTYPE,
SALESDOCUMENT,
SALESDOCUMENTITEM,
SALESORGANIZATION,
SEGMENT,
SMLTDACCRAMTINCOCODECRCY,
SMLTDACCRAMTINGLOBCRCY,
SMLTDACCRAMTINTRANSCRCY,
SUBLEDGERACCTLINEITEMTYPE,
TRANSACTIONCURRENCY,
WBSELEMENTEXTERNALID,
WBSELEMENTINTERNALID,
PRIMARY KEY (FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA