I_BUSINESSPARTNERCUSTOMER

CDS View

Business Partner Customer

I_BUSINESSPARTNERCUSTOMER is a CDS View in S/4HANA. Business Partner Customer. It contains 87 fields. 30 CDS views read from this table.

CDS Views using this table (30)

ViewTypeJoinVDMDescription
C_PurgCustomerBPShipToAddrVH view from CONSUMPTION Customer Ship to Addresses
FISTRPGSTR1ITEM view left_outer
FISTRPGSTR3BITEM view left_outer
I_ACMCustPartnerDetailsVH view from BASIC Customer Partner Details
I_BPCustDeptAddrDepdntInfo view inner COMPOSITE BP and Cust dept Addr Depdnt Info
I_BPCustomerGeneralAddressInfo view inner COMPOSITE BP and Cust Addr Depdnt Info
I_BPCustomerMultiAddrVH view from COMPOSITE Customers by Multiple Addresses
I_BPCustRcvgPtAddrDepdntInfo view inner COMPOSITE BP and Cust rcvg pt Addr Depdnt Info
I_BPCustSlsAddrDepdntTaxInfo view inner COMPOSITE BP and Cust Tax ind Addr Depdnt Info
I_BPCustUnldgPtAddrDepdntInfo view inner COMPOSITE BP and Cust unldg Addr Depdnt Info
I_BusinessPartnerCustomerTP view from TRANSACTIONAL BOPF view customer root
I_BusinessPartnerCustomerTP_2 view_entity from TRANSACTIONAL Business Partner Customer
I_CollsPromiseToPayContactVH view from COMPOSITE Promise To Pay Contact Value Help
I_CustomerContactVH view from COMPOSITE Customer Contact Value Help
P_CollectionsAccount view inner COMPOSITE
P_CollectionsAccountNote view inner COMPOSITE
P_CollMgmtRblsItmForKeyDte3 view inner COMPOSITE
P_CollsAccountCollsSegment view inner COMPOSITE
P_CollsAccountCompanyCode view inner COMPOSITE
P_CollsAcctDocInStrCrcy view inner COMPOSITE
P_CollsCustomerContactNote view inner COMPOSITE
P_CollsResubmissionNote view inner COMPOSITE
P_CrdtMNrOfBrokenPromisesToPay view inner COMPOSITE
P_SI_CustomerIndustry view_entity from COMPOSITE Slovenian Partner Industry
P_SlsOrdReqBPOrgAddr view_entity from COMPOSITE Organization and Address Info
P_SlsOrdReqBPPersAddr view_entity from COMPOSITE Person and Address Info
R_BPCollsSegmentAssignmentTP view_entity inner TRANSACTIONAL Business Partner: Collection Segments
R_CollectionsCustomerQuickView view inner COMPOSITE Customer Quick View
R_CollsHeadOfficeResubmission view inner COMPOSITE Head Office Resubmissions
R_CollsMgmtBusinessPartnerTP view_entity inner TRANSACTIONAL Collections Management: Business Partner

Fields (87)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit 12
KEY Customer BusinessPartner,Customer,CustomerForEdit 16
_CustomerToBusinessPartner _CustomerToBusinessPartner 2
AccountTaxType AccountTaxType 1
AddressID AddressID 3
AlternativePayerAccount AlternativePayerAccount 6
AlternativePayerIsAllowed AlternativePayerIsAllowed 1
AuthorizationGroup AuthorizationGroup,CusAuthorizationGroup 10
BillingIsBlockedForCustomer BillingIsBlockedForCustomer 6
BPIsEqualizationTaxSubject BPIsEqualizationTaxSubject 2
BPPlannedAnnualSalesAmount BPPlannedAnnualSalesAmount 1
BPPlannedAnnualSalesCurrency BPPlannedAnnualSalesCurrency 1
BPPlannedAnnualSalesYear BPPlannedAnnualSalesYear 1
BusinessPartnerGrouping BusinessPartnerGrouping 1
BusinessPartnerUUID BusinessPartnerUUID 2
BusinessType BusinessType 1
CityCode CityCode 2
CityLocationCoordinatesCode CityLocationCoordinatesCode 6
Country Country,land1 2
County County 2
CustomerAccountGroup CustomerAccountGroup 10
CustomerCentralDeletionIsBlock CustomerCentralDeletionIsBlock 2
CustomerClassification CustomerClassification 6
CustomerConditionGroup1 CustomerConditionGroup1 6
CustomerConditionGroup2 CustomerConditionGroup2 6
CustomerConditionGroup3 CustomerConditionGroup3 6
CustomerConditionGroup4 CustomerConditionGroup4 6
CustomerConditionGroup5 CustomerConditionGroup5 6
CustomerCorporateGroup CustomerCorporateGroup 6
CustomerHasUnloadingPoint CustomerHasUnloadingPoint 1
CustomerTradingPartnerID CustomerTradingPartnerID 1
CustomerWorkingTimeCalendar CustomerWorkingTimeCalendar 1
DataController1 DataController1 3
DataController10 DataController10 3
DataController2 DataController2 3
DataController3 DataController3 3
DataController4 DataController4 3
DataController5 DataController5 3
DataController6 DataController6 3
DataController7 DataController7 3
DataController8 DataController8 3
DataController9 DataController9 3
DataControllerSet DataControllerSet 3
DataExchangeInstructionKey DataExchangeInstructionKey 6
DataMediumExchangeIndicator DataMediumExchangeIndicator 6
DeletionIndicator DeletionIndicator 2
DeliveryDateTypeRule DeliveryDateTypeRule 6
DeliveryIsBlocked DeliveryIsBlocked 6
ExpressTrainStationName ExpressTrainStationName 2
FiscalAddress FiscalAddress 6
FiscalYearVariant FiscalYearVariant 1
FreeDefinedAttribute01 FreeDefinedAttribute01 1
FreeDefinedAttribute02 FreeDefinedAttribute02 1
FreeDefinedAttribute03 FreeDefinedAttribute03 6
FreeDefinedAttribute04 FreeDefinedAttribute04 1
FreeDefinedAttribute05 FreeDefinedAttribute05 1
FreeDefinedAttribute06 FreeDefinedAttribute06 1
FreeDefinedAttribute07 FreeDefinedAttribute07 1
FreeDefinedAttribute08 FreeDefinedAttribute08 1
FreeDefinedAttribute09 FreeDefinedAttribute09 1
FreeDefinedAttribute10 FreeDefinedAttribute10 1
IndustryCode1 IndustryCode1 6
IndustryCode2 IndustryCode2 6
IndustryCode3 IndustryCode3 6
IndustryCode4 IndustryCode4 1
IndustryCode5 IndustryCode5 1
IndustryType IndustryType 1
InternationalLocationNumber1 InternationalLocationNumber1 1
InternationalLocationNumber2 InternationalLocationNumber2 1
InternationalLocationNumber3 InternationalLocationNumber3 1
IsBusinessPurposeCompleted CusIsBusinessPurposeCompleted,IsBusinessPurposeCompleted 5
IsCompetitor IsCompetitor 6
IsConsumer IsConsumer 6
IsDefaultSoldToParty IsDefaultSoldToParty 6
IsNaturalPerson IsNaturalPerson 6
IsSalesPartner IsSalesPartner 6
Language Language 2
OrderIsBlockedForCustomer OrderIsBlockedForCustomer 6
PaymentReason PaymentReason 2
Plant Plant 6
PostingIsBlocked PostingIsBlocked 6
Region Region 1
SalesIsBlockedForCustomer SalesIsBlockedForCustomer 1
Supplier Supplier 6
TaxInvoiceRepresentativeName TaxInvoiceRepresentativeName 1
TrainStationName TrainStationName 2
VATLiability VATLiability 6

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 Customer
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERCUSTOMER (
    BUSINESSPARTNER,
    CUSTOMER,
    _CUSTOMERTOBUSINESSPARTNER,
    ACCOUNTTAXTYPE,
    ADDRESSID,
    ALTERNATIVEPAYERACCOUNT,
    ALTERNATIVEPAYERISALLOWED,
    AUTHORIZATIONGROUP,
    BILLINGISBLOCKEDFORCUSTOMER,
    BPISEQUALIZATIONTAXSUBJECT,
    BPPLANNEDANNUALSALESAMOUNT,
    BPPLANNEDANNUALSALESCURRENCY,
    BPPLANNEDANNUALSALESYEAR,
    BUSINESSPARTNERGROUPING,
    BUSINESSPARTNERUUID,
    BUSINESSTYPE,
    CITYCODE,
    CITYLOCATIONCOORDINATESCODE,
    COUNTRY,
    COUNTY,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCENTRALDELETIONISBLOCK,
    CUSTOMERCLASSIFICATION,
    CUSTOMERCONDITIONGROUP1,
    CUSTOMERCONDITIONGROUP2,
    CUSTOMERCONDITIONGROUP3,
    CUSTOMERCONDITIONGROUP4,
    CUSTOMERCONDITIONGROUP5,
    CUSTOMERCORPORATEGROUP,
    CUSTOMERHASUNLOADINGPOINT,
    CUSTOMERTRADINGPARTNERID,
    CUSTOMERWORKINGTIMECALENDAR,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DATAEXCHANGEINSTRUCTIONKEY,
    DATAMEDIUMEXCHANGEINDICATOR,
    DELETIONINDICATOR,
    DELIVERYDATETYPERULE,
    DELIVERYISBLOCKED,
    EXPRESSTRAINSTATIONNAME,
    FISCALADDRESS,
    FISCALYEARVARIANT,
    FREEDEFINEDATTRIBUTE01,
    FREEDEFINEDATTRIBUTE02,
    FREEDEFINEDATTRIBUTE03,
    FREEDEFINEDATTRIBUTE04,
    FREEDEFINEDATTRIBUTE05,
    FREEDEFINEDATTRIBUTE06,
    FREEDEFINEDATTRIBUTE07,
    FREEDEFINEDATTRIBUTE08,
    FREEDEFINEDATTRIBUTE09,
    FREEDEFINEDATTRIBUTE10,
    INDUSTRYCODE1,
    INDUSTRYCODE2,
    INDUSTRYCODE3,
    INDUSTRYCODE4,
    INDUSTRYCODE5,
    INDUSTRYTYPE,
    INTERNATIONALLOCATIONNUMBER1,
    INTERNATIONALLOCATIONNUMBER2,
    INTERNATIONALLOCATIONNUMBER3,
    ISBUSINESSPURPOSECOMPLETED,
    ISCOMPETITOR,
    ISCONSUMER,
    ISDEFAULTSOLDTOPARTY,
    ISNATURALPERSON,
    ISSALESPARTNER,
    LANGUAGE,
    ORDERISBLOCKEDFORCUSTOMER,
    PAYMENTREASON,
    PLANT,
    POSTINGISBLOCKED,
    REGION,
    SALESISBLOCKEDFORCUSTOMER,
    SUPPLIER,
    TAXINVOICEREPRESENTATIVENAME,
    TRAINSTATIONNAME,
    VATLIABILITY,
    PRIMARY KEY (BUSINESSPARTNER, CUSTOMER)
);