SAP /PF1/DB_ITEM_FI table - FI Data details in SAP

SAP /PF1/DB_ITEM_FI table summary

Object Name: /PF1/DB_ITEM_FI
Dictionary Type: Transparent table
Description: FI Data

Field list for /PF1/DB_ITEM_FI table on an S/4 SAP system

Details

/PF1/DB_ITEM_FI-CLIENT table field - Client ▼

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

/PF1/DB_ITEM_FI-CLEARING_AREA table field - Clearing Area ▼

Description: Clearing Area
Field Name: CLEARING_AREA
Data Element: /PF1/DTE_BPE_CLEARING_AREA
Data Type: CHAR
length (Dec): 6(0)
Check table: /PF1/T_CLAREA
Conversion Routine:
Domain Name: /PF1/DOM_BPE_CLEARING_AREA
MemoryID: /PF1/P_CLEARING_AREA
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLEARING_AREA

/PF1/DB_ITEM_FI-PI_DATE table field - Payment Item Date ▼

Description: Payment Item Date
Field Name: PI_DATE
Data Element: /PF1/DTE_PO_PI_KEY_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: /PF1/DOM_BPE_REFERENCE_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PI_DATE

/PF1/DB_ITEM_FI-PI_NO table field - Payment Item Number From Number Range ▼

Description: Payment Item Number From Number Range
Field Name: PI_NO
Data Element: /PF1/DTE_PO_PI_SECONDARY_KEY
Data Type: NUMC
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: /PF1/DOM_PO_PO_ID
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PI_NO

/PF1/DB_ITEM_FI-COMP_CODE table field - Company Code ▼

Description: Company Code
Field Name: COMP_CODE
Data Element: BUKRS
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: BUKRS
MemoryID: BUK
AppClass: FB
SHLP: C_T001
SHLP Field: BUKRS
ConvExit:

See all SAP tables containing field COMP_CODE

/PF1/DB_ITEM_FI-BLART table field - Document Type ▼

Description: Document Type
Field Name: BLART
Data Element: BLART
Data Type: CHAR
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: BLART
MemoryID: BAR
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLART

/PF1/DB_ITEM_FI-BUS_ACT table field - Business Transaction ▼

Description: Business Transaction
Field Name: BUS_ACT
Data Element: GLVOR
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine:
Domain Name: CHAR4
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUS_ACT

/PF1/DB_ITEM_FI-GL_ACCOUNT table field - General Ledger Account ▼

Description: General Ledger Account
Field Name: GL_ACCOUNT
Data Element: HKONT
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: SAKNR
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field GL_ACCOUNT

/PF1/DB_ITEM_FI-AWTYPE table field - Reference procedure ▼

Description: Reference procedure
Field Name: AWTYPE
Data Element: AWTYP
Data Type: CHAR
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: AWTYP
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AWTYPE

/PF1/DB_ITEM_FI-AWKEY table field - Reference Key ▼

Description: Reference Key
Field Name: AWKEY
Data Element: AWKEY
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: AWKEY
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AWKEY

/PF1/DB_ITEM_FI-AWSYS table field - Logical system of source document ▼

Description: Logical system of source document
Field Name: AWSYS
Data Element: AWSYS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: LOGSYS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field AWSYS

/PF1/DB_ITEM_FI-DEBCREDIND table field - Transaction Debit/Credit ▼

Description: Transaction Debit/Credit
Field Name: DEBCREDIND
Data Element: /PF1/DTE_BPE_DCFLG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: /PF1/DOM_BPE_DCFLG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEBCREDIND

/PF1/DB_ITEM_FI-AMOUNT table field - Amount in Transaction Currency ▼

Description: Amount in Transaction Currency
Field Name: AMOUNT
Data Element: /PF1/DTE_BPE_AMOUNT
Data Type: CURR
length (Dec): 23(2)
Check table:
Conversion Routine:
Domain Name: /PF1/DOM_BPE_AMOUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AMOUNT

/PF1/DB_ITEM_FI-CURR table field - Transaction Currency ▼

Description: Transaction Currency
Field Name: CURR
Data Element: /PF1/DTE_BPE_CURR
Data Type: CUKY
length (Dec): 5(0)
Check table: TCURC
Conversion Routine:
Domain Name: WAERS
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURR

/PF1/DB_ITEM_FI-BUDAT table field - Posting Date in the Document ▼

Description: Posting Date in the Document
Field Name: BUDAT
Data Element: BUDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUDAT

/PF1/DB_ITEM_FI-RECONC_DATE table field - Reconciliation Date ▼

Description: Reconciliation Date
Field Name: RECONC_DATE
Data Element: /PF1/DTE_RECONC_DATE
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: /PF1/DOM_RECONC_DATE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECONC_DATE

/PF1/DB_ITEM_FI-CRUSR table field - Creating User ▼

Description: Creating User
Field Name: CRUSR
Data Element: /PF1/DTE_BPE_CRUSR
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: USNAM
MemoryID:
AppClass: TEST
SHLP: USER_COMP
SHLP Field: BNAME
ConvExit:

See all SAP tables containing field CRUSR

/PF1/DB_ITEM_FI-CRDAT table field - Creation Date ▼

Description: Creation Date
Field Name: CRDAT
Data Element: /PF1/DTE_BPE_CRDAT
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CRDAT

/PF1/DB_ITEM_FI-CRTIM table field - Creation Time ▼

Description: Creation Time
Field Name: CRTIM
Data Element: /PF1/DTE_BPE_CRTIM
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CRTIM

View list of all SAP tables(S4H/ECC)

Select data from SAP table