sap-crm-表关系图


CRMD_ORDERADM_I Product(FK) GUID Header(FK) CRMD_ORDERADM_H GUID Object_ID Process_Type CRMD_LINK GUID_SET GUID_HI Object_HI Object_Type SCAPPTSEG(30) APPT_GUID APPL_GUID APPT_Type TST_FROM CRMD_PARTNER(07) GUID PARTNER_NO(FK) ADDR_NR PRCD_HEAD(18) KNUMV KALSM CRMD_PAYPLAN(02) GUID BUT000 PARTNER PARTNER_GUID BPKIND PERSNUMBER PRCD_COND KNUMV KPOSN KSCHL KBETR CDMD_PAYPLAN_D HEADER_GUID GUID CDMD_PAYPLAN_DC GUID CRAD_GUID BUT020(Address) ADDRNUMBER(FK) PARTNER(FK) ADRC COUNTRY CITY_CODE(FK) STREETCODE ADDRNUMBER POST_CODE1 NATION COMM_PRODUCT PRODUCT_GUID PRODUCT_ID PRODUCT_Type Object_Family CRMD_SCHEDLIN GUID ITEM_GUID(FK) CRMD_PRICING_I GUID NET_Value TAX_Amout COMM_PRPRDCATR PRODUCT_GUID(FK) CATEGORY_GUID CATEGORY_ID COMM_PR_FRG_ROD PRODUCT_GUID(FK) SALES_ORG FRAGMENT_GUID(FK) STATUS_OBJECT COMM_PR_SALESA FRG_GUID MIN_ORDER S_ITEM_CAT_GROUP CRM_JCDS CHGNR INACT STAT OBJNR(FK) USNAM CRM_JEST OBJNR(FK) STAT INACT CHGNR CRM_JSTO OBJNR OBTYP LOYD_MSH_MS_MEMB MEMS_GUID GUID MEMB_GUID LOYD_MSH_MEMS GUID OBJECT_ID MEMB_GUID MEMS_TYPE LOYD_MSH_MS_TIER REF_GUID TIER_GROUP TIER_LEVEL CRMD_SALES(11) GUID PO_NUMBER_UC PROBABILITY CRMD_SHIPPING(12) GUID INCOTERMS1 DVL_PRIO CRMD_ORGMAN(21) GUID SALES_ORG DIVISION CRMD_PRICING(09) GUID CUST_PRIC_PROC CRMD_CANCEL(42) GUID CANCPARTY CANC_REASON CRMD_SURVEY(58) SURVEY_GUID VALUE_GUID(FK) SET_GUID CRM_SVY_DB_SVS VALUEGUID SURVERID XML CRMD_ACTIVITY_H GUID CATEGORY PRIORITY ADDRESS CRMD_OPPORT_H GUID STARTDATE PROBABILITY CRMD_CUSTOMER_H GUID ZFIELDS CRMD_ACTIVITY_I GUID JOURNAL_GUID DISCUSS CRMD_PRODUCT_I GUID VOLUMN BASE_QTY_UNIT CRMD_STRUCT_I GUID INT_OBJ_NO CRMD_BRELVONAI RELATIONID OBJECT_A(FK) OBJECT_B CRMD_ORDPRP_I GUID PRP_GUID(FK) PRP_OBJL_GUID(FK) COMM_PRSHTEXT PRODUCT_GUID(FK) SHORT_TEXT COMM_PR_UNIT PRODUCT_GUID(FK) UNIT VOLUMN COMM_PR_FRG_REL PRODUCT_GUID(FK) FRAGMENT_GUID(FK) COMM_PR_TAX PRODUCT_GUID(FK) TEXT_TYPE TEXT_GROUP COMM_PR_SALESG FRG_GUID ISU_CONNOBJ FRG_GUID TPLNR ISU_POD FRG_GUID INT_UI VSTELLE COMM_PRMAT FRG_GUID ITEM_CAT_GROUP STATUS PRODUCT ADDRESS PARTNERBIZ Document BUT0CC(Payment) PARTNER(FK) CCARD_ID BUT_FRG0011(Tax) PARTNER_GUID TAX_CTY TAX_TYPE CRMM_BUT_CRMOBJ(site) PARTNER_GUID SITE_ID CRMM_BUT_FRG0050(Status) GUID BIL_BLOCK_REASON DEL_BLOCK_REASON CRMM_BUT_FRG0041(Sales) PARTNER_GUID IS_CUSTOMER ACCOUNT_GROUP CRMM_BUT_FRG0071(exclud.func) PARTNER_GUID PARTNER_FUNCTION AUSP(MKTG) PARTNER_GUID ATINN ATWRT CRMD_BILLPLAN(47) GUID BILLPLAN_TYPE CRMD_BILLING(46) GUID BUAG_GUID BILLING_BLOCK CRMD_SRV_OSSET(29) GUID_SET GUID SUBJECT_PROFILE NOTE: Object_ID: DocumentID(ContractID) Object_HI: If ‘H’ then use 05, else if ‘I’ then use 06 Object_Type: 02,07,09,11,12,…(pls refer to CRMC_OBJECTS) FK: Foreign Key CRMM_PRPADM_H GUID PRP_ID CRMM_PRPADM_I GUID PARENT_GUID(FK) CRMM_PRP_PROD_I GUID PARENT_GUID(FK) Product_Ref_GUID(FK) COMM_PRODUCT(Type=1) PRODUCT_ID PRODUCT_Type Object_Family PRODUCT_GUID BUT021(Usage) ADR_KIND ADDRNUMBER(FK) PARTNER(FK) DFKKBPTAXNUM(Tax) PARTNER(FK) TAXTYPE TAXNUM BUT100(role) PARTNER(FK) RLTYP BUT0IS(industry) PARTNER(FK) IND_SECTOR BUT0ID(id NOs) PARTNER(FK) ID_NUMBER BUT0BK(bank) PARTNER(FK) BKVID BANKN BUT050(relationship) PARTNER1(FK) PARTNER2 RELNR ADRSTREET STRT_CODE(FK) CITY_CODE(FK) COMMU_CODE COUNTRY STREET ADRCITY COUNTRY CITY_CODE(FK) COMMU_CODE REGIONSGOUP CITY_NAME T005(Country) LAND1 NATIO ADRV(where used list) ADDRNUMBER APPL_TABLE APPL_FIELD ADDR_GROUP ADRT(communication) PERSNUMBER ADDRNUMBER DATE_FROM COMMU_TYPE LANGU ADRP(Persons) PERSNUMBER DATE_FROM NATION CRMM_BUAG_L_FICA BUPA_GUID(FK) BUAG_GUID(FK) CRMM_BUAG_BUPA BUPA_GUID ACTV_ACCOUNT CRMM_BUAG(id) BUAG_GUID BUAG_ID BUAG_TEXT CRMM_BUAG_H(Central) BUAG_GUID(FK) BABR_GUID(FK) BUAG_CLASS BUAG_DEFAULT ADDR_CR_GUID CRMM_BABR BABR_GUID(FK) CREATED_BY CRMM_BABR_H(paymnt) BABR_GUID PAYM_METH_IN PAYM_METH_OUT CRMM_BUAG_L_REL BAPF_GUID RELNR PARTNER1_GUID PARTNER2_GUID BIZ AGREEMENT IBIB(ibase) IBASE IB_GUID_16 IB_GUID FM1[GUID_Convert] SEGMENT_RECNO IN_OBJNR/IB_GUID IBIN(componoent) IBASE OBJNR IN_RECNO INSTANCE IN_OBJNR IN_GUID FM2[GUID_Convert] Product_GUID OBJNR IBINVALUES IN_RECNO(FK) SYMBOL_ID IBINOWN(Owner) INSTANCE OBJKEY(FK) INTTYP(1001) IBADDR(address) RECNO ADRNO(FK) SEGMENT_RECNO IBPART(partner) RECNO SEGMENT_RECNO PARTNERSET CRMD_PARTNER(07) GUID PARTNER_NO COMM_CFGOCLASS OBJNAME KBID OBJID OBJTYPE COMM_CFGVALSYM OBJID KBID SYMBOLID CHARVALUE COMM_CFGCHARAC CHARID KBID CHARNAME COMM_CFGCLVAL KBID OBJID SYMBOLID CHARID COMM_CFGCLSDOM OBJID KBID SYMBOLID CHARID CONFIG IBASE PRCD_ITEM KNUMV KPOSN PRCD_COND KNUMV KPOSN KSCHL KBETR CRMD_CUMULATED_I GUID ITEM_GUID(FK) CRMD_BRELVONAE RELATIONID OBJGUID_A_SEL OBJGUID_B_SEL IBST(Structure) IBASE ST_RECNO INSTANCE CRMD_SRV_REFOBJ IB_COMP_REF_GUID GUID_REF CRMD_LEAD_H GUID LEAD_TYPE LOYD_MEM_MEMBER GUID MEMB_ID TYPE

下载pdf到电脑,查找使用更方便

pdf的实际排版效果,会与网站的显示效果略有不同!!

需要 10 金币 [ 分享pdf获得金币 ] 0 人已下载

下载pdf

pdf贡献者

yidoukkc

贡献于2018-03-27

下载需要 10 金币 [金币充值 ]
亲,您也可以通过 分享原创pdf 来获得金币奖励!
下载pdf