C_PT_SAFTWorkingDocItemRef

DDL: C_PT_SAFTWORKINGDOCITEMREF SQL: CPTSAFWDOCIR Type: view CONSUMPTION
7 Fields 3 Data Sources

SAF-T PT WorkingDocument Item References

C_PT_SAFTWorkingDocItemRef is a Consumption CDS View that provides data about "SAF-T PT WorkingDocument Item References" in SAP S/4HANA. It reads from 3 data sources (I_PT_SAFTBillingItem, I_SDDocumentMultiLevelProcFlow, I_PT_BillgDocDgtlSgntr) and exposes 7 fields with key fields CompanyCode, PortugueseInvoiceNumber, DocumentItemNumber, InvoiceReference.

Data Sources (3)

SourceAliasJoin Type
I_PT_SAFTBillingItem a from
I_SDDocumentMultiLevelProcFlow b inner
I_PT_BillgDocDgtlSgntr ReferenceSignedInvoice left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFWDOCIR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T PT WorkingDocument Item References view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_PT_SAFTBillingItem CompanyCode Receiver Company Code
KEY PortugueseInvoiceNumber I_PT_SAFTBillingItem PortugueseInvoiceNumber
KEY DocumentItemNumber I_PT_SAFTBillingItem DocumentItemNumber Item
KEY InvoiceReference I_PT_BillgDocDgtlSgntr PortugueseInvoiceNumber
SDDocumentReason I_PT_SAFTBillingItem SDDocumentReason Order Reason
_CompanyCode _CompanyCode
_SDDocumentReason _SDDocumentReason

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_SAFTWorkingDocItemRef.
-- 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: CPTSAFWDOCIR

CREATE VIEW C_PT_SAFTWorkingDocItemRef AS
SELECT
  a.CompanyCode AS CompanyCode,
  a.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  a.DocumentItemNumber AS DocumentItemNumber,
  ReferenceSignedInvoice.PortugueseInvoiceNumber AS InvoiceReference,
  a.SDDocumentReason AS SDDocumentReason
FROM I_PT_SAFTBillingItem AS a
INNER JOIN I_SDDocumentMultiLevelProcFlow AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_BillgDocDgtlSgntr AS ReferenceSignedInvoice ON /* join condition not captured in parsed metadata */
;

Learn More