P_PH_ImportationSummaryItem

DDL: P_PH_IMPORTATIONSUMMARYITEM Type: view_entity COMPOSITE
38 Fields 2 Data Sources 1 Associations

P_PH_ImportationSummaryItem is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, I_StRpTaxReturnBoxCube) and exposes 38 fields with key fields CompanyCode, AccountingDocument, FiscalYear, StatryRptgEntity, StatryRptCategory. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem _OperationalAcctgDocItem inner
I_StRpTaxReturnBoxCube I_StRpTaxReturnBoxCube from

Parameters (9)

NameTypeDefault
P_CompanyCode fis_bukrs
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_FromReportingDate vatdate
P_ToReportingDate vatdate
P_FromFiscalYear gjahr
P_ToFiscalYear gjahr

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _CalendarDate $projection.PostingDate = _CalendarDate.CalendarDate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode TaxItem CompanyCode Receiver Company Code
KEY AccountingDocument TaxItem AccountingDocument Journal Entry
KEY FiscalYear TaxItem FiscalYear G/L Fiscal Year
KEY StatryRptgEntity TaxItem StatryRptgEntity Reporting Entity
KEY StatryRptCategory TaxItem StatryRptCategory Report ID
KEY StatryRptRunID TaxItem StatryRptRunID Report Run ID
KEY TaxItem TaxItem TaxItem Tax Item
KEY TaxItemGroupingVersion TaxItem TaxItemGroupingVersion Tax Grping Ver.
KEY TransactionTypeDetermination TaxItem TransactionTypeDetermination Transaction Key
KEY TaxCode TaxItem TaxCode Tax Code
KEY TaxBox TaxItem TaxBox Tax.Bs.Gp.No.
KEY ValidFrom TaxItem ValidFrom Vers.Valid From
KEY TaxBoxStructureType TaxItem TaxBoxStructureType
KEY TaxGroup TaxItem TaxGroup Tax Group
TaxBoxStructure TaxItem TaxBoxStructure
TaxBoxStructureName TaxItem TaxBoxStructureName
TaxBoxStrucValidityStartDate TaxItem TaxBoxStrucValidityStartDate
TaxBoxStrucValidityEndDate TaxItem TaxBoxStrucValidityEndDate
FiscalPeriod TaxItem FiscalPeriod Tax period
TaxRate TaxItem TaxRate Tax Rate
TaxType TaxItem TaxType Tax Type
BusinessPartner TaxItem BusinessPartner Issuing Authority
BusinessPlace TaxItem BusinessPlace Business place
DocumentReferenceID TaxItem DocumentReferenceID Reference
ReportingDate TaxItem ReportingDate
PostingDate TaxItem PostingDate Posting Date for GR
DocumentDate TaxItem DocumentDate Journal Entry Date
YearMonth _CalendarDate YearMonth Year Month
GLAccount TaxItem GLAccount General Ledger
AssignmentReference I_OperationalAcctgDocItem AssignmentReference Assignment Reference
ExternalDocumentReferenceID
AccountingDocumentHeaderText AccountingDocument AccountingDocumentHeaderText Doc.Header Text
CountryendendasCustomerSupplierCountry
TaxBaseAmountInRptgCrcy TaxItem TaxBaseAmountInRptgCrcy Base Amount
Currency TaxItem ReportingCurrency Currency
AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
OrganizationBPName1
PaymentReference I_OperationalAcctgDocItem PaymentReference Payment Reference

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_PH_ImportationSummaryItem.
-- 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_CompanyCode : fis_bukrs, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_FromReportingDate : vatdate, P_ToReportingDate : vatdate, P_FromFiscalYear : gjahr, P_ToFiscalYear : gjahr

CREATE VIEW P_PH_ImportationSummaryItem AS
SELECT
  TaxItem.CompanyCode AS CompanyCode,
  TaxItem.AccountingDocument AS AccountingDocument,
  TaxItem.FiscalYear AS FiscalYear,
  TaxItem.StatryRptgEntity AS StatryRptgEntity,
  TaxItem.StatryRptCategory AS StatryRptCategory,
  TaxItem.StatryRptRunID AS StatryRptRunID,
  TaxItem.TaxItem AS TaxItem,
  TaxItem.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  TaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxItem.TaxCode AS TaxCode,
  TaxItem.TaxBox AS TaxBox,
  TaxItem.ValidFrom AS ValidFrom,
  TaxItem.TaxBoxStructureType AS TaxBoxStructureType,
  TaxItem.TaxGroup AS TaxGroup,
  TaxItem.TaxBoxStructure AS TaxBoxStructure,
  TaxItem.TaxBoxStructureName AS TaxBoxStructureName,
  TaxItem.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  TaxItem.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  TaxItem.FiscalPeriod AS FiscalPeriod,
  TaxItem.TaxRate AS TaxRate,
  TaxItem.TaxType AS TaxType,
  TaxItem.BusinessPartner AS BusinessPartner,
  TaxItem.BusinessPlace AS BusinessPlace,
  TaxItem.DocumentReferenceID AS DocumentReferenceID,
  TaxItem.ReportingDate AS ReportingDate,
  TaxItem.PostingDate AS PostingDate,
  TaxItem.DocumentDate AS DocumentDate,
  _CalendarDate.YearMonth AS YearMonth,
  TaxItem.GLAccount AS GLAccount,
  _OperationalAcctgDocItem.AssignmentReference AS AssignmentReference,
  cast(AccountingDocument.DocumentReferenceID as abap.char(30)) AS ExternalDocumentReferenceID,
  AccountingDocument.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  case when _OperationalAcctgDocItem._OneTimeAccountBP.Country is not null then _OperationalAcctgDocItem._OneTimeAccountBP.Country else case when _OperationalAcctgDocItem._Customer.Country is not null then _OperationalAcctgDocItem._Customer.Country else _OperationalAcctgDocItem._Supplier.Country end end as CustomerSupplierCountry AS CountryendendasCustomerSupplierCountry,
  TaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  TaxItem.ReportingCurrency AS Currency,
  _OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  _OperationalAcctgDocItem._Supplier.OrganizationBPName1 AS OrganizationBPName1,
  _OperationalAcctgDocItem.PaymentReference AS PaymentReference
FROM I_StRpTaxReturnBoxCube
INNER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON PostingDate = _CalendarDate.CalendarDate  -- association [0..1]
;

Learn More