on 09-17-2014 1:53 PM
Dear All,
I have created a commercial lease in contract, with an object building and after all inputs when i execute periodic posting there are errors of FI CO anf FM.
If i enter expense GL..error is cost center is mandatory for GL...While i hae no input field fo cost centre
if i enter prepaid rent GL....error is fund centre not entered/ derived..
Kindly let me know configuration settings. Also i want simple entry
Debit....rent exp
cr. ..vendors payable
or any other entry for accrued rent.
plz guide.
BR
Asif Shahzad
Yes the adding is only the groundwork. The rest happens in BADI. You have to implement BADI BADI_RE_RA_CA. In Method 'BEFORE_POST' you got your table CT_ITEM with all positions of the document that has to be posted. There you have to fill for every GL position the order and cost center from your contract. You can get them with function 'API_RE_CN_GET_DETAIL'.
E.g. like:
LOOP AT ct_item ASSIGNING <ls_item>
WHERE objnr(2) EQ 'IM'
AND acctype EQ 'S'.
CALL FUNCTION 'API_RE_CN_GET_DETAIL'
EXPORTING
id_objnr = <ls_item>-partnerobjnr
IMPORTING
et_object_rel = lt_object_rel
EXCEPTIONS
error = 1
OTHERS = 2.
LOOP AT lt_object_rel INTO ls_object_rel
WHERE objtypecn = 'OR'
OR objtypecn = 'KS'.
IF ls_object_rel-objtypecn = 'OR'.
CALL FUNCTION 'CONVERSION_EXIT_AUFNR_INPUT'
EXPORTING
input = ls_object_rel-objidcn
IMPORTING
output = <ls_item>-orderid.
ELSEIF ls_object_rel-objtypecn = 'KS'.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
input = ls_object_rel-objnrcn+12(10)
IMPORTING
output = <ls_item>-costcenter.
ENDIF.
ENDLOOP.
ENDLOOP.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kindly find
h2. RERA_DOC_ITEM_EX
<span style="color: yellow;">Row</span>
<span style="color: yellow;">Field name</span>
<span style="color: yellow;">Position</span>
<span style="color: yellow;">Key</span>
<span style="color: yellow;">Data element</span>
<span style="color: yellow;">Domain</span>
<span style="color: yellow;">Datatype</span>
<span style="color: yellow;">Length</span>
<span style="color: yellow;">Domain text</span>
1 | .INCLUDE | 1 |
|
|
|
| 0 | RE Document Item |
2 | MANDT | 2 |
| MANDT | MANDT | CLNT | 3 | Client |
3 | .INCLUDE | 3 |
|
|
|
| 0 | Key Fields of RE Line Items |
4 | .INCLUDE | 4 |
|
|
|
| 0 | Key Fields of RE Document Header |
5 | DOCGUID | 5 |
| RERADOCGUID | RECAGUID | RAW | 16 | GUID: Unique Internal Key for RE Document |
6 | ITEMNO | 6 |
| POSNR_ACC | POSNR_ACC | NUMC | 10 | Accounting Document Line Item Number |
7 | .INCLUDE | 7 |
|
|
|
| 0 | Contents of RE Line Items |
8 | REFITEMNO | 8 |
| RERAREFITEMNO | POSNR_ACC | NUMC | 10 | Reference to Other Item Number of Document |
9 | BUKRS | 9 |
| BUKRS | BUKRS | CHAR | 4 | Company Code |
10 | ITEMTYPE | 10 |
| RERAITEMTYPE | CHAR02 | CHAR | 2 | Item Category |
11 | REFDATE | 11 |
| DABRBEZ | DDAT | DATS | 8 | Reference Date for Settlement |
12 | PROCESS | 12 |
| RECAPROCESS | RECAPROCESS | CHAR | 4 | Process |
13 | PROCESSGUID | 13 |
| RECAPROCESSGUID | RECAGUID | RAW | 16 | Generic Key of Process |
14 | .INCLUDE | 14 |
|
|
|
| 0 | RE Document Item Status Fields |
15 | CLEARINGSTATUS | 15 |
| RERACLEARINGSTATUS | CHAR02 | CHAR | 2 | Clearing status |
16 | CLEARNGPROCESSID | 16 |
| RECAPROCESSID | RECAPROCESSID | CHAR | 16 | Process Identification -> Accounting Reference Number |
17 | PAYEDSTATUS | 17 |
| RERAPAYEDSTATUS | CHAR02 | CHAR | 2 | Payment Status |
18 | DUNNINGSTATUS | 18 |
| RERADUNNINGSTATUS | CHAR02 | CHAR | 2 | Dunning Status |
19 | .INCLUDE | 19 |
|
|
|
| 0 | RE Posting Rules |
20 | REFGUIDORIGIN | 20 |
| RERAGUIDORIGIN | CHAR04 | CHAR | 4 | Source of GUID |
21 | REFGUID | 21 |
| RERAREFGUID | RECAGUID | RAW | 16 | Reference GUID |
22 | OBJNR | 22 |
| RERAOBJNR | J_OBJNR | CHAR | 22 | Account Assignment: Object Number |
23 | PFROM | 23 |
| DBERVON | DATUM | DATS | 8 | Start of Calculation Period |
24 | PTO | 24 |
| DBERBIS | DATUM | DATS | 8 | End of Calculation Period |
25 | BLINEDATE | 25 |
| DZFBDT | DATUM | DATS | 8 | Baseline Date for Due Date Calculation |
26 | ORIGDUEDATE | 26 |
| RECDORIGDUEDATE | DATUM | DATS | 8 | Original Due Date |
27 | CONDTYPE | 27 |
| RECDCONDTYPE | RECDCONDTYPE | CHAR | 4 | Condition Type |
28 | ISADVANCEPAYMENT | 28 |
| RECDADVANCEPAYMENT | RECABOOL | CHAR | 1 | Condition Is Advance Payment Condition |
29 | FLOWTYPE | 29 |
| RECDFLOWTYPE | RECDFLOWTYPE | CHAR | 4 | Flow Type |
30 | DCINDICATOR | 30 |
| RERADCINDICATOR | RERADCINDICATOR | CHAR | 1 | Debit/Credit Indicator |
31 | TAXGROUPID | 31 |
| RERATAXGROUPID | NUM03 | NUMC | 3 | Group Indicator for Tax Line Items |
32 | TAXDATE | 32 |
| RERATAXDATE | RECADATE | DATS | 8 | Date of Tax Calculation |
33 | TERMNOOA | 33 |
| RETMTERMNO | RETMTERMNO | CHAR | 4 | Term Number |
34 | .INCLUDE | 34 |
|
|
|
| 0 | Table Fields for Term Organizational Assignment |
35 | GSBER | 35 |
| GSBER | GSBER | CHAR | 4 | Business Area |
36 | PRCTR | 36 |
| PRCTR | PRCTR | CHAR | 10 | Profit Center |
37 | ADDOBJNR | 37 |
| RERAADDOBJNR | J_OBJNR | CHAR | 22 | Object Number for Additional Account Assignment |
38 | .INCLUDE | 38 |
|
|
|
| 0 | Table Fields: Funds Management Account Assignments |
39 | .INCLUDE | 39 |
|
|
|
| 0 | Account Assignment Fields - Funds Management |
40 | FUND | 40 |
| RERAFUND | CHAR24 | CHAR | 24 | Fund |
41 | FUNDSCENTER | 41 |
| RERAFUNDSCENTER | CHAR24 | CHAR | 24 | Funds Center |
42 | COMMITMENTITEM | 42 |
| RERACOMMITMENTITEM | FM_FIPEX | CHAR | 24 | Commitment Item |
43 | FUNCTIONALAREA | 43 |
| RERAFUNCTIONALAREA | CHAR24 | CHAR | 24 | Functional Area |
44 | GRANTNUMBER | 44 |
| RERAGRANTNUMBER | CHAR24 | CHAR | 24 | Grant |
45 | MEASURE | 45 |
| RERAMEASURE | CHAR24 | CHAR | 24 | Program in Funds Management |
46 | TERMNOPY | 46 |
| RETMTERMNO | RETMTERMNO | CHAR | 4 | Term Number |
47 | .INCLUDE | 47 |
|
|
|
| 0 | Table Fields for Posting Rule |
48 | PYMTMETH | 48 |
| RERAPYMTMETH | CHAR4 | CHAR | 4 | Payment Method |
49 | PYMTMETHCRMO | 49 |
| RERAPYMTMETHCRMO | CHAR4 | CHAR | 4 | Payment Method for Credit Memos |
50 | PYMTBLOCK | 50 |
| RERAPYMTBLOCK | CHAR4 | CHAR | 4 | Payment block key |
51 | PYMTTERM | 51 |
| RERAPYMTTERM | ZTERM | CHAR | 4 | Terms of Payment Key |
52 | HOUSEBKID | 52 |
| RERAHOUSEBKID | CHAR15 | CHAR | 15 | Key for House Bank |
53 | HOUSEBKACC | 53 |
| RERAHOUSEBKACC | CHAR15 | CHAR | 15 | Key for House Bank Account |
54 | BANKDETAILID | 54 |
| RERABANKDETAILID | CHAR15 | CHAR | 15 | Bank Details ID |
55 | NOTETOPAYEE | 55 |
| RERANOTETOPAYEE | RERANOTETOPAYEE | CHAR | 25 | Note to Payee |
56 | DUNNAREA | 56 |
| RERADUNNAREA | CHAR4 | CHAR | 4 | Dunning Area |
57 | DUNNKEY | 57 |
| RERADUNNKEY | CHAR4 | CHAR | 4 | Dunning Keys |
58 | DUNNBLOCK | 58 |
| RERADUNNBLOCK | CHAR4 | CHAR | 4 | Dunning Block |
59 | ACCDETKEY | 59 |
| RERAACCDETKEY | RERAACCDETKEY | CHAR | 10 | Account Determination Value |
60 | TAXTYPE | 60 |
| RERATAXTYPE | RERATAXTYPE | CHAR | 4 | Tax Type |
61 | TAXGROUP | 61 |
| RERATAXGROUP | RERATAXGROUP | CHAR | 20 | Tax Group |
62 | ISGROSS | 62 |
| RECDISGROSS | RECABOOL | CHAR | 1 | Condition Amount Is Gross Amount |
63 | PARTNER | 63 |
| BU_PARTNER | BU_PARTNER | CHAR | 10 | Business Partner Number |
64 | PARTNEROBJNR | 64 |
| RETMPARTNEROBJNR | J_OBJNR | CHAR | 22 | Object Number for Internal Use |
65 | TXJCD | 65 |
| TXJCD | TXJCD | CHAR | 15 | Tax Jurisdiction |
66 | TERMNOWT | 66 |
| RETMTERMNO | RETMTERMNO | CHAR | 4 | Term Number |
67 | .INCLUDE | 67 |
|
|
|
| 0 | RE Posting Record Account |
68 | ACCTYPE | 68 |
| RERAACCTYPE | RERAACCTYPE | CHAR | 1 | Account Type |
69 | GLACCSYMB | 69 |
| RERAGLACCSYMB | RERAGLACCSYMB | CHAR | 15 | Account Determination: Account Symbols |
70 | GLACCOUNT | 70 |
| RERAGLACCOUNT | RERAGLACCOUNT | CHAR | 10 | General Ledger Account |
71 | .INCLUDE | 71 |
|
|
|
| 0 | RE Currency Structure |
72 | .INCLUDE | 72 |
|
|
|
| 0 | RE Currency Structure |
73 | AMOUNT | 73 |
| RERAAMOUNT | RECACURR | CURR | 15 | Amount |
74 | GROSSAMOUNT | 74 |
| RERAGROSSAMOUNT | RECACURR | CURR | 15 | Gross Amount |
75 | NETAMOUNT | 75 |
| RERANETAMOUNT | RECACURR | CURR | 15 | Net Amount |
76 | TAXAMOUNT | 76 |
| RERATAXAMOUNT | RECACURR | CURR | 15 | Tax Amount |
77 | CURRENCY | 77 |
| WAERS | WAERS | CUKY | 5 | Currency Key |
78 | TAXRATE | 78 |
| RERATAXRATE | PRZ43V | DEC | 7 | Tax Rate |
79 | ITEMTXT | 79 |
| SGTXT | TEXT50 | CHAR | 50 | Item Text |
80 | VENDOR | 80 |
| RERAVENDORNO | RERAPARTNERNO | CHAR | 10 | Vendor number |
81 | CUSTOMER | 81 |
| RERACUSTOMERNO | RERAPARTNERNO | CHAR | 10 | Customer Number |
82 | VALUEDATE | 82 |
| RERAVALUEDATE | RECADATE | DATS | 8 | Value Date |
83 | ALLOCATIONNUMBER | 83 |
| RERAALLOCATIONNUMBER |
| CHAR | 18 | Assignment Number |
84 | ISFLATRATE | 84 |
| RECDFLATRATE | RECABOOL | CHAR | 1 | Condition Is a Flat Rate Condition |
85 | HASMANUALTAX | 85 |
| RERAHASMANUALTAX | RECABOOL | CHAR | 1 | Manual Entry of Tax? |
86 | TXJCD_DEEP | 86 |
| TXJCD | TXJCD | CHAR | 15 | Tax Jurisdiction |
87 | TXJLV | 87 |
| TXJCD_LEVEL | CHAR1 | CHAR | 1 | Tax jurisdiction code level |
88 | EXTREF1 | 88 |
| RERAEXTREF1 |
| CHAR | 60 | External Reference 1 (Line Item) |
89 | EXTREF2 | 89 |
| RERAEXTREF2 |
| CHAR | 60 | External Reference 2 (Line Item) |
90 | EXTREF3 | 90 |
| RERAEXTREF3 |
| CHAR | 60 | External Reference 3 (Line Item) |
91 | QUANTITY | 91 |
| MENGE_D | MENG13 | QUAN | 13 | Quantity |
92 | BASE_UOM | 92 |
| MEINS | MEINS | UNIT | 3 | Base Unit of Measure |
93 | AMTRANSTYPE | 93 |
| REITAMTRANSTYPE | BWASL | CHAR | 3 | Transaction Type of Asset Postings |
94 | PARTNER_PRCTR | 94 |
| RERAPARTNERPRCTR | PRCTR | CHAR | 10 | Partner Profit Center |
95 | PAROBJNR | 95 |
| RERAPARTNEROBJNR | J_OBJNR | CHAR | 22 | Partner Object |
96 | GENDATA | 96 |
|
|
| CHAR | 60 | General Data for Use in BAdI |
97 | ZEROTAX | 97 |
| RECABOOL | RECABOOL | CHAR | 1 | General Yes/No Field |
<br mozdirty="" type="_moz"></p>
Yes I understand but I canot tell you another solution than BADI.
As I said normally RE-FX does not use cost center and order for posting documents. You can switch the distribution object in your contracts conditions to cost center but that will only do half the work because the original post will still get to contract without cost center.
But it is not SAP default to post any document to cost center. It looks like in your field status for this account no. the cost center is defined as obligatory field. So you have to talk to your Financial Experts why it is done like that. If it is not necessary it can be changed in the field status group.
Regards
Michael
Dear Micheal,
Thank you, yes Field status is set as cost center is mandatory field.Our Finance department requires it ,as Cost center derives Fund center and Order derives Fund.
Here what we did:
To derive Fund center i made an assignment rule from profit center.
To derive Fund we define a function module which derives order from CO settlement rule and derives the fund.
But can u please explain me the entries. why posting is separate to transfer?
It is the posting logic of RE-FX.
First posting is:
Vendor TO Credit Rent Account [CO object is contract]
Tax Account
Second posting is
Credit Rent Account TO Credit Rent Account
[CO: contract] [CO: distribution object of condition]
The second posting normally does not have any effect on Finance Accounts, because it is just + - posting which result is 0. It is only for controlling, because the CO object contract will get to 0 in balance, the cost will get transfered to the distribution object, which normally is rental object.
After that you can use some RE-FX controlling (there are special information systems for it) for managing the costs to see which rental object got which cost.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Asif,
Have you specified Organisational Assignment in your contract? On a Posting Parametrs tab of a contract there is a special category called Organizational Assignment, where you can specify required details for your posting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hello yury,
in this tab org assignment only availble is
Business Area
Profit Center
Funds Center
Commitment Item
whereas no Cost center and order. Basically in configuration of >Integration FI-GL, FI-AR, FI-AP>Account Determination>Replace Account Symbols
i have entered an expense GL "Rent Expense" and this GL requires cost center and order. and at the same time B/s GL Prepaid rent requires Fund centre (error no fund centre enterd/derived)
Kindly help..
Can you please double click the error message and have a look at the message number then?
It looks like it is some customized message in your SAP system.
SAP RE-FX normally does not post to cost center, but to rental object which is also CO object. If you want to use cost center, you have to set distribution object for conditions to cost center or you have to use BADI.
Regards
Michael
Dear Michael,
SAP error message is Message no. F5808
The value for field "Cost Ctr" in the interface to Financial Accounting is an initial value but you are required to make an entry in the field selection for G/L account "xxxxxx" in company code "xxxx" linked to the field selection for posting key "40".
Kindly re consider below:
I need a lease-in accounting where our company pay rent to vendor. for that i did:
create an object building
create a commercial lease-in contract
fill all the required entries.
Maintain GL for replace account symbols
In my view entry should be:
Rent expense GL XXXXXX with Cost centre XXXX with order XXXX >>>>>Debit amount
vendor A/c GL XXXXXX>>>>>>> Amount Credit
Now periodic processing.
error is as above mentioned.
What does your conditions in the contract look like? Which calculation and distribution objects did you use there?
When you want to use cost center and order, you will have to use 'BADI_RE_RA_CA' because SAP standard only can post the whole amount (without splitting the amount) to one CO object.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.