TEXT

TEXT is an SAP database table in S/4HANA. It contains 34 fields.

Fields (34)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument,BillingDocumentRequest,PrelimBillingDocument 5
KEY BillingDocumentItem BillingDocumentItem,PrelimBillingDocumentItem 2
KEY HCMCourseLanguage Language 1
KEY hryid HierarchyID 1
KEY Language Language,LanguageForEdit 8
KEY LongTextID LongTextID,LongTextIDForEdit 6
KEY spras Language 1
ABAPPackageName ABAPPackageName 1
antyp_desc ACMAnalysisTypeText 1
as4text description 1
AssignedSupplyTypeName AssignedSupplyTypeName 1
AuditCompAuthznGroupText AuditCompAuthznGroupText 1
CATechnicalResourceIDTypeName CATechnicalResourceIDTypeName 1
CharcValueDescription CharcValueDescription 1
CountryName CountryName 1
ddlanguage Language 1
ddtext BusEvtLgChgDocOldFldValText,MasterDataLoadAssaySubjectText,PrepaymentReqPostStatusText,TextTypeDescription 4
descript nodetxt 2
description CountryName,Description,forward_channel_description,import_channel_description,import_channel_forecast_descr,SI_IntlInstitutionCodeText 7
domvalue_l DomainValueLow 1
fldlogsmatltrckgmlstntext FldLogsMatlTrckgMlstnText 1
fldlogsmatltrckgststext FldLogsStatusTxt 1
HCMCourseDeliveryMethodText HCMCourseDeliveryMethodText 1
hrytxt CtrlObjNameForWBSElement 1
LongText LongText 6
MfgBuyOffDescription MfgBuyOffDescription 1
NationalityName NationalityName 1
p_description_20 Description 1
PurchasingDocumentTypeName OrderTypeName 1
SalesDocumentTypeName SalesDocumentTypeName 1
SystemStatusName EWMWarehouseRequestStatusName 1
text ACMToleranceScheduleIdText 1
utyplongtext utyplongtext 1
vtext CustomerPaymentTermDescription 1

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 (
    BILLINGDOCUMENT,
    BILLINGDOCUMENTITEM,
    HCMCOURSELANGUAGE,
    HRYID,
    LANGUAGE,
    LONGTEXTID,
    SPRAS,
    ABAPPACKAGENAME,
    ANTYP_DESC,
    AS4TEXT,
    ASSIGNEDSUPPLYTYPENAME,
    AUDITCOMPAUTHZNGROUPTEXT,
    CATECHNICALRESOURCEIDTYPENAME,
    CHARCVALUEDESCRIPTION,
    COUNTRYNAME,
    DDLANGUAGE,
    DDTEXT,
    DESCRIPT,
    DESCRIPTION,
    DOMVALUE_L,
    FLDLOGSMATLTRCKGMLSTNTEXT,
    FLDLOGSMATLTRCKGSTSTEXT,
    HCMCOURSEDELIVERYMETHODTEXT,
    HRYTXT,
    LONGTEXT,
    MFGBUYOFFDESCRIPTION,
    NATIONALITYNAME,
    P_DESCRIPTION_20,
    PURCHASINGDOCUMENTTYPENAME,
    SALESDOCUMENTTYPENAME,
    SYSTEMSTATUSNAME,
    TEXT,
    UTYPLONGTEXT,
    VTEXT,
    PRIMARY KEY (BILLINGDOCUMENT, BILLINGDOCUMENTITEM, HCMCOURSELANGUAGE, HRYID, LANGUAGE, LONGTEXTID, SPRAS)
);