SAP ABAP Table CRMT_BSP_SEARES_PHARMA (Business Partner: Result of Search for Pharma), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `CRMT_BSP_SEARES_PHARMA` {Business Partner: Result of Search for Pharma}

Home

                title {label: "SAP ABAP table CRMT_BSP_SEARES_PHARMA {Business Partner: Result of Search for Pharma}", size: "20"}

# Entities

[CRMT_BSP_SEARES_PHARMA] {bgcolor: "tomato"}
+BPGROUP {label: "CHAR (4)"}
+BPSUBGROUP {label: "CHAR (4)"}
+CITY_CODE {label: "CHAR (12)"}
+CITYP_CODE {label: "CHAR (8)"}
+CITYH_CODE {label: "CHAR (12)"}
+REGIOGROUP {label: "CHAR (8)"}
+DONT_USE_P {label: "CHAR (4)"}
+CITY_CODE2 {label: "CHAR (12)"}
+PO_BOX_REG {label: "CHAR (3)"}
+PO_BOX_CTY {label: "CHAR (3)"}
+TRANSPZONE {label: "CHAR (10)"}
+DONT_USE_S {label: "CHAR (4)"}
+STREETCODE {label: "CHAR (12)"}
+STREETABBR {label: "CHAR (2)"}
+COUNTRY {label: "CHAR (3)"}
+LANGU {label: "LANG (1)"}
+REGION {label: "CHAR (3)"}
+ADDRORIGIN {label: "CHAR (4)"}
+TIME_ZONE {label: "CHAR (6)"}
+LANGU_CREA {label: "LANG (1)"}
+DELI_SERV_TYPE {label: "CHAR (4)"}
+COUNTY_CODE {label: "CHAR (8)"}
+TOWNSHIP_CODE {label: "CHAR (8)"}
+PARTNER_ROLE {label: "CHAR (6)"}
+PARTNERTYPE {label: "CHAR (4)"}
+PARTNERLANGUAGE {label: "LANG (1)"}
+DATAORIGINTYPE {label: "CHAR (4)"}
+TITLE_KEY {label: "CHAR (4)"}
+TITLE_ACA1 {label: "CHAR (4)"}
+TITLE_ACA2 {label: "CHAR (4)"}
+TITLE_SPPL {label: "CHAR (4)"}
+PREFIX1 {label: "CHAR (4)"}
+PREFIX2 {label: "CHAR (4)"}
+NAMEFORMAT {label: "CHAR (2)"}
+NAMCOUNTRY {label: "CHAR (3)"}
+MARITALSTATUS {label: "CHAR (1)"}
+CORRESPONDLANGUAGE {label: "LANG (1)"}
+LEGALFORM {label: "CHAR (2)"}
+INDUSTRYSECTOR {label: "CHAR (10)"}
+GROUPTYPE {label: "CHAR (4)"}
+INDUSTRY {label: "CHAR (4)"}
+ACCOUNT_GROUP {label: "CHAR (4)"}
+NIELSEN_ID {label: "CHAR (2)"}
+CLASSIFIC {label: "CHAR (2)"}
+ATTRIBUTE {label: "CHAR (2)"}
+ATTRIB_2 {label: "CHAR (2)"}
+ATTRIB_3 {label: "CHAR (2)"}
+ATTRIB_4 {label: "CHAR (2)"}
+ATTRIB_5 {label: "CHAR (2)"}
+ATTRIB_6 {label: "CHAR (3)"}
+ATTRIB_7 {label: "CHAR (3)"}
+ATTRIB_8 {label: "CHAR (3)"}
+ATTRIB_9 {label: "CHAR (3)"}
+ATTRIB_10 {label: "CHAR (3)"}

[ADDRC_DELI_SERV] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*DELI_SERV_TYPE {label: "CHAR (4)"}

[ADRCITY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*CITY_CODE {label: "CHAR (12)"}

[ADRCITYPRT] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+CITY_CODE {label: "CHAR (12)"}
*CITYP_CODE {label: "CHAR (8)"}

[ADRCOUNTY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*COUNTY_CODE {label: "CHAR (8)"}

[ADRREGGRP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*REGIOGROUP {label: "CHAR (8)"}

[ADRSTREET] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRT_CODE {label: "CHAR (12)"}

[ADRSTRTYPE] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRTYPEAB {label: "CHAR (2)"}

[ADRTOWNSHIP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*+COUNTY_CODE {label: "CHAR (8)"}
*TOWNSHIP_CODE {label: "CHAR (8)"}

[CRMC_ATTR01] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIBUTE {label: "CHAR (2)"}

[CRMC_ATTR02] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_2 {label: "CHAR (2)"}

[CRMC_ATTR03] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_3 {label: "CHAR (2)"}

[CRMC_ATTR04] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_4 {label: "CHAR (2)"}

[CRMC_ATTR05] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_5 {label: "CHAR (2)"}

[CRMC_ATTR06] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_6 {label: "CHAR (3)"}

[CRMC_ATTR07] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_7 {label: "CHAR (3)"}

[CRMC_ATTR08] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_8 {label: "CHAR (3)"}

[CRMC_ATTR09] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_9 {label: "CHAR (3)"}

[CRMC_ATTR10] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ATTRIB_10 {label: "CHAR (3)"}

[CRMC_CLASSIF] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*CLASSIFIC {label: "CHAR (2)"}

[CRMC_INDUSTRY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*INDUSTRY {label: "CHAR (4)"}

[CRMC_NIELSEN] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*NIELSEN_ID {label: "CHAR (2)"}

[CRMC_T077D] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ACCOUNT_GROUP {label: "CHAR (4)"}

[CRMPHAC_BP_GRP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*BPGROUP {label: "CHAR (4)"}

[CRMPHAC_BP_SGR] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+BPGROUP {label: "CHAR (4)"}
*BPSUBGROUP {label: "CHAR (4)"}

[T002] {bgcolor: "#d0e0d0"}
*SPRAS {label: "LANG (1)"}

[T005] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LAND1 {label: "CHAR (3)"}

[T005N] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*NAMEFORMAT {label: "CHAR (2)"}

[T005S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*BLAND {label: "CHAR (3)"}

[TB004] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*BPKIND {label: "CHAR (4)"}

[TB005] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*SOURCE {label: "CHAR (4)"}

[TB019] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*LEGAL_ENTY {label: "CHAR (2)"}

[TB023] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*IND_SECTOR {label: "CHAR (10)"}

[TB025] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*PARTGRPTYP {label: "CHAR (4)"}

[TB027] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*MARST {label: "CHAR (1)"}

[TBZ0] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+OBJAP {label: "CHAR (4)"}
*RLTYP {label: "CHAR (6)"}

[TSAD12] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*UNDELIVER {label: "CHAR (4)"}

[TSAD2] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TITLE_KEY {label: "CHAR (4)"}

[TSAD3] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TITLE {label: "CHAR (4)"}

[TSAD4] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*PREFIX_KEY {label: "CHAR (4)"}

[TSAD5] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TITLE_KEY {label: "CHAR (4)"}

[TSAD6] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ORIGIN {label: "CHAR (4)"}

[TTZZ] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TZONE {label: "CHAR (6)"}

[TZONE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*ZONE1 {label: "CHAR (10)"}

# Relationships

CRMT_BSP_SEARES_PHARMA ?--* CRMC_T077D {label: "CRMT_BSP_SEARES_PHARMA-ACCOUNT_GROUP = CRMC_T077D-ACCOUNT_GROUP"}
CRMT_BSP_SEARES_PHARMA ?--* TSAD6 {label: "CRMT_BSP_SEARES_PHARMA-ADDRORIGIN = TSAD6-ORIGIN"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR01 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIBUTE = CRMC_ATTR01-ATTRIBUTE"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR10 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_10 = CRMC_ATTR10-ATTRIB_10"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR02 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_2 = CRMC_ATTR02-ATTRIB_2"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR03 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_3 = CRMC_ATTR03-ATTRIB_3"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR04 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_4 = CRMC_ATTR04-ATTRIB_4"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR05 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_5 = CRMC_ATTR05-ATTRIB_5"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR06 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_6 = CRMC_ATTR06-ATTRIB_6"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR07 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_7 = CRMC_ATTR07-ATTRIB_7"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR08 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_8 = CRMC_ATTR08-ATTRIB_8"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_ATTR09 {label: "CRMT_BSP_SEARES_PHARMA-ATTRIB_9 = CRMC_ATTR09-ATTRIB_9"}
CRMT_BSP_SEARES_PHARMA 1--* CRMPHAC_BP_GRP {label: "CRMT_BSP_SEARES_PHARMA-BPGROUP = CRMPHAC_BP_GRP-BPGROUP"}
CRMT_BSP_SEARES_PHARMA 1--* CRMPHAC_BP_SGR {label: "CRMT_BSP_SEARES_PHARMA-BPSUBGROUP = CRMPHAC_BP_SGR-BPSUBGROUP"}
CRMT_BSP_SEARES_PHARMA ?--* ADRCITY {label: "CRMT_BSP_SEARES_PHARMA-CITYH_CODE = ADRCITY-CITY_CODE"}
CRMT_BSP_SEARES_PHARMA ?--* ADRCITYPRT {label: "CRMT_BSP_SEARES_PHARMA-CITYP_CODE = ADRCITYPRT-CITYP_CODE"}
CRMT_BSP_SEARES_PHARMA ?--* ADRCITY {label: "CRMT_BSP_SEARES_PHARMA-CITY_CODE = ADRCITY-CITY_CODE"}
CRMT_BSP_SEARES_PHARMA ?--* ADRCITY {label: "CRMT_BSP_SEARES_PHARMA-CITY_CODE2 = ADRCITY-CITY_CODE"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_CLASSIF {label: "CRMT_BSP_SEARES_PHARMA-CLASSIFIC = CRMC_CLASSIF-CLASSIFIC"}
CRMT_BSP_SEARES_PHARMA ?--* T002 {label: "CRMT_BSP_SEARES_PHARMA-CORRESPONDLANGUAGE = T002-SPRAS"}
CRMT_BSP_SEARES_PHARMA 1--? T005 {label: "CRMT_BSP_SEARES_PHARMA-COUNTRY = T005-LAND1"}
CRMT_BSP_SEARES_PHARMA ?--* ADRCOUNTY {label: "CRMT_BSP_SEARES_PHARMA-COUNTY_CODE = ADRCOUNTY-COUNTY_CODE"}
CRMT_BSP_SEARES_PHARMA 1--* TB005 {label: "CRMT_BSP_SEARES_PHARMA-DATAORIGINTYPE = TB005-SOURCE"}
CRMT_BSP_SEARES_PHARMA 1--* ADDRC_DELI_SERV {label: "CRMT_BSP_SEARES_PHARMA-DELI_SERV_TYPE = ADDRC_DELI_SERV-DELI_SERV_TYPE"}
CRMT_BSP_SEARES_PHARMA ?--* TSAD12 {label: "CRMT_BSP_SEARES_PHARMA-DONT_USE_P = TSAD12-UNDELIVER"}
CRMT_BSP_SEARES_PHARMA ?--* TSAD12 {label: "CRMT_BSP_SEARES_PHARMA-DONT_USE_S = TSAD12-UNDELIVER"}
CRMT_BSP_SEARES_PHARMA 1--* TB025 {label: "CRMT_BSP_SEARES_PHARMA-GROUPTYPE = TB025-PARTGRPTYP"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_INDUSTRY {label: "CRMT_BSP_SEARES_PHARMA-INDUSTRY = CRMC_INDUSTRY-INDUSTRY"}
CRMT_BSP_SEARES_PHARMA 1--* TB023 {label: "CRMT_BSP_SEARES_PHARMA-INDUSTRYSECTOR = TB023-IND_SECTOR"}
CRMT_BSP_SEARES_PHARMA 1--* T002 {label: "CRMT_BSP_SEARES_PHARMA-LANGU = T002-SPRAS"}
CRMT_BSP_SEARES_PHARMA ?--* T002 {label: "CRMT_BSP_SEARES_PHARMA-LANGU_CREA = T002-SPRAS"}
CRMT_BSP_SEARES_PHARMA 1--* TB019 {label: "CRMT_BSP_SEARES_PHARMA-LEGALFORM = TB019-LEGAL_ENTY"}
CRMT_BSP_SEARES_PHARMA 1--* TB027 {label: "CRMT_BSP_SEARES_PHARMA-MARITALSTATUS = TB027-MARST"}
CRMT_BSP_SEARES_PHARMA ?--* T005 {label: "CRMT_BSP_SEARES_PHARMA-NAMCOUNTRY = T005-LAND1"}
CRMT_BSP_SEARES_PHARMA ?--* T005N {label: "CRMT_BSP_SEARES_PHARMA-NAMEFORMAT = T005N-NAMEFORMAT"}
CRMT_BSP_SEARES_PHARMA ?--* CRMC_NIELSEN {label: "CRMT_BSP_SEARES_PHARMA-NIELSEN_ID = CRMC_NIELSEN-NIELSEN_ID"}
CRMT_BSP_SEARES_PHARMA 1--* T002 {label: "CRMT_BSP_SEARES_PHARMA-PARTNERLANGUAGE = T002-SPRAS"}
CRMT_BSP_SEARES_PHARMA 1--* TB004 {label: "CRMT_BSP_SEARES_PHARMA-PARTNERTYPE = TB004-BPKIND"}
CRMT_BSP_SEARES_PHARMA 1--* TBZ0 {label: "CRMT_BSP_SEARES_PHARMA-PARTNER_ROLE = TBZ0-RLTYP"}
CRMT_BSP_SEARES_PHARMA ?--* T005 {label: "CRMT_BSP_SEARES_PHARMA-PO_BOX_CTY = T005-LAND1"}
CRMT_BSP_SEARES_PHARMA ?--* T005S {label: "CRMT_BSP_SEARES_PHARMA-PO_BOX_REG = T005S-BLAND"}
CRMT_BSP_SEARES_PHARMA *--* TSAD4 {label: "CRMT_BSP_SEARES_PHARMA-PREFIX1 = TSAD4-PREFIX_KEY"}
CRMT_BSP_SEARES_PHARMA *--* TSAD4 {label: "CRMT_BSP_SEARES_PHARMA-PREFIX2 = TSAD4-PREFIX_KEY"}
CRMT_BSP_SEARES_PHARMA ?--* ADRREGGRP {label: "CRMT_BSP_SEARES_PHARMA-REGIOGROUP = ADRREGGRP-REGIOGROUP"}
CRMT_BSP_SEARES_PHARMA 1--? T005S {label: "CRMT_BSP_SEARES_PHARMA-REGION = T005S-BLAND"}
CRMT_BSP_SEARES_PHARMA ?--* ADRSTRTYPE {label: "CRMT_BSP_SEARES_PHARMA-STREETABBR = ADRSTRTYPE-STRTYPEAB"}
CRMT_BSP_SEARES_PHARMA ?--* ADRSTREET {label: "CRMT_BSP_SEARES_PHARMA-STREETCODE = ADRSTREET-STRT_CODE"}
CRMT_BSP_SEARES_PHARMA ?--* TTZZ {label: "CRMT_BSP_SEARES_PHARMA-TIME_ZONE = TTZZ-TZONE"}
CRMT_BSP_SEARES_PHARMA *--* TSAD2 {label: "CRMT_BSP_SEARES_PHARMA-TITLE_ACA1 = TSAD2-TITLE_KEY"}
CRMT_BSP_SEARES_PHARMA *--* TSAD2 {label: "CRMT_BSP_SEARES_PHARMA-TITLE_ACA2 = TSAD2-TITLE_KEY"}
CRMT_BSP_SEARES_PHARMA *--* TSAD3 {label: "CRMT_BSP_SEARES_PHARMA-TITLE_KEY = TSAD3-TITLE"}
CRMT_BSP_SEARES_PHARMA *--* TSAD5 {label: "CRMT_BSP_SEARES_PHARMA-TITLE_SPPL = TSAD5-TITLE_KEY"}
CRMT_BSP_SEARES_PHARMA ?--* ADRTOWNSHIP {label: "CRMT_BSP_SEARES_PHARMA-TOWNSHIP_CODE = ADRTOWNSHIP-TOWNSHIP_CODE"}
CRMT_BSP_SEARES_PHARMA ?--* TZONE {label: "CRMT_BSP_SEARES_PHARMA-TRANSPZONE = TZONE-ZONE1"}

E-R Diagram for table CRMT_BSP_SEARES_PHARMA (Business Partner: Result of Search for Pharma)

Foreign Key tables (43)

ADDRC_DELI_SERV {Address Service Types}
ADRCITY {Postal cities}
ADRCITYPRT {Postal districts}
ADRCOUNTY {County codes}
ADRREGGRP {Regional structure grouping}
ADRSTREET {Streets}
ADRSTRTYPE {Street type}
ADRTOWNSHIP {Township codes}
CRMC_ATTR01 {Attribute 1 (Business Partner)}
CRMC_ATTR02 {Attribute 2 (Business Partner)}
CRMC_ATTR03 {Attribute 3 (Business Partner)}
CRMC_ATTR04 {Attribute 4 (Business Partner)}
CRMC_ATTR05 {Attribute 5 (Business Partner)}
CRMC_ATTR06 {Attribute 6 (Business Partner)}
CRMC_ATTR07 {Attribute 7 (Business Partner)}
CRMC_ATTR08 {Attribute 8 (Business Partner)}
CRMC_ATTR09 {Attribute 9 (Business Partner)}
CRMC_ATTR10 {Attribute 10 (Business Partner)}
CRMC_CLASSIF {Customer Classification}
CRMC_INDUSTRY {Industry Sector}
CRMC_NIELSEN {Nielsen ID}
CRMC_T077D {Customer account groups}
CRMPHAC_BP_GRP {Business Partner Groups}
CRMPHAC_BP_SGR {Business Partner Subgroup}
T002 {Language Keys (Component BC-I18)}
T005 {Countries}
T005N {Name formats}
T005S {Taxes: Region (Province) Key}
TB004 {BP types}
TB005 {BP data sources}
TB019 {BP legal forms}
TB023 {BP industries (Obsolete ==> TB038A)}
TB025 {BP group types}
TB027 {BP marital status}
TBZ0 {BDT Object Parts}
TSAD12 {Reasons for Non-Delivery (Business Address Services)}
TSAD2 {Academic Title (Business Address Services)}
TSAD3 {Forms of Address (Key) (Business Address Services)}
TSAD4 {Name Prefixes (Business Address Services)}
TSAD5 {Name Suffixes/Title (Key) (Business Address Services)}
TSAD6 {Source Address or Personal Data (Business Address Services)}
TTZZ {Time zones}
TZONE {Customers: Regional zones}