C_SE_PTRSupplierInvoiceItemC

DDL: C_SE_PTRSUPPLIERINVOICEITEMC Type: view_entity CONSUMPTION Package: GLO_FIN_IS_AUDIT_SE
37 Fields 1 Data Sources 2 Associations

Swedish PRT Supplier Invoice Item - Cube

C_SE_PTRSupplierInvoiceItemC is a Consumption CDS View (Cube) that provides data about "Swedish PRT Supplier Invoice Item - Cube" in SAP S/4HANA. It reads from 1 data source (P_SE_PTRSupplierInvoiceItem) and exposes 37 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem, StatryRptCategory. It has 2 associations to related views. Part of development package GLO_FIN_IS_AUDIT_SE.

Data Sources (1)

SourceAliasJoin Type
P_SE_PTRSupplierInvoiceItem BSEGITEM from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_JournalEntryItemOneTimeData _JournalEntryItemOneTime BSEGITEM.CompanyCode = _JournalEntryItemOneTime.CompanyCode and BSEGITEM.FiscalYear = _JournalEntryItemOneTime.FiscalYear and BSEGITEM.AccountingDocument = _JournalEntryItemOneTime.AccountingDocument and BSEGITEM.AccountingDocumentItem = _JournalEntryItemOneTime.AccountingDocumentItem
[0..*] I_StRpJournalEntryHeaderLog _ReportedItemsLog $projection.CompanyCode = _ReportedItemsLog.CompanyCode and $projection.AccountingDocument = _ReportedItemsLog.AccountingDocument and $projection.FiscalYear = _ReportedItemsLog.FiscalYear

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
EndUserText.label Swedish PRT Supplier Invoice Item - Cube view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SE_PTRSupplierInvoiceItem CompanyCode Receiver Company Code
KEY FiscalYear P_SE_PTRSupplierInvoiceItem FiscalYear G/L Fiscal Year
KEY AccountingDocument P_SE_PTRSupplierInvoiceItem AccountingDocument Journal Entry
KEY AccountingDocumentItem P_SE_PTRSupplierInvoiceItem AccountingDocumentItem Posting View Item
KEY StatryRptCategory _ReportedItemsLog StatryRptCategory Report ID
KEY StatryRptgEntity _ReportedItemsLog StatryRptgEntity Reporting Entity
KEY StatryRptRunID _ReportedItemsLog StatryRptRunID Report Run ID
AccountingDocumentType P_SE_PTRSupplierInvoiceItem AccountingDocumentType Journal Entry Type
PostingKey P_SE_PTRSupplierInvoiceItem PostingKey Posting Key
IsUsedInPaymentTransaction P_SE_PTRSupplierInvoiceItem IsUsedInPaymentTransaction Is Used In Payment Transaction
SpecialGLCode P_SE_PTRSupplierInvoiceItem SpecialGLCode Special G/L Ind
FinancialAccountType P_SE_PTRSupplierInvoiceItem FinancialAccountType Fin. Account Type
Supplier P_SE_PTRSupplierInvoiceItem Supplier Supplier
BusinessPartner P_SE_PTRSupplierInvoiceItem BusinessPartner Issuing Authority
BusinessPartnerName P_SE_PTRSupplierInvoiceItem BusinessPartnerName Extracted Customer Name
SupplierIsOneTimeAccount P_SE_PTRSupplierInvoiceItem SupplierIsOneTimeAccount
VATRegistration P_SE_PTRSupplierInvoiceItem VATRegistration VAT Registration No.
Country P_SE_PTRSupplierInvoiceItem Country Venue: Ctry/Reg
PostingDate P_SE_PTRSupplierInvoiceItem PostingDate Posting Date for GR
DocumentDate P_SE_PTRSupplierInvoiceItem DocumentDate Journal Entry Date
DueCalculationBaseDate P_SE_PTRSupplierInvoiceItem DueCalculationBaseDate Due Calculation Base Date
NetDueDate P_SE_PTRSupplierInvoiceItem NetDueDate Net Due Date
ClearingDate P_SE_PTRSupplierInvoiceItem ClearingDate Clearing Date
AgreedPaymentPeriodDays
SE_InvoicePaidNumber
PaymentTerms P_SE_PTRSupplierInvoiceItem PaymentTerms Pyt Terms
CompanyCodeCurrency P_SE_PTRSupplierInvoiceItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_SE_PTRSupplierInvoiceItem AmountInCompanyCodeCurrency Local Crcy Amt
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_AccountingDocumentType _AccountingDocumentType
_PostingKey _PostingKey
_SpecialGLCode _SpecialGLCode
_FinancialAccountType _FinancialAccountType
_Supplier _Supplier
_CompanyCodeCurrency _CompanyCodeCurrency

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_SE_PTRSupplierInvoiceItemC.
-- 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_SE_PTRSupplierInvoiceItemC AS
SELECT
  BSEGITEM.CompanyCode AS CompanyCode,
  BSEGITEM.FiscalYear AS FiscalYear,
  BSEGITEM.AccountingDocument AS AccountingDocument,
  BSEGITEM.AccountingDocumentItem AS AccountingDocumentItem,
  _ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  _ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  _ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  BSEGITEM.AccountingDocumentType AS AccountingDocumentType,
  BSEGITEM.PostingKey AS PostingKey,
  BSEGITEM.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  BSEGITEM.SpecialGLCode AS SpecialGLCode,
  BSEGITEM.FinancialAccountType AS FinancialAccountType,
  BSEGITEM.Supplier AS Supplier,
  BSEGITEM.BusinessPartner AS BusinessPartner,
  BSEGITEM.BusinessPartnerName AS BusinessPartnerName,
  BSEGITEM.SupplierIsOneTimeAccount AS SupplierIsOneTimeAccount,
  BSEGITEM.VATRegistration AS VATRegistration,
  BSEGITEM.Country AS Country,
  BSEGITEM.PostingDate AS PostingDate,
  BSEGITEM.DocumentDate AS DocumentDate,
  BSEGITEM.DueCalculationBaseDate AS DueCalculationBaseDate,
  BSEGITEM.NetDueDate AS NetDueDate,
  BSEGITEM.ClearingDate AS ClearingDate,
  cast( dats_days_between( BSEGITEM.DocumentDate, BSEGITEM.NetDueDate ) as agreedpaymentperioddays ) AS AgreedPaymentPeriodDays,
  cast( 1 as septrinvcitemcounter ) AS SE_InvoicePaidNumber,
  BSEGITEM.PaymentTerms AS PaymentTerms,
  BSEGITEM.CompanyCodeCurrency AS CompanyCodeCurrency,
  BSEGITEM.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency
FROM P_SE_PTRSupplierInvoiceItem AS BSEGITEM
LEFT OUTER JOIN I_JournalEntryItemOneTimeData AS _JournalEntryItemOneTime ON BSEGITEM.CompanyCode = _JournalEntryItemOneTime.CompanyCode AND BSEGITEM.FiscalYear = _JournalEntryItemOneTime.FiscalYear AND BSEGITEM.AccountingDocument = _JournalEntryItemOneTime.AccountingDocument AND BSEGITEM.AccountingDocumentItem = _JournalEntryItemOneTime.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_StRpJournalEntryHeaderLog AS _ReportedItemsLog ON CompanyCode = _ReportedItemsLog.CompanyCode AND AccountingDocument = _ReportedItemsLog.AccountingDocument AND FiscalYear = _ReportedItemsLog.FiscalYear  -- association [0..*]
;

Learn More