SAP Note 10868 - Line items: Add.account assgnmnts for G/L accounts.

Symptom

Program : RFEPOS00 FBL1 FBL2 FBL3 FBL4 FBL5 FBL6

Some additional account assignments in the G/L account (examples:
purchasing document, sales document) can exist in the line layout yet
no values are displayed although an entry has been made in the G/L
account item (BSEG). Furthermore, it is not possible to total or sort
by fields of this type.

Cause and prerequisites

The fields are missing in the secondary index (BSIS).
They can nevertheless be chosen for the line layout since they
exist in the secondary index for vendors (BSIK), for example.

Solution

Currently none (except an extension of BSIS which is not advisable).
The error has been corrected in Release 3.0 for the following fields: Asset number (ANLN1, ANLN2)
Purchasing document (EBELN, EBELP)
Routing number of operations (AUFPL)
Commitment item (FIPOS)
Network (NPLNR)
(The change involves a special variant being made automatically from the variant and the field being read from the BSEG.)
The error has been corrected in Release 3.0 for the VBELN and VBEL2 fields:
As an interim correction, you can add this to a 3.0 Release as follows: SE38 - SAPDFKA1, FIND EBELN

CASE LSTCL.
WHEN '2'.
DIFTAB-FDNAM = 'ANLN1'. DIFTAB-XSACH = 'X'. APPEND DIFTAB.
DIFTAB-FDNAM = 'ANLN2'. DIFTAB-XSACH = 'X'. APPEND DIFTAB.
DIFTAB-FDNAM = 'EBELN'. DIFTAB-XSACH = 'X'. APPEND DIFTAB.
DIFTAB-FDNAM = 'EBELP'. DIFTAB-XSACH = 'X'. APPEND DIFTAB.
DIFTAB-FDNAM = 'AUFPL'. DIFTAB-XSACH = 'X'. APPEND DIFTAB.
DIFTAB-FDNAM = 'FIPOS'. DIFTAB-XSACH = 'X'. APPEND DIFTAB.
DIFTAB-FDNAM = 'NPLNR'. DIFTAB-XSACH = 'X'. APPEND DIFTAB.
DIFTAB-FDNAM = 'VBEL2'. DIFTAB-XSACH = 'X'. APPEND DIFTAB. <-insert DIFTAB-FDNAM = 'VBELN'. DIFTAB-XSACH = 'X'. APPEND DIFTAB. <-insert ENDCASE. As of 2.2B, a note will be issued when maintaining the line layout variants if fields are used which do not also exist in the secondary index for all account types. It is recommended that you work with 2 variants rather than creating just one variant with the above fields for all account types at the same time: V1 for customer: with sales document (= standard variant) V2 for G/L account: with sales document ( = special variant) By using the following code, help is also available prior to Release 3.0: REPORT ZZTEST01. TABLES: T021, T021Z. SELECT * FROM T021 WHERE LSTCL = '2' AND VARNR = '...'. <-- line layout variant CHECK T021-FNAME = '.....' <-- 'EBELN', 'EBELP', ... OR T021-FNAME = '.....'. <-- 'ANLN1', 'ANLN2', ... T021-TNAME = 'BSEG'. MODIFY T021. WRITE: / 'T021 changed, rc = ', SY-SUBRC. ENDSELECT. SELECT SINGLE * FROM T021Z WHERE LSTCL = '2' AND VARNR = '....'.<-- line l. var. CHECK SY-SUBRC = 0. T021Z-XBSEG = 'X'. MODIFY T021Z. WRITE: / 'T021Z changed, rc = ', SY-SUBRC. To be able to total or sort by fields such as EBELN, you must proceed as follows for Release 2.2* (not for Release 2.1):

1. Carry out the following change in the L0F14I01 program

/NSE38, L0F14I01

FORM EXCTAB_FUELLEN_T021S.
.....
REFRESH EXCTAB.
CLEAR EXCTAB.
LOOP AT NAMETAB.
CHECK NAMETAB-FIELDNAME <> 'EBELN'
AND NAMETAB-FIELDNAME <> 'EBELP'
AND NAMETAB-FIELDNAME <> 'ANLN1'
AND NAMETAB-FIELDNAME <> 'ANLN2'.
EXCTAB-FIELDNAME = NAMETAB-FIELDNAME. APPEND EXCTAB.
ENDLOOP.
.....
ENDFORM.

2. Call up transaction SM30, Table/View: V_T021S "Maintain"
Add entries with table = BSEG and field = XXXX, where XXXX = EBELN, EBELP, ANLN1,...

Key word: Line items

Additional key words

Line item display
F4691 EBELN VBELN VBEL2