I_NETWORKACTIVITYVERSION

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.

-- Network Activity Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_NETWORKACTIVITYVERSION (
    NETWORKACTIVITY,
    PROJECTNETWORK,
    SUPERIORNTWKACTIVITYEXTERNALID,
    VERSION,
    _BUSINESSAREA,
    _CONTROLLINGOBJECTCLASS,
    _MATERIALGROUP,
    _MRPCONTROLLER,
    _NETWORKACTIVITYQUANTITYUNIT,
    _NTWKACTIVITYWORKQUANTITYUNIT,
    _PURCHASINGGROUP,
    _TAXJURISDICTION,
    _WORKCENTER,
    ACTIVITYCONFFCSTDDURATION,
    ACTIVITYCONFFCSTDDURATIONUNIT,
    ACTIVITYISACCOUNTASSIGNED,
    ACTIVITYQUANTITY,
    ACTUALENDDATE,
    ACTUALEXECUTIONENDTIME,
    ACTUALEXECUTIONSTARTTIME,
    ACTUALSTARTDATE,
    ACTUALWORKQUANTITY,
    ACTYBSCENDDATECONSTRAINTTYPE,
    ACTYBSCSTARTDATECONSTRAINTTYPE,
    ACTYCONFFCSTDENDDATE,
    ACTYCONFFCSTDENDTIME,
    ACTYFCSTENDDATECONSTRAINTTYPE,
    ACTYFCSTSTARTDTECONSTRAINTTYPE,
    ACTYISTAKENACCTFORPROJSMMRY,
    BASICDATESFREEFLOAT,
    BUSINESSAREA,
    CAPACITYREQUIREMENTDISTRKEY,
    COMPANYCODE,
    COMPANYCODENAME,
    CONSTRAINTDATEFORBSCENDDATE,
    CONSTRAINTDATEFORBSCSTARTDATE,
    CONSTRAINTTIMEFORBASICENDTIME,
    CONSTRAINTTIMEFORBSCSTARTTIME,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTCLASS,
    COSTCTRACTIVITYTYPE,
    COSTELEMENT,
    DISPATCHEDENDDATE,
    DISPATCHEDENDTIME,
    DISPATCHEDSTARTDATE,
    DISPATCHEDSTARTTIME,
    EMPLOYEESUITABILITY,
    EMPLOYEEWAGETYPE,
    ENDDATEOFFSETDURATION,
    ENDDATEOFFSETDURATIONUNIT,
    EXCHANGERATE,
    EXTERNALPROCESSINGPRICE,
    FACTORYCALENDAR,
    FCSTDSTANDARDDURATIONUNIT,
    FORECASTEDDATESFREEFLOAT,
    FORECASTEDENDDATE,
    FORECASTEDENDTIME,
    FORECASTEDMINIMUMDURATION,
    FORECASTEDMINIMUMDURATIONUNIT,
    FORECASTEDSTANDARDDURATION,
    FORECASTEDSTARTDATE,
    FORECASTEDSTARTTIME,
    FORECASTEDWORKQTY,
    FREEDEFINEDAMOUNT1,
    FREEDEFINEDAMOUNT1CURRENCY,
    FREEDEFINEDAMOUNT2,
    FREEDEFINEDAMOUNT2CURRENCY,
    FREEDEFINEDATTRIBUTE01,
    FREEDEFINEDATTRIBUTE02,
    FREEDEFINEDATTRIBUTE03,
    FREEDEFINEDATTRIBUTE04,
    FREEDEFINEDDATE1,
    FREEDEFINEDDATE2,
    FREEDEFINEDINDICATOR1,
    FREEDEFINEDINDICATOR2,
    FREEDEFINEDQUANTITY1,
    FREEDEFINEDQUANTITY1UNIT,
    FREEDEFINEDQUANTITY2,
    FREEDEFINEDQUANTITY2UNIT,
    FREEDEFINEDTABLEFIELDSEMANTIC,
    FUNCTIONALAREA,
    GOODSRECIPIENTNAME,
    ISCOSTACTIVITY,
    ISEXTERNALACTIVITY,
    ISINTERNALACTIVITY,
    ISMARKEDFORDELETION,
    ISSERVICEACTIVITY,
    JNTVENTUREORIGLCOSTOBJECTTYPE,
    JOINTVENTURE,
    JOINTVENTURECLASS,
    JOINTVENTUREOBJECTTYPE,
    JOINTVENTURESUBCLASS,
    LANGUAGE,
    LATESTSCHEDLDFCSTDENDDATE,
    LATESTSCHEDLDFCSTDSTARTDATE,
    LEADTIMEREDUCTIONSTRATEGY,
    MATERIALGROUP,
    MINIMUMDURATION,
    MINIMUMDURATIONUNIT,
    MRPCONTROLLER,
    NETWORKACTIVITYCATEGORY,
    NETWORKACTIVITYCONFIRMATION,
    NETWORKACTIVITYCONTROLPROFILE,
    NETWORKACTIVITYCOST,
    NETWORKACTIVITYCURRENCY,
    NETWORKACTIVITYDESCRIPTION,
    NETWORKACTIVITYDESCRIPTION2,
    NETWORKACTIVITYINTERNALID,
    NETWORKACTIVITYOBJECT,
    NETWORKACTIVITYOBJECTCURRENCY,
    NETWORKACTIVITYPRICEBASEQTY,
    NETWORKACTIVITYPRIORITY,
    NETWORKACTIVITYQUANTITYUNIT,
    NTWKACCOUNTASSIGNMENTCODE,
    NTWKACTIVITYWORKQUANTITYUNIT,
    NTWKACTYCONFIRMATIONCOUNT,
    NTWKACTYISRELEVANTFORMATLPLNG,
    NUMBEROFCAPACITIES,
    NUMBEROFEMPLOYEES,
    OBJBASEDAUTHORIZATIONISACTIVE,
    OBJECTISCONFIRMED,
    OBJECTISPARTIALLYCONFIRMED,
    OPERATIONCALCULATIONCONTROL,
    OPERATIONIMPORTANCE,
    PARTNERCOSTCENTER,
    PLANNEDDELIVERYDURATIONINDAYS,
    PLANNEDWORKQUANTITY,
    PLANT,
    PLANTNAME,
    PROFITCENTER,
    PROGRESSANLYSAGGREGATIONWEIGHT,
    PROJECT,
    PROJECTDESCRIPTION,
    PROJECTINTERNALID,
    PROJECTNETWORKINTERNALID,
    PROJECTOBJECT,
    PROJECTTEXTINTERNALID,
    PROJECTTYPE,
    PROJECTWITHCODINGMASK,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGGROUP,
    PURCHASINGGROUPNAME,
    PURCHASINGINFORECDADDLGRPGNAME,
    PURCHASINGINFORECORD,
    PURCHASINGORGANIZATION,
    PURCHASINGORGANIZATIONNAME,
    PURGINFORECDDATAISFIXED,
    REMAININGWORKQUANTITY,
    REQGCOSTCENTERCONTROLLINGAREA,
    REQUESTINGCOSTCENTER,
    REQUISITIONERUSER,
    RESPCOSTCENTERCONTROLLINGAREA,
    RESPONSIBLECOSTCENTER,
    SCHEDLDBASICEARLIESTENDDATE,
    SCHEDLDBASICEARLIESTENDTIME,
    SCHEDLDBASICEARLIESTSTARTDATE,
    SCHEDLDBASICEARLIESTSTARTTIME,
    SCHEDLDBASICLATESTENDTIME,
    SCHEDLDBASICLATESTSTARTDATE,
    SCHEDLDBASICLATESTSTARTTIME,
    SCHEDLDFCSTDEARLIESTENDDATE,
    SCHEDLDFCSTDEARLIESTENDTIME,
    SCHEDLDFCSTDEARLIESTSTARTDATE,
    SCHEDLDFCSTDEARLIESTSTARTTIME,
    SCHEDLDFCSTDLATESTENDTIME,
    SCHEDLDFCSTDLATESTSTARTTIME,
    SCHEDULEDBASICLATESTENDDATE,
    STANDARDDURATION,
    STANDARDDURATIONISFLEXIBLE,
    STANDARDDURATIONUNIT,
    STANDARDTEXTINTERNALID,
    STARTDATEOFFSETDURATION,
    STARTDATEOFFSETDURATIONUNIT,
    SUPERIORNTWKACTIVITYINTERNALID,
    SUPPLIER,
    SUPPLIERNAME,
    TAXJURISDICTION,
    TAXJURISDICTIONCALCPROCEDURE,
    TOTALFLOATFORBASICDATES,
    TOTALFLOATFORFORECASTEDDATES,
    UNLOADINGPOINTNAME,
    USAGECODE,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTHIERARCHYLEVEL,
    WBSELEMENTINTERNALID,
    WBSELEMENTOBJECT,
    WBSELEMENTWITHCODINGMASK,
    WORKCENTER,
    WORKCENTERINTERNALID,
    PRIMARY KEY (NETWORKACTIVITY, PROJECTNETWORK, SUPERIORNTWKACTIVITYEXTERNALID, VERSION)
);