C_SupplierBusinessPartnerTax

DDL: C_SUPPLIERBUSINESSPARTNERTAX Type: view_entity CONSUMPTION
7 Fields 1 Data Sources 2 Associations 1 OData Services 1 Fiori Apps

Supplier Business Partner Tax Number

C_SupplierBusinessPartnerTax is a Consumption CDS View that provides data about "Supplier Business Partner Tax Number" in SAP S/4HANA. It reads from 1 data source (I_Businesspartnertaxnumber) and exposes 7 fields with key fields BusinessPartner, BPTaxType. It has 2 associations to related views. It is exposed through 1 OData service (FAP_DISPLAY_SUPPLIER_LIST). It is used in 1 Fiori application: Display Supplier List.

Data Sources (1)

SourceAliasJoin Type
I_Businesspartnertaxnumber BusinessPartnerTaxNumber from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] I_BusPartTaxTypeText _TaxCategoryText $projection.BPTaxType = _TaxCategoryText.BPTaxType and _TaxCategoryText.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Business Partner Tax Number view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
FAP_DISPLAY_SUPPLIER_LIST FAP_DISPLAY_SUPPLIER_LIST V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F1861 Display Supplier List Transactional Display Supplier List

Display Supplier List

Business Role: Accounts Payable Accountant

With this app you can display and download a list of suppliers. You can use the search filters to create custom lists of suppliers to provide to stakeholders and auditors. Key FeaturesView contact details for your suppliersGenerate custom lists of obsolete suppliers, blocked suppliers, or suppliers based on payment methodAccess the bank details and payment methods for your suppliers

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_Businesspartnertaxnumber BusinessPartner Issuing Authority
KEY BPTaxType I_Businesspartnertaxnumber BPTaxType Category
BPTaxNumber I_Businesspartnertaxnumber BPTaxNumber Tax Number
BPTaxLongNumber I_Businesspartnertaxnumber BPTaxLongNumber Tax Number Long
TaxTypeName _TaxCategoryText TaxTypeName
AuthorizationGroup _BusinessPartner AuthorizationGroup AuthorizGroup
_BusinessPartner _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SupplierBusinessPartnerTax.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_SupplierBusinessPartnerTax AS
SELECT
  BusinessPartnerTaxNumber.BusinessPartner AS BusinessPartner,
  BusinessPartnerTaxNumber.BPTaxType AS BPTaxType,
  BusinessPartnerTaxNumber.BPTaxNumber AS BPTaxNumber,
  BusinessPartnerTaxNumber.BPTaxLongNumber AS BPTaxLongNumber,
  _TaxCategoryText.TaxTypeName AS TaxTypeName,
  _BusinessPartner.AuthorizationGroup AS AuthorizationGroup
FROM I_Businesspartnertaxnumber AS BusinessPartnerTaxNumber
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusPartTaxTypeText AS _TaxCategoryText ON BPTaxType = _TaxCategoryText.BPTaxType AND _TaxCategoryText.Language = $session.system_language  -- association [1..1]
;

Learn More