CN111381984A - Method for SAP system interface to automatically generate accounting voucher without accounting code - Google Patents

Method for SAP system interface to automatically generate accounting voucher without accounting code Download PDF

Info

Publication number
CN111381984A
CN111381984A CN202010157942.6A CN202010157942A CN111381984A CN 111381984 A CN111381984 A CN 111381984A CN 202010157942 A CN202010157942 A CN 202010157942A CN 111381984 A CN111381984 A CN 111381984A
Authority
CN
China
Prior art keywords
accounting
code
interface
sap system
codes
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
Application number
CN202010157942.6A
Other languages
Chinese (zh)
Other versions
CN111381984B (en
Inventor
郭颖
冷宝剑
杨林
刘晓进
孙双
胡浩
郑波
高鹏
李凯军
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tangshan Iron and Steel Group Co Ltd
HBIS Co Ltd Tangshan Branch
Original Assignee
Tangshan Iron and Steel Group Co Ltd
HBIS Co Ltd Tangshan Branch
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Tangshan Iron and Steel Group Co Ltd, HBIS Co Ltd Tangshan Branch filed Critical Tangshan Iron and Steel Group Co Ltd
Priority to CN202010157942.6A priority Critical patent/CN111381984B/en
Publication of CN111381984A publication Critical patent/CN111381984A/en
Application granted granted Critical
Publication of CN111381984B publication Critical patent/CN111381984B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/46—Multiprogramming arrangements
    • G06F9/54—Interprogram communication
    • G06F9/547—Remote procedure calls [RPC]; Web services
    • 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
    • G06Q40/125—Finance or payroll
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30—Computing systems specially adapted for manufacturing

Abstract

The invention relates to a method for automatically generating an accounting voucher by an SAP system interface without a bookkeeping code, belonging to the technical field of enterprise informatization management. The technical scheme is as follows: the method comprises the steps that an SAP system interface receives data, automatically matches a bookkeeping code, automatically generates an accounting document, and returns a generated accounting document number or error reporting information to a source system, a correspondence table of the bookkeeping code is manually maintained in the SAP system by service personnel, and interface information can be inquired in real time. The invention realizes the bridge function between the financial function sharing system and the SAP system, so that the financial function can be stripped from the SAP system, the problem that a user frequently inputs wrong accounting codes is solved, and the functions of automatically generating accounting vouchers and returning processing results by an SAP system interface are realized.

Description

Method for SAP system interface to automatically generate accounting voucher without accounting code
Technical Field
The invention relates to a method for automatically generating an accounting voucher by an SAP system interface without a bookkeeping code, belonging to the technical field of enterprise informatization management.
Background
In the field of enterprise information management, the SAP system interface has very important significance, and the SAP system interface has a bridge function with other information systems, so that the SAP system is effectively prevented from becoming an information isolated island in the enterprise information management.
With continuous deepening of informatization, more and more large enterprises apply the SAP system to carry out enterprise operation management, and with continuous deepening of application, each large enterprise starts to feel that the functions of the SAP system are not refined and comprehensive enough, so that a plurality of functions are gradually stripped from the SAP system to be managed by a professional functional software system, and meanwhile, main data information is returned to the SAP system, and the SAP system continues to carry out enterprise overall operation management.
In the field of financial information management, a plurality of software such as golden butterfly, friends and the like develop stronger and more detailed financial management functions, which are not possessed by SAP systems if expense reimbursement, one-key invoicing, business travel business and the like. SAP systems are increasingly unable to meet the needs of users, but the powerful enterprise overall operation management functions of the SAP systems prevent users from completely switching off the SAP systems, so some enterprises strip the financial functions of the SAP systems from the SAP systems. After stripping, a bridge needs to be established between the SAP system and the financial sharing management system, so that the accounting document of the financial function sharing system can be synchronized into the SAP system. Meanwhile, as a large amount of accounting codes need to be memorized during financial accounting operation of the SAP system, the situation that a user fills wrong accounting codes often occurs.
The existing functions of the existing SAP system interface can not realize the requirement of real-time synchronization of financial accounting vouchers between the SAP system and the function sharing system, and the BAPI technology of the existing SAP system can not realize the requirement of no need of entering accounting codes during financial accounting, so a new method is needed to solve the problem that the SAP system interface can automatically generate accounting vouchers without the need of the accounting codes.
Disclosure of Invention
The invention aims to provide a method for automatically generating an accounting voucher by an SAP system interface without a bookkeeping code, so that a bridge function between a financial function sharing system and an SAP system is realized, and the financial function can be stripped from the SAP system; the function of automatically filling the accounting codes is realized by using a new idea, and the problem that the user frequently mistakenly inputs the accounting codes is solved; the BAPI technology is utilized to realize the functions of automatically generating accounting documents by the SAP system interface and returning processing results; the universality is very strong, and the iron and steel enterprises implementing the SAP system can directly copy and transplant, thereby effectively solving the problems in the background technology.
The technical scheme of the invention is as follows: the SAP system interface automatic generation accounting document and no need of the method of the bookkeeping code, comprising the following steps:
step 1, establishing an interface between an SAP system and a financial function sharing system;
step 2, establishing an interface table in the interface module, wherein the interface table comprises a header table, a borrower table, a lender table and a result table;
step 3, establishing a self-established table in the SAP system, wherein the self-established table comprises a corresponding relation table of the accounting codes and an interface information table;
step 4, developing a maintenance program of the corresponding relation of the accounting codes;
step 5, developing an interface program, matching corresponding accounting codes according to the contents of the debit form and the credit form, filling a BAPI inner table according to the contents of the header form, the debit form and the credit form, calling the BAPI to generate an accounting voucher, filling a result table with a newly generated accounting voucher number if the result table is successful, and filling result information into the result table if the result table is failed;
step 6, returning result table information to the financial function sharing system, successfully returning accounting document numbers, and failing to return error reporting information;
and 7, developing an interface information inquiry program for monitoring the interface information.
ABAP language is adopted for development in SAP system.
In the step 4, the user maintains the corresponding relation of the accounting codes, and the corresponding relation can be flexibly changed along with the change of the SAP system configuration. Only a few users need to know the configuration rule, most users do not need to memorize a large amount of SAP accounting codes, the operation difficulty of the users is greatly reduced, and the error rate is effectively reduced.
In the step 5, the logic of matching the corresponding relation is as follows, and the program respectively takes out corresponding accounting codes and special general ledger identifications from the corresponding relation table according to the uploading information of the debit table and the credit table and backfills the accounting codes and the special general ledger identification fields of the debit table and the credit table; the fetch logic is as follows: (1) taking a bookkeeping code and a special general ledger identification according to the accounting subject; (2) if no value is obtained in the step (1), the accounting code and the special general ledger identification are obtained according to the current 4 bits of the accounting department; (3) if no value is obtained in the step (2), adding a first bit of a customer code according to the accounting subjects to obtain an accounting code and a special general ledger identifier; (4) if no value is obtained in step (3), the accounting code and the special general ledger identification are obtained according to the accounting subjects and the first bit of the supplier code; (5) if no value is obtained in the step (4), the accounting code and the special general ledger identification are obtained according to the current 4-bit plus customer code of the accounting department; (6) if no value is obtained in the step (5), the accounting code and the special general ledger identification are obtained according to the current 4 bits of the accounting department plus the first bit of the supplier code; (7) and (6) if no value is obtained, returning error information by the program, and prompting the user to maintain the accounting code corresponding relation table.
The invention has the beneficial effects that: the bridge function between the financial function sharing system and the SAP system is realized, so that the financial function can be stripped from the SAP system; the function of automatically filling the accounting codes is realized by using a new idea, and the problem that the user frequently mistakenly inputs the accounting codes is solved; the BAPI technology is utilized to realize the functions of automatically generating accounting documents by the SAP system interface and returning processing results; the universality is very strong, and the iron and steel enterprises implementing the SAP system can directly copy and transplant.
Drawings
FIG. 1 is a schematic development flow diagram of the present invention;
FIG. 2 is a diagram of a header table structure of the present invention;
FIG. 3 is a view of the debit table structure of the present invention;
FIG. 4 is a block diagram of a credit meter of the present invention;
FIG. 5 is a table of results structure of the present invention;
FIG. 6 is a diagram of a table of account codes according to the present invention;
FIG. 7 is a partial data diagram of a billing code correspondence table of the present invention;
fig. 8 is a partial data diagram of the interface information table of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the following will clearly and completely describe the technical solutions of the embodiments of the present invention with reference to the drawings of the embodiments, and it is obvious that the described embodiments are a small part of the embodiments of the present invention, rather than all embodiments, and all other embodiments obtained by a person of ordinary skill in the art without creative work based on the embodiments of the present invention belong to the protection scope of the present invention.
The SAP system interface automatic generation accounting document and no need of the method of the bookkeeping code, comprising the following steps:
step 1, establishing an interface between an SAP system and a financial function sharing system;
step 2, establishing an interface table in the interface module, wherein the interface table comprises a header table, a borrower table, a lender table and a result table;
step 3, establishing a self-established table in the SAP system, wherein the self-established table comprises a corresponding relation table of the accounting codes and an interface information table;
step 4, developing a maintenance program of the corresponding relation of the accounting codes;
step 5, developing an interface program, matching corresponding accounting codes according to the contents of the debit form and the credit form, filling a BAPI inner table according to the contents of the header form, the debit form and the credit form, calling the BAPI to generate an accounting voucher, filling a result table with a newly generated accounting voucher number if the result table is successful, and filling result information into the result table if the result table is failed;
step 6, returning result table information to the financial function sharing system, successfully returning accounting document numbers, and failing to return error reporting information;
and 7, developing an interface information inquiry program for monitoring the interface information.
ABAP language is adopted for development in SAP system.
In the step 4, the user maintains the corresponding relation of the accounting codes, and the corresponding relation can be flexibly changed along with the change of the SAP system configuration. Only a few users need to know the configuration rule, most users do not need to memorize a large amount of SAP accounting codes, the operation difficulty of the users is greatly reduced, and the error rate is effectively reduced.
In the step 5, the logic of matching the corresponding relation is as follows, and the program respectively takes out corresponding accounting codes and special general ledger identifications from the corresponding relation table according to the uploading information of the debit table and the credit table and backfills the accounting codes and the special general ledger identification fields of the debit table and the credit table; the fetch logic is as follows: (1) taking a bookkeeping code and a special general ledger identification according to the accounting subject; (2) if no value is obtained in the step (1), the accounting code and the special general ledger identification are obtained according to the current 4 bits of the accounting department; (3) if no value is obtained in the step (2), adding a first bit of a customer code according to the accounting subjects to obtain an accounting code and a special general ledger identifier; (4) if no value is obtained in step (3), the accounting code and the special general ledger identification are obtained according to the accounting subjects and the first bit of the supplier code; (5) if no value is obtained in the step (4), the accounting code and the special general ledger identification are obtained according to the current 4-bit plus customer code of the accounting department; (6) if no value is obtained in the step (5), the accounting code and the special general ledger identification are obtained according to the current 4 bits of the accounting department plus the first bit of the supplier code; (7) and (6) if no value is obtained, returning error information by the program, and prompting the user to maintain the accounting code corresponding relation table.

Claims (4)

  1. A method for SAP system interface to automatically generate accounting documents without accounting codes, comprising the steps of:
    step 1, establishing an interface between an SAP system and a financial function sharing system;
    step 2, establishing an interface table in the interface module, wherein the interface table comprises a header table, a borrower table, a lender table and a result table;
    step 3, establishing a self-established table in the SAP system, wherein the self-established table comprises a corresponding relation table of the accounting codes and an interface information table;
    step 4, developing a maintenance program of the corresponding relation of the accounting codes;
    step 5, developing an interface program, matching corresponding accounting codes according to the contents of the debit form and the credit form, filling a BAPI inner table according to the contents of the header form, the debit form and the credit form, calling the BAPI to generate an accounting voucher, filling a result table with a newly generated accounting voucher number if the result table is successful, and filling result information into the result table if the result table is failed;
    step 6, returning result table information to the financial function sharing system, successfully returning accounting document numbers, and failing to return error reporting information;
    and 7, developing an interface information inquiry program for monitoring the interface information.
  2. 2. The SAP system interface of claim 1, wherein the method automatically generates accounting documents without accounting codes, comprises: ABAP language is adopted for development in SAP system.
  3. 3. The SAP system interface of claim 1, wherein the method automatically generates accounting documents without accounting codes, comprises: in the step 4, the user maintains the corresponding relation of the accounting codes, and the corresponding relation can be flexibly changed along with the change of the SAP system configuration; only a few users need to know the configuration rule, most users do not need to memorize a large amount of SAP accounting codes, the operation difficulty of the users is greatly reduced, and the error rate is effectively reduced.
  4. 4. The SAP system interface of claim 1, wherein the method automatically generates accounting documents without accounting codes, comprises: in the step 5, the logic of matching the corresponding relation is as follows, and the program respectively takes out corresponding accounting codes and special general ledger identifications from the corresponding relation table according to the uploading information of the debit table and the credit table and backfills the accounting codes and the special general ledger identification fields of the debit table and the credit table; the fetch logic is as follows: (1) taking a bookkeeping code and a special general ledger identification according to the accounting subject; (2) if no value is obtained in the step (1), the accounting code and the special general ledger identification are obtained according to the current 4 bits of the accounting department; (3) if no value is obtained in the step (2), adding a first bit of a customer code according to the accounting subjects to obtain an accounting code and a special general ledger identifier; (4) if no value is obtained in step (3), the accounting code and the special general ledger identification are obtained according to the accounting subjects and the first bit of the supplier code; (5) if no value is obtained in the step (4), the accounting code and the special general ledger identification are obtained according to the current 4-bit plus customer code of the accounting department; (6) if no value is obtained in the step (5), the accounting code and the special general ledger identification are obtained according to the current 4 bits of the accounting department plus the first bit of the supplier code; (7) and (6) if no value is obtained, returning error information by the program, and prompting the user to maintain the accounting code corresponding relation table.
CN202010157942.6A 2020-03-09 2020-03-09 Method for automatically generating accounting document without billing code by SAP system interface Active CN111381984B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010157942.6A CN111381984B (en) 2020-03-09 2020-03-09 Method for automatically generating accounting document without billing code by SAP system interface

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010157942.6A CN111381984B (en) 2020-03-09 2020-03-09 Method for automatically generating accounting document without billing code by SAP system interface

Publications (2)

Publication Number Publication Date
CN111381984A true CN111381984A (en) 2020-07-07
CN111381984B CN111381984B (en) 2023-04-21

Family

ID=71221459

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010157942.6A Active CN111381984B (en) 2020-03-09 2020-03-09 Method for automatically generating accounting document without billing code by SAP system interface

Country Status (1)

Country Link
CN (1) CN111381984B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111966764A (en) * 2020-08-20 2020-11-20 上海明华电力科技有限公司 Data processing system compatible with Oracle EBS and SAP system

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080004998A1 (en) * 2006-06-30 2008-01-03 Michael Conrad Systems and methods for generating an accounting document
CN108961028A (en) * 2018-07-05 2018-12-07 北京小马欢腾信息科技有限公司 Financial automated system and method based on a kind of operation flow by business economic
CN110097444A (en) * 2019-05-14 2019-08-06 京东方科技集团股份有限公司 A kind of flowing water code generating method and device
CN110163737A (en) * 2019-04-26 2019-08-23 北京用友政务软件股份有限公司 A kind of processing method and system of financial data
CN110570291A (en) * 2019-07-31 2019-12-13 苏宁云计算有限公司 Method and device for generating accounting document based on SAP system

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080004998A1 (en) * 2006-06-30 2008-01-03 Michael Conrad Systems and methods for generating an accounting document
CN108961028A (en) * 2018-07-05 2018-12-07 北京小马欢腾信息科技有限公司 Financial automated system and method based on a kind of operation flow by business economic
CN110163737A (en) * 2019-04-26 2019-08-23 北京用友政务软件股份有限公司 A kind of processing method and system of financial data
CN110097444A (en) * 2019-05-14 2019-08-06 京东方科技集团股份有限公司 A kind of flowing water code generating method and device
CN110570291A (en) * 2019-07-31 2019-12-13 苏宁云计算有限公司 Method and device for generating accounting document based on SAP system

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111966764A (en) * 2020-08-20 2020-11-20 上海明华电力科技有限公司 Data processing system compatible with Oracle EBS and SAP system

Also Published As

Publication number Publication date
CN111381984B (en) 2023-04-21

Similar Documents

Publication Publication Date Title
US6910021B2 (en) Financial management system including an offset payment process
CN111192004A (en) Method for displaying current to-do task and subsequent to-do workflow
CN111079397B (en) Task file generation method and device based on image recognition
CN101431580B (en) Voice service charging method and apparatus thereof
WO2019019447A1 (en) Annuity data processing method and device, server and storage medium
CN101727648A (en) Overtime control method in service system and service system
CN111275402B (en) Processing method, system, equipment and medium for rapidly storing same-industry operation assembly line
CN111381984A (en) Method for SAP system interface to automatically generate accounting voucher without accounting code
US20110161215A1 (en) Method and System for Tracking Billing Information
CN110866813A (en) Intelligent accounting system for managing accountants
CN108809669A (en) Group customer underpayment management method and system, group customer framework
CN115775188A (en) Asset financial integrated system
CN114971637A (en) Risk early warning method, device, equipment and medium
CN112488814A (en) Method, device, electronic equipment and medium for automatically generating accounting entry
CN112651730A (en) Transfer method and system of account transfer platform
CN111429125A (en) Account management method and device, storage medium and electronic equipment
US20110060668A1 (en) System and method for generating a combined statement
CN110751546A (en) Decentralized distributed node accounting method
Redman Data quality for telecommunications
CN114785625B (en) Method, device and system for processing bill charging
CN107169723A (en) A kind of enterprise staff management method
CN117764699A (en) Service processing method, device, electronic equipment and storage medium
CN113869875A (en) Dynamic business document generation method
CN117314659A (en) Management method of non-insurance documents
CN114092214A (en) Intelligent certificate making method based on expense reimbursement service

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
GR01 Patent grant