C_SlsOrdPaytCardAuthznTP

DDL: C_SLSORDPAYTCARDAUTHZNTP Type: view_entity CONSUMPTION

Payment Card Reauthorization

C_SlsOrdPaytCardAuthznTP is a Consumption CDS View that provides data about "Payment Card Reauthorization" in SAP S/4HANA. It reads from 1 data source (R_SlsOrdPaytCardAuthznTP) and exposes 41 fields with key fields SalesOrder, DeliveryDocument, PaymentPlan, PaymentPlanItem.

Data Sources (1)

SourceAliasJoin Type
R_SlsOrdPaytCardAuthznTP R_SlsOrdPaytCardAuthznTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Payment Card Reauthorization view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder SD Document
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY PaymentPlan PaymentPlan Paym.Ca.Pl.No.
KEY PaymentPlanItem PaymentPlanItem Item
SalesOrderType SalesOrderType Sales Order Type
SalesOrderDate SalesOrderDate Document Date
SoldToParty SoldToParty Sold-to Party
CustomerName _SoldToParty CustomerName Name of Customer
CustomerReferenceNumber CustomerReferenceNumber
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
DeliveryCreationDate DeliveryCreationDate Delivery Date
OrderCreationDate OrderCreationDate
OverallSDProcessStatus OverallSDProcessStatus
PaytAuthsnCreditCheckSts PaytAuthsnCreditCheckSts
DelivPaytAuthznCrdtChkSts DelivPaytAuthznCrdtChkSts
PaytCardAuthznRqmtStatus PaytCardAuthznRqmtStatus
GoodsMovementStatus GoodsMovementStatus Gds Movemt Status
DeliveryTotalCreditCheckStatus DeliveryTotalCreditCheckStatus
TotalCreditCheckStatus TotalCreditCheckStatus
PreauthorizationIsRequested PreauthorizationIsRequested
AuthorizationDate AuthorizationDate
PaymentCardType PaymentCardType
PaytCardAuthznExprtnDate PaytCardAuthznExprtnDate
PaytCardAuthznExprtnDteCritlty PaytCardAuthznExprtnDteCritlty
PaymentCardAuthznPeriodDays PaymentCardAuthznPeriodDays
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
TotalOpenAuthorizedAmount TotalOpenAuthorizedAmount
AuthorizationCurrency AuthorizationCurrency
OutboundDelivery OutboundDelivery LE Delivery
_OverallSDProcessStatus _OverallSDProcessStatus
_PaytAuthsnCreditCheckSts _PaytAuthsnCreditCheckSts
_DelivPaytAuthznCrdtChkSts _DelivPaytAuthznCrdtChkSts
_PaytCardAuthznRqmtStatus _PaytCardAuthznRqmtStatus
_GoodsMovementStatus _GoodsMovementStatus
_OutboundDelivery _OutboundDelivery
_SoldToParty _SoldToParty
_TotalCreditCheckStatus _TotalCreditCheckStatus
_DelivTotalCreditCheckStatus _DelivTotalCreditCheckStatus

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_SlsOrdPaytCardAuthznTP.
-- 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 C_SlsOrdPaytCardAuthznTP AS
SELECT
  SalesOrder,
  DeliveryDocument,
  PaymentPlan,
  PaymentPlanItem,
  SalesOrderType,
  SalesOrderDate,
  SoldToParty,
  _SoldToParty.CustomerName AS CustomerName,
  CustomerReferenceNumber,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  DeliveryCreationDate,
  OrderCreationDate,
  OverallSDProcessStatus,
  PaytAuthsnCreditCheckSts,
  DelivPaytAuthznCrdtChkSts,
  PaytCardAuthznRqmtStatus,
  GoodsMovementStatus,
  DeliveryTotalCreditCheckStatus,
  TotalCreditCheckStatus,
  PreauthorizationIsRequested,
  AuthorizationDate,
  PaymentCardType,
  PaytCardAuthznExprtnDate,
  PaytCardAuthznExprtnDteCritlty,
  PaymentCardAuthznPeriodDays,
  TotalNetAmount,
  TransactionCurrency,
  TotalOpenAuthorizedAmount,
  AuthorizationCurrency,
  OutboundDelivery
FROM R_SlsOrdPaytCardAuthznTP
;