I_PL_SAFTGetInvoiceDataAll

DDL: I_PL_SAFTGETINVOICEDATAALL SQL: IPLGETACCTSALES Type: view_entity COMPOSITE
43 Fields 2 Data Sources

SAFT PL FA Accounting and Sales Invcs

I_PL_SAFTGetInvoiceDataAll is a Composite CDS View (Cube) that provides data about "SAFT PL FA Accounting and Sales Invcs" in SAP S/4HANA. It reads from 2 data sources (P_PL_SAFTGETACCOUNTINGINVCDATA, P_PL_SAFTGetSalesInvoiceData) and exposes 43 fields with key fields CompanyCode, AccountingDocument, FiscalYear, BillingDocumentItem, DocumentReferenceID.

Data Sources (2)

SourceAliasJoin Type
P_PL_SAFTGETACCOUNTINGINVCDATA P_PL_SAFTGETACCOUNTINGINVCDATA from
P_PL_SAFTGetSalesInvoiceData P_PL_SAFTGetSalesInvoiceData union

Parameters (5)

NameTypeDefault
P_StartDate datum
P_EndDate datum
P_PL_CheckForLandText land1
P_CompanyCode bukrs
P_FiscalYear gjahr

Annotations (11)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
Analytics.internalName #LOCAL view
Analytics.dataCategory #CUBE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
EndUserText.label SAFT PL FA Accounting and Sales Invcs view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_PL_SAFTGETACCOUNTINGINVCDATA CompanyCode Receiver Company Code
KEY AccountingDocument P_PL_SAFTGETACCOUNTINGINVCDATA AccountingDocument Journal Entry
KEY FiscalYear P_PL_SAFTGETACCOUNTINGINVCDATA FiscalYear G/L Fiscal Year
KEY BillingDocumentItem Item
KEY DocumentReferenceID
MaterialDescription P_PL_SAFTGETACCOUNTINGINVCDATA MaterialDescription Text
UnitOfMeasure P_PL_SAFTGETACCOUNTINGINVCDATA UnitOfMeasure Unit Protected Qty
TransactionCurrency P_PL_SAFTGETACCOUNTINGINVCDATA TransactionCurrency Transaction Currency
CompanyCodeCurrency P_PL_SAFTGETACCOUNTINGINVCDATA CompanyCodeCurrency Local Currency
Quantity P_PL_SAFTGETACCOUNTINGINVCDATA Quantity Value
NetPriceAmount
NetAmount Stated Amount
GrossPriceAmountInCCCrcy
GrossAmount
DiscountAmount Cash Discount
P_StartDate
P_EndDate
P_PL_CheckForLandText
P_CompanyCode
P_StartDate
P_EndDate
P_PL_CheckForLandText
P_CompanyCode
P_StartDate
P_EndDate
P_PL_CheckForLandText
P_CompanyCode
CompanyCode Receiver Company Code
KEY AccountingDocument P_PL_SAFTGetSalesInvoiceData AccountingDocument Journal Entry
KEY FiscalYear P_PL_SAFTGetSalesInvoiceData FiscalYear G/L Fiscal Year
KEY BillingDocumentItem P_PL_SAFTGetSalesInvoiceData BillingDocumentItem Item
KEY DocumentReferenceID
MaterialDescription P_PL_SAFTGetSalesInvoiceData MaterialDescription Text
UnitOfMeasure P_PL_SAFTGetSalesInvoiceData UnitOfMeasure Unit Protected Qty
TransactionCurrency P_PL_SAFTGetSalesInvoiceData TransactionCurrency Transaction Currency
CompanyCodeCurrency P_PL_SAFTGetSalesInvoiceData CompanyCodeCurrency Local Currency
Quantity P_PL_SAFTGetSalesInvoiceData Quantity Value
dec232asNetPriceAmount
dec232endasNetAmount
dec232asGrossPriceAmountInCCCrcy
dec232endasGrossAmount
dec232asDiscountAmount
TaxRateAsTextendasTaxRateAsText

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 I_PL_SAFTGetInvoiceDataAll.
-- 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: IPLGETACCTSALES
-- Parameters: P_StartDate : datum, P_EndDate : datum, P_PL_CheckForLandText : land1, P_CompanyCode : bukrs, P_FiscalYear : gjahr

CREATE VIEW I_PL_SAFTGetInvoiceDataAll AS
SELECT
  P_PL_SAFTGETACCOUNTINGINVCDATA.CompanyCode AS CompanyCode,
  P_PL_SAFTGETACCOUNTINGINVCDATA.AccountingDocument AS AccountingDocument,
  P_PL_SAFTGETACCOUNTINGINVCDATA.FiscalYear AS FiscalYear,
  cast(concat('000',P_PL_SAFTGETACCOUNTINGINVCDATA.AccountingDocumentItem) as posnr_vf ) AS BillingDocumentItem,
  cast(P_PL_SAFTGETACCOUNTINGINVCDATA.InvoiceDocumentNumber as abap.char(16)) AS DocumentReferenceID,
  P_PL_SAFTGETACCOUNTINGINVCDATA.MaterialDescription AS MaterialDescription,
  P_PL_SAFTGETACCOUNTINGINVCDATA.UnitOfMeasure AS UnitOfMeasure,
  P_PL_SAFTGETACCOUNTINGINVCDATA.TransactionCurrency AS TransactionCurrency,
  P_PL_SAFTGETACCOUNTINGINVCDATA.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_PL_SAFTGETACCOUNTINGINVCDATA.Quantity AS Quantity,
  cast(0 as abap.dec( 31, 9 )) AS NetPriceAmount,
  cast (NetAmount as abap.dec(23,2)) AS NetAmount,
  cast(0 as abap.dec( 31, 9 )) AS GrossPriceAmountInCCCrcy,
  cast(0 as abap.dec( 23, 2 )) AS GrossAmount,
  cast( DiscountAmount as abap.dec(23,3)) AS DiscountAmount,
  TaxRateAsText AS P_StartDate,
  P_EndDate: $parameters.P_EndDate AS P_EndDate,
  P_PL_CheckForLandText: $parameters.P_PL_CheckForLandText AS P_PL_CheckForLandText,
  P_CompanyCode: $parameters.P_CompanyCode AS P_CompanyCode,
  cast ( case when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = 'Y') then cast( 0 as abap.dec(23,2)) when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = 'Y' ) then cast( 0 as abap.dec(23,2)) when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X' and P_PL_SAFTGetSalesInvcDataTag9.ConditionAmount < 0 ) then abs(P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount) when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X' and P_PL_SAFTGetSalesInvcDataTag9.ConditionAmount > 0 ) then -1 * P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' and P_PL_SAFTGetSalesInvcDataTag9.ConditionAmount < 0 ) then -1 * P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' ) then abs(P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount) when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' ) then cast( 0 as abap.dec(23,2)) else cast ( P_PL_SAFTGetSalesInvoiceData.NetPriceAmount as abap.dec(23,2) ) end as abap.dec(23,2)) as NetPriceAmount AS dec232asNetPriceAmount,
  case when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = 'Y') then 0 when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = 'Y' ) then 0 when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' ) then 0 else cast( P_PL_SAFTGetSalesInvoiceData.NetAmount as abap.dec(23,2) ) end as NetAmount AS dec232endasNetAmount,
  cast( case when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = 'Y') then 0 when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = 'Y' ) then 0 when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' ) then 0 when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X' and P_PL_SAFTGetSalesInvcDataTag9.ConditionAmount < 0 ) then abs(P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount) when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X' and P_PL_SAFTGetSalesInvcDataTag9.ConditionAmount > 0 ) then -1 * P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' and P_PL_SAFTGetSalesInvcDataTag9.ConditionAmount < 0 ) then -1 * P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' ) then abs(P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount) when (P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X') then -1 * P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' ) then P_PL_SAFTGetSalesInvcDataTag9.ConditionRateAmount else cast(0 as abap.dec( 23, 2 )) end as abap.dec(23,2)) as GrossPriceAmountInCCCrcy AS dec232asGrossPriceAmountInCCCrcy,
  case when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = 'Y') then 0 when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = 'Y' ) then 0 when ( P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' ) then 0 else cast( P_PL_SAFTGetSalesInvoiceData.GrossAmount as abap.dec(23,2) ) end as GrossAmount AS dec232endasGrossAmount,
  cast( case when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = 'Y') then cast( 0 as abap.dec(23,2)) when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = 'Y' ) then cast( 0 as abap.dec(23,2)) when (P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' and P_PL_SAFTSlsInvcDtaDiscTag10.PL_DiscountPricingTagText = 'P_10' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X') then -1 * division(cast(P_PL_SAFTSlsInvcDtaDiscTag10.ConditionAmount as abap.dec(23,2)), cast(P_PL_SAFTGetSalesInvoiceData.Quantity as abap.dec(13,2)),2) when (P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' and P_PL_SAFTSlsInvcDtaDiscTag10.PL_DiscountPricingTagText = 'P_10' ) then division(cast(P_PL_SAFTSlsInvcDtaDiscTag10.ConditionAmount as abap.dec(23,2)),cast(P_PL_SAFTGetSalesInvoiceData.Quantity as abap.dec(13,2)),2) when (P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' and P_PL_SAFTSlsInvcDtaDiscTag10.PL_DiscountPricingTagText = 'P_10' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X') then -1 * division(cast( P_PL_SAFTSlsInvcDtaDiscTag10.ConditionAmount as abap.dec(23,2)), cast(P_PL_SAFTGetSalesInvoiceData.Quantity as abap.dec(13,2)),2) when (P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B' and P_PL_SAFTSlsInvcDtaDiscTag10.PL_DiscountPricingTagText = 'P_10') then division(cast( P_PL_SAFTSlsInvcDtaDiscTag10.ConditionAmount as abap.dec(23,2)), cast(P_PL_SAFTGetSalesInvoiceData.Quantity as abap.dec(13,2)),2) when (P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9A' or P_PL_SAFTGetSalesInvcDataTag9.PL_DiscountPricingTagText = 'P_9B') then cast( 0 as abap.dec(23,2)) when (P_PL_SAFTSlsInvcDtaDiscTag10.PL_DiscountPricingTagText = 'P_10' and P_PL_SAFTGetSalesInvoiceData.ItemSignIsReversed = 'X') then -1 * division(cast( P_PL_SAFTSlsInvcDtaDiscTag10.ConditionAmount as abap.dec(23,2)), cast(P_PL_SAFTGetSalesInvoiceData.Quantity as abap.dec(13,2)),2) when P_PL_SAFTSlsInvcDtaDiscTag10.PL_DiscountPricingTagText = 'P_10' then division( cast(P_PL_SAFTSlsInvcDtaDiscTag10.ConditionAmount as abap.dec(23,2)),cast(P_PL_SAFTGetSalesInvoiceData.Quantity as abap.dec(13,2)),2) else division(cast( P_PL_SAFTGetSalesInvoiceData.DiscountAmount as abap.dec(23,2)), cast(P_PL_SAFTGetSalesInvoiceData.Quantity as abap.dec(13,2)),2) end as abap.dec(23,2) ) as DiscountAmount AS dec232asDiscountAmount,
  case when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcTourismSrvcsTxt = 'Y' ) then '' when ( P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = '1' or P_PL_SAFTGetSalesInvoiceData.PL_MarginProcSecondHandGoodTxt = 'Y' ) then '' else P_PL_SAFTGetSalesInvoiceData.TaxRateAsText end as TaxRateAsText AS TaxRateAsTextendasTaxRateAsText
FROM P_PL_SAFTGETACCOUNTINGINVCDATA
-- UNION with additional select branch(es): P_PL_SAFTGetSalesInvoiceData
;

Learn More