C_PT_SAFTMasterDataTaxCube

DDL: C_PT_SAFTMASTERDATATAXCUBE Type: view_entity CONSUMPTION Package: GLO_FIN_IS_SAFT_PT
40 Fields 4 Data Sources

Tax Master Data Section - Cube

C_PT_SAFTMasterDataTaxCube is a Consumption CDS View (Cube) that provides data about "Tax Master Data Section - Cube" in SAP S/4HANA. It reads from 4 data sources (I_PT_SAFTBillgAccountingTax, I_PT_SAFTSalesInvoiceTax, I_PT_SAFTDeliveryTax, I_PT_SAFTSettlementTax) and exposes 40 fields with key fields CompanyCode, PT_SAFTTaxCode, PT_SAFTTaxType, PT_SAFTCountryText, PT_SAFTTaxCode. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (4)

SourceAliasJoin Type
I_PT_SAFTBillgAccountingTax AcctTax from
I_PT_SAFTSalesInvoiceTax BillTax union
I_PT_SAFTDeliveryTax DelTax union
I_PT_SAFTSettlementTax SMTax union

Parameters (2)

NameTypeDefault
P_StartDate dats
P_EndDate dats

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Analytics.dataCategory #CUBE view
EndUserText.label Tax Master Data Section - Cube view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_PT_SAFTBillgAccountingTax CompanyCode Receiver Company Code
KEY PT_SAFTTaxCode I_PT_SAFTBillgAccountingTax PT_SAFTTaxCode Tax Code
KEY PT_SAFTTaxType I_PT_SAFTBillgAccountingTax PT_SAFTTaxType Tax Type
KEY PT_SAFTCountryText I_PT_SAFTBillgAccountingTax CountryRegion
TaxCodeDescription I_PT_SAFTBillgAccountingTax TaxCodeDescription
CompanyCodeCurrency I_PT_SAFTBillgAccountingTax CompanyCodeCurrency Local Currency
EndDateelse00000000endasValidityEndDate
TaxRate I_PT_SAFTBillgAccountingTax TaxRate Tax Rate
CompanyCode Receiver Company Code
KEY PT_SAFTTaxCode I_PT_SAFTSalesInvoiceTax PT_SAFTTaxCode Tax Code
KEY PT_SAFTTaxType I_PT_SAFTSalesInvoiceTax PT_SAFTTaxType Tax Type
KEY PT_SAFTCountryText I_PT_SAFTSalesInvoiceTax CountryRegion
TaxCodeDescription I_PT_SAFTSalesInvoiceTax TaxCodeDescription
CompanyCodeCurrency I_PT_SAFTSalesInvoiceTax CompanyCodeCurrency Local Currency
EndDateelse00000000endasValidityEndDate
TaxRate I_PT_SAFTSalesInvoiceTax TaxRate Tax Rate
CompanyCode Receiver Company Code
KEY PT_SAFTTaxCode I_PT_SAFTSettlementTax PT_SAFTTaxCode Tax Code
KEY PT_SAFTTaxType I_PT_SAFTSettlementTax PT_SAFTTaxType Tax Type
KEY PT_SAFTCountryText I_PT_SAFTSettlementTax CountryRegion
TaxCodeDescription I_PT_SAFTSettlementTax TaxCodeDescription
CompanyCodeCurrency I_PT_SAFTSettlementTax CompanyCodeCurrency Local Currency
EndDateelse00000000endasValidityEndDate
TaxRate I_PT_SAFTSettlementTax TaxRate Tax Rate
CompanyCode Receiver Company Code
KEY PT_SAFTTaxCode I_PT_SAFTDeliveryTax TargetTaxCode Tax Code
KEY PT_SAFTTaxType I_PT_SAFTDeliveryTax TaxType Tax Type
KEY PT_SAFTCountryText I_PT_SAFTDeliveryTax TaxReturnCountry
TaxCodeDescription I_PT_SAFTDeliveryTax TaxCodeDescription
CompanyCodeCurrency I_PT_SAFTDeliveryTax CompanyCodeCurrency Local Currency
EndDateelse00000000endasValidityEndDate
TaxRate I_PT_SAFTDeliveryTax TaxRate Tax Rate
KEY PT_SAFTTaxCode PT_SAFTTaxCode Tax Code
KEY PT_SAFTTaxType PT_SAFTTaxType Tax Type
KEY PT_SAFTCountryText PT_SAFTCountryText
TaxCodeDescription TaxCodeDescription
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ValidityEndDate ValidityEndDate ValidTo
TaxRate TaxRate Tax Rate
TaxAmount TaxAmount Tax Amt in Rptg Crcy

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_PT_SAFTMasterDataTaxCube.
-- 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.
-- Parameters: P_StartDate : dats, P_EndDate : dats

CREATE VIEW C_PT_SAFTMasterDataTaxCube AS
SELECT
  AcctTax.CompanyCode AS CompanyCode,
  AcctTax.PT_SAFTTaxCode AS PT_SAFTTaxCode,
  AcctTax.PT_SAFTTaxType AS PT_SAFTTaxType,
  AcctTax.CountryRegion AS PT_SAFTCountryText,
  AcctTax.TaxCodeDescription AS TaxCodeDescription,
  AcctTax.CompanyCodeCurrency AS CompanyCodeCurrency,
  case when AcctTax.EndDate <= $parameters.P_EndDate then AcctTax.EndDate else '00000000' end as ValidityEndDate AS EndDateelse00000000endasValidityEndDate,
  AcctTax.TaxRate AS TaxRate,
  ValidityEndDate,
  TaxAmount
FROM I_PT_SAFTBillgAccountingTax AS AcctTax
-- UNION with additional select branch(es): I_PT_SAFTSalesInvoiceTax, I_PT_SAFTSettlementTax, I_PT_SAFTDeliveryTax
;

Learn More