Содержание
- 2. Module Objectives After completing this module you should be able to: Define a party business component
- 3. Business Challenge: Modeling Party Data Party data is the ubiquitous information found in most RDBMS Some
- 4. Business Challenge: Modeling Party Data Continued Representing these relationships could result in data models that do
- 5. Business Solution: Party Business Component Provides a way to create a network of relationships between party
- 6. Party Business Components Are similar to standard business components; they: Group data according to business logic
- 7. Differences Between Party and Non-Party BCs In standard BCs, most data is stored in the base
- 8. S_PARTY and Its Extension Tables Eight prominent S_PARTY extension tables store the data S_PARTY Person-related S_EMP_PER
- 9. Commonly Used Party Business Components Represent a variety of entities that can be arranged into groups
- 10. Person-Related Party Business Components Store their main data in S_CONTACT May store additional data in S_USER
- 11. Person-Related Party Business Components Continued Primarily reference person-related S_PARTY extension tables CJONES 3 Jones Chris 3
- 12. Person-Related Party Business Components Continued A number of person-related business components use these tables First Name
- 13. Organization-Related Party Business Components Store their main data in S_ORG_EXT May store additional data in S_BU
- 14. Organization-Related Party Business Components Continued Multiple organization-related business components use these tables Name Internal Org Flag
- 15. Groupings for Access Control Represent groupings of party instances User List Access Group Position ROW_ID ROW_ID
- 16. Groupings for Access Control Continued Name User List Name Access Group Access Group, User List, and
- 17. Example, Relating Party Data A user list can be associated with persons via the S_PARTY intersection
- 18. Example, Relating Party Data Continued An access group can then be networked with those users, or
- 19. Party Implicit Joins Used to populate the prominent S_PARTY extension tables Created automatically for these extension
- 20. Explicit Join: Non-Party Business Component Data in a party table can be joined into a non-party
- 21. Explicit Join Definition References the extension table that contains data of interest ROW_ID NAME DESC_TEXT CURCY_CD
- 22. Explicit Join: Another Party Business Component Uses an explicit join to the party table, and not
- 23. Explicit Join Definition Select or create an explicit join to the desired S_PARTY extension table Use
- 24. Module Highlights Party types have dynamic or ad hoc relationships Party BCs create relationships between party
- 26. Скачать презентацию