SAP Table BAPICUSTOMER_04
BAPI Interface Structure/GetDetail/General Data
BAPICUSTOMER_04 (BAPI Interface Structure/GetDetail/General Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BAPICUSTOMER_04 to other SAP tables.
BAPICUSTOMER_04 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
CUSTOMER | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||
NAME | Name 1 | NAME1_GP | CHAR | 35 | 0 | |||
NAME_2 | Name 2 | NAME2_GP | CHAR | 35 | 0 | |||
NAME_3 | Name 3 | NAME3_GP | CHAR | 35 | 0 | |||
NAME_4 | Name 4 | NAME4_GP | CHAR | 35 | 0 | |||
CITY | City | ORT01_GP | CHAR | 35 | 0 | |||
DISTRICT | District | ORT02_GP | CHAR | 35 | 0 | |||
PO_BOX | PO Box | PFACH | CHAR | 10 | 0 | |||
POBX_PCD | P.O. Box Postal Code | PSTL2 | CHAR | 10 | 0 | |||
POSTL_CODE | Postal Code | PSTLZ | CHAR | 10 | 0 | |||
REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||
COUNTYCODE | County Code | COUNC | T005E | CHAR | 3 | 0 | ||
CITY_CODE | City Code | CITYC | T005G | CHAR | 4 | 0 | ||
STREET | House number and street | STRAS_GP | CHAR | 35 | 0 | |||
TELEPHONE | First telephone number | TELF1 | CHAR | 16 | 0 | |||
COUNTRY | Country Key | LAND1_GP | T005 | CHAR | 3 | 0 | ||
COUNTRYISO | Country ISO code | INTCA | CHAR | 2 | 0 | |||
POBX_CTY | PO Box city | PFORT_GP | CHAR | 35 | 0 | |||
LANGU | Language Key | SPRAS | LANG | 1 | 0 | |||
LANGU_ISO | 2-Character SAP Language Code | LAISO | CHAR | 2 | 0 | |||
SORT_FLD | Sort field | SORTL | CHAR | 10 | 0 | |||
MATCHCODE1 | Search term for matchcode search | MCDD1 | CHAR | 25 | 0 | |||
MATCHCODE2 | Search Term for Matchcode Search | MCDD2 | CHAR | 25 | 0 | |||
MATCHCODE3 | Search term for matchcode search | MCDD3 | CHAR | 25 | 0 | |||
FORMOFADDR | Title | ANRED | CHAR | 15 | 0 | |||
TELEBOX | Telebox number | TELBX | CHAR | 15 | 0 | |||
TELEPHONE2 | Second telephone number | TELF2 | CHAR | 16 | 0 | |||
TELETEX | Teletex number | TELTX | CHAR | 30 | 0 | |||
TELEX | Telex number | TELX1 | CHAR | 30 | 0 | |||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | 0 | |||
NIELSEN_ID | Nielsen ID | NIELS | CHAR | 2 | 0 |
BAPICUSTOMER_04 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
BAPICUSTOMER_04 | CITY_CODE | BAPICUSTOMER_04 | REGION | T005G | City | REGIO |
BAPICUSTOMER_04 | CITY_CODE | BAPICUSTOMER_04 | CITY_CODE | T005G | City | CITYC |
BAPICUSTOMER_04 | CITY_CODE | SYST | MANDT | T005G | City | MANDT |
BAPICUSTOMER_04 | CITY_CODE | BAPICUSTOMER_04 | COUNTRY | T005G | City | LAND1 |
BAPICUSTOMER_04 | COUNTRY | SYST | MANDT | T005 | Countries | MANDT |
BAPICUSTOMER_04 | COUNTRY | BAPICUSTOMER_04 | COUNTRY | T005 | Countries | LAND1 |
BAPICUSTOMER_04 | COUNTYCODE | SYST | MANDT | T005E | County | MANDT |
BAPICUSTOMER_04 | COUNTYCODE | BAPICUSTOMER_04 | COUNTRY | T005E | County | LAND1 |
BAPICUSTOMER_04 | COUNTYCODE | BAPICUSTOMER_04 | REGION | T005E | County | REGIO |
BAPICUSTOMER_04 | COUNTYCODE | BAPICUSTOMER_04 | COUNTYCODE | T005E | County | COUNC |
BAPICUSTOMER_04 | CUSTOMER | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
BAPICUSTOMER_04 | CUSTOMER | BAPICUSTOMER_04 | CUSTOMER | KNA1 | General Data in Customer Master | KUNNR |
BAPICUSTOMER_04 | REGION | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
BAPICUSTOMER_04 | REGION | BAPICUSTOMER_04 | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
BAPICUSTOMER_04 | REGION | BAPICUSTOMER_04 | REGION | T005S | Taxes: Region (Province) Key | BLAND |