_SOURCE

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SOURCE (
    CHARTOFACCOUNTS,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONRECORDNUMBER,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONVERSION,
    FINANCIALSTATEMENTITEM,
    FROMFISCALYEARPERIOD,
    GROUPSTRUCFROMFISCALYEARPERIOD,
    HIERARCHYNODE,
    LANGUAGE,
    METHASSGMTFROMFISCALYEARPERIOD,
    VALIDITYENDDATE,
    _CNSLDTNVERSION,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    ADDITIONALMASTERDATASOURCE,
    AMOUNTINGROUPCURRENCY,
    AMOUNTINLOCALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCLASS,
    ASSIGNMENTREFERENCE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BILLINGDOCUMENTTYPE,
    BILLTOPARTY,
    BREAKDOWNCATEGORY,
    BSL,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    CNSLDTNFSITEMMAPPING,
    CNSLDTNFSITEMMAPPINGREVISION,
    CNSLDTNISADDITIONALMASTERDATA,
    CNSLDTNOFFSETTINGTARGETFSITEM,
    CNSLDTNSUBITEMSOURCE,
    CNSLDTNUNITGROUPCRCYSOURCE,
    CNSLDTNUNITLOCALCRCYSOURCE,
    COMPANY,
    COMPANYCODE,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONINVESTMENTMETHOD,
    CONSOLIDATIONLEDGER,
    CONSOLIDATIONUNITLOCALCURRENCY,
    CONTROLLINGAREA,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COUNTRY,
    CREATIONDATETIME,
    CSL,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNEL,
    DIVESTITUREFISCALYEARPERIOD,
    DIVESTITUREISATBEGINOFPERIOD,
    DIVESTITUREISDUETOMERGER,
    DOCUMENTENTRYISINGROUPCURRENCY,
    DOMAINVALUE,
    DSL,
    ELIMINATIONTARGETFSITEM,
    ESL,
    ETAG,
    FINANCIALCLOSINGSTEP,
    FINANCIALPLANNINGDATAPACKET,
    FINANCIALPLANNINGENTRYITEM,
    FINANCIALPLANNINGREQTRANSSQNC,
    FINANCIALSTATEMENTITEMISBLKD,
    FINANCIALSTATEMENTITEMLONGTEXT,
    FINANCIALSTATEMENTITEMMDMTEXT,
    FINANCIALSTATEMENTITEMROLE,
    FINANCIALSTATEMENTITEMTEXT,
    FINANCIALSTATEMENTITEMTYPE,
    FINANCIALTRANSACTIONTYPE,
    FIRSTCNSLDTNFISCALYEARPERIOD,
    FIRSTCNSLDTNISATENDOFPERIOD,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARPERIOD,
    FSITEMCASHFLOW,
    FSITEMCURRENCYTRANSLATION,
    FSITEMCUSTOMERSPECIFIC,
    FSITEMDATACOLLECTION,
    FSITEMELIMINATION,
    FSITEMLINK,
    FSITEMLINKLABEL,
    FSITEMMAPPINGVERSION,
    FSITEMSCOPE,
    FSL,
    FUNCTIONALAREA,
    GLACCOUNT,
    GROUPCURRENCY,
    GROUPMASTERFIXEDASSET,
    GROUPSTRUCTOFISCALYEARPERIOD,
    GSL,
    HIERARCHYNODELEVEL,
    HIERARCHYNODESEQUENCE,
    HIERARCHYNODETEXT,
    HIERARCHYVERSION,
    ISCONSOLIDATIONITEM,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LEDGER,
    LEDGERFISCALPERIOD,
    LEDGERFISCALYEAR,
    LEDGERFISCALYEARPERIOD,
    LEDGERGLLINEITEM,
    LOCALCURRENCY,
    MATERIAL,
    MATERIALGROUP,
    METHASSGMTTOFISCALYEARPERIOD,
    METHCHANGEISATBEGINOFPERIOD,
    NCITARGETFSITEM,
    NETBALANCEISCARRIEDFORWARD,
    NODETYPE,
    ORDERID,
    ORGANIZATIONDIVISION,
    OSL,
    PARENTNODE,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREA,
    PARTNERPROFITCENTER,
    PARTNERSEGMENT,
    PLANNINGTARGETFSITEM,
    PLANT,
    PROFITCENTER,
    PROJECT,
    QUANTITYINBASEUNIT,
    REFERENCEDOCUMENTNUMBER,
    REFERENCEFISCALYEAR,
    SALESDISTRICT,
    SALESORGANIZATION,
    SEGMENT,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SOURCELEDGER,
    SUBITEM,
    SUBITEMCATEGORY,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    TOFISCALYEARPERIOD,
    TRANSACTIONCURRENCY,
    UNIVERSALHIERARCHYTEXT,
    VALIDITYSTARTDATE,
    VSL,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (CHARTOFACCOUNTS, CONSOLIDATIONCHARTOFACCOUNTS, CONSOLIDATIONGROUP, CONSOLIDATIONRECORDNUMBER, CONSOLIDATIONUNIT, CONSOLIDATIONVERSION, FINANCIALSTATEMENTITEM, FROMFISCALYEARPERIOD, GROUPSTRUCFROMFISCALYEARPERIOD, HIERARCHYNODE, LANGUAGE, METHASSGMTFROMFISCALYEARPERIOD, VALIDITYENDDATE)
);