I_FINANCIALPLANNINGENTRYITEM

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.

-- Financial Planning Entry Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FINANCIALPLANNINGENTRYITEM (
    ACCOUNTASSIGNMENTTYPE,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGDEBITCREDITCODE,
    CONTROLLINGOBJECT,
    COSTESTIMATEVALIDITYENDDATE,
    COSTESTIMATEVALIDITYSTARTDATE,
    COSTINGLOTSIZE,
    COSTORIGINGROUP,
    COSTSOURCEUNIT,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FUNCTIONALAREA,
    GLACCOUNT,
    ISLOTSIZEINDEPENDENT,
    LEDGER,
    LEDGERFISCALYEAR,
    LOTSIZEUNIT,
    MATERIAL,
    ORDERID,
    ORDERITEM,
    ORDEROPERATION,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PARTNERORDER,
    PLANNINGCATEGORY,
    PLANT,
    POSTINGDATE,
    PRODUCEDPRODUCT,
    PROFITCENTER,
    PROJECTINTERNALID,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    WORKCENTERINTERNALID,
    _ASSEMBLY,
    _BILLABLECONTROL,
    _BILLINGDOCUMENTTYPE,
    _BILLTOPARTY,
    _BUDGETINGTYPE,
    _BUDGETPERIOD,
    _BUDGETPROCESS,
    _BUSINESSAREA,
    _BUSINESSTRANSACTIONCATEGORY,
    _BUSINESSTRANSACTIONTYPE,
    _CALENDARDATE,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _CONTROLLINGDEBITCREDITCODE,
    _CONTROLLINGOBJECTCURRENCY,
    _COSTANALYSISRESOURCE,
    _COSTCENTER,
    _COSTCTRACTIVITYTYPE,
    _COSTSOURCEUNIT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERCOMPANY,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _CUSTOMERSUPPLIERINDUSTRYTEXT,
    _DISTRIBUTIONCHANNEL,
    _EMPLOYMENT,
    _EQUIPMENT,
    _FINANCIALMANAGEMENTAREA,
    _FINANCIALTRANSACTIONTYPE,
    _FISCALCALENDARDATE,
    _FISCALPERIODFORVARIANT,
    _FISCALYEAR,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FIXEDASSET,
    _FUNCTIONALAREA,
    _FUND,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _GRANT,
    _INTERNALORDER,
    _LEDGER,
    _LEDGERFISCALYEAR,
    _LEDGERFISCALYEARFORVARIANT,
    _LOTSIZEUNIT,
    _MAINTENANCEACTIVITYTYPE,
    _MASTERFIXEDASSET,
    _ORDER,
    _ORGANIZATIONDIVISION,
    _ORIGINCOSTCENTER,
    _ORIGINCOSTCTRACTIVITYTYPE,
    _PARTNERBUSINESSAREA,
    _PARTNERCOMPANY,
    _PARTNERCOMPANYCODE,
    _PARTNERCOSTCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _PARTNERFUNCTIONALAREA,
    _PARTNERORDER,
    _PARTNERORDER_2,
    _PARTNERPROFITCENTER,
    _PARTNERPROJECTBASICDATA,
    _PARTNERSEGMENT,
    _PARTNERWBSELEMENTBASICDATA,
    _PERSONWORKAGREEMENT_1,
    _PLANNINGCATEGORY,
    _PLANT,
    _PRODUCEDPRODUCT,
    _PRODUCT,
    _PRODUCTGROUP_2,
    _PROFITCENTER,
    _PROJECTBASICDATA,
    _REFERENCEQUANTITYUNIT,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SALESORGANIZATION,
    _SEGMENT,
    _SEMTAGGLACCOUNT,
    _SERVICECONTRACT,
    _SERVICECONTRACTITEM,
    _SERVICECONTRACTTYPE,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTITEM,
    _SERVICEDOCUMENTTYPE,
    _SHIPTOPARTY,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP_2,
    _SPONSOREDCLASS,
    _SPONSOREDPROGRAM,
    _SUBLEDGERACCLINEITEMTYPE,
    _TRANSACTIONCURRENCY,
    _USER,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTBYINTERNALKEY,
    _WORKCENTER,
    _WORKPACKAGE,
    _WORKPACKAGEWORKITEM,
    ALTERNATIVEBILLOFMATERIAL,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSEMBLY,
    ASSETACCTTRANSCLASSFCTN,
    ASSETCLASS,
    ASSETDEPRECIATIONAREA,
    ASSIGNMENTREFERENCE,
    BILLABLECONTROL,
    BILLINGDOCUMENTTYPE,
    BILLOFMATERIAL,
    BILLOFMATERIALVARIANTUSAGE,
    BILLTOPARTY,
    BUDGETDOCWORKFLOWSTATUS,
    BUDGETINGTYPE,
    BUDGETPERIOD,
    BUDGETPROCESS,
    BUSINESSTRANSACTIONCATEGORY,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    COMPONENTSCRAPQUANTITY,
    CONTROLLINGOBJECTCURRENCY,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTESTIMATEISFORPROCMTALTV,
    COSTESTISMIXEDCOSTING,
    CUSTOMER,
    CUSTOMERBASICAUTHORIZATIONGRP,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTITEMTEXT,
    EQUIPMENT,
    FINANCIALMANAGEMENTAREA,
    FINANCIALTRANSACTIONTYPE,
    FINPLNGENTRYITEMCREATEDBYUSER,
    FINPLNGENTRYITEMCRTNDATETIME,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINGLOBALCRCY,
    FIXEDASSET,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALCURRENCY,
    FUND,
    GLACCOUNTAUTHORIZATIONGROUP,
    GLOBALCURRENCY,
    GRANTID,
    GTEEMBUDGETVALIDITYNUMBER,
    ISSTATISTICALCOSTCENTER,
    ISSTATISTICALORDER,
    ISSTATISTICALSALESDOCUMENT,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREPRODUCTIONDATE,
    MAINTENANCEACTIVITYTYPE,
    MAINTENANCEORDERPLANNINGCODE,
    MAINTPRIORITY,
    MAINTPRIORITYTYPE,
    MASTERFIXEDASSET,
    MATERIALGROUP,
    MMSERVICEPACKAGE,
    MMSERVICEPACKAGELINE,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    OFFSETTINGCHARTOFACCOUNTS,
    ORDERSUBOPERATION,
    ORDERTYPE,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCENTER,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINORDER,
    ORIGINORDEROPERATION,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PARTNERCOMPANYCODE,
    PARTNERFUNCTIONALAREA,
    PARTNERORDER_2,
    PARTNERORDERITEM,
    PARTNERPROFITCENTER,
    PARTNERPROJECT,
    PARTNERPROJECTINTERNALID,
    PARTNERSEGMENT,
    PARTNERWBSELEMENT,
    PARTNERWBSELEMENTINTERNALID,
    PERSONNELNUMBER,
    PLANPRICEINCOMPANYCODECURRENCY,
    PLANPRICEINGLOBALCURRENCY,
    PLANPRICEINTRANSACTIONCURRENCY,
    PROCESSOFCOPRODUCT,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTIONVERSION,
    PROJECT,
    PROJECTNETWORK,
    REALESTATEBUILDING,
    REALESTATECONTRACT,
    REALESTATEPROPERTY,
    REBUSINESSENTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    REFERENCEQUANTITY,
    REFERENCEQUANTITYUNIT,
    RERENTALOBJECT,
    RESERVATION,
    RESERVATIONITEM,
    RESERVATIONTYPE,
    RESERVICECHARGEKEY,
    RESETTLEMENTUNITID,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDERTYPE,
    SALESORGANIZATION,
    SCRAPQUANTITY,
    SEGMENT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SETTLEMENTREFERENCEDATE,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SPONSOREDCLASS,
    SPONSOREDPROGRAM,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPERIORORDER,
    TASKLISTGROUP,
    TASKLISTGROUPCOUNTER,
    TASKLISTTYPE,
    TRANSACTIONCURRENCY,
    VALUATIONQUANTITY,
    VALUATIONTYPE,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    WBSISSTATISTICALWBSELEMENT,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTASSIGNMENTTYPE, BUSINESSAREA, BUSINESSTRANSACTIONTYPE, COMPANYCODE, CONTROLLINGAREA, CONTROLLINGDEBITCREDITCODE, CONTROLLINGOBJECT, COSTESTIMATEVALIDITYENDDATE, COSTESTIMATEVALIDITYSTARTDATE, COSTINGLOTSIZE, COSTORIGINGROUP, COSTSOURCEUNIT, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALPERIOD, FISCALYEAR, FISCALYEARPERIOD, FUNCTIONALAREA, GLACCOUNT, ISLOTSIZEINDEPENDENT, LEDGER, LEDGERFISCALYEAR, LOTSIZEUNIT, MATERIAL, ORDERID, ORDERITEM, ORDEROPERATION, PARTNERACCOUNTASSIGNMENTTYPE, PARTNERCOSTCENTER, PARTNERCOSTCTRACTIVITYTYPE, PARTNERORDER, PLANNINGCATEGORY, PLANT, POSTINGDATE, PRODUCEDPRODUCT, PROFITCENTER, PROJECTINTERNALID, SERVICEDOCUMENT, SERVICEDOCUMENTITEM, SERVICEDOCUMENTTYPE, WORKCENTERINTERNALID)
);