I_BUSINESSPARTNERTAXNUMBER

CDS View
4 Fields 15 CDS Views

Core view for Tax Number

I_BUSINESSPARTNERTAXNUMBER is a CDS View in S/4HANA. Core view for Tax Number. It contains 4 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
A_BusinessPartnerTaxNumber view from BASIC Tax Number
C_NL_SAFTBusinessPartner view left_outer CONSUMPTION SAF-T NL Business Partner
C_QA_BPIdentificationTypeNmbr view from CONSUMPTION BP Identification Number
C_RO_SAFTBusPartEUTaxNumber view inner CONSUMPTION BP EU VAT Number for RO SAFT
C_SupplierBusinessPartnerTax view_entity from CONSUMPTION Supplier Business Partner Tax Number
I_BusinessPartnerTaxNumberTP view from TRANSACTIONAL Partner Tax Number BO View
I_BusinessPartnerTaxNumberTP_2 view_entity from TRANSACTIONAL Business Partner Tax Number
I_BusPartTaxNumberGov view union_all COMPOSITE BP Tax Number Governance
I_CO_UGPPBusPartnerTaxNumber view_entity from COMPOSITE
P_CO_DIANBusPartnerTaxNumber view from CONSUMPTION
P_CO_DIANBusPrtnByRefID view_entity inner CONSUMPTION
P_PT_CADocItmAnnex view_entity inner CONSUMPTION Contract Accounting Document Item for Portugal Annex O
P_RO_SAFTCustomerVATNumber view_entity from CONSUMPTION RO SAFT Customer VAT number
P_RO_SAFTSupplierVATNumber view_entity from CONSUMPTION RO SAFT Supplier VAT number
P_SAFTBPVATCountry view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY BPTaxLongNumber BPTaxLongNumber 5
KEY BPTaxNumber BPTaxNumber,VATRegistration 4
KEY BPTaxType BPTaxType,BPTaxTypeForEdit,BPTaxTypeForEditValue 5
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit 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.

-- Core view for Tax Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERTAXNUMBER (
    BPTAXLONGNUMBER,
    BPTAXNUMBER,
    BPTAXTYPE,
    BUSINESSPARTNER,
    PRIMARY KEY (BPTAXLONGNUMBER, BPTAXNUMBER, BPTAXTYPE, BUSINESSPARTNER)
);

Learn More