The CIM_D_OTS_DATA table in SAP ERP or S/4HANA stores One Time Supplier Data data. There are total 38 fields in CIM_D_OTS_DATA table. The One Time Supplier Data 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 CIM_D_OTS_DATA table. It is in CIM: Unified data model (APPL_CIM_DATA_MODEL) ABAP package and is part of the Central Invoice Management Hub (MM-IV-HUB) module.
SAP CIM_D_OTS_DATA Table Fields
Following is the list of fields that are available in SAP CIM_D_OTS_DATA table. The primary key fields of the table are MANDT (Client), PRMTHBRPLDSUPPLIERINVOICEUUID (Universal Unique Identifier).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| PRMTHBRPLDSUPPLIERINVOICEUUID | Universal Unique Identifier | CIM_UUID | RAW (16) | |
| ONETIMESUPPLIERNAME1 | Name 1 | NAME1_GP | CHAR (35) | |
| ONETIMESUPPLIERNAME2 | Name 2 | NAME2_GP | CHAR (35) | |
| ONETIMESUPPLIERNAME3 | Name 3 | NAME3_GP | CHAR (35) | |
| ONETIMESUPPLIERNAME4 | Name 4 | NAME4_GP | CHAR (35) | |
| POSTALCODE | Postal Code | PSTLZ | CHAR (10) | |
| CITYNAME | City | ORT01_GP | CHAR (35) | |
| COUNTRY | Country Key | LAND1_GP | CHAR (3) | |
| STREETADDRESSNAME | Street and House Number | STRAS_GP | CHAR (35) | |
| POBOX | PO Box | PFACH | CHAR (10) | |
| POBOXPOSTALCODE | P.O. Box Postal Code | PSTL2 | CHAR (10) | |
| POSTOFFICEBANKACCOUNT | PO Bank Current Acct No. or Building Society Ref. No. | PSKTO | CHAR (16) | |
| BANKACCOUNT | Bank account number | BANKN | CHAR (18) | |
| BANKNUMBER | Bank number | BANKL | CHAR (15) | |
| BANKCOUNTRY | Bank country key | BANKS | * | CHAR (3) |
| SUPPLIERTAXID1 | Tax Number 1 | STCD1 | CHAR (16) | |
| SUPPLIERTAXID2 | Tax Number 2 | STCD2 | CHAR (11) | |
| SUPPLIERTAXID3 | Tax Number 3 | STCD3 | CHAR (18) | |
| SUPPLIERTAXID4 | Tax Number 4 | STCD4 | CHAR (18) | |
| SUPPLIERTAXID5 | Tax Number 5 | STCD5 | CHAR (60) | |
| VATLIABILITY | Liable for VAT | STKZU | CHAR (1) | |
| BPISEQUALIZATIONTAXSUBJECT | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR (1) | |
| ADDRESSREGION | Region (State, Province, County) | REGIO | * | CHAR (3) |
| BANKCONTROLKEY | Bank Control Key | BKONT | CHAR (2) | |
| DATAEXCHANGEINSTRUCTION | Instruction key for data medium exchange | DTAWS | * | CHAR (2) |
| DATAMEDIUMEXCHANGEINDICATOR | Report key for data medium exchange | DTAMS | CHAR (1) | |
| LANGUAGE | Character field of length 1 | CHAR_LG_01 | CHAR (1) | |
| SUPPLIERISONETIMEACCOUNT | Indicator: Is the account a one-time account? | XCPDK | CHAR (1) | |
| PAYMENTRECIPIENT | Payment Recipient Code | EMPFG | CHAR (16) | |
| ISNATURALPERSON | Natural Person | STKZN | CHAR (1) | |
| BANKDETAILREFERENCE | Reference specifications for bank details | BKREF | CHAR (20) | |
| REPRESENTATIVENAME | Name of Representative | REPRES | CHAR (10) | |
| BUSINESSTYPE | Type of Business | GESTYP | * | CHAR (30) |
| INDUSTRYTYPE | Type of Industry | INDTYP | * | CHAR (30) |
| FORMOFADDRESS | Title | ANRED | CHAR (15) | |
| VATREGISTRATION | VAT Registration Number | STCEG | CHAR (20) | |
| ACCOUNTINGCLERKINTERNETADDRESS | Internet address of partner company clerk | INTAD | CHAR (130) |
