Deprecated
This CDS view is deprecated in S/4HANA. Use C_PL_SAFTGetInvoiceDataAll instead. View all deprecated CDS views →

C_PL_SAFTGetInvoiceDataTotal

DDL: C_PL_SAFTGETINVOICEDATATOTAL SQL: CPLGETACCTSALEST Type: view CONSUMPTION

SAFT PL Invoice Data Total

C_PL_SAFTGetInvoiceDataTotal is a Consumption CDS View that provides data about "SAFT PL Invoice Data Total" in SAP S/4HANA. It reads from 1 data source (I_PL_SAFTGetInvoiceDataAll) and exposes 3 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_PL_SAFTGetInvoiceDataAll I_PL_SAFTGetInvoiceDataAll from

Parameters (5)

NameTypeDefault
P_StartDate datum
P_EndDate datum
P_PL_CheckForLandText land1
P_CompanyCode bukrs
P_FiscalYear gjahr

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CPLGETACCTSALEST view
VDM.viewType #CONSUMPTION view
Analytics.query true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_PL_SAFTGetInvoiceDataAll view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAFT PL Invoice Data Total view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
NumberOfLines 0 Material Count
TotalNetAmount 0 TOTAL

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

CREATE VIEW C_PL_SAFTGetInvoiceDataTotal AS
SELECT
  CompanyCode,
  0 AS NumberOfLines,
  0 AS TotalNetAmount
FROM I_PL_SAFTGetInvoiceDataAll
;