P_PaymentAdviceHeader

DDL: P_PAYMENTADVICEHEADER SQL: PPAYTADVCHDR Type: view BASIC
4 Fields 1 Data Sources

P_PaymentAdviceHeader is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (avik) and exposes 4 fields with key fields CompanyCode, PaymentAdviceAccountType, PaymentAdviceAccount, PaymentAdvice.

Data Sources (1)

SourceAliasJoin Type
avik avik from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPAYTADVCHDR view
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY PaymentAdviceAccountType koart Account type
KEY PaymentAdviceAccount konto G/L Account
KEY PaymentAdvice avsid Payt Advice No.

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_PaymentAdviceHeader.
-- 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: PPAYTADVCHDR

CREATE VIEW P_PaymentAdviceHeader AS
SELECT
  bukrs AS CompanyCode,
  koart AS PaymentAdviceAccountType,
  konto AS PaymentAdviceAccount,
  avsid AS PaymentAdvice
FROM avik
;

Learn More