CN110570291A - Method and device for generating accounting document based on SAP system - Google Patents
Method and device for generating accounting document based on SAP system Download PDFInfo
- Publication number
- CN110570291A CN110570291A CN201910702304.5A CN201910702304A CN110570291A CN 110570291 A CN110570291 A CN 110570291A CN 201910702304 A CN201910702304 A CN 201910702304A CN 110570291 A CN110570291 A CN 110570291A
- Authority
- CN
- China
- Prior art keywords
- accounting
- document
- calculation
- fields
- voucher
- 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.)
- Pending
Links
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 method and a device for generating an accounting document based on SAP (service access point), wherein the method comprises the following steps: receiving service data integrated by taking an accounting event as a dimension; according to the accounting event, configuration information corresponding to the accounting event is searched in prestored configuration data, and a first accounting voucher is generated according to the configuration information, wherein the configuration information comprises: accounting document structure of each accounting event and calculation rules of each field in the accounting document. The invention can realize configurable input structure of the source order, can deal with various business accounting scenes, can realize flexible accounting, and improves the expansibility, maintainability and reusability of the existing accounting device.
Description
Technical Field
the invention relates to the technical field of computers, in particular to a method and a device for generating an accounting document based on SAP.
background
The current financial accounting modes of SAP devices include manual accounting and programmed accounting. Manual billing is accomplished by standard transaction codes provided by SAP. Programmatic accounting is accomplished by calling standard accounting BAPI functions provided by SAP through the ABAP programming language.
in the two types of accounting modes, the programmed accounting has the characteristics of high efficiency and flexibility compared with manual accounting, but when an accounting service is added or a certain accounting is changed, corresponding codes are required to be added or relevant codes are required to be modified to meet the change of the service, and from the principle of software design, the programmed accounting mode violates the maintainability and reusability in software design and easily influences the existing realized accounting service.
disclosure of Invention
In order to solve the problems in the prior art, the invention provides a method and a device for generating accounting documents based on SAP (System applications and products), through the technical scheme of the invention, the accounting task can be completed only through configuration without repeatedly compiling codes, and the efficient, flexible and extensible maintainable functions of programmed accounting are really realized. The technical scheme is as follows:
in one aspect, a method for generating an accounting document based on SAP is provided, the method comprising:
Receiving service data integrated by taking an accounting event as a dimension;
According to the accounting event, configuration information corresponding to the accounting event is searched in prestored configuration data, and a first accounting voucher is generated according to the configuration information, wherein the configuration information comprises: accounting document structures of accounting events and calculation rules of fields in the accounting documents, the accounting document structures including: the voucher heading and the voucher item line.
Further, after receiving the business data integrated with the accounting event as the dimension, the method further comprises the following steps:
And calling the configuration data according to the accounting event by utilizing an external interface.
Further, the method further comprises: and summarizing the first accounting voucher with a specified dimension to generate a second accounting voucher.
further, the generating a first accounting credential according to the configuration information comprises:
Traversing accounting document structures of the accounting events in the configuration information, determining the document heading of the first accounting document, and determining the document item line of the first accounting document according to the configuration conditions of the document item line;
and traversing the calculation rule of each field in the configuration information, and determining the calculation rule of each field in the first accounting certificate according to the configuration condition of the calculation rule.
further, when the calculation rule is a direct allocation rule, the field calculation of the first accounting credential comprises:
And directly assigning any one or more fields in the business order data to the field of the first accounting voucher.
further, when the calculation rule is a table query rule, the field calculation of the first accounting credential comprises:
and according to any one or more fields in the service order data, one or more fields corresponding to the service order data are searched out from the condition intermediate table and are assigned to the field of the first accounting voucher.
Further, when the calculation rule is a derivation rule, the field calculation of the first accounting credential comprises:
And according to any one or more fields in the service order data, deducing one or more fields corresponding to the one or more fields by using a deduction table, and assigning the fields to the first accounting voucher.
Further, when the computation rule is a code enhancement rule, the field computation of the first accounting credential comprises:
And assigning values to the fields of the first accounting voucher in an ABAP language programming mode according to any one or more fields of the business order data.
In another aspect, there is provided an apparatus for generating an accounting document based on SAP, the apparatus including:
The data receiving module is used for receiving service data integrated by taking the accounting events as dimensions;
The credential generation module is used for generating a first accounting credential, and comprises:
A configuration module, configured to search configuration information corresponding to the accounting event in pre-stored configuration data according to the accounting event, where the configuration information includes: accounting document structures of accounting events and calculation rules of fields in the accounting documents, the accounting document structures including: the head of the certificate and the item of the certificate;
And the calculation module is used for generating the first accounting voucher according to the configuration information.
Further, the apparatus further comprises: and the SAP module is used for calling the configuration data according to the accounting event by utilizing an external interface.
further, the calculation module further comprises: and the summarizing module is used for summarizing the first accounting document by using a specified dimension to generate a second accounting document.
Further, the configuration module includes: an accounting document structure configuration module, configured to traverse accounting document structures of the accounting events in the configuration information, determine the document heading of the first accounting document, and determine the document entry line of the first accounting document according to a configuration condition of the document entry line;
and the calculation rule configuration module is used for traversing the calculation rules of all the fields in the configuration information and determining the calculation rules of all the fields in the first accounting certificate according to the configuration conditions of the calculation rules.
further, the calculation rule configuration module comprises one or more of the following sub-modules:
The direct distribution module is used for storing a direct distribution rule;
the table query module is used for storing table query rules;
The deduction calculation module is used for storing deduction calculation rules;
and the code enhancement module is used for storing the code enhancement rule.
Further, the calculation module includes one or more of the following sub-modules:
A direct distribution calculation module, configured to assign a value to a field of the first accounting credential according to the direct distribution rule, including:
And directly assigning any one or more fields in the business order data to the field of the first accounting voucher.
A table query computation module, configured to assign a value to a field of the first accounting credential according to the table query rule, including:
and according to any one or more fields in the service order data, one or more fields corresponding to the service order data are searched out from the condition intermediate table and are assigned to the field of the first accounting voucher.
A derivation calculation module, configured to assign a value to a field of the first accounting credential according to the derivation rule, including:
And according to any one or more fields in the service order data, deducing one or more fields corresponding to the one or more fields by using a deduction table, and assigning the fields to the first accounting voucher.
the code enhancement calculation module is used for assigning values to the fields of the first accounting voucher according to the code enhancement rule and comprises the following steps:
And assigning values to the fields of the first accounting voucher in an ABAP language programming mode according to any one or more fields of the business order data.
the technical scheme provided by the invention has the beneficial effects that:
1. The invention can realize configurable input structure of the source order, can deal with various business accounting scenes, realize flexible accounting and improve the expansibility, maintainability and reusability of the existing accounting device;
2. The calculation rules of each field in the accounting document comprise: direct allocation, table query, derivation and code enhancement can meet different calculation scenes, and the configuration can be flexibly selected;
3. The voucher generating module in the device disclosed by the invention comprises: the accounting document management system comprises a configuration module and a calculation module, wherein the configuration module is responsible for configuration of accounting document structures of all accounting events and calculation rules of all fields in the accounting documents, the calculation module performs calculation according to configuration of the configuration module, and different modules are responsible for different tasks and have separated responsibilities.
drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed to be used in the description of the embodiments will be briefly introduced 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 to obtain other drawings based on these drawings without creative efforts.
Fig. 1 is a flowchart of a method for generating an accounting document based on SAP according to embodiment 1 of the present invention;
FIG. 2 is a diagram illustrating a relationship between an accounting document structure and a field calculation rule according to embodiment 1 of the present invention;
fig. 3 is a schematic block diagram of an apparatus for generating an accounting document based on SAP according to embodiment 1 of the present invention;
FIG. 4 is a flowchart of a method for generating accounting documents based on SAP according to embodiment 2 of the present invention;
fig. 5 is a schematic diagram of the generated accounting document provided in embodiment 2 of the present invention.
Detailed Description
in order to make the objects, technical solutions and advantages of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying 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.
The service data input to the SAP device may be divided into service data associated with the accounting document (i.e., data that the accounting document needs to be generated to use) and data unrelated to the accounting document (i.e., data that the accounting document does not need to be generated or needs to be rarely used). In the prior art, the SAP device does not process business data and directly generates the accounting document, and because the business of an enterprise is changed frequently, the generation of the accounting document needs to be changed along with the change of the business of the enterprise, so that the generation code of the accounting document needs to be changed frequently, and manpower is consumed. The embodiment of the invention separates the bookkeeping function in the SAP device and generates the accounting voucher according to the configuration rule, so that a user can select or define the configuration rule according to the service characteristics and the self requirement during use without modifying the original code, thereby improving the expandability, maintainability and reusability of the device.
Example 1
As shown in fig. 1, a method of generating an accounting document based on SAP includes:
receiving service data integrated by taking an accounting event as a dimension;
According to the accounting event, configuration information corresponding to the accounting event is searched in prestored configuration data, and a first accounting voucher is generated according to the configuration information, wherein the configuration information comprises: accounting document structures of accounting events and calculation rules of fields in the accounting documents, the accounting document structures including: the voucher heading and the voucher item line.
It should be noted that, in the above method, the business data refers to data related to business of the enterprise. The service order data mainly refers to data related to accounting and billing, and may be information which is automatically input by a user, or information which is automatically identified by a device through a service order, such as information of an order form, such as a sales order form, a purchase order form, a cost order form, a transfer order form, and the like. Accounting events can be distinguished by the nature of the type of business account occurrence, such as: the method provided by the embodiment of the invention comprises the steps of inputting a code of an accounting event, namely receiving all business data under the code of the accounting event. One accounting event always corresponds to one type of accounting document, and the accounting events are used as generating units in the subsequent accounting document generation. The service data integrated by taking the accounting event as a dimension specifically comprises the following steps: and analyzing, sorting and inductive processing the business order data, and splitting each business order into one or more accounting events. Accounting document structure includes: as shown in FIG. 2, the configuration information corresponding to the accounting event is searched for, that is, the configuration information corresponds to one type of accounting document according to the accounting event and the calculation rules of the fields in the type of accounting document are obtained, so as to clarify the new line and item to be included in the accounting document and the values of the new line and item, and generate a first accounting document. In the method, the accounting document structure and the calculation rules of all the fields are preset, so that after the accounting event is determined, the configuration information required by generating the accounting document can be directly searched according to the accounting event, and the configuration information is executed to generate the first accounting document. If the calculation rule corresponding to the accounting event cannot be found in the preset calculation rules, the configuration data can be called through an external interface according to the accounting event.
generating the first accounting credential according to the configuration information comprises:
Traversing accounting document structures of the accounting events in the configuration information, determining the document heading of the first accounting document, and determining the document item line of the first accounting document according to the configuration conditions of the document item line;
and traversing the calculation rule of each field in the configuration information, and determining the calculation rule of each field in the first accounting certificate according to the configuration condition of the calculation rule.
it should be noted that each accounting event can correspond to an accounting document structure, the accounting document structure is preset in the device, the calculation rules of the fields correspond to the fields in the accounting document, and are also preset in the device, so once the accounting event is determined, the head-up and item items and the head-up and item values of the corresponding accounting document can be configured and determined according to the respective configuration conditions, wherein the head-up of the accounting document has no configuration condition, the item items of the accounting document and the field calculation rules in the item items of the accounting document have corresponding configuration conditions, and the corresponding item items and calculation rules can be configured only after the business data meets the corresponding configuration conditions. If there is a new accounting event or accounting document field, it needs to configure accounting structure for the new accounting event and configure calculation rule for the new field.
The calculation rules of the fields of the accounting document comprise: one or more of direct assignment, table lookup, derivative calculation, code enhancement.
Wherein, when the calculation rule is a direct distribution rule, the field calculation of the first accounting certificate comprises: and directly assigning any one or more fields in the business order data to the field of the first accounting voucher.
When the calculation rule is a table query rule, the field calculation of the first accounting voucher comprises: and according to any one or more fields in the service order data, one or more fields corresponding to the service order data are searched out from the condition intermediate table and are assigned to the field of the first accounting voucher.
When the calculation rule is a derivation rule, the field calculation of the first accounting credential comprises: and according to any one or more fields in the service order data, deducing one or more fields corresponding to the one or more fields by using a deduction table, and assigning the fields to the first accounting voucher.
When the computation rule is a code enhancement rule, the field computation of the first accounting credential comprises: and assigning values to the fields of the first accounting voucher in an ABAP language programming mode according to any one or more fields of the business order data. The code enhancement rule is that the user directly realizes the calculation of the field of the first accounting certificate in a programming mode, and the code enhancement rule mainly plays a supplementary role in direct distribution rules, form query rules and derivation rules, so that the method disclosed by the embodiment of the invention has wider application condition.
In practical use, a user has a need for merging accounting documents, so the method disclosed by the embodiment of the invention further comprises the following steps: and summarizing the first accounting voucher with a specified dimension to generate a second accounting voucher.
The dimension specified in the above method is any one or more fields in the first accounting credential. Aggregating the first accounting credential in the specified dimension may be: aggregated in customer code, aggregated in payment mode, etc.
To interface with SAP devices, configuration data is invoked from the accounting events using an external interface in embodiments of the present invention. The generated first accounting voucher or the second accounting voucher may be returned to the SAP device through an external interface for presentation.
as shown in fig. 3, the SAP-based accounting document generation device established based on the above method includes:
The data receiving module is used for receiving service data integrated by taking the accounting events as dimensions;
And the SAP module is used for calling the configuration data according to the accounting event by utilizing an external interface.
the credential generation module is used for generating a first accounting credential, and comprises:
a configuration module, configured to search configuration information corresponding to the accounting event in pre-stored configuration data according to the accounting event, where the configuration information includes: accounting document structures of accounting events and calculation rules of fields in the accounting documents, the accounting document structures including: the head of the certificate and the item of the certificate;
and the calculation module is used for generating the first accounting voucher according to the configuration information.
The calculation module further comprises: and the summarizing module is used for summarizing the first accounting document by using a specified dimension to generate a second accounting document. The specified dimension includes one or more fields in the first accounting credential.
A configuration module, specifically comprising: an accounting document structure configuration module, configured to traverse accounting document structures of the accounting events in the configuration information, determine the document heading of the first accounting document, and determine the document entry line of the first accounting document according to a configuration condition of the document entry line;
And the calculation rule configuration module is used for traversing the calculation rules of all the fields in the configuration information and determining the calculation rules of all the fields in the first accounting certificate according to the configuration conditions of the calculation rules.
The calculation rule configuration module comprises one or more of the following sub-modules:
The direct distribution module is used for storing a direct distribution rule;
The table query module is used for storing table query rules;
the deduction calculation module is used for storing deduction calculation rules;
and the code enhancement module is used for storing the code enhancement rule.
The calculation module includes one or more of the following sub-modules:
a direct distribution calculation module, configured to assign a value to a field of the first accounting credential according to the direct distribution rule, including:
And directly assigning any one or more fields in the business order data to the field of the first accounting voucher.
A table query computation module, configured to assign a value to a field of the first accounting credential according to the table query rule, including:
And according to any one or more fields in the service order data, one or more fields corresponding to the service order data are searched out from the condition intermediate table and are assigned to the field of the first accounting voucher.
A derivation calculation module, configured to assign a value to a field of the first accounting credential according to the derivation rule, including:
And according to any one or more fields in the service order data, deducing one or more fields corresponding to the one or more fields by using a deduction table, and assigning the fields to the first accounting voucher.
The code enhancement calculation module is used for assigning values to the fields of the first accounting voucher according to the code enhancement rule and comprises the following steps:
And assigning values to the fields of the first accounting voucher in an ABAP language programming mode according to any one or more fields of the business order data.
Example 2
The embodiment will explain the technical solution of the present invention in detail by combining a specific application scenario on the basis of embodiment 1.
As shown in fig. 4, a method of generating an accounting document based on SAP includes:
S01, receiving business data integrated by taking the accounting event as a dimension, wherein the accounting event is 'SK 01' as shown in the following. Raising head
And S02, calling configuration data by using the external interface and loading configuration information.
S03, traversing the accounting document structure of each accounting event in the configuration information, and determining the document structure of the first accounting document. Further, step S03 further includes: and judging whether the configuration of the first accounting certificate structure is enabled or not, and if not, traversing again.
It should be noted that: in determining the voucher structure of the first accounting voucher, the entries of the accounting voucher may determine whether to configure according to conditions preset by the entries, such as: and if the payment mode in the business bookkeeping data meets the condition of the preset payment mode of an accounting document item row, configuring the item row, and if the payment mode in the business bookkeeping data does not meet the condition, not configuring the item row. The determination of the initiation of the configuration of the accounting document structure in step S03 is to determine whether the business data satisfies the configuration condition of the accounting document entry line.
The credential structure of the first accounting credential determined from the accounting event comprises:
1. Voucher head-up
a. The credential type BLART.
b. Refer to the XBLNR computation strategy.
c. credential date BLDAT.
d. the posting date BUDAT.
e. company code BUKRS.
f. The currency code WAERS.
2. Credential item lines: borrowing money
a. subject HKONT.
b. The customer number KUNNR.
c. The subject type KOART.
d. The special ledger identifies UMSKZ.
e. the voucher currency amount WRBTR.
f. ZUONR is assigned.
g. The loan identifier SHKZG.
3. Credential item lines: loan
a. The subject type KOART.
b. General ledger section HKONT.
c. supplier LIFNR.
d. item text SGTXT.
e. The loan identifier SHKZG.
f. the reason code RSTGR.
s04, traversing the calculation rule of each field in the configuration information, and respectively determining the calculation rule of each field in the first accounting voucher. Further, step S04 further includes: and judging whether the field calculation rule is started or not, and if not, traversing again.
It should be noted that each field may contain multiple calculation rules, and therefore, one of the multiple calculation rules needs to be determined to be suitable for the service data, and therefore, similar to the configuration condition of the above item row, the configuration of the field calculation rule is also provided with a corresponding condition. When the service data meets the configuration condition of the field calculation rule, the corresponding field calculation rule is configured. In step S04, the enabling of the calculation rule is determined to determine whether the service data satisfies the configuration condition of the calculation rule.
according to the above credential structure, the calculation rules of each field in the first accounting credential are configured as follows:
1. Voucher head-up
a. The credential type BLART calculation strategy is directly distributed, and the value is as follows: a fixed value SK.
b. Referring to the XBLNR calculation strategy as direct assignment, the value is: the OMS lineup plus in the service head-up data is divided into order numbers.
c. the credential date BLDAT calculation policy is directly assigned with the value: "status date" in the traffic head-up data.
d. The calculation strategy of the posting date BUDAT is directly distributed, and the value is as follows: "posting date" in the transaction header data.
e. the calculation strategy of the company code BUKRS is directly distributed, and the value is as follows: "sales company" in business head-up data.
f. the currency code WAERS calculates the policy as direct allocation, and the value is: "currency code" in the business overhead data.
2. Credential item lines: borrowing money
a. Subject HKENT, the calculation strategy is a table query, and the search logic: and according to the payment mode in the service item row data, searching the accounting subjects in a configuration table (ZFIT 101).
b. the client number KUNNR, the calculation strategy is table query, and the search logic: and looking up the client in a configuration table (ZFIT101) according to the payment mode in the service item row data.
c. Subject type KOART, calculation strategy is table query, lookup logic: and searching the subject type in a configuration table (ZFIT101) according to the payment mode in the business item row data.
d. The special general ledger identification UMSKZ, the calculation strategy is table query, and the search logic is as follows: and checking the special general ledger identification in a configuration table (ZFIT101) according to the payment mode in the business item row data.
e. the voucher currency amount WRBTR is directly distributed according to the calculation strategy, and the value is as follows: the "payment amount" in the business item line data.
f. Allocating ZUONR, wherein the calculation strategy is directly allocated, and the value is as follows: the "pos single" + "payment store" in the new line.
g. The loan identifier SHKZG, the calculation policy is a derivation rule, and the derivation logic: according to the derivation table configured by the configuration engine, the corresponding value of 'document direction' 1 in the new line is S.
3. credential item lines: loan
a. Subject type KOART, calculation strategy is table query, lookup logic: AND (4) searching the subject type in a configuration table (ZFIT076) according to the 'arrearage identification' AND 'sales mode' in the business new line.
b. And the general account subject HKENT calculates the strategy as table query, and searches the logic: AND checking the general account in a configuration table (ZFIT076) according to the 'arrearage identification' AND 'sales mode' in the business new line.
c. supplier LIFNR, calculation strategy is direct assignment, value is: "sales companies" in business new line.
d. and (3) the item text SGTXT is directly distributed in the calculation strategy and has the value: the status date + in the business new line confirms the sale of goods and services.
e. The loan identifier SHKZG, the calculation policy is a derivation rule, and the derivation logic: according to the derivation table configured by the configuration engine, the corresponding value of 'document direction' 1 in the new line is H.
f. Reason code RSTGR, the calculation policy is directly assigned, the value is: a fixed value of 02.
and S05, calculating according to the calculation rule of each field in the first accounting voucher to generate the first accounting voucher. Fig. 5 shows the generated first accounting voucher, and the calculation process is as follows:
1. voucher head-up
a. the credential type BLART is a fixed value SK.
b. Reference to XBLNR is to divide the OMS line single "+" into order numbers in the traffic head-up data, which has a value of 0070165000750111000701650007501001.
c. The voucher date BLDAT is the "status date" in the business new line data, and has a value of 2018.10.27.
d. the posting date BUDAT is the "posting date" in the business new line data, and has a value of 2018.10.27.
e. The company code BUKRS is "sales company" in the business head-up data, and has a value of H007.
f. the currency code WAERS is the "currency code" in the business head-up data, and the value is CNY.
2. Credential item lines: borrowing money
a. The subject HKONT finds the billing subject 70108916 in the configuration table (ZFIT101) according to the "payment method" in the service item row data 4237.
b. The client number KUNNR refers to the client as 70108916 in the configuration table (ZFIT101) according to the "payment method" in the service item row data as 4237.
c. and the subject type KOART is detected to be D in a configuration table (ZFIT101) according to the payment mode 4237 in the business item line data.
d. And the special general ledger identifier UMSKZ is found in a configuration table (ZFIT101) according to the payment mode 4237 in the business item line data.
e. The voucher currency amount WRBTR is the 'repayment amount' in the business item row data and has a value of 709.00.
f. ZUONR was assigned as a "pos single" + "payment store" in head-up, with a value of AF 21246344871S.
g. And the loan identifier SHKZG is configured according to a derivation table configured by a configuration engine, and the corresponding value of 'document direction' 1 in the new heading is S.
3. Credential item lines: loan
a. AND the subject type KOART is searched to be S in a configuration table (ZFIT076) according to the 'arrearage identification' in the business new line, which is N AND 'sales mode' which is 02.
b. AND the general account HKONT finds that the general account is 2131260040 in a configuration table (ZFIT076) according to the 'arrearage identification' in the business new line, which is N AND AND 'sales mode', which is 02.
c. Supplier LIFNR, a "sales company" in business new line, with a value of H007.
d. The item text SGTXT confirms the sale of goods and services for the status date + in the business new header, and the value is 2018.10.27.
e. And the loan identifier SHKZG is configured according to a derivation table configured by a configuration engine, and the corresponding value of 'document direction' 1 in the new header is H.
f. The reason code RSTGR is a fixed value of 02.
S06, checking whether each field in the first accounting voucher is completed or not.
S07, checking whether the voucher structure of the first accounting voucher is complete.
and S08, collecting the first accounting voucher, combining the first accounting voucher according to the specified dimension, and generating a second accounting voucher.
And S09, returning the second accounting document by using the external interface.
The accounting document generating device executing the accounting document generating method comprises the following modules:
the data receiving module is used for receiving service data integrated by taking the accounting events as dimensions;
and the SAP module is used for calling the configuration data according to the accounting event by utilizing an external interface and returning a second accounting document.
the credential generation module is used for generating a first accounting credential, and comprises:
A configuration module, configured to search configuration information corresponding to the accounting event in pre-stored configuration data according to the accounting event, where the configuration information includes: accounting document structures of accounting events and calculation rules of fields in the accounting documents, the accounting document structures including: the head of the certificate and the item of the certificate;
and the calculation module is used for generating the first accounting voucher according to the configuration information.
The calculation module further comprises: and the summarizing module is used for summarizing the first accounting document by using a specified dimension to generate a second accounting document. The specified dimension includes one or more fields in the first accounting credential.
the configuration module includes: an accounting document structure configuration module, configured to traverse accounting document structures of the accounting events in the configuration information, determine the document heading of the first accounting document, and determine the document entry line of the first accounting document according to a configuration condition of the document entry line;
And the calculation rule configuration module is used for traversing the calculation rules of all the fields in the configuration information and determining the calculation rules of all the fields in the first accounting certificate according to the configuration conditions of the calculation rules.
The calculation rule configuration module comprises the following sub-modules:
the direct distribution module is used for storing a direct distribution rule;
The table query module is used for storing table query rules;
The deduction calculation module is used for storing deduction calculation rules;
and the code enhancement module is used for storing the code enhancement rule.
The calculation module comprises the following sub-modules:
A direct distribution calculation module, configured to assign a value to a field of the first accounting credential according to the direct distribution rule, including: and directly assigning any one or more fields in the business order data to the field of the first accounting voucher.
A table query computation module, configured to assign a value to a field of the first accounting credential according to the table query rule, including: and according to any one or more fields in the service order data, one or more fields corresponding to the service order data are searched out from the condition intermediate table and are assigned to the field of the first accounting voucher.
A derivation calculation module, configured to assign a value to a field of the first accounting credential according to the derivation rule, including: and according to any one or more fields in the service order data, deducing one or more fields corresponding to the one or more fields by using a deduction table, and assigning the fields to the first accounting voucher.
The code enhancement calculation module is used for assigning values to the fields of the first accounting voucher according to the code enhancement rule and comprises the following steps: and assigning values to the fields of the first accounting voucher in an ABAP language programming mode according to any one or more fields of the business order data.
The technical scheme provided by the invention has the beneficial effects that:
1. the invention can realize configurable input structure of the source order, can deal with various business accounting scenes, realize flexible accounting and improve the expansibility, maintainability and reusability of the existing accounting device;
2. The calculation rules of each field in the accounting document comprise: direct allocation, table query, derivation and code enhancement can meet different calculation scenes, and the configuration can be flexibly selected;
3. The voucher generating module in the device disclosed by the invention comprises: the accounting document management system comprises a configuration module and a calculation module, wherein the configuration module is responsible for configuration of accounting document structures of all accounting events and calculation rules of all fields in the accounting documents, the calculation module performs calculation according to configuration of the configuration module, and different modules are responsible for different tasks and have separated responsibilities.
all the above-mentioned optional technical solutions can be combined arbitrarily to form the optional embodiments of the present invention, and are not described herein again.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (10)
1. A method of generating accounting documents based on SAP, comprising:
receiving service data integrated by taking an accounting event as a dimension;
according to the accounting event, configuration information corresponding to the accounting event is searched in prestored configuration data, and a first accounting voucher is generated according to the configuration information, wherein the configuration information comprises: accounting document structures of accounting events and calculation rules of fields in the accounting documents, the accounting document structures including: the voucher heading and the voucher item line.
2. the SAP based method of generating accounting documents as recited in claim 1, wherein after receiving service data integrated in dimension of accounting events, the method further comprises:
and calling the configuration data according to the accounting event by utilizing an external interface.
3. The method of generating accounting documents based on SAP as claimed in claim 1 wherein said method further comprises: and summarizing the first accounting voucher with a specified dimension to generate a second accounting voucher.
4. The method of any of claims 1-3, wherein the generating a first accounting voucher based on the configuration information comprises:
traversing accounting document structures of the accounting events in the configuration information, determining the document heading of the first accounting document, and determining the document item line of the first accounting document according to the configuration conditions of the document item line;
and traversing the calculation rule of each field in the configuration information, and determining the calculation rule of each field in the first accounting certificate according to the configuration condition of the calculation rule.
5. The SAP based method of generating accounting documents as claimed in claim 4, wherein when the calculation rule is a direct allocation rule, the field calculation of the first accounting document comprises:
and directly assigning any one or more fields in the business order data to the field of the first accounting voucher.
6. The SAP based accounting document generation method of claim 4, wherein when the calculation rule is a table lookup rule, the field calculation of the first accounting document comprises:
And according to any one or more fields in the service order data, one or more fields corresponding to the service order data are searched out from the condition intermediate table and are assigned to the field of the first accounting voucher.
7. The SAP based accounting document generation method of claim 4, wherein when the calculation rule is a derivation rule, the field calculation of the first accounting document comprises:
And according to any one or more fields in the service order data, deducing one or more fields corresponding to the one or more fields by using a deduction table, and assigning the fields to the first accounting voucher.
8. The SAP based method of generating accounting documents as claimed in claim 4, wherein when the calculation rule is a code enhancement rule, the field calculation of the first accounting document comprises:
And assigning values to the fields of the first accounting voucher in an ABAP language programming mode according to any one or more fields of the business order data.
9. an SAP based accounting document generation device established based on the method of any one of claims 1-8, comprising:
The data receiving module is used for receiving service data integrated by taking the accounting events as dimensions;
The credential generation module is used for generating a first accounting credential, and comprises:
A configuration module, configured to search configuration information corresponding to the accounting event in pre-stored configuration data according to the accounting event, where the configuration information includes: accounting document structures of accounting events and calculation rules of fields in the accounting documents, the accounting document structures including: the head of the certificate and the item of the certificate;
And the calculation module is used for generating the first accounting voucher according to the configuration information.
10. The apparatus for generating accounting documents based on SAP as claimed in claim 9 wherein said apparatus further comprises: and the SAP module is used for calling the configuration data according to the accounting event by utilizing an external interface.
Priority Applications (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910702304.5A CN110570291A (en) | 2019-07-31 | 2019-07-31 | Method and device for generating accounting document based on SAP system |
| CA3150626A CA3150626A1 (en) | 2019-07-31 | 2020-06-24 | Method and device for generating accounting voucher based on sap system |
| PCT/CN2020/097851 WO2021017694A1 (en) | 2019-07-31 | 2020-06-24 | Method and device for generating accounting document based on sap system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910702304.5A CN110570291A (en) | 2019-07-31 | 2019-07-31 | Method and device for generating accounting document based on SAP system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110570291A true CN110570291A (en) | 2019-12-13 |
Family
ID=68773238
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910702304.5A Pending CN110570291A (en) | 2019-07-31 | 2019-07-31 | Method and device for generating accounting document based on SAP system |
Country Status (3)
| Country | Link |
|---|---|
| CN (1) | CN110570291A (en) |
| CA (1) | CA3150626A1 (en) |
| WO (1) | WO2021017694A1 (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111381984A (en) * | 2020-03-09 | 2020-07-07 | 唐山钢铁集团有限责任公司 | Method for SAP system interface to automatically generate accounting voucher without accounting code |
| CN111581246A (en) * | 2020-05-08 | 2020-08-25 | 北京字节跳动网络技术有限公司 | Method, device, electronic equipment and computer readable medium for generating data |
| WO2021017694A1 (en) * | 2019-07-31 | 2021-02-04 | 苏宁云计算有限公司 | Method and device for generating accounting document based on sap system |
| CN112559613A (en) * | 2020-12-16 | 2021-03-26 | 深圳市中农网有限公司 | Voucher data extraction method and device, computer equipment and storage medium |
| CN113220797A (en) * | 2020-01-21 | 2021-08-06 | 浙江大搜车软件技术有限公司 | Information configuration method, device, system, computer device and storage medium |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113158857A (en) * | 2021-04-09 | 2021-07-23 | 陈世海 | Electronic accounting voucher processing method and device, electronic equipment and medium |
| CN113239770B (en) * | 2021-04-30 | 2022-12-20 | 国网河北省电力有限公司沧州供电分公司 | Financial statement accounting method |
| CN113094401B (en) * | 2021-05-07 | 2023-08-08 | 北京京东振世信息技术有限公司 | Target source data generation method, device, equipment and storage medium |
| CN113869875A (en) * | 2021-10-12 | 2021-12-31 | 北京机械工业自动化研究所有限公司 | Dynamic business document generation method |
| CN116932091B (en) * | 2023-09-15 | 2023-12-26 | 畅捷通信息技术股份有限公司 | Configuration file generation method and device during credential generation and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404950A (en) * | 2014-11-18 | 2016-03-16 | 国网山东省电力公司 | SAP park document realization method and system based on service configuration |
| CN109615492A (en) * | 2017-09-29 | 2019-04-12 | 北京华融启明风险管理技术股份有限公司 | A kind of bookkeeping voucher generation method and system |
| CN109725898A (en) * | 2018-11-30 | 2019-05-07 | 平安科技（深圳）有限公司 | Configuration method, device, computer equipment and the storage medium of voucher rule |
| CN109785092A (en) * | 2018-12-10 | 2019-05-21 | 平安科技（深圳）有限公司 | Accounting voucher generates management method, device and computer equipment, storage medium |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8364563B2 (en) * | 2007-10-11 | 2013-01-29 | Car Parts, Inc. Color Systems | System and method for standardizing accounting of consumables |
| US20140114817A1 (en) * | 2012-10-23 | 2014-04-24 | Clearwater Analytics, Llc | System and method for applying diverse accounting events to account balances and generating financial reports |
| CN107705197A (en) * | 2017-10-24 | 2018-02-16 | 四川长虹电器股份有限公司 | Automatic bookkeeping methods based on controlling element in cloud finance platform |
| CN109409326A (en) * | 2018-11-09 | 2019-03-01 | 四川长虹电器股份有限公司 | A method of it is kept accounts automatically based on VAT invoice electronic data and generates voucher |
| CN109636557A (en) * | 2018-12-11 | 2019-04-16 | 厦门商集网络科技有限责任公司 | A kind of intelligent classification bookkeeping methods and equipment based on bank slip recognition |
| CN110570291A (en) * | 2019-07-31 | 2019-12-13 | 苏宁云计算有限公司 | Method and device for generating accounting document based on SAP system |
-
2019
- 2019-07-31 CN CN201910702304.5A patent/CN110570291A/en active Pending
-
2020
- 2020-06-24 CA CA3150626A patent/CA3150626A1/en active Pending
- 2020-06-24 WO PCT/CN2020/097851 patent/WO2021017694A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105404950A (en) * | 2014-11-18 | 2016-03-16 | 国网山东省电力公司 | SAP park document realization method and system based on service configuration |
| CN109615492A (en) * | 2017-09-29 | 2019-04-12 | 北京华融启明风险管理技术股份有限公司 | A kind of bookkeeping voucher generation method and system |
| CN109725898A (en) * | 2018-11-30 | 2019-05-07 | 平安科技（深圳）有限公司 | Configuration method, device, computer equipment and the storage medium of voucher rule |
| CN109785092A (en) * | 2018-12-10 | 2019-05-21 | 平安科技（深圳）有限公司 | Accounting voucher generates management method, device and computer equipment, storage medium |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021017694A1 (en) * | 2019-07-31 | 2021-02-04 | 苏宁云计算有限公司 | Method and device for generating accounting document based on sap system |
| CN113220797A (en) * | 2020-01-21 | 2021-08-06 | 浙江大搜车软件技术有限公司 | Information configuration method, device, system, computer device and storage medium |
| CN111381984A (en) * | 2020-03-09 | 2020-07-07 | 唐山钢铁集团有限责任公司 | Method for SAP system interface to automatically generate accounting voucher without accounting code |
| CN111381984B (en) * | 2020-03-09 | 2023-04-21 | 唐山钢铁集团有限责任公司 | Method for automatically generating accounting document without billing code by SAP system interface |
| CN111581246A (en) * | 2020-05-08 | 2020-08-25 | 北京字节跳动网络技术有限公司 | Method, device, electronic equipment and computer readable medium for generating data |
| CN112559613A (en) * | 2020-12-16 | 2021-03-26 | 深圳市中农网有限公司 | Voucher data extraction method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2021017694A1 (en) | 2021-02-04 |
| CA3150626A1 (en) | 2021-02-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110570291A (en) | Method and device for generating accounting document based on SAP system | |
| US20220261759A1 (en) | Methods And Systems For Expense Management | |
| US5835899A (en) | System and method for deriving financial responsibility identification | |
| US8458071B2 (en) | Instantaneous merchant information retrieval for financial transactions | |
| US9852407B2 (en) | Systems and methods for routing debit transactions | |
| TWI715950B (en) | Property execution method and system based on blockchain | |
| TWI720519B (en) | Amount settlement system and method | |
| CN108446968A (en) | A kind of method, apparatus and terminal device of accounting entry | |
| CN108897729B (en) | Transaction template sharing method and device, electronic equipment and storage medium | |
| CN102208061A (en) | Data cancel after verification processing device and method | |
| CN112348420A (en) | Storage position information acquisition method and system, storage medium and electronic equipment | |
| CN113935821A (en) | Method, device, electronic equipment and medium for settling commission charge in banking business | |
| CN115841395A (en) | Method and system for generating accounting entry data and related equipment | |
| CN112650748A (en) | Business clue distribution method and device, electronic equipment and readable storage medium | |
| JP2022512074A (en) | Purchase management system and method | |
| CN109544126A (en) | A kind of wallet creation method, equipment and storage medium | |
| CN112861140B (en) | Service data processing method and device and readable storage medium | |
| US8688609B2 (en) | Transforming a list of purchase types based on a configurable rule | |
| CN113762863A (en) | Inventory management method and device | |
| CN110738806A (en) | Payment mode determination method, device and system and electronic equipment | |
| JP2010122756A (en) | Edi integration system, edi integration method, and edi integration program | |
| CN113127559B (en) | Account book establishment method and device of financial block chain and computer equipment | |
| JP6953369B2 (en) | Allocation processing system and its method | |
| CN104067302A (en) | Mobile terminal management server, and mobile terminal management program | |
| US20060271375A1 (en) | Project information providing system and project information providing method |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191213 |
|
| RJ01 | Rejection of invention patent application after publication |