SAP中创建分部机构凭证号码并且按年度编号
這是SAP提供的官方解決方案,盡管是針對意大利的,但是其要求和用法同中國一樣的。
?746162 - Using official document numbering for Italy
Document numbers in Italy should be restarted with each new calendar year, while the number range for the FI document allocates the numbers based on the fiscal year of the document. This causes a problem in case the company uses shifted fiscal year.
?
Other Terms
ODN
?
Reason and Prerequisites
This is an Italian-specific requirement
?
Solution
Using the official document numbering functionality, you can allocate an additional document number to each created FI document or billing document with an own, calendar year dependent number range.
The functionality is designed such that the official document number maybe used for official legal reporting by selection via the logical data base used for the reports. However, the official document number functionality has not been designed to replace the standard accounting document number BKPF-BELNR in daily operations (e.g. creating accounting documents, electronic bank statement transfer,??DME etc.) and no additional functionality shall be offered to this effect.
In the case of billing documents the official document number is stored in field XBLNR (in table VBRK). When you create the accounting document for the billing document, the official document number is copied to field XBLNR_ALT in table BKPF (Alternative Reference Number). For documents created in the logistics invoice verification or in FI, the value is only stored in field XBLNR_ALT (table BKPF).
The solution represented below enables the creation of these additional document numbers.
The solution is delivered in the indicated support packages. Note that you need to perform some manual activities (as described further below):
Create a new index for BKPF (see 4.b)
Enhance the logical data base BRF (see 11)
Customizing settings (see 12)
You can also implement the attached correction instructions. In this case you need to do manual activities as follows:
??????????????Package / Development class: FIN1
??????????????Short description: Character field with length of 16 for Official Document Numb
??????????????Data type Char, Length 16, output length 16,
??????????????Conversion routine ODNIT
2. Create a new Domain XBLNR_ALT??????????????Package / Development class: FIN1
??????????????Short description: Alternative Reference Number
??????????????Data type Char, Length 26, output length 26
??????????????Conversion routine ODNIT
3. Create a new Data Element XBLNR_ALT??????????????Package / Development class: FIN1
??????????????Short description: Alternative Reference Number
??????????????Domain to be used: XBLNR_ALT
??????????????Field label (10, 15,20, 16): Reference
4. Enhance table BKPF a) Add a new field to table BKPF in last position???????????????????????Field: XBLNR_ALT, Data element: XBLNR_ALT
b) Create a new index???????????????????????Include fields MANDT, BUKRS, XBLNR_ALT in this new, non-unique index.
???????????????????????Note: this new index will not be delivered by SAP.
5. Change table DOCCLSS??????????????Change of foreign key of field LAND1: Change the cardinality from 1:CN to 1:C and the foreign key field type from 'not specified' to 'Key fields/candidates'
6. Create table OFNUM_IT_1??????????????Package / Development class: FIN1
??????????????Short Descript: Official Numbering by Document Class-enabled ranges(IT)
??????????????Create a new table with following fields:
??????????????Field???Key??In. Value??DataElement???Check table
??????????????MANDT??????X???????X?????MANDT
??????????????BUKRS??????X??????X?????BUKRS??????????T001
??????????????DOCCLASS??X??????X?????DOCCLS?????????DOCCLSS
??????????????GROUPNUMBER??X????X?????NRNR???????????NRIV
??????????????LASTDATE?????????????????J_1ADATETO
??????????????For the foreign key for NRNR you need the following settings
??????????????CheckTable ChkTableFld ForKeytable??For.KeyField??Generic??const
??????????????NRIV????????CLIENT???????OFNUM_IT_1???MANDT
??????????????NRIV????????OBJECT????????????????????????????????????????'FIN2_IT'
??????????????NRIV????????SUBOBJECT??????????????????????????????????X
??????????????NRIV????????NRRANGENR????OFNUM_IT_1???GROUPNUMBER
??????????????NRIV????????TOYEAR??????????????????????????????????????X
??????????????
??????????????Delivery class: C
??????????????Data Browser/Table View Maint. : Display/Maintenance Allowed
??????????????Data Class: APPL2
??????????????Size Category: 0
??????????????Buffering switched on
??????????????Fully buffered
7. Create new Maintenance-View V_OFFNUM_IT??????????????Package / Development class: FIN1
??????????????Short Description: Assign Number Ranges to Document Types - Italy
??????????????Tables: OFNUM_IT_1, T001, T005, DOCCLSS
??????????????View field??Table????????Field??????P (Maintenance Attribute)
??????????????MANDT???????OFNUM_IT_1???MANDT
??????????????BUKRS???????OFNUM_IT_1???BUKRS???????S
??????????????DOCCLASS????OFNUM_IT_1???DOCCLASS
??????????????GROUPNUMBER OFNUM_IT_1???GROUPNUMBER
??????????????DOCCLS??????DOCCLSS??????DOCCLS??????H
??????????????LASTDATE????OFNUM_IT_1???LASTDATE
??????????????Once you have created the view go to menu option Utilities and run the Table Maintenance Generator. Create the Maintenance Dialog with following settings:
??????????????Authorization Group:??&NC&
??????????????Function Group:???????FIN3
??????????????Package:??????????????FIN1
??????????????Maintenance type:?????one step
??????????????Maintenance screen No: 30
1. Create new Number Range Object (FIN2_IT)??????????????With transaction SNRO you create the new number range object
??????????????Short text: Official Number
??????????????Long text:??Number Range for Official Document Number Italy
??????????????Subobject data element: BUKRS
??????????????To-year Flag:??X
??????????????Number length domain: ODN16
??????????????Number range transaction
a) For release 47 and ERP2004:??FGSODN_IT1 b) For release 40B, 45B, 46B, 46C FGSODN_IT2??????????????Warning %: 0,1
??????????????Main memory buffering: x
??????????????No. of numbers in buffer: 0
2. Create new function modules??????????????Create four new function modules, change existing function module
??????????????OFF_NUMBER_LOCAL_NUMBERING_IT and OFF_NUMBER_LOCAL_ASSIGN_IT, CONVERSION_EXIT_ODNIT_INPUT, CONVERSION_EXIT_ODNIT_OUTPUT in function group FIN2, original language German
a) OFF_NUMBER_LOCAL_NUMBERING_IT???????????????????????Import Parameters:??????????????????????optional??Pass value
?????????????????????????I_FIN1_PARAM_EX LIKE FIN1_PARAM_EX???????????????????X
?????????????????????????I_BKPF LIKE BKPF??????????????????????????X
?????????????????????????I_VBRK LIKE VBRKVB????????????????????????X
???????????????????????Export Parameters:??????????????????????Pass value
?????????????????????????O_XBLNR?????LIKE FIN1_PARAM_EX-XBLNR??????X
?????????????????????????O_XBLNR_ALT TYPE XBLNR_ALT????????????????X
???????????????????????Exceptions:
?????????????????????????INPUT_INCOMPLETE
?????????????????????????NUMBER_NOT_VALID
b) OFF_NUMBER_LOCAL_ASSIGN_IT?????????????????????????I_BUKRS?????TYPE??OFNUM_IT_1-BUKRS
?????????????????????????I_DOCCLASS??TYPE??OFNUM_IT_1-DOCCLASS
?????????????????????????I_POSTDATE??TYPE??BUDAT
?????????????????????????I_OFFNREL???TYPE??J_1AOFFNREL
???????????????????????Export Parameters:
?????????????????????????O_XBLNR?????TYPE XBLNR
?????????????????????????O_XBLNR_ALT TYPE XBLNR_ALT
???????????????????????Exceptions:
?????????????????????????INPUT_NOT_COMPLETE
?????????????????????????NO_NUMBER_AVAILABLE
c) CONVERSION_EXIT_ODNIT_INPUT???????????????????????Import Parameters:
?????????????????????????INPUT
???????????????????????Export Parameters:
?????????????????????????OUTPUT
???????????????????????Exceptions:
?????????????????????????WRONG_INPUT
d) CONVERSION_EXIT_ODNIT_OUTPUT???????????????????????Import Parameters:
?????????????????????????INPUT
???????????????????????Export Parameters:
?????????????????????????OUTPUT
e) OFF_NUMBER_GLOBAL_NUMBERING???????????????????????New Export Parameter:
??????????????????????????O_XBLNR_ALT TYPE XBLNR_ALT, mark pass value
3. Screens??????????????For document display the following screens need to be enhanced:
??????????????SAPLF064, screen 1710 (only for releases 46B, 46C, 47, ERP2004)
??????????????SAPMF05L, screen 1710
??????????????Add field BKPF-XBLNR_ALT.
a) For releases 40B, 45B, 46B, 46C add it underneath field Branch Number (BKPF-BRNCH) b) For releases 47 and ERP2004 add it underneath field Request Number (BKPF-LOTKZ).??????????????For this you need to move all following fields one line further down. Define the field as output field and mark the display as invisible. The assosiated program makes the field visible for Italian company codes.
4. Enhance logical Data Base BRF??????????????In order to have the new field XBLNR_ALT available in the dynamic selections for document display (FB02, FB03) and of some tax reports (e.g. RFUMSV00) you need to enhance the logical data base using BKPF.
??????????????In transaction SE36 select logical data base BRF and go to Menu - Extras - Selection Views
??????????????Make a copy of the SAP standard selection view and select CUS as origin for the target view
??????????????Enter the target view in the change mode. Double click on table BKPF, all fields of this table are now displayed. You make the field XBLNR_ALT available by selecting it with 01 in the first column.
5. Customizing settings??????????????A new number range for the official document number is defined per document class. You can assign more than one document type of an financial accounting document to the same document class. This allows you that documents with different document types share the same document class and therefore the same number range (e.g. you set up one document class for invoices and one document class for credit memos).
??????????????
??????????????In order to have a new official document number generated you need to make the following customizing settings:
a) Maintain Document Classes using view V_DOCCLS b) Assign Document Class to Document Type using view V_T003_B_I.???????????????????????Here you assign the document class to the document types. In field Official Doc. Number select 'B Generate Official Document Number, with date control'
???????????????????????Choose 'Force Numbering' if you want to force the generation of an official document number for billing documents even when the billing document value is zero
???????????????????????Note: If you generate the official document number for SD billing documents, it is necessary that all documents are released daily and transferred to FI, in order to ensure chronological numbering
c) Maintain Number Ranges using transaction???????????????????????FGSODN_IT1: For release 47 and ERP2004:
???????????????????????FGSODN_IT2: For release 40B, 45B, 46B, 46C
d) Assign Number Ranges to document class using view V_OFFNUM_IT??????????????You can maintain the mentioned views by using transaction SM30.
e) Assign document type to billing type??????????????If you create official document numbers also for billing documents, you need to make sure, that a document type is assigned to the billing type in view V_TVFK.
Upgrade
During a later upgrade, make sure that you include the relevant support package level of the new release into the upgrade procedure to avoid a possible loss of data.
- 4.6C: SP50
- 4.70 Enterprise: SP24
- ERP 2004: SP07
If this is not possible, you have to manually create data element and domain XBLNR_ALT as described above before activating table BKPF
?
對于分支機構(gòu)的編號,需要激活business place 功能,這個功能默認只支持意大利,臺灣,智利,阿根廷等地區(qū),如果要支持中國需要設(shè)置。然后可以把編號組分配給business place. 中國使用offical doucment number 功能需要ECC6版本并且激活BADI組件。
In China, accounting documents and journal entries must be assigned an official document
number. Furthermore, for accounting documents that have to be submitted to the auditors or to
the tax authorities, you must start the official document numbering from the first day of every
month — which requires document number ranges to be linked to the fiscal year and period. The
SAP system provides functions to number documents according to these requirements.
The system assigns an official document number only to posted documents. No official
document number is assigned to parked documents.
When you print accounting documents, the system includes the official document
number.
Official document number is assigned to all financial documents regardless of the component
from which those documents originate. For example, the system assigns ODN also for financial
documents transferred from Materials Management (MM) and Sales and Distribution (SD).
However, it is not required to generate ODN for clearing accounting documents without line items.
Maintain the relevant settings in Customizing for Cross-Application Components, under
General Application Functions Cross-Application Document Numbering China Automatic
Document Numbering Maintain Settings for Clearing Documents w/o Line Items .
Prerequisites
You have made the required settings in Customizing for Cross-Application Components, under
General Application Functions Cross-Application Document Numbering China .
Features
When you create an accounting document or a journal entry, the system generates an official
document number and stores it in the Alternative Reference Number (XBLNR_ALT) field.
Depending on your Customizing settings, the system enables you to maintain year-dependent
and period-dependent number ranges for the official document for a company code.
For all documents, the official document number comprises of the following five parts:
總結(jié)
以上是生活随笔為你收集整理的SAP中创建分部机构凭证号码并且按年度编号的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 物料帐结算,库存差异为何在下月初冲回
- 下一篇: ALV OO的栏位属性