C_SlsOrdPaytCardAuthznTP

DDL: C_SLSORDPAYTCARDAUTHZNTP Type: view_entity CONSUMPTION Package: RAP_SD_SLS_EPY
45 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

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 45 fields with key fields SalesOrder, DeliveryDocument, PaymentPlan, PaymentPlanItem. It is exposed through 2 OData services (ASQL_F4793, SD_ORD_PAYTCARDAUTHZN). It is used in 1 Fiori application: Resolve Payment Card Issues - Reauthorizations. Part of development package RAP_SD_SLS_EPY.

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 #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4793 ASQL_F4793 C2 NOT_RELEASED
SD_ORD_PAYTCARDAUTHZN SD_ORD_PAYTCARDAUTHZN V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4793 Resolve Payment Card Issues - Reauthorizations Transactional

Resolve Payment Card Issues - Reauthorizations

Business Role: Internal Sales Representative

With this app, you can search for and filter sales orders and their subsequent outbound deliveries with payment cards that need to be authorized again and to trigger this reauthorization.

Fields (45)

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
CustomerReferenceNumber CustomerReferenceNumber
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
DivisionNameasDivisionNamelocalized
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
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_OrganizationDivision _OrganizationDivision

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,
  cast( _SoldToParty.CustomerName as vdm_sold_to_name preserving type ) AS CustomerName,
  CustomerReferenceNumber,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  _OrganizationDivision._Text.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  DeliveryCreationDate,
  OrderCreationDate,
  OverallSDProcessStatus,
  PaytAuthsnCreditCheckSts,
  DelivPaytAuthznCrdtChkSts,
  PaytCardAuthznRqmtStatus,
  GoodsMovementStatus,
  DeliveryTotalCreditCheckStatus,
  TotalCreditCheckStatus,
  PreauthorizationIsRequested,
  AuthorizationDate,
  PaymentCardType,
  PaytCardAuthznExprtnDate,
  PaytCardAuthznExprtnDteCritlty,
  PaymentCardAuthznPeriodDays,
  TotalNetAmount,
  TransactionCurrency,
  TotalOpenAuthorizedAmount,
  AuthorizationCurrency,
  OutboundDelivery
FROM R_SlsOrdPaytCardAuthznTP
;

Learn More