Customer Number
Technical Name: 0CUSTOMER_ATTR
Technical Data
DataSource Type |
Attributes (Master Data) |
|---|---|
Application Components |
(LO-IO) |
Available as from OLTP Release |
R/3 3.1I |
Available as from PlugIn Release |
PI 1999.1_31I |
RemoteCube-Capable |
No |
Use
This data source is used for loading customer master data to the SAP BW system.
Delta Update
Update via ALE delta
Fields of Origin for the Extract Structure
Fields in the Extract Structure |
Description of the Field in the Extract Structure |
Table of Origin |
Field in the Table of Origin |
|---|---|---|---|
ABRVW |
Usage indicator |
KNA1 |
ABRVW |
BRAN1 |
Industry code 1 |
KNA1 |
BRAN1 |
BRAN2 |
Industry code 2 |
KNA1 |
BRAN2 |
BRAN3 |
Industry code 3 |
KNA1 |
BRAN3 |
BRAN4 |
Industry code 4 |
KNA1 |
BRAN4 |
BRAN5 |
Industry code 5 |
KNA1 |
BRAN5 |
BRSCH |
Industry key |
KNA1 |
BRSCH |
COUNC |
County Code |
KNA1 |
COUNC |
DEAR6 |
Indicator: Consumer |
KNA1 |
DEAR6 |
KTOKD |
Customer Account Group |
KNA1 |
KTOKD |
KUKLA |
Customer classification |
KNA1 |
KUKLA |
LAND1 |
Country key |
KNA1 |
LAND1 |
LIFNR |
Account number of vendor or creditor |
KNA1 |
LIFNR |
LOEVM |
Central Deletion Flag for Master Record |
KNA1 |
LOEVM |
NAME1 |
Name 1 |
KNA1 |
NAME1 |
NAME2 |
Name 2 |
KNA1 |
NAME2 |
NAME3 |
Name 3 |
KNA1 |
NAME3 |
NIELS |
Nielsen ID |
KNA1 |
NIELS |
ORT01 |
City |
KNA1 |
ORT01 |
ORT02 |
District |
KNA1 |
ORT02 |
PERIV |
Fiscal year variant |
KNA1 |
PERIV |
PFACH |
P.O. Box |
KNA1 |
PFACH |
PFORT |
PO Box city |
KNA1 |
PFORT |
PSTL2 |
P.O. Box postal code |
KNA1 |
PSTL2 |
PSTLZ |
Postal Code |
KNA1 |
PSTLZ |
REGIO |
Region (State, Province, County) |
KNA1 |
REGIO |
SORTL |
Sort field |
KNA1 |
SORTL |
SPRAS |
Language Key |
KNA1 |
SPRAS |
STCD1 |
Tax number 1 |
KNA1 |
STCD1 |
STCD2 |
Tax number 2 |
KNA1 |
STCD2 |
STCD3 |
Tax Number 3 |
KNA1 |
STCD3 |
STRAS |
House number and street |
KNA1 |
STRAS |
TELF1 |
First telephone number |
KNA1 |
TELF1 |
TELFX |
Fax number |
KNA1 |
TELFX |
VBUND |
Company ID of trading partner |
KNA1 |
VBUND |
WERKS |
Plant |
KNA1 |
WERKS |
XCPDK |
Indicator: Is the account a one-time account? |
KNA1 |
XCPDK |