P_ACTPLNSEMTAGANDSUBLDGRITM

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.

-- Plan&Actual G/L Account Item Union by SemTag and SLALITTYPE
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ACTPLNSEMTAGANDSUBLDGRITM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    CURRENCYFIELD,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    LINEISSEMTAGCALCULATED,
    SEMANTICTAG,
    SOURCELEDGER,
    _ACCOUNTINGDOCUMENTTYPE,
    _BASEUNIT,
    _BILLTOPARTY,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTANALYSISRESOURCE,
    _COSTSOURCEUNIT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _CUSTOMERSUPPLIERINDUSTRY,
    _DISTRIBUTIONCHANNEL,
    _EMPLOYMENT,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _FUNCTIONALAREA,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _LEDGER,
    _MATERIAL,
    _ORDER,
    _ORIGINCOSTCTRACTIVITYTYPE,
    _ORIGINPROFITCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _PLANT,
    _PROFITCENTER,
    _PROJECTBASICDATA,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESORDER,
    _SALESORDERITEM,
    _SALESORGANIZATION,
    _SEGMENT,
    _SEMANTICTAG,
    _SERVICEDOCUMENT,
    _SHIPTOPARTY,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP,
    _SOURCELEDGER,
    _SUPPLIER,
    _WBSELEMENTBASICDATA,
    _WORKPACKAGE,
    _WORKPACKAGEWORKITEM,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ACCRUEDCOGSAMTINDSPCRCY,
    ACCRUEDREVENUEAMTINDSPCRCY,
    ACTLFIXEDCOSTINDSPCRCY,
    ACTUALCOSTAMTINDSPCRCY,
    ACTUALPLANCODE,
    ACTUALSALESDDCTDINDSPCRCY,
    ACTUALVALUATIONQUANTITY,
    ADMINOVERHEADAMTINDSPCRCY,
    AMOUNTINDISPLAYCURRENCY,
    ASSETCLASS,
    BASEUNIT,
    BDGTCTRLDBDGTCOSTINDSPCRCY,
    BILLABLECONTROL,
    BILLEDHOURSQUANTITY,
    BILLEDREVENUEAMTINDSPCRCY,
    BILLTOPARTY,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSINESSTRANSACTIONTYPE,
    CAPAMOUNTINDSPCRCY,
    CHARTOFACCOUNTS,
    COGSADJUSTMENTAMTINDSPCRCY,
    COMPLETEDWORKQUANTITY,
    CONDITIONCONTRACT,
    CONFIRMEDHOURSQUANTITY,
    CONTROLLINGAREA,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTOFGOODSSOLDAMTINDSPCRCY,
    COSTSOURCEUNIT,
    CURRENCY,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DEFERREDCOGSAMTINDSPCRCY,
    DEFERREDREVENUEAMTINDSPCRCY,
    DISTRIBUTIONCHANNEL,
    DOCUMENTITEMTEXT,
    DOWNPAYMENTAMOUNTINDSPCRCY,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINDSPCRCY,
    FUNCTIONALAREA,
    FXDCOGSAMTINDSPCRCY,
    GLACCOUNT,
    IMMINENTLOSSRSRVADJAMTINDC,
    IMMNTLOSSRSRVBALSHTAMTINDC,
    INPTPRVARCAMTINDSPCRCY,
    INPTQTYVARCAMTINDSPCRCY,
    INPTRMNGVARCAMTINDSPCRCY,
    ISCOMMITMENT,
    LEDGERFISCALYEAR,
    LOTSIZEVARCAMTINDSPCRCY,
    MARKETINGOVHDAMTINDSPCRCY,
    MATERIAL,
    MATLSTKAMTINDSPCRCY,
    MNLCONTRACCRBALSHTAMTINDSPCRCY,
    MNLCONTRACCRINCSTATAMTINDC,
    MNLCONTRACCRPNLITMAMTINDSPCRCY,
    NONBILLABLEAMTINDSPCRCY,
    NONBILLABLEHOURSQUANTITY,
    ORDERCATEGORY,
    ORDERID,
    ORDERTYPE,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINPROFITCENTER,
    OUTPPRVARCAMTINDSPCRCY,
    PARTNERCOSTCTRACTIVITYTYPE,
    PERSONNELNUMBER,
    PLANNEDCOSAMTINDSPCRCY,
    PLANNEDREVENUEAMTINDSPCRCY,
    PLANNINGCATEGORY,
    PLANT,
    PLANVALUATIONQUANTITY,
    POSTINGDATE,
    PRICEDIFFAMTINDISPLAYCRCY,
    PROFITCENTER,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PURCHASINGDOCUMENT,
    QUANTITY,
    RECOGNIZEDCOGSAMTINDSPCRCY,
    RECOGNIZEDMARGAMTINDISPLAYCRCY,
    RECOGNIZEDREVNAMTINDSPCRCY,
    REVENUEADJUSTMENTAMTINDSPCRCY,
    RNDOVERHEADAMTINDSPCRCY,
    RSCEUSGEVARCAMTINDSPCRCY,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SALESOVERHEADAMTINDSPCRCY,
    SEGMENT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SERVICESRENDEREDDATE,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    TIMECONFIRMATIONAMTINDSPCRCY,
    TIMESHEETOVERTIMECATEGORY,
    UNBILLEDREVNINDSPCRCY,
    VALUATIONAREA,
    WBSELEMENTINTERNALID,
    WIPAMTINDISPLAYCURRENCY,
    WIPHOURSQUANTITY,
    WIPPRODNAMTINDSPCRCY,
    WORKITEM,
    WORKPACKAGE,
    WRITTENOFFAMTINDSPCRCY,
    WRITTENOFFHOURSQUANTITY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, CURRENCYFIELD, FINANCIALPLANNINGDATAPACKET, FINANCIALPLANNINGENTRYITEM, FINANCIALPLANNINGREQTRANSSQNC, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, LINEISSEMTAGCALCULATED, SEMANTICTAG, SOURCELEDGER)
);