The CFG_SD_SLSOFFADR table in SAP ERP or S/4HANA stores CBC – DDIC for eCatt /SMB99/SM30_O005_J02 data. There are total 32 fields in CFG_SD_SLSOFFADR table. The CBC – DDIC for eCatt /SMB99/SM30_O005_J02 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 CFG_SD_SLSOFFADR table. It is in ECATT replacement for Sales Office (SD_MD_SALES_OFFICE_SMB) ABAP package and is part of the Material Maintenance (SD-MD-MM) module.
SAP CFG_SD_SLSOFFADR Table Fields
Following is the list of fields that are available in SAP CFG_SD_SLSOFFADR table. The primary key fields of the table are I_MANDT (Client), I_VKBUR (Sales office).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| I_MANDT | Client | MANDT | CLNT (3) | |
| I_VKBUR | Sales office | VKBUR | CHAR (4) | |
| I_CITY1 | City | AD_CITY1 | CHAR (40) | |
| I_CITY2 | District | AD_CITY2 | CHAR (40) | |
| I_COUNTRY | Country/Region Key | LAND1 | CHAR (3) | |
| I_FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR (10) | |
| I_FAX_NUMBER | First Fax No.: Area Code + Number | AD_FXNMBR1 | CHAR (30) | |
| I_HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR (10) | |
| I_LANGU | SAP Language Key (2-letter code) | ISOLA | CHAR (2) | |
| I_LOCATION | Street 5 | AD_LCTN | CHAR (40) | |
| I_NAME1 | Name 1 | AD_NAME1 | CHAR (40) | |
| I_NAME2 | Name 2 | AD_NAME2 | CHAR (40) | |
| I_NAME3 | Name 3 | AD_NAME3 | CHAR (40) | |
| I_NAME4 | Name 4 | AD_NAME4 | CHAR (40) | |
| I_POST_CODE | City postal code | AD_PSTCD1 | CHAR (10) | |
| I_POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR (10) | |
| I_PO_BOX | PO Box | AD_POBX | CHAR (10) | |
| I_PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR (3) | |
| I_PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR (40) | |
| I_PO_BOX_REG | Region for PO Box (Country/Region, State, Province, …) | AD_POBXREG | CHAR (3) | |
| I_REGION | Region (State, Province, County) | REGIO | CHAR (3) | |
| I_SMTP_ADDR | E-Mail Address | AD_SMTPADR | CHAR (241) | |
| I_STREET | Street | AD_STREET | CHAR (60) | |
| I_STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR (40) | |
| I_STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR (40) | |
| I_STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR (40) | |
| I_TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR (15) | |
| I_TAXJURCODE_NV | Tax Jurisdiction | AD_TXJCD | CHAR (15) | |
| I_TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR (10) | |
| I_TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR (30) | |
| I_TIME_ZONE | Address time zone | AD_TZONE | CHAR (6) | |
| I_TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR (10) |
