The table below lists the new content of the MDM 7.1 Vendor. Reasons are:
DS = prevent Data loss in Syndication PT = Performance Tuning
RE = Repository Enhancement RS = Repository Synchronization
Component What is new? Reason
Lookup Tables in general
Only the display fields within lookup tables are defined for sorting. This is required to improve the import performance. All other fields are not sorted. This decreases the repository's load time.
Each lookup table contains a Code field. The code is generally a copy of the (remote) key field. This enables user to switch of key mapping on lookup tables if they can ensure that the keys of customizing data are always identical for each remote system. Import and Syndication Maps have to be adjusted in this case.
The length of all Name fields has been aligned to the related length in the remote systems.
PT, RS
Lookup [Hierarchy]
Tables in general
Hierarchy lookup tables contain additional codes as separate fields.
The reason is that the Code field within hierarchy lookups is not unique. The additional codes combined with the actual code guarantee the uniqueness of a single record. Example: The unique code of a region consists of the concatenation of country code and region code.
RS
LT Business Types This is a flat lookup table named Business Types used by the Vendors main table.
DS
LT Communication Types
This is a flat lookup named Communication Types used by the Vendors main table.
DS
LT Delivery Service Types
This is a flat lookup named Delivery Service Types used by the Vendors main table.
DS
LT Industry Types This is a flat lookup named Industry Types used by the Vendors main table.
DS
LT Phone Number Types
This table is a flat lookup named Phone Number Types used by the Phone Numbers tuple definition.
RS
LT POD Indicators This table is a flat lookup named POD Indicators used by the Vendors main table.
DS
LT Plants This table is a flat lookup named Plants used by the Vendor main table.
It is required for the Purchasing Organization enhancement.
RE, RS
Component What is new? Reason LT Undeliverable
Reasons
This table is a flat lookup named Undeliverable Reasons used by the Vendors main table.
DS
MT Banks This main table covers the Bank Master Data. The table consists of thirteen member fields in a fixed order:
1) ID is an MDM Auto ID field used as simple counter.
2) Bank Country is a lookup to flat lookup table _Countries_.
3) Bank Name is a text field for the name of the bank.
4) Bank Key is a text field for the key of the bank. The combination of bank country and bank key has to be unique. Country, Name and Key fields are used as display fields of the main table.
5) Bank Address is a calculated field showing the full bank address.
6) Street is a text field for the bank's street and house number.
7) City is a text field for the postal code and city.
8) Region is a hierarchy lookup for the region.
9) SWIFT Code is a text field for the SWIFT code.
10) Bank Group is a text field for the bank group.
11) Bank Number is a text field for the bank number.
12) Bank Branch is a text field for the bank branch.
13) Postbank Account is a flat lookup linked with the Yes/No Indicator.
RS
MT Vendors The field Address Note is a fixed text field. DS
MT Vendors The field Alternative Payee is a main lookup field to Vendors. DS MT Vendors The field Business Type is a flat lookup field to Business Types. DS MT Vendors The field Communication Type is a flat lookup field to Communication
Types.
DS
MT Vendors The field Customer is a fixed text field. DS
MT Vendors The field Delivery Service Number is a fixed text field. DS MT Vendors The field Delivery Service Type is a flat lookup field to Delivery Service
Types.
DS
MT Vendors The field Different City is a fixed text field. DS
MT Vendors The field Fiscal Address is a main lookup field to Vendors. DS MT Vendors The field Full Address is a calculated field. It shows the street, house
number, postal code, city, country and region as concatenated value within a single string.
RS
MT Vendors The field Full Name is a calculated field. It shows the title and all the names as concatenated value within a single string.
RS
MT Vendors The field Industry Type is a flat lookup field to Industry Types. DS MT Vendors The field Instruction Key is a fixed text field. DS MT Vendors The field Last Review (External) is a literal date field. DS MT Vendors The field Name of Representative is a fixed text field. DS
Component What is new? Reason MT Vendors The field Plant is a flat lookup field to Plants. It is required for the
Purchasing Organization enhancement.
RE
MT Vendors The field Plant Level Relevant is a flat lookup field to Yes/No Indicator.
It is required for the Purchasing Organization enhancement.
RE
MT Vendors The field PO Box Address Undeliverable Reason is a flat lookup field to Undeliverable Reasons.
DS
MT Vendors The field PO Box Lobby is a fixed text field. DS
MT Vendors The field POD-Relevant is a flat lookup field to POD Indicators. DS MT Vendors The field QM System valid to is a literal date field. DS MT Vendors The field Street Address Undeliverable Reason is a flat lookup to
Undeliverable Reasons.
DS
MT Vendors The field Tax Number is a fixed text field. DS
MT Vendors The Field Tax Office is a main lookup field to Vendors. DS Tuple Bank Details This tuple definition covers Bank Details (Bank Accounts). It consists of
seven member fields in a fixed order.
1) Bank is a single-valued lookup to main table Banks.
2) Bank Account Number is a text field for the bank account number. It is the only display field of the tuple as long as MDM has the limitation of not being able to use lookup main fields as display fields within tuple definition. As soon as this limitation is resolved, the lookup main Bank will be an additional display field.
3) Bank Control Key is a text field for the bank control key.
4) Partner Bank Type is a text field for the partner bank type.
5) Reference Details is a text field for the reference details.
6) Account Holder is a text field for the account holder name.
7) Collection Authorization is a lookup to flat lookup Yes/No Indicator.
Related multi-valued tuple fields within the object main table and/or other tuple definitions carry the same name Bank Details, too.
RS
Tuple Company Code Data
This tuple definition covers the Company Code related fields. It consists of 52 fields in a fixed order. Furthermore it includes new lookup tables:
Company Codes, Dunning Notice Grouping Keys, Exemption Authorities, Interest Calculation Frequencies, Interest Calculation Indicators, Minority Indicators, Payment Advices by XML, Payment Blocks, Payment Grouping Keys, Payment Method Supplements, Payment Terms, Periodic Account Statements, Planning Groups, Prepayment Relevances, Release Approval Groups, Sort Keys, Subsidy Indicators
Clerks, House Banks, Payment Methods, Recipient Types,
Reconciliation Accounts, Tolerance Groups (Business Partner or G/L Account), Tolerance Groups (Invoice), Withholding Tax Codes, Withholding Tax Countries
RE, RS
Component What is new? Reason Tuple E-Mail
Addresses
This tuple definition covers E-Mail Addresses. It consists of five member fields in a fixed order.
1) Is Standard E-Mail Address is a lookup to the flat lookup Yes/No Indicator.
2) E-Mail Address is a text field for the E-Mail Address itself. First and second fields are the only display fields of the tuple definition.
3) Sequence Number is a text field that is a counter of the e-Mail addresses. The format is fixed (three digits with leading zeros).
4) Not Used is a lookup to the flat lookup Yes/No Indicator.
5) Is TNEF enabled? Is a lookup to the flat lookup Yes/No Indicator.
Related multi-valued tuple fields within the object main table and/or other tuple definitions carry the same name E-Mail Addresses, too.
RS
Tuple EU Tax Numbers
This tuple definition covers additional European VAT Registration Numbers for a main record. It consists of two member fields in a fixed sequence. Country is a lookup to the flat lookup table Countries. It indicates the country of the VAT Registration Number that is the second field. Both fields are display fields whereas the VAT is the first, the Country the second.
Related multi-valued tuple fields within the object main table carry the same name EU Tax Numbers, too.
RS
Tuple Fax Numbers
This tuple definition covers Fax Numbers. It consists of seven member fields in a fixed sequence.
1) Is Standard Fax Number is a lookup to flat lookup Yes/No Indicator.
It is the first display field of the tuple.
2) Fax Country is a lookup to flat lookup Countries.
3) Fax Number is a text field for the fax dialing code and number.
4) Fax Extension is a text field for the fax number extension.
5) Complete Fax Number is a text field for the complete fax number. It is the second display field of the tuple.
6) Sequence Number is a text field that is a counter of the fax numbers. The format is fixed (three digits with leading zeros).
7) Not Used is a lookup to the flat lookup Yes/No Indicator.
Related multi-valued tuple fields within the object main table and/or other tuple definitions carry the same name Fax Numbers, too.
RS
Tuple Phone Numbers
This tuple definition covers Phone Numbers. It consists of nine member fields in a fixed sequence.
1) Is Standard Phone Number is a lookup to flat lookup Yes/No Indicator. It is the first display field of the tuple.
2) Phone Country is a lookup to flat lookup Countries.
3) Phone Number is a text field for the phone dialing code and number.
4) Phone Extension is a text field for the phone number extension.
5) Complete Phone Number is a text field for the complete phone number. It is the second display field of the tuple.
6) Phone Number Type is a lookup to the flat lookup Phone Number
RS
Component What is new? Reason Types.
7) Is SMS enabled is a lookup to the flat lookup Yes/No Indicator.
8) Sequence Number is a text field that is a counter of the phone numbers. The format is fixed (three digits with leading zeros).
9) Not Used is a lookup to the flat lookup Yes/No Indicator.
Related multi-valued tuple fields within the object main table and/or other tuple definitions carry the same name Phone Numbers, too.
Tuple Purchasing Organization Data
This tuple definition covers the Purchasing Organization related fields.
It consists of 50 fields in a fixed order. Furthermore it includes new lookup tables:
Activity Profiles, Confirmation Control Keys, Currencies, Groups for Calculation Schema, Incoterms, Payment Terms, Plants, Price Determination Date Controls, Price Marking Agreements, Profiles for Material Data Transfer, Purchasing Groups, Purchasing Organizations, Restriction Profiles, Shipping Conditions, Sort Criteria for Materials, Transportation Chains, Unit of Measure Groups
Customs Offices, Modes of Transport, Planning Calendars, Rounding Profiles
RE
Tuple Web This duple definition covers the FTP and URL Address related fields for communication data. It consists of 14 fields in a fixed order.
Furthermore it includes a new flat lookup table URI Types.
RE
Import Maps All changes as described above are reflected within the Import Maps.
MDMGX All changes as described above are reflected within the MDMGX configuration text file.
MDMGX The repository initialization (load of reference data) is now using the MDMGX Process Levels. Process levels handle the import of dependent customizing entries.
MDMGX MDMGX extractors have been enhanced to cover the Company Code and Purchasing Organization customizing extraction.
RE
PI Content The XSLTs MDM71CreDebmdmAddressFilterIn.xsl and
MDM71CreDebmdmToCreDebmasSplit have been enhanced to handle the Company Code’s Payment Methods correctly.
RE
Portal Content All changes as described above are reflected within the Portal Content.
Sample Data All changes as described above are reflected within the Sample Data.
Syndication Maps All changes as described above are reflected within the Syndication Maps.
Validations Validations have been completely re-worked according to the current MDM features
RE, RS
Workflows Workflows have been completely re-worked according to the current MDM features
RE, RS