P_RO_SAFTBP

DDL: P_RO_SAFTBP SQL: PROSAFTBP Type: view CONSUMPTION
19 Fields 4 Data Sources

P_RO_SAFTBP is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_GLAccountLineItemRawData, I_GLAccountLineItemRawData, P_RO_SAFTCustomerVATNumber, P_RO_SAFTSupplierVATNumber) and exposes 19 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (4)

SourceAliasJoin Type
I_GLAccountLineItemRawData Acdoca inner
I_GLAccountLineItemRawData Acdoca inner
P_RO_SAFTCustomerVATNumber BPTax from
P_RO_SAFTSupplierVATNumber BPTax union_all

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PROSAFTBP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_GLAccountLineItemRawData SourceLedger Source Ledger
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
KEY FinancialAccountType
TaxID5 P_RO_SAFTSupplierVATNumber BPTaxLongNumber Tax Number Long
Customer I_GLAccountLineItemRawData Customer Sold-to Party
Supplier I_GLAccountLineItemRawData Supplier Supplier
SourceLedgerasLedger
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
KEY AccountingDocument I_GLAccountLineItemRawData AccountingDocument Journal Entry
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
KEY FinancialAccountType
TaxID5 P_RO_SAFTSupplierVATNumber BPTaxLongNumber Tax Number Long
Customer I_GLAccountLineItemRawData Customer Sold-to Party
Supplier I_GLAccountLineItemRawData Supplier Supplier
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR

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_RO_SAFTBP.
-- 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: PROSAFTBP

CREATE VIEW P_RO_SAFTBP AS
SELECT
  Acdoca.SourceLedger AS Ledger,
  Acdoca.CompanyCode AS CompanyCode,
  Acdoca.FiscalYear AS FiscalYear,
  Acdoca.AccountingDocument AS AccountingDocument,
  Acdoca.LedgerGLLineItem AS LedgerGLLineItem,
  'D' AS FinancialAccountType,
  BPTax.BPTaxLongNumber AS TaxID5,
  Acdoca.Customer AS Customer,
  Acdoca.Supplier AS Supplier,
  Acdoca.PostingDate AS SourceLedgerasLedger,
  Acdoca.PostingDate AS PostingDate
FROM P_RO_SAFTCustomerVATNumber AS BPTax
INNER JOIN I_GLAccountLineItemRawData AS Acdoca ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_RO_SAFTSupplierVATNumber
;

Learn More