cancel
Showing results for 
Search instead for 
Did you mean: 

Lease-in contract periodic posting errors

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

0 Kudos

Thank u now i am going to try this...will get back to u if i got any issue.

0 Kudos
Dear Michael,

Kindly identify the type of <ls_item>


We declare <ls_item> as following:


FIELD-SYMBOLS <ls_item> type RERA_DOC_ITEM_EX.


But we get error  


The data object "<LS_ITEM>" does not have a component called "ORDERID".


Former Member
0 Kudos

No, its simply LIKE LINE OF ct_item.

0 Kudos

yes we are using the same but still getting the error . we got the input data from contract i.e cost center and order but we could not find where to fill in for accounting document.

Former Member
0 Kudos

Hmm in my SAP system (ERP 6.00 EHP 6) structure RERA_DOC_ITEM_EX does have field 'ORDERID' for the order number.

0 Kudos

we are using ERP ECC6.0 with  EHP 0 and we did not find cost center and order fields. Kindly suggest what to do now?

Former Member
0 Kudos

Hm Can you make screenshot of the RERA_DOC_ITEM_EX structure with all its fields?

It looks strange that they do not exist in your structure because we are using this badi for longer time and I do not think that it just was added in one of the EHPs.

0 Kudos

Kindly find 

h2. RERA_DOC_ITEM_EX

RE Document Item Transfer to External System

<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>

.INCLUDE

1

 

 

 

 

0

RE Document Item

MANDT

2

 

MANDT

MANDT

CLNT

3

Client

.INCLUDE

3

 

 

 

 

0

Key Fields of RE Line Items

.INCLUDE

4

 

 

 

 

0

Key Fields of RE Document Header

DOCGUID

5

 

RERADOCGUID

RECAGUID

RAW

16

GUID: Unique Internal Key for RE Document

ITEMNO

6

 

POSNR_ACC

POSNR_ACC

NUMC

10

Accounting Document Line Item Number

.INCLUDE

7

 

 

 

 

0

Contents of RE Line Items

REFITEMNO

8

 

RERAREFITEMNO

POSNR_ACC

NUMC

10

Reference to Other Item Number of Document

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>

0 Kudos

Dear Micheal,

Did u understand what i need? here is requirment once again plz consider..

Periodic posting + transfer ...for a lease-in contract...

where Expense GL is debited

and Vendor credited..

How CO will works here?  I want to update Cost center and order.

Former Member
0 Kudos

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

0 Kudos

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?

Former Member
0 Kudos

Which entries?

0 Kudos

sorry being late replies. Entries:

1. posting entry for Lease-in contract

2.Transfer entry for Lease-in contract

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.

0 Kudos

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..

Former Member
0 Kudos

As I can see, you can specify Cost Center or Order for Rental Object. On a Posting Parametrs tab in a category Postings it is possible to specify type of account assignment (e.g. Cost Center) and choose it from a list. Hope this will help.

0 Kudos

yes i did entered cost center.but something is missing in account/controlling. On periodic posting of the contract error is "Field Cost Ctr is a required field for G/L account XXX XXXXXX"

Former Member
0 Kudos

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

0 Kudos

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.

Former Member
0 Kudos

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.

0 Kudos

Condition type: V100 Credit side basic rent

Calculation>formula> Fixed amount

Distribution obj: RO :XXXX/10000000/1000001

formula :divided equally.

Former Member
0 Kudos

Ok and where do you know which cost center and which order belongs to which contract?

0 Kudos

thats what i need...i dont know where to define ...i didnt find the fields..

Former Member
0 Kudos

I think best way would be to add them in object tab of the contract (you maybe have to customize object type order and cost center in REFX customizing that it will be available) and then fill them with BADI when documents are generated in RERAPP.

Regards
Michael

0 Kudos

i have set configuration and now cost center and order are available in object. I tried and added as object but still could not post the document.  you told a badi for rerapp prog. hope this is the solution. can u elaborate how to and which badi.