I_BPADDITIONALCUSTOMERTP
BO view for Additional Customers of BP
I_BPADDITIONALCUSTOMERTP is a CDS View in S/4HANA. BO view for Additional Customers of BP. It contains 29 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_BPAdditionalCustomer | view | from | CONSUMPTION | C view for BP Additional Customers |
Fields (29)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BusinessPartner | BusinessPartner | 1 |
| KEY | Customer | Customer | 1 |
| AddressNumber | AddressNumber | 1 | |
| AlternativePayerAccount | AlternativePayerAccount | 1 | |
| AuthorizationGroup | AuthorizationGroup | 1 | |
| BillingIsBlockedForCustomer | BillingIsBlockedForCustomer | 1 | |
| BPAssignmentReasonID | BPAssignmentReasonID | 1 | |
| BusinessPartnerForEdit | BusinessPartnerForEdit | 1 | |
| CityName | CityName | 1 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 1 | |
| Country | Country | 1 | |
| CustomerAccountGroup | CustomerAccountGroup | 1 | |
| CustomerClassification | CustomerClassification | 1 | |
| CustomerForEdit | CustomerForEdit | 1 | |
| DataMediumExchangeIndicator | DataMediumExchangeIndicator | 1 | |
| DeletionIndicator | DeletionIndicator | 1 | |
| DeliveryDateTypeRule | DeliveryDateTypeRule | 1 | |
| DeliveryIsBlocked | DeliveryIsBlocked | 1 | |
| HouseNumber | HouseNumber | 1 | |
| OrderIsBlockedForCustomer | OrderIsBlockedForCustomer | 1 | |
| POBox | POBox | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| PostalCode | PostalCode | 1 | |
| PostingIsBlocked | PostingIsBlocked | 1 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 1 | |
| Region | Region | 1 | |
| StreetName | StreetName | 1 | |
| Supplier | Supplier | 1 | |
| VATLiability | VATLiability | 1 |
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.
-- BO view for Additional Customers of BP
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPADDITIONALCUSTOMERTP (
BUSINESSPARTNER,
CUSTOMER,
ADDRESSNUMBER,
ALTERNATIVEPAYERACCOUNT,
AUTHORIZATIONGROUP,
BILLINGISBLOCKEDFORCUSTOMER,
BPASSIGNMENTREASONID,
BUSINESSPARTNERFOREDIT,
CITYNAME,
CORRESPONDENCELANGUAGE,
COUNTRY,
CUSTOMERACCOUNTGROUP,
CUSTOMERCLASSIFICATION,
CUSTOMERFOREDIT,
DATAMEDIUMEXCHANGEINDICATOR,
DELETIONINDICATOR,
DELIVERYDATETYPERULE,
DELIVERYISBLOCKED,
HOUSENUMBER,
ORDERISBLOCKEDFORCUSTOMER,
POBOX,
POBOXPOSTALCODE,
POSTALCODE,
POSTINGISBLOCKED,
PRFRDCOMMMEDIUMTYPE,
REGION,
STREETNAME,
SUPPLIER,
VATLIABILITY,
PRIMARY KEY (BUSINESSPARTNER, CUSTOMER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA