I_BUSINESSPARTNER

CDS View
112 Fields 217 CDS Views

Business Partner

I_BUSINESSPARTNER is a CDS View in S/4HANA. Business Partner. It contains 112 fields. 217 CDS views read from this table.

CDS Views using this table (217)

ViewTypeJoinVDMDescription
/SCMTMS/CV_BP_Common view from Obsolete: Use CDS View /SCMTMS/VE_BPCMN
/SCMTMS/CV_BPOrganization view from Obsolete: Use CDS View /SCMTMS/VE_BPORG
/SCMTMS/CV_BPOrganization view union_all Obsolete: Use CDS View /SCMTMS/VE_BPORG
/SCMTMS/CV_BPSupplierCustomer view from View to get Supplier and Cust ID from BP
/SCMTMS/CV_DriverRoot view_entity from Driver Root
/SCMTMS/VE_BPCMN view_entity from BOPF: Business Partner Common TM Data
/SCMTMS/VE_BPORG view_entity from BOPF: Business Partner Organization
/SCMTMS/VE_BPORG view_entity union_all BOPF: Business Partner Organization
/UCOM/C_BPGENADD_VH view from CONSUMPTION Business Partner with Address
A_BusinessPartner view from BASIC Business Partner
A_ChgRecdBusinessPartner view_entity from COMPOSITE Change Record Business Partner
C_BlockedBusinessPartner view from CONSUMPTION Blocked business partner
C_BPHierarchyBPVH view_entity from BPH - Business Partner Value Help
C_BPUsrRelshpBPOrgVH view from BASIC Business User - Value Help for Company Relationship
C_CABillgReqBPAddress view_entity from COMPOSITE Geschäftspartner Adresse
C_ChmlSuplrMatlSupplierContact view from CONSUMPTION Contact Data of Supplier
C_ChmlSuplrMatlSupplierVH view from CONSUMPTION Value Help for Supplier
C_CollsContactPersonForCrteTP view from CONSUMPTION Contact Person for Create
C_EHSBusinessPartnerAddressVH view from CONSUMPTION CmplRq Permit Issuing Authority
C_EHSBusinessPartnerOrgVH view from CONSUMPTION Business Organization
C_EntProjMemberContactCard view_entity from CONSUMPTION Enterprise Project Member Details
C_InsurClmBPQuickView view from CONSUMPTION Geschäftspartner für Fallauskunft
C_InsurPlcyBusPartner view_entity from CONSUMPTION Geschäftspartner
C_JITOutbContactPersonOvw view from CONSUMPTION Consumption view for contact person
C_MfgBusinessPartnerVH view inner CONSUMPTION Mfg Business Partner Value Help
C_NL_SAFTJournalItemBP view_entity inner CONSUMPTION Audit File NL Journal Item BP
C_ProdCmplncReqCustomerContact view_entity from CONSUMPTION Customer Contact Card
C_ProdCmplncReqSupplierContact view_entity from CONSUMPTION Supplier Contact Card
C_PubSecTaxpayerQuickView view left_outer CONSUMPTION Taxpayer Quick View
C_QA_BPIdentificationType view_entity from CONSUMPTION Qatar BP identification
C_SbscrContrSoldToPtyVH view from CONSUMPTION Sold To Party
C_ServiceDocumentBillToPartyVH view from CONSUMPTION Value Help for Bill To Party
C_ServiceDocumentPayerVH view from CONSUMPTION Value Help for Payer
C_ServiceDocumentShipToPartyVH view from CONSUMPTION Value Help for Ship To Party
C_ServiceDocumentSoldToPartyVH view from CONSUMPTION Value Help for Sold-To Party
C_ServiceEmployeeVH view from CONSUMPTION Value Help for Service Employee
C_SiteBusinessPartnerVH view from CONSUMPTION BP value help
C_SLCMgmtSupplierPortfolio view left_outer CONSUMPTION Display Suppliers
C_SrvcDocBusinessPartnerVH view from CONSUMPTION Value Help for Business Partner
C_SrvcDocPersonResponsibleVH view from CONSUMPTION Employee Responsible Value Help
C_TransportationCarrierVH view from CONSUMPTION Transportation Carrier VH
C_TranspServiceProviderVH view from CONSUMPTION Carrier or Service Provider
C_UtilitiesBPContactData view from CONSUMPTION Business Partner Contact Data
CIC_CustomerData view_entity inner Proj. View on Customer
CIC_SALESDOCUMENTSBLOCKEDBP view_entity inner Sales Document with Blocked BP (Industry Cloud Solutions)
cic_supplierdata view_entity inner Proj. on Supplier (Industry Cloud Solutions)
CRMS4_IU_C_BPFTS view from Business partner by free text
CRMS4_IU_C_BPSUM view from Business partner summary
CRMS4_IU_P_BPFTS_SHLP view from Business partner free text search search help
CRMS4_IU_P_CNTBPC view from Business partner ISU-Contracts count
CRMS4_IU_P_CNTBPCA view from Business partner contracts accounts count
ESH_N_BUSINESSPARTNERS view from
EWA_ALY_P_BP view from
FAC_DART_Z3_C_BP_ADDRESS view inner Business Partner Address for Customer
FAC_DART_Z3_S_BP_ADDRESS view inner Business Partner Address for Supplier
I_BankGroup view from COMPOSITE Bank Business Partner
I_BkPaytTransBusinessPartner view inner COMPOSITE Cash Bank Business Partner Payment Transaction Used
I_BkPOAAuthzdRprstvVH view_entity from COMPOSITE Authorized Representatives
I_BPEmployeeWorkplaceAddr view inner BASIC Business Partner Employee Workplace address
I_BusinessPartnerGov view union_all BASIC Business Partner (Governance)
I_BusinessPartnerPerson view from BASIC Business Partner of type person
I_BusinessPartnerPopOver view from COMPOSITE Business Partner PopOver reuse component
I_BusinessPartnerReplication view_entity from COMPOSITE Replication of a Business Partner
I_BusinessPartnerTP view from TRANSACTIONAL Business Partner
I_BusinessPartnerTP_2 view_entity from TRANSACTIONAL View for Business Partner
I_BusinessPartnerTxt view from BASIC CDS View for BUPA Description
I_BusinessPartnerVH view from BASIC Business Partner
I_ChangeRecordContactPerson view from COMPOSITE Change Responsible
I_ChangeRecordPartnerVH view inner COMPOSITE Obsolete: Value help for Change Record Partner
I_CmmdtyIntCounterpartySubAcct view left_outer BASIC Subaccounts assgn. to int. Counterparty
I_CmmdtyOrdReqCounterpartyVH view from BASIC View for Counter Party Details
I_CmmdtySubAcctBrokerVH view from BASIC View for Commodity Subaccount Broker
I_CO_BusinessPartner view_entity inner COMPOSITE
I_CollsBusinessPartnerVH view from COMPOSITE Business Partner VH
I_CommissionBusinessPartnerVH view_entity from BASIC Commission Business Partner
I_CommoditySubAccountVH view left_outer COMPOSITE Commodity Subaccount Value Help View
I_ContactsVH view from BASIC Value Help for Contacts
I_ContingentWorker view inner BASIC Contingent Worker
I_ContingentWorker_1 view inner COMPOSITE Contingent Worker
I_CreditAnalystVH view from COMPOSITE Value Help for Crdt Analyst in Crdt Mgmt
I_CreditMgmtBPAddress view from COMPOSITE Address of bus. partner in Cred. Mgmt
I_DCBBusinessPartner view from COMPOSITE Business Partner
I_EWA_BusinessPartnerVH view_entity from COMPOSITE Customer Values
I_EWM_BusinessPartner view from COMPOSITE EWM Business Partner
I_EWM_EntitledPlantMapping view_entity from COMPOSITE Mapping of EWM Party Entitled to Dispose to Plant
I_EWM_StockOwnerVH view_entity from COMPOSITE Stock Owner
I_Ftr_Counterparty view from COMPOSITE Counterparty
I_INS_ClaimParticipantMiniBP view_entity from COMPOSITE Insurance Claim Participant Mini BP
I_INS_ClmPrtcpntStdAddress view_entity inner BASIC Basic Interface Participant Address
I_InsurClm1stNotifBP view from COMPOSITE Schadenmeldung - Geschäftspartner
I_InsurClm1stNotifContrValHelp view from COMPOSITE Schadenmeldung - Wertehilfe Vertrag
I_InsurClmPolicyHolderDetail view_entity from COMPOSITE Details of Business Partner
I_InsurCust360CustDetails view from COMPOSITE Customer 360 - Kundeninformationen
I_JITOutbBusinessPartner view from BASIC Interface for Business Partner
I_LastMileDriverValueHelp view_entity from COMPOSITE LMD Driver
I_LastMileRouteProcessDriverVH view_entity inner COMPOSITE LMD Route Process Driver
I_LglCntntMExtCntctDetails view from COMPOSITE LCM External Contact Details
I_LoanContrBPDetWthDflt view left_outer COMPOSITE Loan Contract Business Partner details with defaulting
I_LstMiRouteDriverVH view inner COMPOSITE Last Mile Route Driver VH
I_LstMiRteRsceSecondDriverVH view inner COMPOSITE Last Mile Route Second Driver
I_MDQltyBusinessPartner view from COMPOSITE MDQuality for Business Partner
I_MfgBuyOffProcessorTeamFunc view inner COMPOSITE Buy Off Processor Team Function
I_MstrProjBPContact view from COMPOSITE Master Project Business Partner Contact Details
I_MstrProjManager view inner COMPOSITE Get Project managers
I_MstrProjTeamMember view inner COMPOSITE Master Project Team Member
I_MX_BusinessPartner view_entity inner COMPOSITE Provides BP detailed information
I_NL_SAFTBusinessPartner view inner COMPOSITE SAF-T NL Business Partner
I_NO_SAFTCustomerMasterData view_entity inner COMPOSITE Master data of customers for SAFT
I_NO_SAFTCustomersInPeriod view_entity inner COMPOSITE List of all customers in report period
I_NO_SAFTSupplierMasterData view_entity inner COMPOSITE Master data of suppliers for SAFT
I_NO_SAFTSuppliersInPeriod view_entity inner COMPOSITE List of all customers in report period
I_OutputRecipient view from BASIC Output Recipient for Output Request Item
I_PAYERPAYEE view from BASIC Treasury PayerPayee
I_PersonWorkAgreement_1 view inner COMPOSITE Person Work Agreement Details
I_PersonWorkAgreement_2 view inner COMPOSITE Person Work Agreement Details
I_PMContactCardUser view inner BASIC Contact Card User
I_PrepaymentAgrmtDistrPayeesVH view from BASIC Prepayment Distribution Payees VH
I_ProcurementBusinessUser view from BASIC Businessuser in procurement
I_PurchasingCategorySupplier view inner COMPOSITE Purchasing Category Supplier
I_RblsMgmtBPToCustomer view_entity from COMPOSITE Business Partner to Customer Mapping
I_SecurityClassIssuer view from BASIC Security Class Issuer
I_ServiceDocumentBillToPartyVH view_entity from COMPOSITE Business Partners with Bill To Party role
I_ServiceDocumentShipToPartyVH view_entity from COMPOSITE Business Partners with Ship To Party role
I_ServiceDocumentSoldToPartyVH view_entity from COMPOSITE Business Partners with Sold To Party role
I_ServiceTeam view from BASIC Service Team
I_SLC_SupplierValueHelp view left_outer COMPOSITE Supplier
I_SLCQnaireParty view left_outer BASIC Party Referenced in Questionnaire
I_SrcgProjCntctWorkplaceAddr view inner COMPOSITE Workplace Address of Srcg Proj Contact
I_SupplierActivitySuplrParty view left_outer COMPOSITE Supplier Activity Supplier Party
I_SupplierActivityTaskSupplier view left_outer COMPOSITE Supplier Activity Task Supplier
I_SupplierEvalRespSuplrParty view inner COMPOSITE Supplier Evaluation Response Supplier Party
I_SupplierEvalTemplateParty view left_outer BASIC Party Referenced by Evaluation Template
I_TaxAuthorityValueHelp view_entity from COMPOSITE Tax Authority
I_TMBusinessPartnerByIntKey view from BASIC Business Partner
I_TranspBusinessPartnerVH view from COMPOSITE TM Business Partner value help
I_TranspCarrierVH view from COMPOSITE TM Carrier value help
I_TranspExecCarrierVH view from COMPOSITE TM Execution Carrier value help
I_TransportationOrderAllBP view inner COMPOSITE Transportation Order: All Business Partners
I_TravelExpenseBusinessPartner view from COMPOSITE Travel Expense Business Partner
I_TrdCmplncLicBusPart view inner BASIC License Business Partners
I_WorkAssignment view_entity inner BASIC Work Assignments
I_WorkAssignmentValueHelp view_entity inner COMPOSITE Work Assignments of a Workforce Person
I_WorkerSearch view inner COMPOSITE Workforce CDS view for OP
I_WorkforcePerson view from COMPOSITE Workforce Person Details
I_WorkforcePersonAll view_entity inner COMPOSITE Workforce Person Details
I_WorkForcePersonBPToSupplier view_entity from COMPOSITE Workforce Person BP or Supplier info
I_WorkForcePersonPayt view left_outer COMPOSITE Workforce Person Payment Details for Object Page
I_WorkForcePersonSearch view from COMPOSITE Workforce Person basic details
I_WorkforcePersonTP view_entity from TRANSACTIONAL BUM - Workforce Person TP
N_PersonWorkAgreement_1 view inner Auxillary view
N_PersonWorkAgreement_2 view inner Auxillary View for New Persistency
P_BankaccountWithBGN view left_outer BASIC
P_BG_SAFTCUSTOMERID view_entity inner CONSUMPTION
P_BG_SAFTSUPPLIERID view_entity inner CONSUMPTION
P_BPCreditRiskClass view from COMPOSITE
P_BPNumInExtSystemValueHelp view from BASIC
P_BPTRANSPSTDCARRALPHACODE view_entity inner COMPOSITE
P_BusinessPartnerByUUID view_entity from BASIC
P_BusinessPartnerForMyUser view from COMPOSITE
P_BusinessPartnerTranspIATA view_entity inner COMPOSITE
P_BusinessUser view_entity from BASIC Business User
P_CABusinessPartnerWithVAT view_entity inner COMPOSITE
P_CO_DIANBusPartnerTaxNumber view inner CONSUMPTION
P_CollsAcctColl view_entity inner COMPOSITE Collections Account - FI
P_CollsAcctFI view_entity inner COMPOSITE Collections Account - FI
P_ContactCardType view from COMPOSITE
P_CorrespondenceBuPaEmailAddr view from CONSUMPTION Business Partner Email Addresses
P_CorrespondenceBuPaEmailAddr view union CONSUMPTION Business Partner Email Addresses
P_CPBUPAEMAILALL view union CONSUMPTION Business Partner Emails from all sources
P_Cpbupafaxall view inner CONSUMPTION Business Partner Emails from all sources
P_Cpbupafaxall view union_all CONSUMPTION Business Partner Emails from all sources
P_CreditLimitChange1 view from CONSUMPTION
P_EngmntProjectRoleAssgmt view left_outer COMPOSITE
P_IN_CustomerTaxNumber view_entity inner COMPOSITE
P_ISU_EL_HEADER_BR view inner BASIC
P_JP_CentralBkPaytWithItems view left_outer CONSUMPTION View for Japan Central Bank Payment Detail Items
P_LU_SAFTJournalItemBP view inner COMPOSITE
P_MfgOpActyTeamUserAssgmt view inner COMPOSITE
P_N_PersonWorkAgreement_1 view inner BASIC
P_NL_SAFTBPType view from COMPOSITE
P_NL_SAFTBusinessPartnerCntct view from COMPOSITE
P_NO_SAFTJournalCustSupMD view inner COMPOSITE SAF-T Norway Journal Item BP Master Data
P_O_PersonWorkAgreement_1 view inner BASIC
P_PE_BusinessPartnerTaxNumber view_entity from CONSUMPTION
P_PH_CASForeignBPTIN view_entity inner COMPOSITE
P_PH_ForeignBPTIN view_entity inner COMPOSITE
P_PPM_User view inner BASIC
P_PT_CADocItmAnnex view_entity inner CONSUMPTION Contract Accounting Document Item for Portugal Annex O
P_QltyBPEmployee view from BASIC
P_RO_SAFTCActgPartner view_entity from CONSUMPTION
P_RO_SAFTCACTGPARTNER_RO9 view_entity from CONSUMPTION
P_RO_SAFTCACTGPARTNER_ROX view_entity from CONSUMPTION
P_RO_SAFTCActgStdPartAddr view_entity from CONSUMPTION
P_RO_SAFTCActgStdPartAddrTxNr view_entity from CONSUMPTION
P_RO_SAFTCACTGSTDPARTADDRTXNRM view_entity from CONSUMPTION
P_RO_SAFTCustomerVATNumber view_entity inner CONSUMPTION RO SAFT Customer VAT number
P_RO_SAFTSupplierVATNumber view_entity inner CONSUMPTION RO SAFT Supplier VAT number
P_RSHResourceAuthData view inner COMPOSITE
P_RU_BusinessPartnerEmailAll view inner COMPOSITE
P_SAFTJournalItemBP view inner COMPOSITE
P_SalesCustomerContacts view from CONSUMPTION Sales Customer Contacts
P_WLF_CDS_PERNR_BEGRU view inner BASIC
P_WorkforcePerson view from COMPOSITE
R_BPUsrChangeDocument view_entity inner BASIC Business User Change Document
R_ChgRecdBusinessPartner view_entity from COMPOSITE Change Record Business Partner
R_LU_SAFTContractAccountBP view_entity inner COMPOSITE SAFT LU Contract Account BP
R_ManagerContactCard view_entity inner COMPOSITE Manager Details
R_SrcgSuplrListBPDetailsVH view_entity from COMPOSITE Bus Partner Details for Srcg Suplr List
R_WorkAssgmtPaymentTP view_entity inner TRANSACTIONAL TP View for Payment for Workforce Person
R_WorkforcePerson view_entity from COMPOSITE Workforce Person data
SHSM_SERVICEENTRYSHEETLEANITEM view left_outer Selection View For SESITEM_C Value Help
SHSM_UDM_BP_ROLE view from Business Partners in Credit Management
SHSM_UKM_BP_ROLE view from Business Partners in Credit Management
SHSM_USR21 view inner CDS replacing V_USR_NAME in search help
WFD_PremG view left_outer Workforce Domain - Sel view for PREMG
WFD_PremJ view left_outer Workforce Domain - Sel view for PREMJ
WFD_PremK view left_outer Workforce Domain - Sel view for PREMK

Fields (112)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit,BusinessPartnerSupplier,ContactPerson,EmployeeInternalID,partner,Person,TransportationVehicleDriver 129
KEY BusinessPartnerCategory BusinessPartnerCategory 30
KEY BusinessPartnerUUID BusinessPartnerUUID,partner_guid,PersonUUID,WorkAssignmentUUID 44
_AcademicTitleText _AcademicTitleText 3
_AcademicTitleValueHelp _AcademicTitleValueHelp 5
_AddressIndependentEmail _AddressIndependentEmail 1
_AddressIndependentFax _AddressIndependentFax 1
_AddressIndependentMobile _AddressIndependentMobile 1
_AddressIndependentPhone _AddressIndependentPhone 1
_BPCreditWorthiness _BPCreditWorthiness 2
_BPEmployment _BPEmployment 2
_BPFinancialServicesExt _BPFinancialServicesExt 2
_BPFinancialServicesExtn _BPFinancialServicesExtn 2
_BPRating _BPRating 2
_BuPaIdentification _BuPaIdentification 2
_BusinessPartnerIndustry _BusinessPartnerIndustry 3
_BusinessPartnerRole _BusinessPartnerRole 3
_CreatedByUser _CreatedByUser 2
_CurrentDefaultAddress _CurrentDefaultAddress 6
_DefaultAddress _DefaultAddress 3
_Industries _Industries 2
_LastChangedByUser _LastChangedByUser 2
AcademicTitle AcademicTitle 11
AcademicTitle2 AcademicSecondTitle,AcademicTitle2 5
AdditionalLastName AdditionalLastName 11
AuthorizationGroup AuthorizationGroup,pernr_begru 88
BirthDate BirthDate 17
BPDataControllerIsNotRequired BPDataControllerIsNotRequired 1
BPFirstNameSearchHelp BPFirstNameSearchHelp,GivenName 6
BPLastNameSearchHelp BPLastNameSearchHelp,FamilyName 6
BusinessPartnerBirthDateStatus BusinessPartnerBirthDateStatus 3
BusinessPartnerBirthName BirthName,BusinessPartnerBirthName 6
BusinessPartnerBirthplaceName BusinessPartnerBirthplaceName 4
BusinessPartnerDataOriginType BusinessPartnerDataOriginType 3
BusinessPartnerDeathDate BusinessPartnerDeathDate 3
BusinessPartnerFullName BusinessPartnerFullName,FullName 15
BusinessPartnerGrouping BusinessPartnerGrouping 7
BusinessPartnerGroupType BusinessPartnerGroupType 2
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem 9
BusinessPartnerIsBlocked BusinessPartnerIsBlocked 12
BusinessPartnerIsNotReleased BusinessPartnerIsNotReleased 5
BusinessPartnerName BPCustomerName,BusinessPartnerFullName,BusinessPartnerName,CompanyName,TranspVehicleDriverName 38
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel,NickName 6
BusinessPartnerOccupation BusinessPartnerOccupation 3
BusinessPartnerPrintFormat BusinessPartnerPrintFormat 4
BusinessPartnerSalutation BusinessPartnerSalutation 3
BusinessPartnerSupplementName BusinessPartnerSupplementName,NameSupplement 5
BusinessPartnerType BusinessPartnerType 11
BusPartMaritalStatus BusPartMaritalStatus 4
BusPartNationality BusPartNationality 4
ContactPermission ContactPermission 3
CorrespondenceLanguage BPCorrespondenceLanguage,CorrespondenceLanguage,NativePreferredLanguage 9
CreatedByUser CreatedByUser 6
CreationDate CreationDate 5
CreationTime CreationTime 5
DataController1 DataController1 70
DataController10 DataController10 70
DataController2 DataController2 70
DataController3 DataController3 70
DataController4 DataController4 70
DataController5 DataController5 70
DataController6 DataController6 70
DataController7 DataController7 70
DataController8 DataController8 70
DataController9 DataController9 70
DataControllerSet DataControllerSet 70
ETag ETag,LastChangeDateTime 6
FirstName FirstName,GivenName,PartnerFirstName,UxFcFirstName 50
FormOfAddress FormOfAddress,FormOfAddressGroup,FormOfAddressOrganization,FormOfAddressPerson 14
GenderCodeName GenderCodeName 6
GroupBusinessPartnerName1 FirstName,GroupBusinessPartnerName1,UxFcGroupBusinessPartnerName1 13
GroupBusinessPartnerName2 GroupBusinessPartnerName2,LastName,UxFcGroupBusinessPartnerName2 10
IndependentAddressID IndependentAddressID 4
Industry Industry 5
Initials Initials 5
InternationalLocationNumber1 InternationalLocationNumber1 2
InternationalLocationNumber2 InternationalLocationNumber2 2
InternationalLocationNumber3 InternationalLocationNumber3 2
IsActiveEntity IsActiveEntity 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 86
IsFemale IsFemale 3
IsMale IsMale 3
IsMarkedForArchiving IsMarkedForArchiving 8
IsNaturalPerson IsNaturalPerson 6
IsNotContractuallyCapable IsNotContractuallyCapable 1
IsSexUnknown IsSexUnknown 3
Language BPLanguage,Language 6
LastChangeDate LastChangeDate 4
LastChangedByUser LastChangedByUser 5
LastChangeTime LastChangeTime 4
LastName FamilyName,LastName,PartnerLastName,UxFcLastName 50
LastNamePrefix LastNamePrefix 5
LastNameSecondPrefix LastNameSecondPrefix 5
LegalEntityOfOrganization LegalEntityOfOrganization 3
LegalForm LegalForm 5
MiddleName MiddleName 14
NameCountry NameCountry 8
NameFormat NameFormat 6
NaturalPersonEmployerName NaturalPersonEmployerName 2
NonResidentCompanyOriginCntry NonResidentCompanyOriginCntry 3
OrganizationBPName1 FirstName,OrganizationBPName1,UxFcOrganizationBPName1 26
OrganizationBPName2 LastName,OrganizationBPName2,UxFcOrganizationBPName2 23
OrganizationBPName3 OrganizationBPName3 12
OrganizationBPName4 OrganizationBPName4 12
OrganizationFoundationDate OrganizationFoundationDate 5
OrganizationLiquidationDate OrganizationLiquidationDate 5
PersonFullName BusinessPartnerFullName,EmployeeFullName,Person_full_name,PersonFullName 28
PersonNumber AddressPersonID,PersonNumber 13
SearchTerm1 SearchTerm1 12
SearchTerm2 SearchTerm2 13
TrdCmplncLicenseIsMilitarySctr TrdCmplncLicenseIsMilitarySctr 2
TrdCmplncLicenseIsNuclearSctr TrdCmplncLicenseIsNuclearSctr 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Business Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNER (
    BUSINESSPARTNER,
    BUSINESSPARTNERCATEGORY,
    BUSINESSPARTNERUUID,
    _ACADEMICTITLETEXT,
    _ACADEMICTITLEVALUEHELP,
    _ADDRESSINDEPENDENTEMAIL,
    _ADDRESSINDEPENDENTFAX,
    _ADDRESSINDEPENDENTMOBILE,
    _ADDRESSINDEPENDENTPHONE,
    _BPCREDITWORTHINESS,
    _BPEMPLOYMENT,
    _BPFINANCIALSERVICESEXT,
    _BPFINANCIALSERVICESEXTN,
    _BPRATING,
    _BUPAIDENTIFICATION,
    _BUSINESSPARTNERINDUSTRY,
    _BUSINESSPARTNERROLE,
    _CREATEDBYUSER,
    _CURRENTDEFAULTADDRESS,
    _DEFAULTADDRESS,
    _INDUSTRIES,
    _LASTCHANGEDBYUSER,
    ACADEMICTITLE,
    ACADEMICTITLE2,
    ADDITIONALLASTNAME,
    AUTHORIZATIONGROUP,
    BIRTHDATE,
    BPDATACONTROLLERISNOTREQUIRED,
    BPFIRSTNAMESEARCHHELP,
    BPLASTNAMESEARCHHELP,
    BUSINESSPARTNERBIRTHDATESTATUS,
    BUSINESSPARTNERBIRTHNAME,
    BUSINESSPARTNERBIRTHPLACENAME,
    BUSINESSPARTNERDATAORIGINTYPE,
    BUSINESSPARTNERDEATHDATE,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERGROUPING,
    BUSINESSPARTNERGROUPTYPE,
    BUSINESSPARTNERIDBYEXTSYSTEM,
    BUSINESSPARTNERISBLOCKED,
    BUSINESSPARTNERISNOTRELEASED,
    BUSINESSPARTNERNAME,
    BUSINESSPARTNERNICKNAMELABEL,
    BUSINESSPARTNEROCCUPATION,
    BUSINESSPARTNERPRINTFORMAT,
    BUSINESSPARTNERSALUTATION,
    BUSINESSPARTNERSUPPLEMENTNAME,
    BUSINESSPARTNERTYPE,
    BUSPARTMARITALSTATUS,
    BUSPARTNATIONALITY,
    CONTACTPERMISSION,
    CORRESPONDENCELANGUAGE,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    ETAG,
    FIRSTNAME,
    FORMOFADDRESS,
    GENDERCODENAME,
    GROUPBUSINESSPARTNERNAME1,
    GROUPBUSINESSPARTNERNAME2,
    INDEPENDENTADDRESSID,
    INDUSTRY,
    INITIALS,
    INTERNATIONALLOCATIONNUMBER1,
    INTERNATIONALLOCATIONNUMBER2,
    INTERNATIONALLOCATIONNUMBER3,
    ISACTIVEENTITY,
    ISBUSINESSPURPOSECOMPLETED,
    ISFEMALE,
    ISMALE,
    ISMARKEDFORARCHIVING,
    ISNATURALPERSON,
    ISNOTCONTRACTUALLYCAPABLE,
    ISSEXUNKNOWN,
    LANGUAGE,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    LASTNAME,
    LASTNAMEPREFIX,
    LASTNAMESECONDPREFIX,
    LEGALENTITYOFORGANIZATION,
    LEGALFORM,
    MIDDLENAME,
    NAMECOUNTRY,
    NAMEFORMAT,
    NATURALPERSONEMPLOYERNAME,
    NONRESIDENTCOMPANYORIGINCNTRY,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    ORGANIZATIONBPNAME3,
    ORGANIZATIONBPNAME4,
    ORGANIZATIONFOUNDATIONDATE,
    ORGANIZATIONLIQUIDATIONDATE,
    PERSONFULLNAME,
    PERSONNUMBER,
    SEARCHTERM1,
    SEARCHTERM2,
    TRDCMPLNCLICENSEISMILITARYSCTR,
    TRDCMPLNCLICENSEISNUCLEARSCTR,
    PRIMARY KEY (BUSINESSPARTNER, BUSINESSPARTNERCATEGORY, BUSINESSPARTNERUUID)
);

Learn More