The CUSTSA_TEXT_D table in SAP ERP or S/4HANA stores I_BUSINESSPARTNERTP I_BPSALESAREATEXTTP data. There are total 23 fields in CUSTSA_TEXT_D table. The I_BUSINESSPARTNERTP I_BPSALESAREATEXTTP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CUSTSA_TEXT_D table. It is in VDM Master Data BP (VDM_MD_BP) ABAP package and is part of the Business Partners (LO-MD-BP) module.
SAP CUSTSA_TEXT_D Table Fields
Following is the list of fields that are available in SAP CUSTSA_TEXT_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| ROOTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| BUSINESSPARTNER | Business Partner Number | BU_PARTNER | CHAR (10) | |
| SALESORGANIZATION | Sales Organization | VKORG | CHAR (4) | |
| DISTRIBUTIONCHANNEL | Distribution Channel | VTWEG | CHAR (2) | |
| DIVISION | Division | SPART | CHAR (2) | |
| LONGTEXTID | Text ID | TDID | CHAR (4) | |
| LANGUAGE | Language key | TDSPRAS | LANG (1) | |
| CUSTOMER | Customer Number | KUNNR | CHAR (10) | |
| BUSINESSPARTNERFOREDIT | Business Partner Number | BU_PARTNER | CHAR (10) | |
| SALESORGANIZATIONFOREDIT | Sales Organization | VKORG | CHAR (4) | |
| DISTRIBUTIONCHANNELFOREDIT | Distribution Channel | VTWEG | CHAR (2) | |
| DIVISIONFOREDIT | Division | SPART | CHAR (2) | |
| LONGTEXTIDFOREDIT | Text ID | TDID | CHAR (4) | |
| LANGUAGEFOREDIT | Language key | TDSPRAS | LANG (1) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
