SAP ABAP Table /DSD/ME_CUST_HD (DSD CN: Customer Details)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ LE-DSD-DC-CN (Application Component) DSD Connector
⤷ /DSD/ME (Package) DSD Connector
⤷ LE-DSD-DC-CN (Application Component) DSD Connector
⤷ /DSD/ME (Package) DSD Connector
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | /DSD/ME_CUST_HD | Table Relationship Diagram |
Short Description | DSD CN: Customer Details |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | CUST_NO | /DSD/ME_CUSTNO | CHAR10 | CHAR | 10 | 0 | DSD Connector: Customer Number | ||
3 | REF_CPD | /DSD/ME_REFCPD | CHAR1 | CHAR | 1 | 0 | DSD Connector: Ref. CPD Flag | ||
4 | HH_CREATE | /DSD/ME_HH_CREATE | CHAR1 | CHAR | 1 | 0 | DSD Connector: HH Create flag | ||
5 | COUNTRY | /DSD/ME_COUNTRY | CHAR3 | CHAR | 3 | 0 | DSD Connector: Country Code | ||
6 | NAME | /DSD/ME_NAME | CHAR35 | CHAR | 35 | 0 | DSD Connector: Name | ||
7 | ADDRESS | /DSD/ME_ADDRESS | CHAR40 | CHAR | 40 | 0 | DSD Connector: Address | ||
8 | STREET | /DSD/ME_STREET | CHAR35 | CHAR | 35 | 0 | DSD Connector: Street | ||
9 | CITY | /DSD/ME_CITY | CHAR35 | CHAR | 35 | 0 | DSD Connector: City | ||
10 | DISTRICT | /DSD/ME_DISTRICT | CHAR35 | CHAR | 35 | 0 | DSD Connector: District | ||
11 | REGION | /DSD/ME_REGION | CHAR3 | CHAR | 3 | 0 | DSD Connector: Region | ||
12 | PCODE | /DSD/ME_PCODE | CHAR10 | CHAR | 10 | 0 | DSD Connector: Post Code | ||
13 | PHONE | /DSD/ME_PHONE | CHAR16 | CHAR | 16 | 0 | DSD Connector: Phone number | ||
14 | SALES_ORG | /DSD/ME_SALES_ORG | CHAR4 | CHAR | 4 | 0 | DSD Connector: Sales Organization | ||
15 | DIST_CHANNEL | /DSD/ME_DIST_CHANNEL | CHAR2 | CHAR | 2 | 0 | DSD Connector: Distribution Channel | ||
16 | DIVISION | /DSD/ME_DIVISION | CHAR2 | CHAR | 2 | 0 | DSD Connector: Division | ||
17 | PRC_LIST | /DSD/ME_PRC_LIST | CHAR2 | CHAR | 2 | 0 | DSD Connector: Pricing List | ||
18 | LANGUAGE | /DSD/ME_LANGUAGE | CHAR2 | CHAR | 2 | 0 | DSD Connector: Language | ||
19 | BILL_BLOCK | /DSD/ME_BILL_BLOCK | CHAR1 | CHAR | 1 | 0 | DSD Connector: Bill Block | ||
20 | DELV_BLOCK | /DSD/ME_DELV_BLOCK | CHAR1 | CHAR | 1 | 0 | DSD Connector: Delivery Block | ||
21 | SALE_BLOCK | /DSD/ME_SALE_BLOCK | CHAR1 | CHAR | 1 | 0 | DSD Connector: Order Block | ||
22 | EMPTY_DEPOSIT | /DSD/ME_EMPTY_DEPOSIT | CHAR1 | CHAR | 1 | 0 | DSD Connector: Empty Deposit | ||
23 | EMPTY_UPDATE | /DSD/ME_EMPTY_UPDATE | CHAR1 | CHAR | 1 | 0 | DSD Connector: Empty Update | ||
24 | SOLD_TO_NO | /DSD/ME_SOLD_TO_NO | CHAR10 | CHAR | 10 | 0 | DSD Connector: Sold to number | ||
25 | BILL_TO_NO | /DSD/ME_BILL_TO_NO | CHAR10 | CHAR | 10 | 0 | DSD Connector: Bill to Number | ||
26 | SHIP_TO_NO | /DSD/ME_SHIP_TO_NO | CHAR10 | CHAR | 10 | 0 | DSD Connector: Ship to number | ||
27 | PAYER_NO | /DSD/ME_PAYER_NO | CHAR10 | CHAR | 10 | 0 | DSD Connector: Payer Number | ||
28 | COLLECT_TYPE | /DSD/ME_COLLECT | CHAR1 | CHAR | 1 | 0 | DSD Connector: Flag Last Field | ||
29 | PYMT_METHOD | /DSD/ME_PYMT_METHOD | CHAR1 | CHAR | 1 | 0 | DSD Connector: Payment Method | ||
30 | INV_GEN | /DSD/ME_INV_GEN | CHAR1 | CHAR | 1 | 0 | DSD Connector: Invoice generating | ||
31 | POD_INV | /DSD/ME_POD_INV | CHAR1 | CHAR | 1 | 0 | DSD Connector: POD Invoice | ||
32 | INV_MSTAT | /DSD/ME_INV_MSTAT | CHAR1 | CHAR | 1 | 0 | DSD Connector: Flag for invoice or monthly statement | ||
33 | PAY_CODE | /DSD/ME_ZTERM | CHAR4 | CHAR | 4 | 0 | DSD Connector: Payment term key (code) | ||
34 | PAY_TERMS | /DSD/ME_PAY_TERMS | CHAR40 | CHAR | 40 | 0 | DSD Connector: Payment term | ||
35 | C_CTR_AREA | /DSD/ME_C_CTR_AREA | CHAR4 | CHAR | 4 | 0 | DSD Connector: Credit Control Area | ||
36 | CRED_DATE | /DSD/ME_CRED_DATE | DATS | DATS | 8 | 0 | DSD Connector: Credit created date | ||
37 | CRED_TIME | /DSD/ME_CRED_TIME | TIME | TIMS | 6 | 0 | DSD Connector: Credit created time | ||
38 | DAYS_ARREARS | /DSD/ME_DAYS_ARREARS | DEC6 | DEC | 6 | 0 | DSD Connector: Days in Arrears | ||
39 | DUE_ITEMS | /DSD/ME_DUE_ITEMS | /DSD/ME_DEC23_4 | DEC | 23 | 4 | DSD Connector: Due Items | ||
40 | CRED_LIMIT | /DSD/ME_CRED_LIMIT | BAPICURR | DEC | 23 | 4 | DSD Connector: Credit Limit | ||
41 | CNTRY_BK | /DSD/ME_CNTRY_BK | CHAR3 | CHAR | 3 | 0 | DSD Connector: Country Bank | ||
42 | BK_KEY | /DSD/ME_BK_KEY | CHAR15 | CHAR | 15 | 0 | DSD Connector: Bank Key | ||
43 | BK_ACC | /DSD/ME_BK_ACC | CHAR18 | CHAR | 18 | 0 | DSD Connector: Bank Account Number | ||
44 | PY_C_TYPE | /DSD/ME_PY_C_TYPE | CHAR4 | CHAR | 4 | 0 | DSD Connector: Payment Card Type | ||
45 | PY_C_NUM | /DSD/ME_PY_C_NUM | /DSD/ME_NUMC25 | NUMC | 25 | 0 | DSD Connector: Payment Card Number | ||
46 | PY_C_EXP | /DSD/ME_PY_C_EXP | DATS | DATS | 8 | 0 | DSD Connector: Payment Card Expiration Date | ||
47 | VATREG_NO | /DSD/ME_VATREG_NO | CHAR20 | CHAR | 20 | 0 | DSD Connector: VAT Registration Number | ||
48 | JURIS_CODE | /DSD/ME_JURIS_CODE | CHAR15 | CHAR | 15 | 0 | DSD Connector: Jurisdiction Code | ||
49 | TAX_CAT1 | /DSD/ME_TAX_CAT | CHAR4 | CHAR | 4 | 0 | DSD Connector: Tax Category | ||
50 | TAX_CLASS1 | /DSD/ME_TAX_CLASS | CHAR1 | CHAR | 1 | 0 | DSD Connector: Tax Class | ||
51 | TAX_CAT2 | /DSD/ME_TAX_CAT | CHAR4 | CHAR | 4 | 0 | DSD Connector: Tax Category | ||
52 | TAX_CLASS2 | /DSD/ME_TAX_CLASS | CHAR1 | CHAR | 1 | 0 | DSD Connector: Tax Class | ||
53 | TAX_CAT3 | /DSD/ME_TAX_CAT | CHAR4 | CHAR | 4 | 0 | DSD Connector: Tax Category | ||
54 | TAX_CLASS3 | /DSD/ME_TAX_CLASS | CHAR1 | CHAR | 1 | 0 | DSD Connector: Tax Class | ||
55 | PRICE_GROUP | /DSD/ME_PRICE_GROUP | CHAR2 | CHAR | 2 | 0 | DSD Connector: Price Group | ||
56 | COMP_CODE | /DSD/ME_COMPANY_CODE | CHAR4 | CHAR | 4 | 0 | DSD Connector: Company code | ||
57 | DELIV_COUNTRY | /DSD/ME_COUNTRY | CHAR3 | CHAR | 3 | 0 | DSD Connector: Country Code | ||
58 | DEST_COUNTRY | /DSD/ME_COUNTRY | CHAR3 | CHAR | 3 | 0 | DSD Connector: Country Code | ||
59 | LEGAL_NUM1 | /DSD/ME_STCD1 | CHAR16 | CHAR | 16 | 0 | DSD Connector: Tax number 1 | ||
60 | LEGAL_NUM2 | /DSD/ME_STCD2 | CHAR11 | CHAR | 11 | 0 | DSD Connector: Tax number 2 | ||
61 | CASH_PAYER | /DSD/ME_FLAG | CHAR1 | CHAR | 1 | 0 | DSD Connector: Flag | ||
62 | CASH_PAYER_AF | /DSD/ME_FLAG | CHAR1 | CHAR | 1 | 0 | DSD Connector: Flag | ||
63 | INVOICE_PAYER | /DSD/ME_FLAG | CHAR1 | CHAR | 1 | 0 | DSD Connector: Flag | ||
64 | PLANT | /DSD/ME_PLANT_CODE | CHAR4 | CHAR | 4 | 0 | DSD Connector: plant code | ||
65 | CUSTOMER_GROUP | /DSD/ME_CUST_GROUP | CHAR2 | CHAR | 2 | 0 | DSD Connector: Customer Group | ||
66 | EXTFLD1 | /DSD/ME_EXT30 | CHAR30 | CHAR | 30 | 0 | DSD Connector: Extension field(30Char) | ||
67 | EXTFLD2 | /DSD/ME_EXT60 | CHAR60 | CHAR | 60 | 0 | DSD Connector: Extension field(60Char) | ||
68 | EXTFLD3 | /DSD/ME_EXT60 | CHAR60 | CHAR | 60 | 0 | DSD Connector: Extension field(60Char) | ||
69 | EXTFLD4 | /DSD/ME_EXT60 | CHAR60 | CHAR | 60 | 0 | DSD Connector: Extension field(60Char) | ||
70 | EXTFLD5 | /DSD/ME_EXT60 | CHAR60 | CHAR | 60 | 0 | DSD Connector: Extension field(60Char) | ||
71 | EXTFLD6 | /DSD/ME_EXT60 | CHAR60 | CHAR | 60 | 0 | DSD Connector: Extension field(60Char) | ||
72 | UPDFLG | /DSD/ME_FLAG | CHAR1 | CHAR | 1 | 0 | DSD Connector: Flag | ||
73 | UPDTS | TIMESTAMPL | TZNTSTMPL | DEC | 21 | 7 | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
74 | ME_ACTION | /DSD/ME_MEACTION | CHAR | 1 | 0 | DSD Connector: ME Action | |||
75 | NAME2 | /DSD/ME_NAME | CHAR35 | CHAR | 35 | 0 | DSD Connector: Name | ||
76 | NAME3 | /DSD/ME_NAME | CHAR35 | CHAR | 35 | 0 | DSD Connector: Name | ||
77 | NAME4 | /DSD/ME_NAME | CHAR35 | CHAR | 35 | 0 | DSD Connector: Name | ||
78 | CUST_GROUP_TEXT | /DSD/ME_CUST_GROUP_TEXT | CHAR | 20 | 0 | DSD Connector: Customer Group Text | |||
79 | CUSTOMER_GROUP1 | /DSD/ME_CUST_GROUP1 | CHAR | 3 | 0 | DSD Connector: Customer Group 1 | |||
80 | CUST_GROUP1_TEXT | /DSD/ME_CUST_GROUP1_TEXT | CHAR | 20 | 0 | DSD Connector: Customer Group 1 Text | |||
81 | STR_SUPPL1 | AD_STRSPP1 | TEXT40 | CHAR | 40 | 0 | Street 2 | ||
82 | STR_SUPPL2 | AD_STRSPP2 | TEXT40 | CHAR | 40 | 0 | Street 3 | ||
83 | LEGAL_NUM3 | STCD3 | CHAR18 | CHAR | 18 | 0 | Tax Number 3 | ||
84 | NAT_PERS_IND | STKZN | STKZN | CHAR | 1 | 0 | Natural Person | ||
85 | COUNTY_CODE | COUNC | COUNC | CHAR | 3 | 0 | County Code | * | |
86 | CITY_CODE | CITYC | CITYC | CHAR | 4 | 0 | City Code | * | |
87 | BBBNR | BBBNR | NUM07 | NUMC | 7 | 0 | International location number (part 1) | ||
88 | BBSNR | BBSNR | NUM05 | NUMC | 5 | 0 | International location number (Part 2) | ||
89 | BUBKZ | BUBKZ | NUM01 | NUMC | 1 | 0 | Check digit for the international location number | ||
90 | CARD_GUID | CARD_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Payment Card |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /DSD/ME_CUST_HD | CLIENT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 461 |