I_CNSLDTNGROUPJRNLENTRYITEM

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.

-- Group Journal Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNGROUPJRNLENTRYITEM (
    CNSLDTNGROUPJRNLENTRY,
    CNSLDTNGROUPJRNLENTRYITEM,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONLEDGER,
    FISCALYEAR,
    AMOUNTINGROUPCURRENCY,
    AMOUNTINLOCALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BASEUNIT,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    CASHLEDGERACCOUNT,
    CHARTOFACCOUNTS,
    CNSLDTNADHOCITEM,
    CNSLDTNADHOCSET,
    CNSLDTNADHOCSETITEM,
    CNSLDTNCASHLEDGERCHARTOFACCTS,
    CNSLDTNCSTMSIGNAMTINGRPCRCY,
    CNSLDTNCSTMSIGNAMTINLOCLCRCY,
    CNSLDTNCSTMSIGNAMTINTRANSCRCY,
    CNSLDTNCSTMSIGNLONGQTYINBSUNIT,
    CNSLDTNCSTMSIGNQTYINBASEUNIT,
    CNSLDTNGROUPJRNLENTRYBUNDLE,
    CNSLDTNQUANTITYINBASEUNIT,
    COMPANY,
    COMPANYCODE,
    CONSOLIDATIONACQUISITIONPERIOD,
    CONSOLIDATIONACQUISITIONYEAR,
    CONSOLIDATIONAPPORTIONMENT,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONDOCREVERSALYEAR,
    CONSOLIDATIONDOCUMENTTYPE,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONPOSTGITEMAUTOFLAG,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONVERSION,
    CONTROLLINGAREA,
    COSTCENTER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    CURRENCYCONVERSIONSDIFFTYPE,
    CURRENCYTRANSLATIONDATE,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNEL,
    DOCUMENTCATEGORY,
    DOCUMENTITEMTEXT,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALSTATEMENTITEM,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FUNCTIONALAREA,
    FUND,
    GHGCATEGORY,
    GHGDATAQUALITYCHARACTERISTIC,
    GHGENERGYCLASSIFICATION,
    GHGENERGYMIX,
    GHGENERGYSOURCINGTYPE,
    GHGSCOPE,
    GHGSCOPE2CALCULATIONMETHOD,
    GHGSCOPE2CONTRACTUALINSTRUMENT,
    GLACCOUNT,
    GLRECORDTYPE,
    GRANTID,
    GROUPCURRENCY,
    INVESTEECONSOLIDATIONUNIT,
    INVESTMENTACTIVITY,
    INVESTMENTACTIVITYTYPE,
    INVESTORCONSOLIDATIONUNIT,
    LOCALCURRENCY,
    LOGICALSYSTEM,
    MATCHINGREASONCODE,
    MATERIAL,
    MATERIALGROUP,
    ORDERID,
    ORGANIZATIONDIVISION,
    ORIGINREFERENCE,
    ORIGINTYPE,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREA,
    PARTNERFUND,
    PARTNERPROFITCENTER,
    PARTNERSEGMENT,
    PLANT,
    POSTINGDATE,
    POSTINGLEVEL,
    PROFITCENTER,
    PROJECT,
    QUANTITYINBASEUNIT,
    REFBUSINESSTRANSACTIONTYPE,
    REFCONSOLIDATIONDOCUMENTNUMBER,
    REFCONSOLIDATIONDOCUMENTTYPE,
    REFCONSOLIDATIONPOSTINGITEM,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REFERENCEFISCALYEAR,
    REVERSEDDOCUMENT,
    REVERSEDOCUMENT,
    SALESDISTRICT,
    SALESORGANIZATION,
    SEGMENT,
    SHIPTOPARTY,
    SOLDMATERIAL,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUBITEM,
    SUBITEMCATEGORY,
    SUPPLIER,
    SUSTAINABILITYMODEOFTRANSPORT,
    TRANSACTIONCURRENCY,
    USERID,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (CNSLDTNGROUPJRNLENTRY, CNSLDTNGROUPJRNLENTRYITEM, CONSOLIDATIONDIMENSION, CONSOLIDATIONLEDGER, FISCALYEAR)
);