I_SDDocumentPaymentCard

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_SDDocumentPaymentCard.
-- 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: ISDDOCPAYTCARD

CREATE VIEW I_SDDocumentPaymentCard AS
SELECT
  fplnr AS BillingPlan,
  fpltr AS BillingPlanItem,
  ccins AS PaymentCardType,
  ccnum AS PaymentCardMaskedNumber,
  datab AS PaymentCardValidityStartDate,
  datbi AS PaymentCardValidityEndDate,
  ccname AS PaymentCardHolderName,
  autwr AS AuthorizedAmountInAuthznCrcy,
  ccwae AS AuthorizationCurrency,
  aunum AS AuthorizationByDigitalPaytSrvc,
  autra AS AuthorizationByAcquirer,
  audat AS AuthorizationDate,
  autim AS AuthorizationTime,
  merch AS MerchantByClearingHouse,
  ccpre AS PreauthorizationIsRequested
FROM fpltc
LEFT OUTER JOIN I_SDDocumentPaymentCardType AS _PaymentCardType ON PaymentCardType = _PaymentCardType.PaymentCardType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AuthorizationCurrency ON AuthorizationCurrency = _AuthorizationCurrency.Currency  -- association [0..1]
;