I_BUSINESSPARTNERTAXNUMBER

CDS View
4 Fields 27 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. 27 CDS views read from this table.

CDS Views using this table (27)

ViewTypeJoinVDMDescription
A_BusinessPartnerTaxNumber view from BASIC Tax Number
C_BG_SAFTBusPartEUTaxNumber view_entity inner CONSUMPTION BP EU VAT Number for BG SAFT
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 inner COMPOSITE Colombia UGPP Business Partner Tax Number
I_IN_EDCBusinessPartnerVH view_entity from BASIC India GSTR Business Partner
P_BE_AnnSlsListCABPTaxNumber view_entity from CONSUMPTION Domestic Sales List FI-CA BP Tax Number Helper View
P_BG_SAFTCUSTOMERID view_entity from CONSUMPTION BG SAFT Customer ID
P_BG_SAFTSUPPLIERID view_entity from CONSUMPTION BG SAFT Supplier ID
P_CO_DIANBusPartnerTaxNumber view from CONSUMPTION All Formats - Business Partner Tax Number
P_CO_DIANBusPrtnByRefID view_entity inner CONSUMPTION Colombia DIAN Business Partner By Reference ID
P_CO_UGPPUniqueBPTaxType view_entity from COMPOSITE Colombia UGPP Unique Business Partner Tax Type
P_IL_BusinessPartnerTaxNumber view_entity from COMPOSITE Busines partner IL tax numbers
P_IN_CustomerTaxNumber view_entity inner COMPOSITE Customer Tax Number
P_PE_BPReportingTaxCategory view_entity from CONSUMPTION Peru Business Partner Reporting Tax Category
P_PL_BusinessPartnerTxNumber view_entity from CONSUMPTION SAFT PL KR PD Business Partner Tx Num
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 SAF-T BP Vat Country
R_LU_SAFTContractAccountBP view_entity inner COMPOSITE SAFT LU Contract Account BP
SDM_GLO_RO_BPTAXNUM_BPNUM view_entity left_outer SDM View for DFKKBPTAXNUM - Romania

Fields (4)

KeyField CDS FieldsUsed in Views
KEY BPTaxType BPTaxType,BPTaxTypeForEdit,BPTaxTypeForEditValue 7
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit 8
BPTaxLongNumber BPTaxLongNumber 7
BPTaxNumber BPTaxNumber,TaxNumber3,VATRegistration 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 (
    BPTAXTYPE,
    BUSINESSPARTNER,
    BPTAXLONGNUMBER,
    BPTAXNUMBER,
    PRIMARY KEY (BPTAXTYPE, BUSINESSPARTNER)
);

Learn More