Universal Journal Entry
DataSource Transactional Data: 0FI_ACDOCA_10
This data source extracts data records for universal journal entries. The data records are read from table ACDOCA
. This table covers field in General Ledger Accounting (FI-GL)
, Asset Accounting (FI-AA)
, Profitability Analysis (CO-PA)
and the Material Ledger (CO-PC-ACT)
.
For more information on the universal journal entry, see SAP Simple Finance, On-Premise-Edition.
All customer enhancement fields of the journal entry table (ACDOCA
) are available, in addition to the fields of the extract structure listed below. This includes customer-defined CO-PA market segment characteristics labeled with *_PA
.
Technical Data
Application Component | Financial Accounting: General Ledger Accounting (FI-GL) |
|---|---|
Available as of Release | SAP Simple Finance, On-Premise Edition 1503 |
Shipment | Not specified |
Content Versions | No content versions exist |
RemoteCube-Capable | Not specified |
Delta-Capable | Yes |
Extraction from Archives | Not specified |
Verifiable |
Data Modeling
Delta Update
AIMD: After Images with deletion indicator in delta queue
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
| Transaction Type |
| |
| Transaction Type for General Ledger | ||
| Business Transaction CO |
| |
| Business Transaction Type |
| |
| Reference Transaction |
| |
| Logical System of Source Document |
| |
| Reference Organizational Units | ||
| Reference Document Number | ||
| Reference Document Line Item | ||
| Group of Reference Document Line Items | ||
| Partial Document to be Balanced to Zero | ||
| Indicator: Item is Reversing Another Item | ||
| Indicator: Item is Reversed | ||
| Indicator: True reversal (i.e. Cancellation) | ||
| Reversal: Reference Transaction of Document To Be Reversed | ||
| Reversal: Reverse Document Reference Organization | ||
| Reversal: Reverse Document Reference Document Number | ||
| Reversal: Partial Document to be Balanced to Zero | ||
| Indicator: Item is Settling or Transferring Another Item | ||
| Indicator: Line item is Settled or Transferred | ||
| Preceding Document Reference Transaction | ||
| Preceding Document Reference Organizational Units | ||
| Preceding Document Reference Document Number | ||
| Preceding Reference Document Line Item | ||
| Preceding Partial Document to be Balanced to Zero | ||
| Currency Key |
| |
| Currency Key of Original Transaction Currency |
| |
| Local Currency |
| |
| Currency Key of Third Currency |
| |
| Currency Key of Fourth Currency |
| |
| Currency Key of Fifth Currency |
| |
| Currency Key |
| |
| Base Unit of Measure |
| |
| Unit of Measure for Valuation Quantity |
| |
| Unit of Measure for Reference Quantity |
| |
| Additional Unit of Measure 1 | ||
| Additional Unit of Measure 2 | ||
| Additional Unit of Measure 3 | ||
| Cost Center |
| |
| Profit Center |
| |
| Functional Area |
| |
| Business Area |
| |
| Controlling Area |
| |
| Segment for Segment Reporting |
| |
| Sender Cost Center |
| |
| Partner Profit Center |
| |
| Partner Functional Area |
| |
| Trading Partner's Business Area |
| |
| Company ID of Trading Partner |
| |
| Partner Segment for Segment Reporting |
| |
| Value in Transaction Currency | ||
| Value in Original Transaction Currency (Document Currency) | ||
| Value in Local Currency | ||
| Value in Group Currency | ||
| Value in Another Currency | ||
| Amount in Fourth Currency | ||
| Amount in Fifth Currency | ||
| Fixed Value in Group Currency | ||
| Total Price Variance in Group Currency | ||
| Fixed Price Variance in Group Currency | ||
| Value in CO Object Currency | ||
| Inventory Value in Group Currency | ||
| Inventory Value in Group Currency | ||
| Inventory Value in Another Currency | ||
| Inventory Value in Fourth Currency | ||
| Alternative Inventory Value in Local Currency | ||
| Alternative Inventory Value in Another Currency | ||
| Alternative Inventory Value in Fourth Currency | ||
| Moving Average Price in Local Currency | ||
| Moving Average Price in Group Currency | ||
| Moving Average Price in Another Currency | ||
| Standard Price in Fourth Currency | ||
| Standard Price in Local Currency | ||
| Standard Price in Group Currency | ||
| Standard Price in Another Currency | ||
| Standard Price in Fourth Currency | ||
| Alternative Value in Local Currency | ||
| Alternative Value in Group Currency | ||
| Alternative Value in Another Currency | ||
| Alternative Value in Another Currency | ||
| External Value in Local Currency | ||
| External Value in Group Currency | ||
| External Value in Another Currency | ||
| External Value in Fourth Currency | ||
| External Value in Fourth Currency | ||
| Value at Sales Price in Local Currency | ||
| Inventory Value at Sales Price in Local Currency | ||
| Quantity | ||
| Fixed Quantity | ||
| Valuation Quantity | ||
| Fixed Valuation Quantity | ||
| Reference Quantity | ||
| Additional Quantity 1 | ||
| Additional Quantity 2 | ||
| Additional Quantity 3 | ||
| Inventory Quantity | ||
| Debit/Credit Indicator |
| |
| Posting Period | ||
| Fiscal Year Variant | ||
| Period/Year | ||
| Posting Date in the Document | ||
| Document Date in Document | ||
| Document Type | ||
| Number of Line Item Within Accounting Document | ||
| Assignment Number | ||
| Posting Key |
| |
| Document Status | ||
| Item Category |
| |
| Transaction Key | ||
| Subledger-Specific Line Item Type | ||
| Item Changed by Document Splitting | ||
| User Name |
| |
| UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| Partner Profit Center for Elimination of Internal Business |
| |
| Type of Origin Object (EC-PCA) |
| |
| Chart of Accounts |
| |
| Alternative Account Number in Company Code | ||
| Chart of Accounts According to Country Legislation | ||
| Number of the Invoice the Transaction Belongs To | ||
| Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
| Line Item in the Relevant Invoice | ||
| Follow-On Document Type | ||
| Category of Reference Purchase Order | ||
| Purchasing Document Number | ||
| Item Number of Purchasing Document | ||
| Sequential Number of Account Assignment | ||
| Item Text | ||
| Sales Order Number |
| |
| Item Number in Sales Order |
| |
| Item Number in Sales Order |
| |
| Material Number |
| |
| Plant |
| |
| Account Number of Vendor or Creditor |
| |
| Customer Number |
| |
| Account Type | ||
| Special G/L Indicator |
| |
| Tax on Sales/Purchases Code |
| |
| Short Key for a House Bank |
| |
| ID for Account Details |
| |
| Indicator: Open Item Management? | ||
| Clearing Date | ||
| Document Number of the Clearing Document | ||
| Fiscal Year of Clearing Document | ||
| Real Depreciation Area |
| |
| Main Asset Number |
| |
| Asset Subnumber |
| |
| Asset Value Date | ||
| Asset Transaction Type |
| |
| Classification of Transaction Type | ||
| Posting Period of Depreciation | ||
| Group Asset | ||
| Subnumber of Group Asset | ||
| Distribution Rule Group | ||
| Cost Estimate Number for Cost Est. w/o Qty Structure |
| |
| Price Control Indicator | ||
| Material Price Determination: Control | ||
| Valuation of Special Stock | ||
| Vendor Stock Valuation Indicator | ||
| Special Stock Indicator |
| |
| Valuation Time Stamp | ||
| Sales Document Number of Valuated Special Inventory |
| |
| Sales Order Item of Valuated Sales Order Stock |
| |
| Valuated Sales Order Stock WBS Element | ||
| WBS Element (external) of Valuated Special Inventory | ||
| Vendor of Valuated Special Inventory | ||
| Valuation Type |
| |
| Valuation Area |
| |
| Price Unit in Local Currency | ||
| Price Unit in Group Currency | ||
| Price Unit in Another Currency | ||
| Price Unit in Fourth Currency | ||
| Original Process Category | ||
| Category in Material Update Structure | ||
| Procurement Alternative/Process | ||
| Production Process | ||
| Type of Period | ||
| G/L Account Number in Sender System | ||
| Account Assignment in Sender System | ||
| Object Type in Sender System | ||
| Object Number |
| |
| CO Key Subnumber |
| |
| Origin Group as Subdivision of Cost Element |
| |
| Partner Object (Always Filled) |
| |
| Source of PAROB: PAROB1 or Type of Partner Object | ||
| Source Object (Cost Center/Activity Type) |
| |
| CO Debit/Credit Indicator | ||
| Debit/Credit Indicator (Origin) | ||
| Debit Type | ||
| Quantity Complete/Incomplete | ||
| Offsetting Account Number | ||
| Offsetting Account Type | ||
| Completion Indicator for Line Item | ||
| Personnel Number | ||
| Profitability Segment Number (CO-PA) | ||
| Indicator: Profitability Segm. Relevant for CO Compatibility | ||
| Object Class | ||
| Logical System of Object |
| |
| Company Code of Partner |
| |
| Partner Object Class | ||
| Logical System of Partner Object |
| |
| Strategy for Determining an Allocation Price | ||
| Object Number of Origin Object |
| |
| Origin Order Number | ||
| Origin Cost Center |
| |
| Origin Activity |
| |
| Source: Business Process | ||
| Account Assignment | ||
| Object Type |
| |
| Activity Type |
| |
| Order Number |
| |
| Order Category | ||
| Work Breakdown Structure (WBS Element) |
| |
| Project Definition |
| |
| Network Number for Account Assignment | ||
| Operation/Activity Number | ||
| Business Process |
| |
| Accounting Indicator | ||
| Notification No. | ||
| Operating Concern |
| |
| Partner Account Assignment | ||
| Partner Object Type |
| |
| Partner Activity Type |
| |
| Partner Order Number |
| |
| Partner Order Category | ||
| Partner Work Breakdown Structure Element |
| |
| Partner Project | ||
| Number of Partner Sales Order |
| |
| Partner Sales Order Item |
| |
| Partner Profitability Segment Number (CO-PA) | ||
| Partner Network | ||
| Partner Operation Number | ||
| Partner Business Process |
| |
| Partner Cost Object | ||
| Type of First Statistical Account Assignment | ||
| Type of Second Statistical Account Assignment | ||
| Type of Third Statistical Account Assignment | ||
| Document Item Number | ||
| Document Number |
| |
| Posting Row |
| |
| Posting Row of Reference Document | ||
| Billing Type |
| |
| Sales Organization |
| |
| Distribution Channel |
| |
| Division |
| |
| Product for Profitability Analysis |
| |
| Material Group | ||
| Customer Group | ||
| Country Key | ||
| Industry Key | ||
| Sales District | ||
| Bill-to Party | ||
| Ship-to Party | ||
| Group Key | ||
| Cash Ledger: Company Code for Expense/Revenue |
| |
| Cash Ledger: Expense or Revenue Account |
| |
| Financial Management Area |
| |
| Funds Center |
| |
| Funded Program |
| |
| Fund |
| |
| Grant |
| |
| FM: Budget Period |
| |
| Partner Fund |
| |
| Partner Grant |
| |
| FM: Partner Budget Period |
| |
| Joint Venture |
| |
| Equity Group |
| |
| Recovery Indicator |
| |
| Partner Account Number |
| |
| Payroll Type |
| |
| Equity Type |
| |
| Production Month (Date to Find Period and Year) | ||
| Business Entity Number | ||
| Building Number | ||
| Number of Rental Unit | ||
| Real Estate Contract Number | ||
| Service Charge Key | ||
| Settlement Unit | ||
| Reference Date for Settlement | ||
| Partner Business Entity Number | ||
| Partner Land Number for BE | ||
| Partner Building Number | ||
| Number of Partner Rental Unit | ||
| Number of Partner Rental Unit | ||
| Partner Real Estate Contract Number | ||
| Partner Service Charge Key | ||
| Partner Settlement Unit | ||
| Partner Reference Date for Settlement | ||
| Source of a Migrated Journal Entry Item | ||
| Item ID of Migrated G/L Line Item | ||
| BW Delta Process: Record Mode | ||
| Client |
| |
| Ledger in General Ledger Accounting |
| |
| Company Code |
| |
| Fiscal Year | ||
| Accounting Document Number | ||
| Six-Character Posting Item for Ledger | ||
| General Ledger Fiscal Year | ||
| Record Type |
| |
| Account Number |
|
Extractor Logic
The extractor uses the extraction method F1
(function module). The data is extracted with a function module that splits the data in packages. This is useful for very large data amounts.
Extractor: FINS_ACDOCA_BW_EXTRACT_DATA
Extraction structure: FINS_ACDOCA_BW