_TEXT

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 _TEXT (
    ALLOCALGORITHMPARAMFXDVAL,
    BILLINGDOCUMENTTYPE,
    BUSINESSAREA,
    CHANGERECORDLIFECYCLESTATUS,
    CHARTOFACCOUNTS,
    CHGRECDCURRENTITEMPROCGSTATUS,
    CHGRECDNEXTITEMPROCGSTATUS,
    CONDITIONAPPLICATION,
    CONDITIONUSAGE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    CUSTOMER,
    CUSTOMERGROUP,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOMVALUE_L,
    EHSCMPLRQPERMITLIFECYCLENAME,
    ENVWSTTRANSPDOCSTATUSNAME,
    FINANCIALTRANSACTIONTYPE,
    FUNCTIONALAREA,
    GLACCOUNT,
    INDUSTRY,
    LANGU,
    LANGUAGE,
    ORDERID,
    PLANT,
    PRICINGCONDITIONFIELD,
    PRODUCT,
    PRODUCTDESCRIPTION,
    PRODUCTGROUP,
    PROFITCENTER,
    SALESDISTRICT,
    SALESORGANIZATION,
    SEGMENT,
    SPRAS,
    SUPPLIER,
    TEXTOBJECTTYPE,
    _LANGUAGE,
    ABOPSEGMENTDESCRIPTION,
    ABOPVARIANTDESCRIPTION,
    ACCOUNTINGTYPEDESC,
    ADDITIONALMASTERDATATEXT,
    ALLOCATIONCYCLENAMETEXT,
    ALLOCDISPLAYCURRENCYTYPENAME,
    ALLOCFIELDGROUPCOLUMNTEXT,
    ALLOCFIELDGROUPROWTEXT,
    ALTVBSDCONFSUBSTNSTRGYTEXT,
    APP_TITLE,
    APPLICATIONLOGSUBOBJECTTEXT,
    AS4TEXT,
    ASSETEVALUATIONKEYNAME,
    BANKACCOUNTCONTRACTTYPENAME,
    BANKACCOUNTDESCRIPTION,
    BANKACCOUNTTYPETEXT,
    BANKCATEGORYDESCRIPTION,
    BANKFEECHARGETYPETEXT,
    BATXT,
    BEZEI,
    BILLINGDOCUMENTTYPENAME,
    BILLINGQTLOCTEXT,
    BILLOFMATERIALVARIANTUSAGEDESC,
    BILLOFOPERATIONSTYPENAME,
    BKCHNPAYTMETHSUPLMNTINFO,
    BO_TEXT,
    BPCOUNTYTEXT,
    BROKERFEEVOLUMETYPEDESCR,
    BULKSHIPMENTEVENTTYPEDESC,
    BUSINESSAREANAME,
    BUSINESSTRANSACTIONTYPENAME,
    BUSPARTRELSHPCATDESCRIPTION2,
    CALENDARMONTHNAME,
    CAPACITYTEXT,
    CASEESCALATIONREASONNAME,
    CHARACTERISTICVALUEDESCRIPTION,
    CHARTOFACCOUNTSNAME,
    CITYCODENAME,
    CITYNAME,
    CLASSDESCRIPTION,
    CLEARING_AREAT_L,
    CLEARING_NAME,
    CMMDTYHDGBOOKAUTHZNGROUPTEXT,
    CMMDTYHEDGEDELIVERYPERIODTEXT,
    CMMDTYHEDGESPECPERIODICITYTEXT,
    CMPLRQVERSCMPLNCSTATEMENTTEXT,
    CMPLRQVERSEXEMPTIONTEXT,
    CNSLDTNINVESTMENTMETHODTEXT,
    CNSLDTNISADDITIONALMASTERDATA,
    CNVRSNASSGMTCLASSDESCRIPTION,
    COMMITMENTITEMDESCRIPTION,
    CONTACTCARD,
    CONTENT,
    CONTROLLINGAREANAME,
    CORRESPONDENCEFIRSTDATENAME,
    CORRESPONDENCESECONDDATENAME,
    COSTCENTERDESCRIPTION,
    COSTCENTERNAME,
    COSTCTRACTIVITYTYPEDESC,
    COSTCTRACTIVITYTYPENAME,
    COSTREVENUERATECODENAME,
    COUNTRYNAME,
    CURRENCYNAME,
    CURVW,
    CUSTOMERGROUPNAME,
    CUSTOMERNAME,
    DANGEROUSGOODSLISTITMADDLDESC,
    DB_KEY,
    DDLANGUAGE,
    DDTEXT,
    DELIVERYDOCUMENTTYPENAME,
    DEMANDTYPETEXT,
    DESCL,
    DESCM,
    DESCOFDNGRSGDSPCKGCOMPLETENAME,
    DESCOFDNGRSGDSPCKGNAME,
    DESCR,
    DESCRIPTION,
    DEVPROJTSKRELSHPTEXT,
    DISTRIBUTIONCHANNELNAME,
    DIVISIONNAME,
    DOMAINTEXT,
    EARMARKEDFUNDSDOCCATEGORYTEXT,
    EHSCLASSIFIERNAME,
    EHSLOCATIONNAME,
    EHSLOCCLASSIFIERTEXT,
    FASCODETEXT,
    FINANCIALACCRTRANSACTYPENAME,
    FINANCIALTRANSACTIONTYPENAME,
    FINSUBSTNVALDTNRULEDESCRIPTION,
    FINTRANSTIMETOMATURITYTEXT,
    FLDLOGSCONTAINERCATEGORYTEXT,
    FLDLOGSCONTAINERTYPETEXT,
    FLDLOGSCTNCERTIFICATETYPETEXT,
    FORECASTRESULTTYPEDESCRIPTION,
    FORECASTTYPEDESCRIPTION,
    FORMATT_L,
    FRCELMNTORGLANGUAGE,
    FRCELMNTORGPLNGSTATUSNAME,
    FRCELMNTORGUSAGETYPEDESC,
    FREIGHTPAYERDESC,
    FREQUENCYDESCRIPTION,
    FUNCTIONALAREANAME,
    FUNCTIONALLOCATIONDESCRIPTION,
    GLACCOUNTLONGNAME,
    GLACCOUNTNAME,
    GOODSMOVEMENTTYPENAME,
    GOVERNINGPARTYNAME,
    GROUP5ASSETEVALUATIONKEYNAME,
    HCMDOCUMENTCATEGORYNAME,
    HIER_TYPE_TEXT,
    IDENTDESC,
    IL_CASHSHORTDESCRIPTION,
    IL_PAYMENTASSIGNMENTTEXT,
    IMPCTMGMTOBJECTDESCRIPTION,
    IMPORTEDRECORDNAME,
    INCOTERMSVERSIONNAME,
    INDUSTRYKEYDESCRIPTION,
    INDUSTRYNAME,
    INSTRUMENTTYPEDESC,
    INSURCLMSUBOBJECTCATEGORYNAME,
    INSURCLMTRANSACTIONTYPETEXT,
    ISSUECATEGORYNAME,
    JOINTVENTURETYPETEXT,
    KTEXT,
    LANDX,
    LANGUAGENAME,
    LASTMILEVISITLISTTYPETEXT,
    LEADTIMECALCULATIONMETHODDESC,
    LGLCNTNTMDOCIMPORTANTTXT,
    LIQUIDITYITEMNAME,
    LISTINGRULECHECKTYPENAME,
    LOCATIONDESCRIPTION,
    LSTMIRTESETLRESOLUTIONCODETEXT,
    MAIFDYNAMICFORMAGENTNAME,
    MAINTEVENTTYPEDESCRIPTION,
    MAJORPRODUCTNAME,
    MATERIAL_NAME,
    MATERIALALIASDESCR,
    MATERIALGROUPNAME,
    MATERIALGROUPTEXT,
    MATERIALNAME,
    MFGBUYOFFDESCRIPTION,
    MILESTONEDESCRIPTION,
    MOTVEHICLEPROVIDERNAME,
    MSGCLASSDESC,
    NAME,
    NATIONALITYNAME,
    NETWORKMEDIUMDESCRIPTION,
    NETWORKOBJECTDESCRIPTION,
    NETWORKOBJECTTYPEDESCRIPTION,
    NOTE,
    OL_TYPET_S,
    OPERATIONACTIVITYNAME,
    ORDERDESCRIPTION,
    ORDERSTATUSTEXT,
    PATTERN_NAME,
    PAYMENTTYPENAME,
    PHYSICALINVENTORYSTOCKTYPENAME,
    PLAINLONGTEXT,
    PLANTNAME,
    PO_TYPET_L,
    PPSCONTACTCATEGORYTEXT,
    PRICINGCONDITIONFIELDTEXT,
    PROCESSINGSTATUSDESC,
    PROCMTHUBMESSAGESTATUSDESC,
    PRODALLOCASSGDORDERTYPEDESC,
    PRODALLOCOBJECTDESCRIPTION,
    PRODCMPLNCRISKLEVELDESC,
    PRODCMPLNCRISKLEVELNAME,
    PRODUCTGROUPNAME,
    PRODUCTIONSUPPLYAREANAME,
    PRODUCTNAME,
    PRODUNIVHIERARCHYNODETEXT,
    PRODUNIVHIERARCHYTEXT,
    PROFITCENTERLONGNAME,
    PROFITCENTERNAME,
    PROJECTDEMANDTYPENAME,
    PROPERSHIPPINGNAME,
    PRPSAGTWORKLISTPROCGSTATUSTXT,
    PT_SERIESBUSINESSPROCTEXT,
    PT_SERIESDOCTYPETEXT,
    PT_SERIESDOCUMENTCLASSTEXT,
    PT_SERIESPROCGCODETEXT,
    PT_SERIESTYPECODETEXT,
    PT_SUPPLIERCATEGORYTEXT,
    PURCHASINGDOCUMENTCATEGORYNAME,
    PURCHASINGDOCUMENTTYPENAME,
    PURGDOCEXTERNALITEMCATEGORY,
    PURGDOCITEMCATEGORYNAME,
    REGULATIONDESCR,
    ROUTE_NAME,
    SAC_TENANT_DESC,
    SALESDISTRICTNAME,
    SALESDOCUMENTTYPENAME,
    SALESORGANIZATIONNAME,
    SAPOBJECTTYPENAME,
    SCENARIONAME,
    SDDOCUMENTCATEGORYNAME,
    SEGMENTNAME,
    SETDESCRIPTION,
    SHELFLIFEEXPRTNDATEPERIODNAME,
    SHIFTSEQUENCENAME,
    SHIPPINGINSTRUCTIONNAME,
    SITECATEGORYNAME,
    STATEMENTOFCHANGESTYPENAME,
    STATRYRPTCATEGORYNAME,
    STATRYRPTGENTITY,
    STATUSAREADESCRIPTION,
    STATUSDESCRIPTION,
    STATUSTRENDDESCRIPTION,
    STREETNAME,
    SUPPLIERCERTORIGINCATNAME,
    SUPPLIERCONFCONTROLKEYNAME,
    SUPPLIERNAME,
    SUPPLIERSUBRANGENAME,
    SYSTEMSTATUSNAME,
    TAXJURISDICTIONNAME,
    TEXT,
    TEXT_LONG,
    TEXT_SHORT,
    TEXT40,
    TEXTDESCRIPTION,
    TITLE,
    TOWNSHIPNAME,
    TRADER_ID_TEXT,
    TRANS_TYPET_L,
    TRANSPCMMDTYCODEDESC,
    TRDCLASSFCTNNMBROFFICIALDESC,
    TRSYPOSMANAGEMENTPROCEDURENAME,
    TSNAM,
    TTEXT,
    TXT_SH,
    UNITOFMEASURENAME,
    USERDESCRIPTION,
    USFEDAGENCYLOCATIONCODETEXT,
    USFEDFIELDVALUETEXT,
    USFEDPAYMENTOFFICETEXT,
    VALIDATIONRULELONGDESCRIPTION,
    VALIDATIONRULESHORTDESCRIPTION,
    WORKCENTERTEXT,
    WORKPERMITREFERENCEOBJTYPEDESC,
    ZTEXT,
    PRIMARY KEY (ALLOCALGORITHMPARAMFXDVAL, BILLINGDOCUMENTTYPE, BUSINESSAREA, CHANGERECORDLIFECYCLESTATUS, CHARTOFACCOUNTS, CHGRECDCURRENTITEMPROCGSTATUS, CHGRECDNEXTITEMPROCGSTATUS, CONDITIONAPPLICATION, CONDITIONUSAGE, CONTROLLINGAREA, COSTCENTER, COUNTRY, CUSTOMER, CUSTOMERGROUP, DISTRIBUTIONCHANNEL, DIVISION, DOMVALUE_L, EHSCMPLRQPERMITLIFECYCLENAME, ENVWSTTRANSPDOCSTATUSNAME, FINANCIALTRANSACTIONTYPE, FUNCTIONALAREA, GLACCOUNT, INDUSTRY, LANGU, LANGUAGE, ORDERID, PLANT, PRICINGCONDITIONFIELD, PRODUCT, PRODUCTDESCRIPTION, PRODUCTGROUP, PROFITCENTER, SALESDISTRICT, SALESORGANIZATION, SEGMENT, SPRAS, SUPPLIER, TEXTOBJECTTYPE)
);