P_AU_PAYMENTTERMSCONDITIONS1

DDL: P_AU_PAYMENTTERMSCONDITIONS1 Type: view_entity BASIC
17 Fields 1 Data Sources

P_AU_PAYMENTTERMSCONDITIONS1 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t052) and exposes 17 fields with key fields zterm, ztagg.

Data Sources (1)

SourceAliasJoin Type
t052 t052 from

Annotations (3)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY zterm zterm Terms of Payment
KEY ztagg ztagg Day Limit
koart koart Account type
ztag1 ztag1 Days from Baseline Date for Payment
ztag2 ztag2 Days from Baseline Date for Payment
ztag3 ztag3 Days from Baseline Date for Payment
zprz1 zprz1 Cash Discount Percentage Rate
zprz2 zprz2 Cash Discount Percentage Rate
zstg1 zstg1 Due Date for Special Condition
zstg2 zstg2 Due Date for Special Condition
zstg3 zstg3 Due Date for Special Condition
zsmn1 zsmn1 Additional Months
zsmn2 zsmn2 Additional Months
zsmn3 zsmn3 Additional Months
ztag1_length
ztag2_length
ztag3_length

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_AU_PAYMENTTERMSCONDITIONS1.
-- 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.

CREATE VIEW P_AU_PAYMENTTERMSCONDITIONS1 AS
SELECT
  zterm,
  ztagg,
  koart,
  ztag1,
  ztag2,
  ztag3,
  zprz1,
  zprz2,
  zstg1,
  zstg2,
  zstg3,
  zsmn1,
  zsmn2,
  zsmn3,
  length(ztag1) AS ztag1_length,
  length(ztag2) AS ztag2_length,
  length(ztag3) AS ztag3_length
FROM t052
;

Learn More