CN113506159A - SAP HANA-based cost allocation method, SAP HANA-based cost allocation device, SAP HANA-based cost allocation equipment and SAP storage medium - Google Patents
SAP HANA-based cost allocation method, SAP HANA-based cost allocation device, SAP HANA-based cost allocation equipment and SAP storage medium Download PDFInfo
- Publication number
- CN113506159A CN113506159A CN202110630520.0A CN202110630520A CN113506159A CN 113506159 A CN113506159 A CN 113506159A CN 202110630520 A CN202110630520 A CN 202110630520A CN 113506159 A CN113506159 A CN 113506159A
- Authority
- CN
- China
- Prior art keywords
- cost
- account
- data
- result
- processing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- WVCHIGAIXREVNS-UHFFFAOYSA-N 2-hydroxy-1,4-naphthoquinone Chemical compound C1=CC=C2C(O)=CC(=O)C(=O)C2=C1 WVCHIGAIXREVNS-UHFFFAOYSA-N 0.000 title claims abstract description 56
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000003860 storage Methods 0.000 title claims abstract description 13
- 238000007781 pre-processing Methods 0.000 claims abstract description 35
- 238000009795 derivation Methods 0.000 claims abstract description 26
- 230000008569 process Effects 0.000 claims description 16
- 238000005192 partition Methods 0.000 claims description 10
- 239000011248 coating agent Substances 0.000 claims description 5
- 238000000576 coating method Methods 0.000 claims description 5
- 238000009826 distribution Methods 0.000 claims description 5
- 238000002360 preparation method Methods 0.000 claims description 5
- 238000004590 computer program Methods 0.000 claims description 3
- 230000006870 function Effects 0.000 abstract description 10
- 239000000047 product Substances 0.000 description 11
- 238000004458 analytical method Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 238000011144 upstream manufacturing Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000007795 chemical reaction product Substances 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a cost allocation method, a device, equipment and a storage medium based on SAP HANA, wherein the method comprises the following steps: introducing cost data of cost allocation to an SAP system, carrying out settlement processing through a SAPHANA layer, firstly determining the cost to be allocated in the cost data, and then preprocessing the allocated cost data; importing single account data to an SAP system, and deducing configuration rules of the single account through SAPHANA layer sinking processing; redistributing the single account in the derivation result through SAPHANA layer sinking processing; processing the intermediate layer of the redistribution result by SAPHANA layer sinking treatment; and (4) carrying out single-account expense allocation by using a preprocessing result and a middle layer processing result through SAPHANA layer sinking treatment. According to the invention, the cost allocation module is designed and built in the HANA system, all allocation functions are sunk to the HANA for processing, the time required by the cost allocation work is greatly shortened, the work efficiency is improved, and the purposes of efficient, fine and flexible allocation are realized.
Description
Technical Field
The invention relates to the technical field of expense allocation, in particular to a cost allocation method, a device, equipment and a storage medium based on SAP HANA.
Background
The charge sharing function is one of the most common functions in the existing management accounting system, and is used for sharing the common charges among all departments and all products so as to facilitate scientific calculation of all production costs. The reason for the cost sharing is that modern production causes the appearance of common cost, and high technology further improves the proportion of the common cost, however, when the existing management accounting system performs the cost sharing function, it takes 36 hours to process 300 ten thousand single accounts and 1000 ten thousand shared data, the execution efficiency is low, and the timeliness requirement of the business department cannot be met.
Disclosure of Invention
The invention aims to provide a cost allocation method, a device, equipment and a storage medium based on SAP HANA, so as to solve the problem of low efficiency when the existing system performs cost allocation.
In order to overcome the defects in the prior art, the invention provides a cost allocation method based on SAP HANA, which comprises the following steps:
introducing cost data of cost allocation to an SAP system, determining cost to be allocated in the cost data through SAPHANA layer sinking processing, and preprocessing the allocated cost data;
importing single account data to an SAP system, and deducing configuration rules of the single account through SAPHANA layer sinking processing;
redistributing the single account in the derivation result through SAPHANA layer sinking processing;
processing the intermediate layer of the redistribution result by SAPHANA layer sinking treatment;
and (4) carrying out single-account expense allocation by using a preprocessing result and a middle layer processing result through SAPHANA layer sinking treatment.
Further, the deriving the configuration rule of the single account includes:
acquiring the verified single account which is not deduced, and deducing according to a preset configuration rule;
and importing the single account into the interface table DATATD data, marking in the derivation identification field, and writing into the single account derivation result table.
Further, the intermediate layer processing of the redistribution result by the SAPHANA layer sinking process includes:
removing account dimension data in the redistribution result, taking the account dimension data as a motive factor and participating in the distribution; and a process for the preparation of a coating,
and removing account dimension data in the preset range data of the single-account preprocessing and the client in the list, summarizing, and writing into the middle layer processing result list.
Further, the allocating the cost of the single account by using the preprocessing result and the middle layer processing result comprises:
and providing data of a preprocessing result and a customer partition table according to the intermediate layer processing result and the cause, and writing the result into a single-account partition result table.
The invention also provides a cost apportionment system based on SAP HANA, comprising:
the system comprises a cost preprocessing unit, a SAPHANA layer sinking processing unit and a data processing unit, wherein the cost preprocessing unit is used for importing cost data with cost sharing to an SAP system, firstly determining the cost to be shared in the cost data through the SAPHANA layer sinking processing, and then preprocessing the shared cost data;
the single account deduction unit is used for importing single account data to an SAP system, sinking through a SAPHANA layer and deducing the configuration rule of the single account;
the reallocation unit is used for reallocating the single account in the derivation result through SAPHANA layer sinking processing;
the middle layer processing unit is used for processing the middle layer of the redistribution result through SAPHANA layer sinking treatment;
and the cost allocation unit is used for performing single-account cost allocation by using the preprocessing result and the middle layer processing result through SAPHANA layer sinking processing.
Further, the single account derivation unit is further configured to:
acquiring the verified single account which is not deduced, and deducing according to a preset configuration rule;
and importing the single account into the interface table DATATD data, marking in the derivation identification field, and writing into the single account derivation result table.
Further, the intermediate layer processing unit is further configured to:
removing account dimension data in the redistribution result, taking the account dimension data as a motive factor and participating in the distribution; and a process for the preparation of a coating,
and removing account dimension data in the preset range data of the single-account preprocessing and the client in the list, summarizing, and writing into the middle layer processing result list.
Further, the cost apportionment unit is further configured to:
and providing data of a preprocessing result and a customer partition table according to the intermediate layer processing result and the cause, and writing the result into a single-account partition result table.
The present invention also provides a terminal device, comprising:
one or more processors;
a memory coupled to the processor for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the SAP HANA based cost amortization method of any one of the above.
The present invention also provides a computer readable storage medium having stored thereon a computer program for execution by a processor to implement the SAP HANA based cost amortization method as defined in any one of the above.
Compared with the prior art, the invention has the beneficial effects that:
1) the present invention utilizes the high-speed memory computing power of the HANA to replace the processing mode of the DB2 in the prior art, and the HANA uses a large memory to provide a memory database, and uses column-type storage in the memory database so as to load more data into the memory.
2) The cost allocation function of the management accounting system is sunk to the HANA memory database for execution, the high-efficiency memory operation capacity of the HANA can be effectively utilized, the overall performance of cost allocation is effectively improved, and therefore execution time is shortened.
3) The new scheme amortizes granularity fine to account level, amortizing dimensions (e.g.: guest groups, five-level classification, time limit, product level and the like) can be flexibly combined, the apportioned data volume is increased from about 1000 ten thousand to over 9 hundred million, but the total time consumption is reduced by nearly 90 percent compared with the original scheme, and the efficiency is obviously improved.
Drawings
In order to more clearly illustrate the technical solution of the present invention, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a schematic flow chart of a SAP HANA based cost sharing method according to one embodiment of the present invention;
FIG. 2 is a schematic diagram of the operation of a HANA according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating a comparison of the cost sharing process between the original solution and the solution of the present invention according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a cost sharing system based on SAP HANA according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be understood that the step numbers used herein are for convenience of description only and are not used as limitations on the order in which the steps are performed.
It is to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in the specification of the present invention and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
The terms "comprises" and "comprising" indicate the presence of the described features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
The term "and/or" refers to and includes any and all possible combinations of one or more of the associated listed items.
In a first aspect:
referring to fig. 1, an embodiment of the present invention provides a cost sharing method based on SAP HANA, including:
s10, importing cost data of cost allocation to an SAP system, performing settlement processing through a SAPHANA layer, determining cost to be allocated in the cost data, and preprocessing the allocated cost data;
s20, importing single account data to an SAP system, sinking through a SAPHANA layer, and deducing configuration rules of the single account;
s30, redistributing the single account in the derivation result through SAPHANA layer sinking processing;
s40, carrying out middle layer processing on the redistribution result through SAPHANA layer sinking processing;
and S50, carrying out single-account cost allocation by using the preprocessing result and the middle layer processing result through SAPHANA layer sinking processing.
It should be noted that, the existing cost apportionment module of the existing management accounting system realizes one-way apportionment of products and clients, does not support the combination analysis of clients and products, has an account number of 300 ten thousand, has a single apportionment result data volume of 1000 ten thousand, requires 36 hours for one-time apportionment, and cannot meet the requirements of service refinement apportionment appeal and data timeliness. The main reason is that the core apportionment processing process of the cost apportionment module mainly depends on the apportionment program of the SAP product, and the bottom database adopts IBM DB 2. In the sharing mode, the program execution efficiency is easily influenced by the data volume factor, and the technical bottleneck is encountered. HANA provides a memory database using a large memory, and uses column-wise storage in the memory database so as to load more data into the memory. The cost allocation function is sunk to the HANA end to be executed, the high-efficiency computing capability of the HANA can be effectively utilized, the overall performance of cost allocation is effectively improved, and therefore execution time is shortened.
As shown in fig. 2, fig. 2 provides the working principle of the HANA database, in which the HANA memory database uses columnar storage, so that more data can be loaded into the memory for business personnel to access the data details related to the cost sharing module from the SAP client. Meanwhile, the service can also input service parameters such as customer share proportion, cost factor to be shared, sharing factor and the like through the SAP client, and finally the service parameters are written into the HANA hard disk for storage.
Specifically, in the present embodiment, the implementation steps of the apportionment method are mainly as shown in fig. 3, and include
Step1, importing expense data:
it should be noted that the expense data refers to the business bank expenses, which refer to the expenses incurred in the business management and management work, and refers to the middle and back office management costs and expenses in the cost sharing project. In this step, the cost data of the cost sharing is obtained by the SAP system in a manner of reading the upstream system file through the interface, and the SAP HANA is read in.
Step 2: and (3) apportioning the cost to be apportioned:
the expense to be shared refers to the expense to be distributed secondarily, such as: the expense to be shared by the human resource department, the office department, the financial accounting department and the like, and the expense to be shared by a certain department is transferred and distributed or shared among other departments in the bank. Wherein, the memory usage of the step is mainly processed by sinking the SAP HANA layer.
Step 3: preprocessing the cost:
the cost preprocessing refers to secondary processing of the allocated cost data, and other analysis dimensions are derived and supplemented by a cost department and a cost classification, such as: expense source profit center, department wide category, expense wide category, profit center (territory) for subsequent contribution. Its memory usage is also through SAP HANA layer sinking process.
Step 4: single account access:
the single account refers to various accounts opened by the customer in the bank, including accounts of various bank products such as loan deposit, financing, insurance and the like. In this step, the cost-apportioned single-account data is obtained by the SAP system from the upstream system file server through an interface.
Step 5: single account derivation:
the single account derivation refers to the derivation of the single account verified at Step4 and not derived according to the established configuration rule, the single account is successfully imported into the interface table DATATD data, the derivation identification field is marked with Y, and the derivation result table is written. Its memory usage is also through SAP HANA layer sinking process.
Step 6: single account reallocation:
the single account reallocation is to allocate some dimensions of the single account to other single accounts according to reallocation rules set by a business department. Its memory usage is also through SAP HANA layer sinking process.
Step 7: processing the intermediate layer:
after the single account is redistributed, the result data is used as an incentive after the account dimensionality is removed, and participates in allocation. The single account preprocessing and the client are divided into data in a specific range in the form and the interior, account dimensions are removed, and the data are summarized and written into a middle layer processing result table. Its memory usage is also through SAP HANA layer sinking process.
Step 8: and (3) allocating the cost of a single account and detailed products:
single account amortization is the apportionment of charges from the middle tier to the single account. In the Step, specific cost in the result is allocated from the Step7 intermediate layer, and according to the established rule of the service, the result is written into the single account allocation result table by taking the data of the single account preprocessing and the client dividing into the specific data type range in the table. Its memory usage is also through SAP HANA layer sinking process.
In addition, fig. 3 compares the original solution with the apportionment method provided by the embodiment of the present invention, and as can be seen from fig. 3, compared with the original solution, the front-end product with the apportioned cost of the present embodiment applies the SAP before and after the modification, but the database of the application is changed from the original DB2 to the HANA. The single account allocation, the middle layer processing (the transformation scheme is Step 4-Step 8) and other steps are designed to be processed at the HANA end, and the efficiency is improved by utilizing the HANA memory operation capacity. Meanwhile, the original scheme uses the cost sharing function provided by the SAP product, and the execution efficiency is obviously prolonged due to the gradual increase of the data volume. In the embodiment, the cost data import and cost allocation processing (the transformation schemes Step1 to Step3) is self-developed by an inline project team, related functions are split and sunk to HANA for processing, and the high-speed memory computing capability of HANA is fully utilized.
The cost allocation method provided by the embodiment of the invention sinks the cost allocation function into the HANA memory database for execution, can effectively utilize the high-efficiency memory operation capability of the HANA, effectively improves the overall performance of cost allocation, and further shortens the execution time.
In one embodiment, a comparison of the calculation effect of the apportioned cost of the embodiment of the present invention and the original scheme is given, as shown in the following table:
TABLE 1 comparison of the cost calculation results of the present invention and the original scheme
As can be seen from table 1, the expense before modification is only allocated to the customer level, the product and the customer are allocated in one way, the combination analysis of the customer and the product is not supported, the allocation dimension is single and inflexible, the data size of million levels, namely the number of single accounts is 300 ten thousand, the time consumption of about 36 hours is when the amount of allocation results is 1000 ten thousand, and the allocation granularity is only the customer; by using the method provided by the embodiment, the bottleneck of apportionment performance is broken by means of a new technology, and efficient apportionment is realized. The expense is finely divided into a single account, and meanwhile, the product and the client are alternately and flexibly divided. The method of the invention, namely, when the number of single account is 1300 ten thousand and the number of the apportioned results is 9 hundred million, the apportionment takes 4 hours and the apportioned granularity is finer, and is specific to the account. Therefore, on the premise of fine data granularity and increased data quantity, the time consumption of the whole cost allocation processing process is greatly reduced, and the allocation efficiency is obviously improved.
In a second aspect:
referring to fig. 4, an embodiment of the present invention further provides a cost sharing system based on SAP HANA, including:
the expense preprocessing unit 01 is used for importing expense data with apportioned cost to an SAP system, determining expense to be apportioned in the expense data through SAPHANA layer sinking processing, and preprocessing the apportioned expense data;
the single account derivation unit 02 is used for importing single account data to an SAP system, performing settlement processing through a SAPHANA layer, and deriving configuration rules of the single account;
the reallocation unit 03 is used for reallocating the single account in the derivation result through SAPHANA layer sinking processing;
the middle layer processing unit 04 is used for processing the middle layer of the redistribution result through SAPHANA layer sinking treatment;
and the cost allocation unit 05 is used for performing single-account cost allocation by using the preprocessing result and the middle layer processing result through SAPHANA layer sinking processing.
Further, the single account derivation unit is further configured to:
acquiring the verified single account which is not deduced, and deducing according to a preset configuration rule;
and importing the single account into the interface table DATATD data, marking in the derivation identification field, and writing into the single account derivation result table.
Further, the intermediate layer processing unit is further configured to:
removing account dimension data in the redistribution result, taking the account dimension data as a motive factor and participating in the distribution; and a process for the preparation of a coating,
and removing account dimension data in the preset range data of the single-account preprocessing and the client in the list, summarizing, and writing into the middle layer processing result list.
Further, the cost apportionment unit is further configured to:
and providing data of a preprocessing result and a customer partition table according to the intermediate layer processing result and the cause, and writing the result into a single-account partition result table.
The cost allocation system provided by the embodiment of the invention is used for executing the method provided by the embodiment, and the cost allocation function is sunk into the HANA memory database for execution, so that the high-efficiency memory operation capability of the HANA can be effectively utilized, the overall performance of cost allocation is effectively improved, and the execution time is shortened.
In a third aspect:
an embodiment of the present invention further provides a terminal device, including:
one or more processors;
a memory coupled to the processor for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the SAP HANA based cost-sharing approach described above.
The processor is used for controlling the overall operation of the terminal equipment to complete all or part of the steps of the cost sharing method based on SAP HANA. The memory is used to store various types of data to support operation at the terminal device, and these data may include, for example, instructions for any application or method operating on the terminal device, as well as application-related data. The Memory may be implemented by any type of volatile or non-volatile Memory device or combination thereof, such as Static Random Access Memory (SRAM), Electrically Erasable Programmable Read-Only Memory (EEPROM), Erasable Programmable Read-Only Memory (EPROM), Programmable Read-Only Memory (PROM), Read-Only Memory (ROM), magnetic Memory, flash Memory, magnetic disk, or optical disk.
The terminal Device may be implemented by one or more Application Specific1 integrated circuits (AS 1C), a Digital Signal Processor (DSP), a Digital Signal Processing Device (DSPD), a Programmable Logic Device (PLD), a Field Programmable Gate Array (FPGA), a controller, a microcontroller, a microprocessor, or other electronic components, and is configured to perform the SAP HANA-based cost sharing method according to any of the embodiments described above, and achieve the technical effects consistent with the above methods.
An embodiment of the present invention also provides a computer readable storage medium comprising program instructions which, when executed by a processor, implement the steps of the SAP HANA based cost amortization method according to any of the embodiments described above. For example, the computer readable storage medium may be the above memory including program instructions executable by the processor of the terminal device to perform the SAP HANA based cost sharing method according to any one of the above embodiments, and achieve the technical effects consistent with the above method.
While the foregoing is directed to the preferred embodiment of the present invention, it will be understood by those skilled in the art that various changes and modifications may be made without departing from the spirit and scope of the invention.
Claims (10)
1. A cost sharing method based on SAP HANA, comprising:
introducing cost data of cost allocation to an SAP system, determining cost to be allocated in the cost data through SAPHANA layer sinking processing, and preprocessing the allocated cost data;
importing single account data to an SAP system, and deducing configuration rules of the single account through SAPHANA layer sinking processing;
redistributing the single account in the derivation result through SAPHANA layer sinking processing;
processing the intermediate layer of the redistribution result by SAPHANA layer sinking treatment;
and (4) carrying out single-account expense allocation by using a preprocessing result and a middle layer processing result through SAPHANA layer sinking treatment.
2. The SAP HANA-based cost sharing method of claim 1, wherein the deriving the configuration rules for the single account comprises:
acquiring the verified single account which is not deduced, and deducing according to a preset configuration rule;
and importing the single account into the interface table DATATD data, marking in the derivation identification field, and writing into the single account derivation result table.
3. A SAP HANA based cost sharing method as claimed in claim 1, wherein said intermediate layer processing of redistribution results by a SAPHANA layer sinking process comprises:
removing account dimension data in the redistribution result, taking the account dimension data as a motive factor and participating in the distribution; and a process for the preparation of a coating,
and removing account dimension data in the preset range data of the single-account preprocessing and the client in the list, summarizing, and writing into the middle layer processing result list.
4. A SAP HANA based cost sharing method according to claim 3, wherein said single account cost sharing using pre-processing results and middle layer processing results comprises:
and providing data of a preprocessing result and a customer partition table according to the intermediate layer processing result and the cause, and writing the result into a single-account partition result table.
5. A SAP HANA based cost sharing system, comprising:
the system comprises a cost preprocessing unit, a SAPHANA layer sinking processing unit and a data processing unit, wherein the cost preprocessing unit is used for importing cost data with cost sharing to an SAP system, firstly determining the cost to be shared in the cost data through the SAPHANA layer sinking processing, and then preprocessing the shared cost data;
the single account deduction unit is used for importing single account data to an SAP system, sinking through a SAPHANA layer and deducing the configuration rule of the single account;
the reallocation unit is used for reallocating the single account in the derivation result through SAPHANA layer sinking processing;
the middle layer processing unit is used for processing the middle layer of the redistribution result through SAPHANA layer sinking treatment;
and the cost allocation unit is used for performing single-account cost allocation by using the preprocessing result and the middle layer processing result through SAPHANA layer sinking processing.
6. The SAP HANA-based cost-sharing system of claim 5, wherein the single-account derivation unit is further configured to:
acquiring the verified single account which is not deduced, and deducing according to a preset configuration rule;
and importing the single account into the interface table DATATD data, marking in the derivation identification field, and writing into the single account derivation result table.
7. The SAP HANA-based cost-sharing system of claim 5, wherein the middle layer processing unit is further configured to:
removing account dimension data in the redistribution result, taking the account dimension data as a motive factor and participating in the distribution; and a process for the preparation of a coating,
and removing account dimension data in the preset range data of the single-account preprocessing and the client in the list, summarizing, and writing into the middle layer processing result list.
8. The SAP HANA-based cost-sharing system of claim 7, wherein the cost-sharing unit is further configured to:
and providing data of a preprocessing result and a customer partition table according to the intermediate layer processing result and the cause, and writing the result into a single-account partition result table.
9. A terminal device, comprising:
one or more processors;
a memory coupled to the processor for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the SAP HANA based cost amortization method of any one of claims 1 to 4.
10. A computer-readable storage medium having stored thereon a computer program, the computer program being executable by a processor to implement the SAP HANA based cost split method according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110630520.0A CN113506159B (en) | 2021-06-07 | 2021-06-07 | Cost allocation method, device, equipment and storage medium based on SAP HANA |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110630520.0A CN113506159B (en) | 2021-06-07 | 2021-06-07 | Cost allocation method, device, equipment and storage medium based on SAP HANA |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113506159A true CN113506159A (en) | 2021-10-15 |
| CN113506159B CN113506159B (en) | 2024-06-25 |
Family
ID=78009044
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110630520.0A Active CN113506159B (en) | 2021-06-07 | 2021-06-07 | Cost allocation method, device, equipment and storage medium based on SAP HANA |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113506159B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114356483A (en) * | 2022-01-05 | 2022-04-15 | 北京京航计算通讯研究所 | SAP ERP system data processing method |
| CN116027938A (en) * | 2023-03-30 | 2023-04-28 | 建信金融科技有限责任公司 | Information interaction method, device, equipment, medium and program product |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150154186A1 (en) * | 2013-12-04 | 2015-06-04 | Johannes Meinecke | Flexibly performing reallocations in databases |
| US20190197450A1 (en) * | 2016-08-25 | 2019-06-27 | Greg GUYE | Cost allocation method and system |
| CN111400272A (en) * | 2018-12-29 | 2020-07-10 | 华润置地控股有限公司 | Dynamic cost allocation method and system |
| CN111444283A (en) * | 2020-05-18 | 2020-07-24 | 江苏电力信息技术有限公司 | Method for calculating SAP BW4 by using SAP HANA |
| CN112862584A (en) * | 2021-03-29 | 2021-05-28 | 中信银行股份有限公司 | Method and system for distributing financial cost and income to households based on big data technology |
-
2021
- 2021-06-07 CN CN202110630520.0A patent/CN113506159B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150154186A1 (en) * | 2013-12-04 | 2015-06-04 | Johannes Meinecke | Flexibly performing reallocations in databases |
| US20190197450A1 (en) * | 2016-08-25 | 2019-06-27 | Greg GUYE | Cost allocation method and system |
| CN111400272A (en) * | 2018-12-29 | 2020-07-10 | 华润置地控股有限公司 | Dynamic cost allocation method and system |
| CN111444283A (en) * | 2020-05-18 | 2020-07-24 | 江苏电力信息技术有限公司 | Method for calculating SAP BW4 by using SAP HANA |
| CN112862584A (en) * | 2021-03-29 | 2021-05-28 | 中信银行股份有限公司 | Method and system for distributing financial cost and income to households based on big data technology |
Non-Patent Citations (1)
| Title |
|---|
| 李文等: "《新常态下商业银行管理会计系统建设及应用探索》", 金融会计, no. 2019, 28 February 2019 (2019-02-28) * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114356483A (en) * | 2022-01-05 | 2022-04-15 | 北京京航计算通讯研究所 | SAP ERP system data processing method |
| CN114356483B (en) * | 2022-01-05 | 2023-04-21 | 北京京航计算通讯研究所 | SAP ERP system data processing method |
| CN116027938A (en) * | 2023-03-30 | 2023-04-28 | 建信金融科技有限责任公司 | Information interaction method, device, equipment, medium and program product |
| CN116027938B (en) * | 2023-03-30 | 2023-06-02 | 建信金融科技有限责任公司 | Information interaction method, device, equipment, medium and program product |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113506159B (en) | 2024-06-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107993151B (en) | Fund transaction clearing method, device, equipment and computer readable storage medium | |
| CN108446176A (en) | A kind of method for allocating tasks, computer readable storage medium and terminal device | |
| CN113506159A (en) | SAP HANA-based cost allocation method, SAP HANA-based cost allocation device, SAP HANA-based cost allocation equipment and SAP storage medium | |
| EP1770620A2 (en) | Method for modelling processing procedures | |
| CN101963969B (en) | Method and database server for realizing load balancing in Oracle RAC (Real Application Cluster) system | |
| CN117076453A (en) | Batch task processing method, device and equipment | |
| CN107729423A (en) | A kind of big data processing method and processing device | |
| CN109615362A (en) | A kind of splitting of values method, device and equipment | |
| CN112052385A (en) | Investment and financing project recommendation method and device, electronic equipment and readable storage medium | |
| US11574347B2 (en) | System for high-speed billing transaction processing on a processing cluster | |
| US20220245721A1 (en) | Machine learning based automated savings goals | |
| CN112016914B (en) | Resource control and fund control method, device and equipment | |
| CN112449021B (en) | Internet resource screening method and device | |
| CN112990709A (en) | Approval task allocation method, device, equipment and storage medium | |
| Ikhsan et al. | The effect of financial development on economic growth in high-income countries | |
| CN115729714A (en) | Resource allocation method, device, storage medium and electronic equipment | |
| CN112418670A (en) | Case allocation method, device, equipment and medium | |
| CN108595669A (en) | A kind of unordered classified variable processing method and processing device | |
| CN108629674A (en) | Auction the distribution method and terminal device of income | |
| CN113342897A (en) | Data synchronization method and device | |
| CN112926892A (en) | Capital matching method and device, electronic equipment and storage medium | |
| Lv et al. | Classification of data granularity in data warehouse | |
| Drexl et al. | A new type of model for multi-item capacitated dynamic lotsizing and scheduling | |
| Kurmanova et al. | Role of financial and credit institutions in the regional economic development | |
| CN106157015A (en) | The method and device of fund recovery |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant |