C_Businesspartnersalesareatax

DDL: C_BUSINESSPARTNERSALESAREATAX SQL: CBUPASATAX Type: view CONSUMPTION
22 Fields 1 Data Sources 7 Associations

BP SA TAX CONSUMPTION VIEW

C_Businesspartnersalesareatax is a Consumption CDS View that provides data about "BP SA TAX CONSUMPTION VIEW" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerSlsAreaTaxTP) and exposes 22 fields with key fields DepartureCountry, CustomerTaxCategory, SalesOrganization, DistributionChannel, Division. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerSlsAreaTaxTP BusinessPartnerSalesAreaTax from

Associations (7)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartnerSalesArea _BusinessPartnerSalesArea $projection.BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner and $projection.SalesOrganization = _BusinessPartnerSalesArea.SalesOrganization and $projection.DistributionChannel = _BusinessPartnerSalesArea.DistributionChannel and $projection.Division = _BusinessPartnerSalesArea.Division
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..*] C_TaxCatVHTextTemp _TaxCategoryText $projection.CustomerTaxCategory = _TaxCategoryText.ConditionType
[1..*] C_TaxClassfctnTextVHTemp _TaxClassfctnText $projection.CustomerTaxClassification = _TaxClassfctnText.TaxClassification and $projection.CustomerTaxCategory = _TaxClassfctnText.TaxCategory
[0..*] C_Countrytextvhtemp _CountryText $projection.DepartureCountryForEdit = _CountryText.Country
[0..*] C_BPCustSlsAddrDepdntTaxInfo _BPCustSlsAddrDepdntTaxInfo $projection.BusinessPartner = _BPCustSlsAddrDepdntTaxInfo.BusinessPartner and $projection.SalesOrganization = _BPCustSlsAddrDepdntTaxInfo.SalesOrganization and $projection.DistributionChannel = _BPCustSlsAddrDepdntTaxInfo.DistributionChannel and $projection.Division = _BPCustSlsAddrDepdntTaxInfo.Division and $projection.DepartureCountry = _BPCustSlsAddrDepdntTaxInfo.DepartureCountry and $projection.CustomerTaxCategory = _BPCustSlsAddrDepdntTaxInfo.CustomerTaxCategory

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CBUPASATAX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label BP SA TAX CONSUMPTION VIEW view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Sales Area Tax view
UI.headerInfo.typeNamePlural Sales Area Taxes view
UI.headerInfo.title.label Tax Category Description view
UI.headerInfo.title.value ConditionText view
VDM.viewType #CONSUMPTION view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY DepartureCountry I_BusinessPartnerSlsAreaTaxTP DepartureCountry Departure Country / Region
KEY CustomerTaxCategory I_BusinessPartnerSlsAreaTaxTP CustomerTaxCategory Tax Cndn Type
KEY SalesOrganization I_BusinessPartnerSlsAreaTaxTP SalesOrganization Sales Organization
KEY DistributionChannel I_BusinessPartnerSlsAreaTaxTP DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_BusinessPartnerSlsAreaTaxTP Division Internal Division ID
KEY BusinessPartner I_BusinessPartnerSlsAreaTaxTP BusinessPartner Issuing Authority
BusinessPartnerForEdit I_BusinessPartnerSlsAreaTaxTP BusinessPartnerForEdit Busn. Partner
DepartureCountryForEdit I_BusinessPartnerSlsAreaTaxTP DepartureCountryForEdit Dep. Ctry/Reg.
Customer I_BusinessPartnerSlsAreaTaxTP Customer Sold-to Party
CustomerTaxCategoryForEdit I_BusinessPartnerSlsAreaTaxTP CustomerTaxCategoryForEdit Tax Cndn Type
CustomerTaxClassification I_BusinessPartnerSlsAreaTaxTP CustomerTaxClassification Tax Classific.
BusinessPartnerUUID I_BusinessPartnerSlsAreaTaxTP BusinessPartnerUUID UUID
SalesOrganizationForEdit I_BusinessPartnerSlsAreaTaxTP SalesOrganizationForEdit Sales Org.
DistributionChannelForEdit I_BusinessPartnerSlsAreaTaxTP DistributionChannelForEdit RefDistCh-Cust/Mat.
DivisionForEdit I_BusinessPartnerSlsAreaTaxTP DivisionForEdit Division
_BusinessPartnerSalesArea _BusinessPartnerSalesArea
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_TaxCategoryText _TaxCategoryText
_TaxClassfctnText _TaxClassfctnText
_CountryText _CountryText
_BPCustSlsAddrDepdntTaxInfo _BPCustSlsAddrDepdntTaxInfo

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_Businesspartnersalesareatax.
-- 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.
-- SQL view name: CBUPASATAX

CREATE VIEW C_Businesspartnersalesareatax AS
SELECT
  BusinessPartnerSalesAreaTax.DepartureCountry AS DepartureCountry,
  BusinessPartnerSalesAreaTax.CustomerTaxCategory AS CustomerTaxCategory,
  BusinessPartnerSalesAreaTax.SalesOrganization AS SalesOrganization,
  BusinessPartnerSalesAreaTax.DistributionChannel AS DistributionChannel,
  BusinessPartnerSalesAreaTax.Division AS Division,
  BusinessPartnerSalesAreaTax.BusinessPartner AS BusinessPartner,
  BusinessPartnerSalesAreaTax.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerSalesAreaTax.DepartureCountryForEdit AS DepartureCountryForEdit,
  BusinessPartnerSalesAreaTax.Customer AS Customer,
  BusinessPartnerSalesAreaTax.CustomerTaxCategoryForEdit AS CustomerTaxCategoryForEdit,
  BusinessPartnerSalesAreaTax.CustomerTaxClassification AS CustomerTaxClassification,
  BusinessPartnerSalesAreaTax.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerSalesAreaTax.SalesOrganizationForEdit AS SalesOrganizationForEdit,
  BusinessPartnerSalesAreaTax.DistributionChannelForEdit AS DistributionChannelForEdit,
  BusinessPartnerSalesAreaTax.DivisionForEdit AS DivisionForEdit
FROM I_BusinessPartnerSlsAreaTaxTP AS BusinessPartnerSalesAreaTax
LEFT OUTER JOIN C_BusinessPartnerSalesArea AS _BusinessPartnerSalesArea ON BusinessPartner = _BusinessPartnerSalesArea.BusinessPartner AND SalesOrganization = _BusinessPartnerSalesArea.SalesOrganization AND DistributionChannel = _BusinessPartnerSalesArea.DistributionChannel AND Division = _BusinessPartnerSalesArea.Division  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_TaxCatVHTextTemp AS _TaxCategoryText ON CustomerTaxCategory = _TaxCategoryText.ConditionType  -- association [0..*]
LEFT OUTER JOIN C_TaxClassfctnTextVHTemp AS _TaxClassfctnText ON CustomerTaxClassification = _TaxClassfctnText.TaxClassification AND CustomerTaxCategory = _TaxClassfctnText.TaxCategory  -- association [1..*]
LEFT OUTER JOIN C_Countrytextvhtemp AS _CountryText ON DepartureCountryForEdit = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN C_BPCustSlsAddrDepdntTaxInfo AS _BPCustSlsAddrDepdntTaxInfo ON BusinessPartner = _BPCustSlsAddrDepdntTaxInfo.BusinessPartner AND SalesOrganization = _BPCustSlsAddrDepdntTaxInfo.SalesOrganization AND DistributionChannel = _BPCustSlsAddrDepdntTaxInfo.DistributionChannel AND Division = _BPCustSlsAddrDepdntTaxInfo.Division AND DepartureCountry = _BPCustSlsAddrDepdntTaxInfo.DepartureCountry AND CustomerTaxCategory = _BPCustSlsAddrDepdntTaxInfo.CustomerTaxCategory  -- association [0..*]
;

Learn More