C_PT_SAFTSelfBillgInvoiceItemQ

DDL: C_PT_SAFTSELFBILLGINVOICEITEMQ SQL: CPTSAFTSBINVITMQ Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PT
25 Fields 1 Data Sources

SAF-T PT Self-Billing Invoice Item Query

C_PT_SAFTSelfBillgInvoiceItemQ is a Consumption CDS View that provides data about "SAF-T PT Self-Billing Invoice Item Query" in SAP S/4HANA. It reads from 1 data source (C_PT_SAFTSelfBillgInvoiceItemC) and exposes 25 fields with key fields CompanyCode, DocumentTransaction, SourceDocumentItem, Supplier, PostingDate. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (1)

SourceAliasJoin Type
C_PT_SAFTSelfBillgInvoiceItemC C_PT_SAFTSelfBillgInvoiceItemC from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFTSBINVITMQ view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.query true view
Analytics.settings.maxProcessingEffort #HIGH view
EndUserText.label SAF-T PT Self-Billing Invoice Item Query view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY DocumentTransaction DocumentTransaction Transaction ID
KEY SourceDocumentItem SourceDocumentItem
KEY Supplier Supplier Supplier
KEY PostingDate PostingDate Posting Date for GR
PortugueseInvoiceNumber PortugueseInvoiceNumber
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderDate PurchaseOrderDate PO Date
PortugueseMaterialWithVersion PortugueseMaterialWithVersion Material w/ Version
MaterialName MaterialName Material Description
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit Quantity
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
DocumentCurrency DocumentCurrency Document Currency
NetPriceAmount NetPriceAmount Net Price
PortugueseInvoiceDate PortugueseInvoiceDate Date
DocumentItemText DocumentItemText Text
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
TaxType TaxType Tax Type
TaxReturnCountry TaxReturnCountry Reporting C/R
TaxCode TaxCode Tax Code
TaxRate TaxRate Tax Rate
TaxAmount TaxAmount Tax Amt in Rptg Crcy
ExemptionReasonText ExemptionReasonText
ExemptionReason 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_SAFTSelfBillgInvoiceItemQ.
-- 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: CPTSAFTSBINVITMQ

CREATE VIEW C_PT_SAFTSelfBillgInvoiceItemQ AS
SELECT
  CompanyCode,
  DocumentTransaction,
  SourceDocumentItem,
  Supplier,
  PostingDate,
  PortugueseInvoiceNumber,
  PurchaseOrder,
  PurchaseOrderDate,
  PortugueseMaterialWithVersion,
  MaterialName,
  QuantityInPurchaseOrderUnit,
  PurchaseOrderQuantityUnit,
  DocumentCurrency,
  NetPriceAmount,
  PortugueseInvoiceDate,
  DocumentItemText,
  DebitAmountInCoCodeCrcy,
  CreditAmountInCoCodeCrcy,
  TaxType,
  TaxReturnCountry,
  TaxCode,
  TaxRate,
  TaxAmount,
  ExemptionReasonText,
  ExemptionReason
FROM C_PT_SAFTSelfBillgInvoiceItemC
;

Learn More