R_CrdtMAcctPaytBehaviorTP

DDL: R_CRDTMACCTPAYTBEHAVIORTP Type: view COMPOSITE Package: ODATA_CREDIT_MGMT_MASTER
36 Fields 1 Data Sources

Credit Mgmt: Payment Behavior

R_CrdtMAcctPaytBehaviorTP is a Composite CDS View that provides data about "Credit Mgmt: Payment Behavior" in SAP S/4HANA. It reads from 1 data source (R_CrdtMAcctPaytBehavior) and exposes 36 fields with key fields BusinessPartner, CreditSegment. Part of development package ODATA_CREDIT_MGMT_MASTER.

Data Sources (1)

SourceAliasJoin Type
R_CrdtMAcctPaytBehavior R_CrdtMAcctPaytBehavior from

Annotations (12)

NameValueLevelField
EndUserText.label Credit Mgmt: Payment Behavior view
AbapCatalog.sqlViewName RCRDTPAYTBEHAVTP view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY CreditSegment CreditSegment Credit Segment
CrdtMDunningInfoIsErroneous CrdtMDunningInfoIsErroneous
MaximumDunnedOpenItem MaximumDunnedOpenItem
MaximumDunningLevel MaximumDunningLevel
MaximumDunnedOpenItemCurrency MaximumDunnedOpenItemCurrency
MaximumDunnedOpenItemAmount MaximumDunnedOpenItemAmount
NumberOfOpenItemsInMaxDunLevel NumberOfOpenItemsInMaxDunLevel
OldestOpenItem OldestOpenItem
CrdtMOverdueItmInfoIsErroneous CrdtMOverdueItmInfoIsErroneous
OldestOpenItemNetDueDate OldestOpenItemNetDueDate Group Net Due Date
OldestOpnItemNrOfDaysInArrears OldestOpnItemNrOfDaysInArrears
OldestOpenItemAmount OldestOpenItemAmount
OldestOpenItemCurrency OldestOpenItemCurrency
CrdtMPaymentInfoIsErroneous CrdtMPaymentInfoIsErroneous
LastPaymentItem LastPaymentItem
LastPaymentDate LastPaymentDate Last Payment
LastPaymentItemAmount LastPaymentItemAmount
LastPaymentCurrency LastPaymentCurrency
CrdtMKeyFigureInfoIsErroneous CrdtMKeyFigureInfoIsErroneous
SenderCurrency SenderCurrency
DaysSalesOutstanding DaysSalesOutstanding
TotalOutstandingAmtInSndrCrcy TotalOutstandingAmtInSndrCrcy
CrdtMKeyFigureTransmnDateTime CrdtMKeyFigureTransmnDateTime
NoCshDiscAvgNrOfDaysInArrears NoCshDiscAvgNrOfDaysInArrears
PaytNoCshDiscTotAmtInSndrCrcy PaytNoCshDiscTotAmtInSndrCrcy
CshDiscClmAvgNrOfDaysInArrears CshDiscClmAvgNrOfDaysInArrears
PaytWthCshDiscTotAmtInSndrCrcy PaytWthCshDiscTotAmtInSndrCrcy
TotLast12MnthsSlsAmtInSndrCrcy TotLast12MnthsSlsAmtInSndrCrcy
Last12MnthsMaxSlsAmtInSndrCrcy Last12MnthsMaxSlsAmtInSndrCrcy
_BusinessPartner _BusinessPartner
_CreditSegment _CreditSegment
_MaximumDunnedOpenItemCurrency _MaximumDunnedOpenItemCurrency
_OldestOpenItemCurrency _OldestOpenItemCurrency
_LastPaymentCurrency _LastPaymentCurrency
_SenderCurrency _SenderCurrency

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 R_CrdtMAcctPaytBehaviorTP.
-- 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 R_CrdtMAcctPaytBehaviorTP AS
SELECT
  BusinessPartner,
  CreditSegment,
  CrdtMDunningInfoIsErroneous,
  MaximumDunnedOpenItem,
  MaximumDunningLevel,
  MaximumDunnedOpenItemCurrency,
  MaximumDunnedOpenItemAmount,
  NumberOfOpenItemsInMaxDunLevel,
  OldestOpenItem,
  CrdtMOverdueItmInfoIsErroneous,
  OldestOpenItemNetDueDate,
  OldestOpnItemNrOfDaysInArrears,
  OldestOpenItemAmount,
  OldestOpenItemCurrency,
  CrdtMPaymentInfoIsErroneous,
  LastPaymentItem,
  LastPaymentDate,
  LastPaymentItemAmount,
  LastPaymentCurrency,
  CrdtMKeyFigureInfoIsErroneous,
  SenderCurrency,
  DaysSalesOutstanding,
  TotalOutstandingAmtInSndrCrcy,
  CrdtMKeyFigureTransmnDateTime,
  NoCshDiscAvgNrOfDaysInArrears,
  PaytNoCshDiscTotAmtInSndrCrcy,
  CshDiscClmAvgNrOfDaysInArrears,
  PaytWthCshDiscTotAmtInSndrCrcy,
  TotLast12MnthsSlsAmtInSndrCrcy,
  Last12MnthsMaxSlsAmtInSndrCrcy
FROM R_CrdtMAcctPaytBehavior
;

Learn More