FINCS_PJE_WF_I

Transparent Table Application Table
112 Fields 1 CDS Views

PGJE line item workflow table

FINCS_PJE_WF_I is an SAP database table in S/4HANA. PGJE line item workflow table. It contains 112 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CnsldtnGrpJrnlEntrItmWrkflw view from BASIC Base items workflow

Fields (112)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY draftuuid /BOBF/UUID Key
parentdraftuuid /BOBF/UUID Key
fiscalyear GJAHR Fiscal Year
consolidationdocumentnumber BELNR_D Document Number
consolidationledger RLDNR Ledger
consolidationpostingitem DOCLN6 G/L Line Item
fiscalyearforedit GJAHR Fiscal Year
consolidationledgerforedit RLDNR Ledger
consolidationdimension FC_DIMEN Dimension
glrecordtype FC_RRCTY Record Type
consolidationversion FC_RVERS Version
transactioncurrency RTCUR Currency
localcurrency LCURR Local crcy
groupcurrency GCURR Ledger curr.
baseunit MEINS Base Unit
fiscalperiod POPER Posting Period
company RCOMP_D Company
consolidationunit FC_BUNIT Cons. Unit
consolidationchartofaccounts FC_ITCLG Cons. COA
financialstatementitem FC_ITEM FS Item
partnerconsolidationunit FC_BUPTR Partner Unit
consolidationunit1isused FC_IND_CU1 Cons unit 1
consolidationgroup FC_CONGR Cons. Group
companycode OBUKR Orig. CC
subitemcategory FC_SITYP Subitem Category
subitem FC_SITEM Subitem
postinglevel FC_PLEVL Posting Level
consolidationapportionment FC_RPFLG Apportionment
currencyconversionsdifftype FC_RTFLG CT Indicator
consolidationdocumenttype FC_DOCTY Document Type
consolidationacquisitionyear FC_RYACQ Acquis. Year
consolidationacquisitionperiod RPACQ Period of Acq.
investeeconsolidationunit FC_COICU Investee Unit
amountintransactioncurrency VTCUR12 Amount in TC
amountinlocalcurrency VLCUR12 Local Crcy Amt
amountingroupcurrency VGCUR12 Amnt in GrpCrcy
quantityinbaseunit FINCS_QUAN Quantity
documentitemtext SGTXT Text
consolidationpostgitemautoflag AUTOM Auto. ID
businesstransactiontype GLVOR Bus.transaction
postingdate BUDAT Posting Date
currencytranslationdate WSDAT Value Date
refaccountingdocument BELNR_D Document Number
refconsolidationdocumentnumber BELNR_D Document Number
referencefiscalyear FC_OYEAR Original FY
refconsolidationpostingitem BUZEI6 Item
refaccountingdocumentitem BUZEI6 Item
refconsolidationdocumenttype DOCCT Document Categ.
refbusinesstransactiontype GLVOR Bus.transaction
creationdate CPUDT Entered On
creationtime CPUTM Entered at
userid USNAM User Name
reversedocument STBLG Reversed With
reverseddocument STBLN Reversed doc.
investmentactivitytype FC_COIAC C/I Activity
investmentactivity FC_COINR Activity Number
consolidationdocreversalyear FC_REVYEAR Year of reversal doc
referencedocumenttype AWTYP Ref. procedure
referencedocumentcontext AWORG Refer. Org.Unit
logicalsystem LOGSYS Logical system
chartofaccounts KTOPL Chart of Accts
glaccount RACCT Account Number
assignmentreference DZUONR Assignment
costcenter KOSTL Cost Center
profitcenter PRCTR Profit Center
functionalarea FKBER Functional Area
businessarea GSBER Business Area
controllingarea KOKRS CO Area
segment FB_SEGMENT Segment
partnercostcenter SKOST Sender Cost Ctr
partnerprofitcenter PPRCTR Partner PC
partnerfunctionalarea SFKBER Partner FArea
partnerbusinessarea PARGB Trdg Part.BA
partnercompany RASSC Trading Partner
partnersegment FB_PSEGMENT Partner Segment
orderid AUFNR Order
customer KUNNR Customer
supplier LIFNR Supplier
material MATNR Material
plant WERKS_D Plant
financialtransactiontype RMVCT Transact. Type
wbselementinternalid PS_PSP_PNR WBS Element
wbselementexternalid PS_POSID WBS Element
project PS_PSPID Project def.
billingdocumenttype FKART Billing Type
salesorganization VKORG Sales Org.
distributionchannel VTWEG Distr. Channel
organizationdivision SPART Division
soldmaterial FINS_MATNR_PA Product Sold
materialgroup FINS_MATKL_MM Material Group
productgroup FINS_MATKL_PA Product Sold Group
customergroup KDGRP Customer Group
customersuppliercountry LAND1_GP Country/Region Key
customersupplierindustry BRSCH Industry
salesdistrict BZIRK Sales District
billtoparty KUNRE Bill-to Party
shiptoparty KUNWE Ship-to Party
customersuppliercorporategroup KONZS Group
consolidationunit3 FC_BUNIT Cons. Unit
partnerconsolidationunit3 FC_BUPTR Partner Unit
fiscalyearperiod FIS_JAHRPER_CONV Fiscal Year Period
hasactiveentity SDRAFT_HAS_ACTIVE Has active
draftentitycreationdatetime SDRAFT_CREATED_AT Draft Created On
draftentitylastchangedatetime SDRAFT_LAST_CHANGED_AT Draft Last Changed On
draftadministrativedatauuid SDRAFT_ADMIN_UUID Draft Adminv Data ID
draftentityconsistencystatus SDRAFT_CONSISTENCY_STATUS Consistency Status
draftentityoperationcode SDRAFT_OPERATION_CODE Draft - Operation Code
dummy_cje_incl_eew_ps CFD_DUMMY Dummy
isactiveentity SDRAFT_IS_ACTIVE Is active
uuidkey SWF_CP_SVC_ID Service ID
parentuuidkey SWF_CP_SVC_ID Service ID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- PGJE line item workflow table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINCS_PJE_WF_I (
    MANDT,                           -- Client [MANDT]
    DRAFTUUID,                       -- Key [/BOBF/UUID]
    PARENTDRAFTUUID,                 -- Key [/BOBF/UUID]
    FISCALYEAR,                      -- Fiscal Year [GJAHR]
    CONSOLIDATIONDOCUMENTNUMBER,     -- Document Number [BELNR_D]
    CONSOLIDATIONLEDGER,             -- Ledger [RLDNR]
    CONSOLIDATIONPOSTINGITEM,        -- G/L Line Item [DOCLN6]
    FISCALYEARFOREDIT,               -- Fiscal Year [GJAHR]
    CONSOLIDATIONLEDGERFOREDIT,      -- Ledger [RLDNR]
    CONSOLIDATIONDIMENSION,          -- Dimension [FC_DIMEN]
    GLRECORDTYPE,                    -- Record Type [FC_RRCTY]
    CONSOLIDATIONVERSION,            -- Version [FC_RVERS]
    TRANSACTIONCURRENCY,             -- Currency [RTCUR]
    LOCALCURRENCY,                   -- Local crcy [LCURR]
    GROUPCURRENCY,                   -- Ledger curr. [GCURR]
    BASEUNIT,                        -- Base Unit [MEINS]
    FISCALPERIOD,                    -- Posting Period [POPER]
    COMPANY,                         -- Company [RCOMP_D]
    CONSOLIDATIONUNIT,               -- Cons. Unit [FC_BUNIT]
    CONSOLIDATIONCHARTOFACCOUNTS,    -- Cons. COA [FC_ITCLG]
    FINANCIALSTATEMENTITEM,          -- FS Item [FC_ITEM]
    PARTNERCONSOLIDATIONUNIT,        -- Partner Unit [FC_BUPTR]
    CONSOLIDATIONUNIT1ISUSED,        -- Cons unit 1 [FC_IND_CU1]
    CONSOLIDATIONGROUP,              -- Cons. Group [FC_CONGR]
    COMPANYCODE,                     -- Orig. CC [OBUKR]
    SUBITEMCATEGORY,                 -- Subitem Category [FC_SITYP]
    SUBITEM,                         -- Subitem [FC_SITEM]
    POSTINGLEVEL,                    -- Posting Level [FC_PLEVL]
    CONSOLIDATIONAPPORTIONMENT,      -- Apportionment [FC_RPFLG]
    CURRENCYCONVERSIONSDIFFTYPE,     -- CT Indicator [FC_RTFLG]
    CONSOLIDATIONDOCUMENTTYPE,       -- Document Type [FC_DOCTY]
    CONSOLIDATIONACQUISITIONYEAR,    -- Acquis. Year [FC_RYACQ]
    CONSOLIDATIONACQUISITIONPERIOD,  -- Period of Acq. [RPACQ]
    INVESTEECONSOLIDATIONUNIT,       -- Investee Unit [FC_COICU]
    AMOUNTINTRANSACTIONCURRENCY,     -- Amount in TC [VTCUR12]
    AMOUNTINLOCALCURRENCY,           -- Local Crcy Amt [VLCUR12]
    AMOUNTINGROUPCURRENCY,           -- Amnt in GrpCrcy [VGCUR12]
    QUANTITYINBASEUNIT,              -- Quantity [FINCS_QUAN]
    DOCUMENTITEMTEXT,                -- Text [SGTXT]
    CONSOLIDATIONPOSTGITEMAUTOFLAG,  -- Auto. ID [AUTOM]
    BUSINESSTRANSACTIONTYPE,         -- Bus.transaction [GLVOR]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    CURRENCYTRANSLATIONDATE,         -- Value Date [WSDAT]
    REFACCOUNTINGDOCUMENT,           -- Document Number [BELNR_D]
    REFCONSOLIDATIONDOCUMENTNUMBER,  -- Document Number [BELNR_D]
    REFERENCEFISCALYEAR,             -- Original FY [FC_OYEAR]
    REFCONSOLIDATIONPOSTINGITEM,     -- Item [BUZEI6]
    REFACCOUNTINGDOCUMENTITEM,       -- Item [BUZEI6]
    REFCONSOLIDATIONDOCUMENTTYPE,    -- Document Categ. [DOCCT]
    REFBUSINESSTRANSACTIONTYPE,      -- Bus.transaction [GLVOR]
    CREATIONDATE,                    -- Entered On [CPUDT]
    CREATIONTIME,                    -- Entered at [CPUTM]
    USERID,                          -- User Name [USNAM]
    REVERSEDOCUMENT,                 -- Reversed With [STBLG]
    REVERSEDDOCUMENT,                -- Reversed doc. [STBLN]
    INVESTMENTACTIVITYTYPE,          -- C/I Activity [FC_COIAC]
    INVESTMENTACTIVITY,              -- Activity Number [FC_COINR]
    CONSOLIDATIONDOCREVERSALYEAR,    -- Year of reversal doc [FC_REVYEAR]
    REFERENCEDOCUMENTTYPE,           -- Ref. procedure [AWTYP]
    REFERENCEDOCUMENTCONTEXT,        -- Refer. Org.Unit [AWORG]
    LOGICALSYSTEM,                   -- Logical system [LOGSYS]
    CHARTOFACCOUNTS,                 -- Chart of Accts [KTOPL]
    GLACCOUNT,                       -- Account Number [RACCT]
    ASSIGNMENTREFERENCE,             -- Assignment [DZUONR]
    COSTCENTER,                      -- Cost Center [KOSTL]
    PROFITCENTER,                    -- Profit Center [PRCTR]
    FUNCTIONALAREA,                  -- Functional Area [FKBER]
    BUSINESSAREA,                    -- Business Area [GSBER]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    SEGMENT,                         -- Segment [FB_SEGMENT]
    PARTNERCOSTCENTER,               -- Sender Cost Ctr [SKOST]
    PARTNERPROFITCENTER,             -- Partner PC [PPRCTR]
    PARTNERFUNCTIONALAREA,           -- Partner FArea [SFKBER]
    PARTNERBUSINESSAREA,             -- Trdg Part.BA [PARGB]
    PARTNERCOMPANY,                  -- Trading Partner [RASSC]
    PARTNERSEGMENT,                  -- Partner Segment [FB_PSEGMENT]
    ORDERID,                         -- Order [AUFNR]
    CUSTOMER,                        -- Customer [KUNNR]
    SUPPLIER,                        -- Supplier [LIFNR]
    MATERIAL,                        -- Material [MATNR]
    PLANT,                           -- Plant [WERKS_D]
    FINANCIALTRANSACTIONTYPE,        -- Transact. Type [RMVCT]
    WBSELEMENTINTERNALID,            -- WBS Element [PS_PSP_PNR]
    WBSELEMENTEXTERNALID,            -- WBS Element [PS_POSID]
    PROJECT,                         -- Project def. [PS_PSPID]
    BILLINGDOCUMENTTYPE,             -- Billing Type [FKART]
    SALESORGANIZATION,               -- Sales Org. [VKORG]
    DISTRIBUTIONCHANNEL,             -- Distr. Channel [VTWEG]
    ORGANIZATIONDIVISION,            -- Division [SPART]
    SOLDMATERIAL,                    -- Product Sold [FINS_MATNR_PA]
    MATERIALGROUP,                   -- Material Group [FINS_MATKL_MM]
    PRODUCTGROUP,                    -- Product Sold Group [FINS_MATKL_PA]
    CUSTOMERGROUP,                   -- Customer Group [KDGRP]
    CUSTOMERSUPPLIERCOUNTRY,         -- Country/Region Key [LAND1_GP]
    CUSTOMERSUPPLIERINDUSTRY,        -- Industry [BRSCH]
    SALESDISTRICT,                   -- Sales District [BZIRK]
    BILLTOPARTY,                     -- Bill-to Party [KUNRE]
    SHIPTOPARTY,                     -- Ship-to Party [KUNWE]
    CUSTOMERSUPPLIERCORPORATEGROUP,  -- Group [KONZS]
    CONSOLIDATIONUNIT3,              -- Cons. Unit [FC_BUNIT]
    PARTNERCONSOLIDATIONUNIT3,       -- Partner Unit [FC_BUPTR]
    FISCALYEARPERIOD,                -- Fiscal Year Period [FIS_JAHRPER_CONV]
    HASACTIVEENTITY,                 -- Has active [SDRAFT_HAS_ACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created On [SDRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Last Changed On [SDRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Draft Adminv Data ID [SDRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- Consistency Status [SDRAFT_CONSISTENCY_STATUS]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SDRAFT_OPERATION_CODE]
    DUMMY_CJE_INCL_EEW_PS,           -- Dummy [CFD_DUMMY]
    ISACTIVEENTITY,                  -- Is active [SDRAFT_IS_ACTIVE]
    UUIDKEY,                         -- Service ID [SWF_CP_SVC_ID]
    PARENTUUIDKEY,                   -- Service ID [SWF_CP_SVC_ID]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More