C_PT_SAFTSelfBillgInvoiceItemC

DDL: C_PT_SAFTSELFBILLGINVOICEITEMC SQL: CPTSAFTSBINVITMC Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PT
26 Fields 2 Data Sources 2 Associations

SAF-T PT Self-Billing Invoice Item Cube

C_PT_SAFTSelfBillgInvoiceItemC is a Consumption CDS View (Cube) that provides data about "SAF-T PT Self-Billing Invoice Item Cube" in SAP S/4HANA. It reads from 2 data sources (I_PT_SAFTSelfBillgInvoiceHdr, I_PT_SAFTSelfBillgInvoiceItem) and exposes 26 fields with key fields CompanyCode, DocumentTransaction, SourceDocumentItem, Supplier, PostingDate. It has 2 associations to related views. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (2)

SourceAliasJoin Type
I_PT_SAFTSelfBillgInvoiceHdr InvoiceHeader inner
I_PT_SAFTSelfBillgInvoiceItem InvoiceItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_PT_SAFTTax _SAFTTax InvoiceItem.TaxCode = _SAFTTax.TaxCode and InvoiceItem.PurchaseOrderDate between _SAFTTax.StartDate and _SAFTTax.EndDate
[0..1] I_SAFTTaxRate _SAFTTaxRate InvoiceItem.TaxCode = _SAFTTaxRate.TaxCode and InvoiceItem.PortugueseInvoiceDate between _SAFTTaxRate.ConditionValidityStartDate and _SAFTTaxRate.ConditionValidityEndDate

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFTSBINVITMC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.allowExtensions true view
EndUserText.label SAF-T PT Self-Billing Invoice Item Cube view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_PT_SAFTSelfBillgInvoiceItem CompanyCode Receiver Company Code
KEY DocumentTransaction I_PT_SAFTSelfBillgInvoiceItem DocumentTransaction Transaction ID
KEY SourceDocumentItem I_PT_SAFTSelfBillgInvoiceItem SourceDocumentItem
KEY Supplier I_PT_SAFTSelfBillgInvoiceHdr Supplier Supplier
KEY PostingDate I_PT_SAFTSelfBillgInvoiceHdr PostingDate Posting Date for GR
PortugueseInvoiceNumber I_PT_SAFTSelfBillgInvoiceItem PortugueseInvoiceNumber
PurchaseOrder I_PT_SAFTSelfBillgInvoiceItem PurchaseOrder Purchasing Document
PurchaseOrderDate I_PT_SAFTSelfBillgInvoiceItem PurchaseOrderDate PO Date
PortugueseMaterialWithVersion I_PT_SAFTSelfBillgInvoiceItem PortugueseMaterialWithVersion Material w/ Version
MaterialName I_PT_SAFTSelfBillgInvoiceItem MaterialName Material Description
QuantityInPurchaseOrderUnit I_PT_SAFTSelfBillgInvoiceItem QuantityInPurchaseOrderUnit Quantity
PurchaseOrderQuantityUnit I_PT_SAFTSelfBillgInvoiceItem PurchaseOrderQuantityUnit Order Unit
DocumentCurrency I_PT_SAFTSelfBillgInvoiceItem DocumentCurrency Document Currency
NetPriceAmount I_PT_SAFTSelfBillgInvoiceItem NetPriceAmount Net Price
PortugueseInvoiceDate I_PT_SAFTSelfBillgInvoiceItem PortugueseInvoiceDate Date
DocumentItemText I_PT_SAFTSelfBillgInvoiceItem DocumentItemText Text
CompanyCodeCurrency I_PT_SAFTSelfBillgInvoiceItem CompanyCodeCurrency Local Currency
DebitAmountInCoCodeCrcy I_PT_SAFTSelfBillgInvoiceItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy I_PT_SAFTSelfBillgInvoiceItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
TaxType _SAFTTax TaxType Tax Type
TaxReturnCountry _SAFTTax TaxReturnCountry Reporting C/R
TaxCode _SAFTTax TargetTaxCode
TaxRate _SAFTTaxRate TaxRate Tax Rate
TaxAmount _SAFTTax TaxAmount Tax Amt in Rptg Crcy
ExemptionReasonText _SAFTTax ExemptionReasonText
ExemptionReason _SAFTTax ExemptionReason Exempt. Reason

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_SAFTSelfBillgInvoiceItemC.
-- 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: CPTSAFTSBINVITMC

CREATE VIEW C_PT_SAFTSelfBillgInvoiceItemC AS
SELECT
  InvoiceItem.CompanyCode AS CompanyCode,
  InvoiceItem.DocumentTransaction AS DocumentTransaction,
  InvoiceItem.SourceDocumentItem AS SourceDocumentItem,
  InvoiceHeader.Supplier AS Supplier,
  InvoiceHeader.PostingDate AS PostingDate,
  InvoiceItem.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  InvoiceItem.PurchaseOrder AS PurchaseOrder,
  InvoiceItem.PurchaseOrderDate AS PurchaseOrderDate,
  InvoiceItem.PortugueseMaterialWithVersion AS PortugueseMaterialWithVersion,
  InvoiceItem.MaterialName AS MaterialName,
  InvoiceItem.QuantityInPurchaseOrderUnit AS QuantityInPurchaseOrderUnit,
  InvoiceItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  InvoiceItem.DocumentCurrency AS DocumentCurrency,
  InvoiceItem.NetPriceAmount AS NetPriceAmount,
  InvoiceItem.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  InvoiceItem.DocumentItemText AS DocumentItemText,
  InvoiceItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  InvoiceItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  InvoiceItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  _SAFTTax.TaxType AS TaxType,
  _SAFTTax.TaxReturnCountry AS TaxReturnCountry,
  _SAFTTax.TargetTaxCode AS TaxCode,
  _SAFTTaxRate.TaxRate AS TaxRate,
  _SAFTTax.TaxAmount AS TaxAmount,
  _SAFTTax.ExemptionReasonText AS ExemptionReasonText,
  _SAFTTax.ExemptionReason AS ExemptionReason
FROM I_PT_SAFTSelfBillgInvoiceItem AS InvoiceItem
INNER JOIN I_PT_SAFTSelfBillgInvoiceHdr AS InvoiceHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTTax AS _SAFTTax ON InvoiceItem.TaxCode = _SAFTTax.TaxCode AND InvoiceItem.PurchaseOrderDate between _SAFTTax.StartDate AND _SAFTTax.EndDate  -- association [0..1]
LEFT OUTER JOIN I_SAFTTaxRate AS _SAFTTaxRate ON InvoiceItem.TaxCode = _SAFTTaxRate.TaxCode AND InvoiceItem.PortugueseInvoiceDate between _SAFTTaxRate.ConditionValidityStartDate AND _SAFTTaxRate.ConditionValidityEndDate  -- association [0..1]
;

Learn More