SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

BP000 Table in SAP | Business Partner Master (General Data) Table & Fields List

BP000 is a SAP table coming under CA module and SAP_APPL component.View details, Fields & related tables of BP000 in SAP.

  • Table description : Business Partner Master (General Data)
  • Module : CA-FS-BP
  • Parent Module : CA
  • Package : FBPAR
  • Software Component : SAP_APPL
BP000 table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP BP000 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
PARTNRBusiness Partner NumberBP_PARTNR_OLDBP_PARTNR
PARTNR_OLDCharacter Field Length = 10CHAR10CHAR10
.INCLUDEBP: Attributes of General Business Partner    
PARTNERBusiness Partner NumberBU_PARTNERBU_PARTNER
PERSNUMBERPerson numberAD_PERSNUMAD_PERSNUM
BU_GROUPBusiness Partner GroupingBU_GROUPBU_GROUP
EXTPARTNRExternal Business Partner IDBP_EXT_PNRCHAR15
CUSTOMERCustomer NumberKUNNRKUNNR
TYPEPartner categoryBP_TYPE_OLDBP_TYPE
BP_GROUPBP: Collective Business Partner IndicatorBP_GROUPXFELD
GROUP_IDBusiness Partner GroupingBP_GRP_ID_OLDBP_GRP_ID
NAME1Name 1 (surname for persons, otherwise company name)BP_NAME1TEXT40
NAME2Name 2 (Continuation of NAME 1)BP_NAME2TEXT40
LANGULanguage KeyLANGUSPRAS
TITLEForm of Address (Key)BP_TITLE_OLDBP_TITLE
TITLE_LETSalutationBP_TITL_LTBP_TITL_LT
ADR_REFAddress IDBP_ADR_REF_OLDBP_ADR_REF
SORT1Sort Field 1BP_SORT1CHAR20
SORT2Sort Field 2BP_SORT2CHAR20
SORT_PHONSort Field for Phonetic Search; ObsoleteBP_SORT_PHCHAR20
MC_NAME1Field NAME1 in Upper CaseBP_MC_NAM1CHAR25
MC_NAME2Field NAME2 in Upper CaseBP_MC_NAM2CHAR25
SOURCESource Key of Business Partner DataBP_SOURCEBP_SOURCE
CRUSEREntered byBP_CRUSERSYCHAR12
CRDATCreation DateBP_CRDATDATUM
VIPBusiness Partner: VIP PartnerBP_VIPPAVIP
GROUP_DTarget GroupBP_GROUP_DBP_GROUP_D
DEL_INDDeletion FlagBP_DEL_INDXFELD
BEGRUAuthorization GroupBEGRUBEGRU
XTITLEText of Form of AddressBP_XTITLETEXT50
XTIT_LESalutationBP_XTIT_LETEXT50
PAR_RELBusiness Partner ReleasedBP_PAR_RELBP_PAR_REL
.INCLUDEBP: Attributes of Natural Persons    
NAME_LASTLast NameBP_NAMLASTTEXT40
NAME_FIRSTFirst NameBP_NAMFRSTTEXT40
TITLE_ACAcademic TitleBP_TITL_AC_OLDTEXT20
N_PREFIXName PrefixBP_PREFIX_OLDTEXT20
N_ADDITIONName AffixBP_ADDITN_OLDTEXT20
NICKNAMEKnown AsBP_NICKNAMTEXT20
SEXGender of Business PartnerBP_SEX_OLDBP_SEX
PROFESSIONDescription of Occupation for Business PartnerBP_PROFESS_OLDTEXT40
NATIONNationalityBP_CNTR_NLAND1
STATECitizenshipBP_CNTR_STLAND1
BIRTH_DATEDate of Birth of Business PartnerBP_BIRTHDDATUM
BIRTH_PLACBirthplaceBP_BIRTHPLTEXT40
BIRTH_NAMEName at BirthBP_BIRTHNATEXT40
BIRTH_N_ADName at Birth AffixBP_BIRTH_ATEXT40
DEATH_DATEDate of DeathBP_DEATH_DDATUM
MARITAL_STMarital StatusBP_MARITAL_OLDBP_MARITAL
PROPRTY_STMarital property regimeBP_PROPRTY_OLDBP_PROPRTY
CHILDRENNumber of Children Belonging to the Business PartnerBP_CHILDRNDEC2
MEM_HOUSENumber of People Living in the HouseholdBP_MEM_HOUDEC2
INCOME_CURCurrency of Net IncomeBP_INC_CURWAERS
NET_INCOMENet Annual IncomeBP_NET_INCWERTV8
MO_NET_INCMonthly Net Income of Business PartnerBP_MO_INCWERTV8
NET_INC_YYear of Net Annual IncomeBP_N_INC_YGJAHR
MO_INC_MCalendar Month of Monthly Net IncomeBP_M_INC_MBP_M_INC_M
MO_INC_YYear of Monthly Net IncomeBP_M_INC_YGJAHR
PERS_NRPersonnel NumberBP_PERS_NRCHAR15
STAFF_GRPEmployee GroupBP_STAFF_GBP_STAFF_G
HR_ORG_REFHR Org. LinkHR_ORG_REFXFELD
XUBNAMEUser Name in User Master RecordXUBNAMEXUBNAME
STAFF_REFEmployeeBP_STAFF_RXFELD
.INCLUDEBP: Attributes of Organizations    
ORG_NAMEName 1 (surname for persons, otherwise company name)BP_NAME1TEXT40
ORG_NAME2Name 2 (Continuation of NAME 1)BP_NAME2TEXT40
CALENDARIDFactory calendarBP_CAL_IDWFCID
LEGAL_ENTYLegal Form of OrganizationBP_LEG_ETY_OLDBP_LEG_ETY
LEGAL_ORGLegal Entity of OrganizationBP_LEG_ORG_OLDBP_LEG_ORG
BALANCE_FLBalance Sheet DisplayBP_BAL_FLGBP_BAL_FLG
FOUND_YEARFoundation Year of OrganizationBP_FOUND_YGJAHR
COMM_REGISEntry in Commercial RegisterBP_COM_REGTEXT50
COMM_REG_DDate of Entry in Commercial RegisterBP_COM_R_DDATUM
CNTRY_COMPCountry of Organization's Registered OfficeBP_CNTR_HDLAND1
REGIORegion of Registered OfficeBP_REGIO_HDREGIO
COMP_HEADRegistered OfficeBP_COMP_HDTEXT35
LIQUID_DATDate of LiquidationBP_LIQUI_DDATUM
COMP_NRInternational location number (part 1)BBBNRNUM07
COMP_NR_ADInternational location number (Part 2)BBSNRNUM05
BUBKZCheck digit for the international location numberBUBKZNUM01
IND_SECTORIndustry KeysBP_BRSCH_OLDBRSCH
MIN_RESERVBank Subject to Minimum Reserve RequirementBP_MIN_RSVXFELD
BAL_SH_CURBalance Sheet CurrencyBP_BAL_CURWAERS
CAP_INCR_AAmount of last capital increaseBP_CA_IN_AWERTV8
CAP_INCR_YYear of Last Capital IncreaseBP_CA_IN_YGJAHR
BANKLBank KeysBANKKBANKK
BANKSBank country keyBANKSLAND1
.INCLU--APBP: Attribute switch-off parallel maintenance    
NO_CONVData element for domain BOOLE: TRUE (='X') and FALSE (=' ')BOOLE_DBOOLE

BP000 related tables

TableNote
JGTBP00IS-M: Business Partner Master Data (General Data)
BP000Business Partner Master (General Data)
BP2000BP: Business Partner - Business Partner - Relationship
BBPM_BUT_FRG0010Business Partner: General BBP Data (Administration)
BBPM_BUT_FRG0011Business Partner: General BBP Data
BID000Business Partner: Bidder General Data
BP1050Business Partner: General Control Data
VEN000Business Partner: General Vendor Data
J_7LE01REA Partner Master Record: General Data (Country-Dependent)
EDPP1EDI Partner (general partner profiles - inb. and outb.)
DFKKCOLL_CHCollection: Changes to Business Partner Master Data
GHO_CUVD_OWN_MDCustomer/Vendor Ownership Master Data of Business partner
J_7LV01REA Packaging Master Data: General Data
BC001Business Partner: Assign Vendor - Partner
BD001Business Partner: Assignment Customer - Partner
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com