P_PT_FITaxItmPrepForAnexoUnion

DDL: P_PT_FITAXITMPREPFORANEXOUNION Type: view_entity CONSUMPTION Package: GLO_FIN_IS_VAT_PT
27 Fields 1 Data Sources 3 Associations

FI Tax items Preperation for Anexo Union

P_PT_FITaxItmPrepForAnexoUnion is a Consumption CDS View that provides data about "FI Tax items Preperation for Anexo Union" in SAP S/4HANA. It reads from 1 data source (P_PT_DocItemWhldgTxCshDisc) and exposes 27 fields with key fields AccountingDocument, CompanyCode, FiscalYear, AccountingDocumentItem, StatryRptgEntity. It has 3 associations to related views. Part of development package GLO_FIN_IS_VAT_PT.

Data Sources (1)

SourceAliasJoin Type
P_PT_DocItemWhldgTxCshDisc whcd from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_Customer_to_BusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer
[0..*] I_Supplier_to_BusinessPartner _SupplierToBusinessPartner $projection.Supplier = _SupplierToBusinessPartner.Supplier
[1..*] I_BusinessPartner _BusinessPartner $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label FI Tax items Preperation for Anexo Union view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument P_PT_DocItemWhldgTxCshDisc AccountingDocument Journal Entry
KEY CompanyCode P_PT_DocItemWhldgTxCshDisc CompanyCode Receiver Company Code
KEY FiscalYear P_PT_DocItemWhldgTxCshDisc FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem P_PT_DocItemWhldgTxCshDisc AccountingDocumentItem Posting View Item
KEY StatryRptgEntity log StatryRptgEntity Reporting Entity
KEY StatryRptCategory log StatryRptCategory Report ID
KEY StatryRptRunID log StatryRptRunID Report Run ID
PostingDate P_PT_DocItemWhldgTxCshDisc PostingDate Posting Date for GR
DocumentDate P_PT_DocItemWhldgTxCshDisc DocumentDate Journal Entry Date
Customer P_PT_DocItemWhldgTxCshDisc Customer Sold-to Party
Supplier P_PT_DocItemWhldgTxCshDisc Supplier Supplier
DebitCreditCode P_PT_DocItemWhldgTxCshDisc DebitCreditCode Single-Character Flag
WithholdingTaxCode P_PT_DocItemWhldgTxCshDisc WithholdingTaxCode WTax Code
BalanceTransactionCurrency P_PT_DocItemWhldgTxCshDisc BalanceTransactionCurrency Currency
AccountingDocumentType P_PT_DocItemWhldgTxCshDisc AccountingDocumentType Journal Entry Type
WithholdingTaxAmount P_PT_DocItemWhldgTxCshDisc WithholdingTaxAmount Withholding Tax Amt
CashDiscountAmtInCoCodeCrcy P_PT_DocItemWhldgTxCshDisc CashDiscountAmtInCoCodeCrcy Discount Amt
CashDiscountAmount P_PT_DocItemWhldgTxCshDisc CashDiscountAmount CD Amount
TransactionCurrency P_PT_DocItemWhldgTxCshDisc TransactionCurrency Transaction Currency
IsSalesRelated P_PT_DocItemWhldgTxCshDisc IsSalesRelated Is Sales Related
AmountInCompanyCodeCurrency P_PT_DocItemWhldgTxCshDisc AmountInCompanyCodeCurrency Local Crcy Amt
FinancialAccountType P_PT_DocItemWhldgTxCshDisc FinancialAccountType Fin. Account Type
AmountInReportingCurrency P_PT_DocItemWhldgTxCshDisc AmountInReportingCurrency
ReportingVATRegistration P_PT_DocItemWhldgTxCshDisc ReportingVATRegistration Reporting VAT Number
CompanyCodeCurrency P_PT_DocItemWhldgTxCshDisc CompanyCodeCurrency Local Currency
VATRegistrationCountry
_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 P_PT_FITaxItmPrepForAnexoUnion.
-- 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 P_PT_FITaxItmPrepForAnexoUnion AS
SELECT
  whcd.AccountingDocument AS AccountingDocument,
  whcd.CompanyCode AS CompanyCode,
  whcd.FiscalYear AS FiscalYear,
  whcd.AccountingDocumentItem AS AccountingDocumentItem,
  log.StatryRptgEntity AS StatryRptgEntity,
  log.StatryRptCategory AS StatryRptCategory,
  log.StatryRptRunID AS StatryRptRunID,
  whcd.PostingDate AS PostingDate,
  whcd.DocumentDate AS DocumentDate,
  whcd.Customer AS Customer,
  whcd.Supplier AS Supplier,
  whcd.DebitCreditCode AS DebitCreditCode,
  whcd.WithholdingTaxCode AS WithholdingTaxCode,
  whcd.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  whcd.AccountingDocumentType AS AccountingDocumentType,
  whcd.WithholdingTaxAmount AS WithholdingTaxAmount,
  whcd.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  whcd.CashDiscountAmount AS CashDiscountAmount,
  whcd.TransactionCurrency AS TransactionCurrency,
  whcd.IsSalesRelated AS IsSalesRelated,
  whcd.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  whcd.FinancialAccountType AS FinancialAccountType,
  whcd.AmountInReportingCurrency AS AmountInReportingCurrency,
  whcd.ReportingVATRegistration AS ReportingVATRegistration,
  whcd.CompanyCodeCurrency AS CompanyCodeCurrency,
  left( whcd.ReportingVATRegistration, 2) AS VATRegistrationCountry
FROM P_PT_DocItemWhldgTxCshDisc AS whcd
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON Customer = _CustomerToBusinessPartner.Customer  -- association [0..*]
LEFT OUTER JOIN I_Supplier_to_BusinessPartner AS _SupplierToBusinessPartner ON Supplier = _SupplierToBusinessPartner.Supplier  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID  -- association [1..*]
;

Learn More