I_PayableToleranceDay

DDL: I_PAYABLETOLERANCEDAY SQL: IPYBLTOLERANCED Type: view BASIC

Payable Tolerance Day

I_PayableToleranceDay is a Basic CDS View (Dimension) that provides data about "Payable Tolerance Day" in SAP S/4HANA. It reads from 1 data source (t042) and exposes 7 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
t042 t042 from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPYBLTOLERANCED view
VDM.viewType #BASIC view
ObjectModel.representativeKey CompanyCode view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Payable Tolerance Day view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
PayingCompanyCode zbukr Paying CoCd
BusinessAreaIsPaidSeparately xgbtr Separate Payment per Business Area
PayableToleranceDays toltg Tolerance Days for Payable
SendingCompanyCode absbu Snd.co.cde
MinimumAcceptedCashDiscPct sktug Outgoing Pmnt with Cash Disc.From
MaxCashDiscountIsUsed xskr1 Max.Cash Discount

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_PayableToleranceDay.
-- 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: IPYBLTOLERANCED

CREATE VIEW I_PayableToleranceDay AS
SELECT
  bukrs AS CompanyCode,
  zbukr AS PayingCompanyCode,
  xgbtr AS BusinessAreaIsPaidSeparately,
  toltg AS PayableToleranceDays,
  absbu AS SendingCompanyCode,
  sktug AS MinimumAcceptedCashDiscPct,
  xskr1 AS MaxCashDiscountIsUsed
FROM t042
;