SAP CMPJRNLQ001 table - Generated Table for View details in SAP


SAP CMPJRNLQ001 table summary

Object Name: CMPJRNLQ001
Dictionary Type: Table view
Description: Generated Table for View


Field list for CMPJRNLQ001 table on an S/4 SAP system

Details
CMPJRNLQ001-MANDT table field - Client

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

See all SAP tables containing field MANDT

CMPJRNLQ001-LEDGER table field - Ledger in General Ledger Accounting

Description: Ledger in General Ledger Accounting
Field Name: LEDGER
Data Element: FINS_LEDGER
Data Type: CHAR
length (Dec): 2(0)
Check table: FINSC_LEDGER
Conversion Routine: ALPHA
Domain Name: FINS_LEDGER
MemoryID: GLN_FLEX
AppClass:
SHLP: FINS_LEDGER
SHLP Field: RLDNR
ConvExit: ALPHA

See all SAP tables containing field LEDGER

CMPJRNLQ001-COMPANYCODE table field - Company Code

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

See all SAP tables containing field COMPANYCODE

CMPJRNLQ001-FISCALYEAR table field - Fiscal Year

Description: Fiscal Year
Field Name: FISCALYEAR
Data Element: FIS_GJAHR
Data Type: NUMC
length (Dec): 4(0)
Check table:
Conversion Routine: GJAHR
Domain Name: GJAHR
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit: GJAHR

See all SAP tables containing field FISCALYEAR

CMPJRNLQ001-ACCOUNTINGDOCUMENT table field - Journal Entry

Description: Journal Entry
Field Name: ACCOUNTINGDOCUMENT
Data Element: FIS_BELNR
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: BELNR
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ACCOUNTINGDOCUMENT

CMPJRNLQ001-FISCALPERIOD table field - Fiscal Period

Description: Fiscal Period
Field Name: FISCALPERIOD
Data Element: FINS_FISCALPERIOD
Data Type: NUMC
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: POPER
MemoryID: POPR
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FISCALPERIOD

CMPJRNLQ001-WBSELEMENT table field - WBS Element

Description: WBS Element
Field Name: WBSELEMENT
Data Element: FIS_WBS
Data Type: CHAR
length (Dec): 24(0)
Check table:
Conversion Routine: ABPSN
Domain Name: FIS_WBS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ABPSN

See all SAP tables containing field WBSELEMENT

CMPJRNLQ001-PROJECTNETWORK table field - Network Number for Account Assignment

Description: Network Number for Account Assignment
Field Name: PROJECTNETWORK
Data Element: NPLNR
Data Type: CHAR
length (Dec): 12(0)
Check table: AUFK
Conversion Routine: ALPHA
Domain Name: AUFNR
MemoryID: NET
AppClass: SAP
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field PROJECTNETWORK

CMPJRNLQ001-RELATEDNETWORKACTIVITY table field - Network activity

Description: Network activity
Field Name: RELATEDNETWORKACTIVITY
Data Element: NPVRG
Data Type: CHAR
length (Dec): 4(0)
Check table:
Conversion Routine: NUMCV
Domain Name: VORNR
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit: NUMCV

See all SAP tables containing field RELATEDNETWORKACTIVITY

CMPJRNLQ001-MATERIAL table field - Material Number

Description: Material Number
Field Name: MATERIAL
Data Element: MATNR
Data Type: CHAR
length (Dec): 40(0)
Check table: MARA
Conversion Routine: MATN1
Domain Name: MATNR
MemoryID: MAT
AppClass: MG
SHLP: S_MAT1
SHLP Field: MATNR
ConvExit: MATN1

See all SAP tables containing field MATERIAL

CMPJRNLQ001-CONTROLLINGOBJECT table field - Controlling Object

Description: Controlling Object
Field Name: CONTROLLINGOBJECT
Data Element: FIS_OBJNR
Data Type: CHAR
length (Dec): 22(0)
Check table: ONR00
Conversion Routine:
Domain Name: J_OBJNR
MemoryID:
AppClass: BONR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTROLLINGOBJECT

CMPJRNLQ001-COSTCTRACTIVITYTYPE table field - Activity Type

Description: Activity Type
Field Name: COSTCTRACTIVITYTYPE
Data Element: LSTAR
Data Type: CHAR
length (Dec): 6(0)
Check table: CSLA
Conversion Routine:
Domain Name: LSTAR
MemoryID: LAR
AppClass: KS
SHLP: LART_EMPTY
SHLP Field: LSTAR
ConvExit:

See all SAP tables containing field COSTCTRACTIVITYTYPE

CMPJRNLQ001-GLACCOUNT table field - G/L Account

Description: G/L Account
Field Name: GLACCOUNT
Data Element: FIS_RACCT
Data Type: CHAR
length (Dec): 10(0)
Check table: SKB1
Conversion Routine: ALPHA
Domain Name: SAKNR
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field GLACCOUNT

CMPJRNLQ001-REFERENCEDOCUMENT table field - Reference document number

Description: Reference document number
Field Name: REFERENCEDOCUMENT
Data Element: AWREF
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine: ALPHA
Domain Name: AWREF
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field REFERENCEDOCUMENT

CMPJRNLQ001-DOCUMENTDATE table field - Journal Entry Date

Description: Journal Entry Date
Field Name: DOCUMENTDATE
Data Element: FIS_BLDAT
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 DOCUMENTDATE

CMPJRNLQ001-BASEUNIT table field - Base Unit of Measure

Description: Base Unit of Measure
Field Name: BASEUNIT
Data Element: MEINS
Data Type: UNIT
length (Dec): 3(0)
Check table: T006
Conversion Routine: CUNIT
Domain Name: MEINS
MemoryID:
AppClass: MG
SHLP:
SHLP Field:
ConvExit: CUNIT

See all SAP tables containing field BASEUNIT

CMPJRNLQ001-ACCOUNTINGDOCCREATEDBYUSER table field - User that created the journal entry

Description: User that created the journal entry
Field Name: ACCOUNTINGDOCCREATEDBYUSER
Data Element: FIS_USNAM
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCOUNTINGDOCCREATEDBYUSER

CMPJRNLQ001-TRANSACTIONCURRENCY table field - Transaction Currency

Description: Transaction Currency
Field Name: TRANSACTIONCURRENCY
Data Element: FIS_RWCUR
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 TRANSACTIONCURRENCY

CMPJRNLQ001-AMOUNTINTRANSACTIONCURRENCY table field - Amount in Transaction Currency

Description: Amount in Transaction Currency
Field Name: AMOUNTINTRANSACTIONCURRENCY
Data Element: FIS_WSL
Data Type: CURR
length (Dec): 23(2)
Check table:
Conversion Routine:
Domain Name: WERTV12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AMOUNTINTRANSACTIONCURRENCY

CMPJRNLQ001-CONTROLLINGOBJECTCURRENCY table field - CO Object Currency

Description: CO Object Currency
Field Name: CONTROLLINGOBJECTCURRENCY
Data Element: FINS_CO_OCUR
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 CONTROLLINGOBJECTCURRENCY

CMPJRNLQ001-AMOUNTINOBJECTCURRENCY table field - Amount in Object Currency

Description: Amount in Object Currency
Field Name: AMOUNTINOBJECTCURRENCY
Data Element: FIS_VCO_OCUR12
Data Type: CURR
length (Dec): 23(2)
Check table:
Conversion Routine:
Domain Name: WERTV12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AMOUNTINOBJECTCURRENCY

CMPJRNLQ001-QUANTITY table field - Quantity

Description: Quantity
Field Name: QUANTITY
Data Element: QUAN1_12
Data Type: QUAN
length (Dec): 23(3)
Check table:
Conversion Routine:
Domain Name: MENGV12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUANTITY

CMPJRNLQ001-BUSINESSTRANSACTIONTYPE table field - Business Transaction Type

Description: Business Transaction Type
Field Name: BUSINESSTRANSACTIONTYPE
Data Element: FIS_CUSTBTTYPE
Data Type: CHAR
length (Dec): 4(0)
Check table: FINSC_CUSTBTTYPE
Conversion Routine:
Domain Name: FINS_CUSTBTTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUSINESSTRANSACTIONTYPE

CMPJRNLQ001-SEGMENT table field - Segment for Segmental Reporting

Description: Segment for Segmental Reporting
Field Name: SEGMENT
Data Element: FB_SEGMENT
Data Type: CHAR
length (Dec): 10(0)
Check table: FAGL_SEGM
Conversion Routine: ALPHA
Domain Name: FB_SEGMENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field SEGMENT

CMPJRNLQ001-BUSINESSAREA table field - Business Area

Description: Business Area
Field Name: BUSINESSAREA
Data Element: FIS_RBUSA
Data Type: CHAR
length (Dec): 4(0)
Check table: TGSB
Conversion Routine:
Domain Name: GSBER
MemoryID: GSB
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BUSINESSAREA

CMPJRNLQ001-FINANCIALACCOUNTTYPE table field - Account Type

Description: Account Type
Field Name: FINANCIALACCOUNTTYPE
Data Element: FARP_KOART
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: FARP_KOART
MemoryID:
AppClass: FB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FINANCIALACCOUNTTYPE

CMPJRNLQ001-POSTINGDATE table field -

Description:
Field Name: POSTINGDATE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field POSTINGDATE

CMPJRNLQ001-REFERENCEDOCUMENTITEM table field - Reference Document Item

Description: Reference Document Item
Field Name: REFERENCEDOCUMENTITEM
Data Element: FIS_AWITEM
Data Type: NUMC
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: NUMC6
MemoryID:
AppClass: PABR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REFERENCEDOCUMENTITEM

CMPJRNLQ001-COSTCENTER table field - Cost Center

Description: Cost Center
Field Name: COSTCENTER
Data Element: FIS_KOSTL
Data Type: CHAR
length (Dec): 10(0)
Check table: CSKS
Conversion Routine: ALPHA
Domain Name: KOSTL
MemoryID: KOS
AppClass: KA
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field COSTCENTER

CMPJRNLQ001-CONTROLLINGAREA table field - Controlling Area

Description: Controlling Area
Field Name: CONTROLLINGAREA
Data Element: FIS_KOKRS
Data Type: CHAR
length (Dec): 4(0)
Check table: TKA01
Conversion Routine:
Domain Name: CACCD
MemoryID: CAC
AppClass: KS
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONTROLLINGAREA

CMPJRNLQ001-PARTNERCOSTCENTER table field - Partner Cost Center

Description: Partner Cost Center
Field Name: PARTNERCOSTCENTER
Data Element: FIS_SKOST
Data Type: CHAR
length (Dec): 10(0)
Check table: CSKS
Conversion Routine: ALPHA
Domain Name: KOSTL
MemoryID: KSK
AppClass: KA
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field PARTNERCOSTCENTER

CMPJRNLQ001-FIXEDQUANTITY table field - Fixed Quantity

Description: Fixed Quantity
Field Name: FIXEDQUANTITY
Data Element: FIS_QUAN1_12_FIX
Data Type: QUAN
length (Dec): 23(3)
Check table:
Conversion Routine:
Domain Name: MENGV12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FIXEDQUANTITY

CMPJRNLQ001-VALUATIONQUANTITY table field - Valuation Quantity

Description: Valuation Quantity
Field Name: VALUATIONQUANTITY
Data Element: FIS_VQUAN1_12
Data Type: QUAN
length (Dec): 23(3)
Check table:
Conversion Routine:
Domain Name: MENGV12
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field VALUATIONQUANTITY

CMPJRNLQ001-PURCHASINGDOCUMENT table field - Purchasing Document

Description: Purchasing Document
Field Name: PURCHASINGDOCUMENT
Data Element: FIS_EBELN
Data Type: CHAR
length (Dec): 10(0)
Check table: EKKO
Conversion Routine: ALPHA
Domain Name: EBELN
MemoryID: BES
AppClass: ME
SHLP: MEKK_C
SHLP Field: EBELN
ConvExit: ALPHA

See all SAP tables containing field PURCHASINGDOCUMENT

CMPJRNLQ001-PURCHASINGDOCUMENTITEM table field - Purchasing Document Item

Description: Purchasing Document Item
Field Name: PURCHASINGDOCUMENTITEM
Data Element: FIS_EBELP
Data Type: NUMC
length (Dec): 5(0)
Check table: EKPO
Conversion Routine:
Domain Name: EBELP
MemoryID:
AppClass: ME
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PURCHASINGDOCUMENTITEM

CMPJRNLQ001-DOCUMENTITEMTEXT table field - Item Text

Description: Item Text
Field Name: DOCUMENTITEMTEXT
Data Element: FARP_SGTXT
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: TEXT50
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DOCUMENTITEMTEXT

CMPJRNLQ001-PERSONNELNUMBER table field - Personnel Number

Description: Personnel Number
Field Name: PERSONNELNUMBER
Data Element: PERNR_D
Data Type: NUMC
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: PERNR
MemoryID: PER
AppClass: PB
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PERSONNELNUMBER

CMPJRNLQ001-ACCOUNTASSIGNMENT table field - Account Assignment

Description: Account Assignment
Field Name: ACCOUNTASSIGNMENT
Data Element: ACCAS
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: ACCAS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCOUNTASSIGNMENT

CMPJRNLQ001-ACCOUNTASSIGNMENTTYPE table field - Account Assignment Type

Description: Account Assignment Type
Field Name: ACCOUNTASSIGNMENTTYPE
Data Element: FIS_ACCASTY
Data Type: CHAR
length (Dec): 2(0)
Check table: TBO00
Conversion Routine:
Domain Name: J_OBART
MemoryID:
AppClass: BONR
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ACCOUNTASSIGNMENTTYPE

CMPJRNLQ001-ORDERID table field - Order ID

Description: Order ID
Field Name: ORDERID
Data Element: FIS_AUFNR
Data Type: CHAR
length (Dec): 12(0)
Check table: AUFK
Conversion Routine: ALPHA
Domain Name: AUFNR
MemoryID: ANR
AppClass: SAP
SHLP:
SHLP Field:
ConvExit: ALPHA

See all SAP tables containing field ORDERID

CMPJRNLQ001-ORDERCATEGORY table field - Order category

Description: Order category
Field Name: ORDERCATEGORY
Data Element: AUFTYP
Data Type: NUMC
length (Dec): 2(0)
Check table:
Conversion Routine:
Domain Name: AUFTYP
MemoryID:
AppClass: KO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ORDERCATEGORY

CMPJRNLQ001-BILLINGDOCUMENTTYPE table field - Billing Type

Description: Billing Type
Field Name: BILLINGDOCUMENTTYPE
Data Element: FKART
Data Type: CHAR
length (Dec): 4(0)
Check table: TVFK
Conversion Routine:
Domain Name: FKART
MemoryID:
AppClass: VF
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BILLINGDOCUMENTTYPE

CMPJRNLQ001-SALESORGANIZATION table field - Sales Organization

Description: Sales Organization
Field Name: SALESORGANIZATION
Data Element: VKORG
Data Type: CHAR
length (Dec): 4(0)
Check table: TVKO
Conversion Routine:
Domain Name: VKORG
MemoryID: VKO
AppClass: MG
SHLP: C_VKORG
SHLP Field: VKORG
ConvExit:

See all SAP tables containing field SALESORGANIZATION

CMPJRNLQ001-DISTRIBUTIONCHANNEL table field - Distribution Channel

Description: Distribution Channel
Field Name: DISTRIBUTIONCHANNEL
Data Element: VTWEG
Data Type: CHAR
length (Dec): 2(0)
Check table: TVTW
Conversion Routine:
Domain Name: VTWEG
MemoryID: VTW
AppClass: MG
SHLP: C_VTWEG
SHLP Field: VTWEG
ConvExit:

See all SAP tables containing field DISTRIBUTIONCHANNEL

CMPJRNLQ001-ORGANIZATIONDIVISION table field - Division

Description: Division
Field Name: ORGANIZATIONDIVISION
Data Element: SPART
Data Type: CHAR
length (Dec): 2(0)
Check table: TSPA
Conversion Routine:
Domain Name: SPART
MemoryID: SPA
AppClass: V
SHLP: C_SPART
SHLP Field: SPART
ConvExit:

See all SAP tables containing field ORGANIZATIONDIVISION


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table