SAP table ANEK (Document Header Asset Posting)

SAP table ANEK has 6 primary key fields being MANDT,BUKRS,ANLN1,ANLN2,GJAHR,LNRAN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
GJAHR Fiscal Year NUMC 4 0 GJAHR
LNRAN Sequence Number of Asset Line Items in Fiscal Year NUMC 5 0 LNRAN
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
MONAT Fiscal period NUMC 2 0 MONAT
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
AEDAT Date of the Last Document Change by Transaction DATS 8 0 AEDAT_BKPF
UPDDT Date of the Last Document Update DATS 8 0 UPDDT
USNAM User Name CHAR 12 0 USNAM
TCODE Transaction Code CHAR 20 0 TSTC TCODE
BVORG Number of Cross-Company Code Posting Transaction CHAR 16 0 BVORG
XBLNR Reference Document Number CHAR 16 0 XBLNR1
STBLG Reverse Document Number CHAR 10 0 STBLG
STJAH Fiscal Year of Reversal Document NUMC 4 0 STJAH
SGTXT Item Text CHAR 50 0 SGTXT
MENGE Quantity QUAN 13 3 MENGE_D
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
ANLU1 Main Asset No. for Target/Sending Asset in Transfer Posting CHAR 12 0 ANLH ANLU1
ANLU2 Asset Subno. for Target/Sending Asset in Transfer Posting CHAR 4 0 ANLA ANLU2
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
GLVOR Business Transaction CHAR 4 0 GLVOR
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
PARGB Trading partner's business area CHAR 4 0 TGSB PARGB
BUREG Distribution Rule Group NUMC 3 0 BUREG
AUGLZ Unused Field Length 3 CHAR 3 0 FILL03
ABRBUP Posting period of settlement NUMC 2 0 ABRBUP
OBART Object type of forwarding object at settlement CHAR 2 0 A_OBART
OBJID Forwarding object nr. CHAR 20 0 A_OBJID
ZUONR Assignment number CHAR 18 0 DZUONR
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
MATNR Material Number CHAR 40 0 MARA MATNR
AUGLN Reserve Field CHAR 5 0 RSERV
BELNR Reference document number CHAR 10 0 AWREF
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BZDAT Asset Value Date DATS 8 0 BZDAT
XANTEI Ind: Post Proportional Values Automatically NUMC 1 0 XANTEI
AWTYP Reference procedure CHAR 5 0 AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
AWSYS Logical System CHAR 10 0 TBDLS LOGSYSTEM
PBUKR Partner Company Code CHAR 4 0 PBUKR
VORGN Transaction Type for General Ledger CHAR 4 0 VORGN
LDGRP Ledger Group CHAR 4 0 FAGL_LDGRP
DOCUMENT_UUID 16 Byte UUID in 16 Bytes (Raw Format) RAW 16 0 SYSUUID_X16
TRANSACTION_UUID 16 Byte UUID in 16 Bytes (Raw Format) RAW 16 0 SYSUUID_X16

ANEK foreign key relationships

Table Field Check Table Check Field
0 ANEK ANLN1 ANLH Main asset number BUKRS
0 ANEK ANLN1 ANLH Main asset number ANLN1
1 ANEK ANLN2 ANLA Asset Master Record Segment BUKRS
1 ANEK ANLN2 ANLA Asset Master Record Segment ANLN1
1 ANEK ANLN2 ANLA Asset Master Record Segment ANLN2
0 ANEK ANLU1 ANLH Main asset number BUKRS
0 ANEK ANLU1 ANLH Main asset number ANLN1
1 ANEK ANLU2 ANLA Asset Master Record Segment BUKRS
1 ANEK ANLU2 ANLA Asset Master Record Segment ANLN1
1 ANEK ANLU2 ANLA Asset Master Record Segment ANLN2
0 ANEK AWSYS TBDLS Logical system LOGSYS
1 ANEK BUKRS T001 Company Codes BUKRS
0 ANEK EBELN EKKO Purchasing Document Header MANDT
0 ANEK EBELN EKKO Purchasing Document Header EBELN
1 ANEK EBELP EKPO Purchasing Document Item MANDT
1 ANEK EBELP EKPO Purchasing Document Item EBELN
0 ANEK MANDT T000 Clients MANDT
1 ANEK MATNR MARA General Material Data MANDT
1 ANEK MATNR MARA General Material Data MATNR
0 ANEK MEINS T006 Units of Measurement MANDT
1 ANEK MWSKZ T007A Tax Keys KALSM
1 ANEK MWSKZ T007A Tax Keys MWSKZ
0 ANEK PARGB TGSB Business Areas MANDT
0 ANEK PARGB TGSB Business Areas GSBER
1 ANEK TCODE TSTC SAP Transaction Codes TCODE
0 ANEK VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 ANEK VBUND T880 Global Company Data (for KONS Ledger) RCOMP