C_PT_SAFTSelfBillgTotals

DDL: C_PT_SAFTSELFBILLGTOTALS SQL: CPTSAFTSBTOTALS Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_PT
7 Fields 1 Data Sources

SAF-T PT Self-Billing Totals

C_PT_SAFTSelfBillgTotals is a Consumption CDS View that provides data about "SAF-T PT Self-Billing Totals" in SAP S/4HANA. It reads from 1 data source (I_PT_SAFTSelfBillgTotal) and exposes 7 fields with key fields CompanyCode, Supplier. Part of development package GLO_FIN_IS_SAFT_PT.

Data Sources (1)

SourceAliasJoin Type
I_PT_SAFTSelfBillgTotal I_PT_SAFTSelfBillgTotal from

Parameters (2)

NameTypeDefault
P_StartDate budat
P_EndDate budat

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPTSAFTSBTOTALS view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label SAF-T PT Self-Billing Totals view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY Supplier Supplier Supplier
NumberOfDocuments
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TotalCreditAmount
TotalDebitAmount
_Supplier _Supplier

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_SAFTSelfBillgTotals.
-- 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: CPTSAFTSBTOTALS
-- Parameters: P_StartDate : budat, P_EndDate : budat

CREATE VIEW C_PT_SAFTSelfBillgTotals AS
SELECT
  CompanyCode,
  Supplier,
  count(distinct DocumentTransaction) AS NumberOfDocuments,
  CompanyCodeCurrency,
  cast(sum(CreditAmountInCoCodeCrcy) as figlcn_tcr_wsl) AS TotalCreditAmount,
  cast(sum(DebitAmountInCoCodeCrcy) as figlcn_tdr_wsl) AS TotalDebitAmount
FROM I_PT_SAFTSelfBillgTotal
;

Learn More