R_CustSettlmtListDEX

DDL: R_CUSTSETTLMTLISTDEX Type: view COMPOSITE
86 Fields 1 Data Sources

Customer Settlmt List Basic Extraction

R_CustSettlmtListDEX is a Composite CDS View that provides data about "Customer Settlmt List Basic Extraction" in SAP S/4HANA. It reads from 1 data source (R_CustSettlmtListItem) and exposes 86 fields with key fields CustSettlmtList, CustSettlmtListItem.

Data Sources (1)

SourceAliasJoin Type
R_CustSettlmtListItem CustSettlmtListItem from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFCUSTSTLSTDEX view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Customer Settlmt List Basic Extraction view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (86)

KeyFieldSource TableSource FieldDescription
KEY CustSettlmtList R_CustSettlmtListItem CustSettlmtList
KEY CustSettlmtListItem R_CustSettlmtListItem CustSettlmtListItem
SettlmtDocType CustSettlmtList SettlmtDocType Settlement Document Type
SettlmtDocCat CustSettlmtList SettlmtDocCat Settlement Document Category
SettlmtProcessType CustSettlmtList SettlmtProcessType Settlement Process Type
LogisticsDataEntryCat CustSettlmtList LogisticsDataEntryCat Entry Category
PostingDate CustSettlmtList PostingDate Posting Date for GR
CustSettlmtListAcctgTransfSts CustSettlmtList CustSettlmtListAcctgTransfSts
DocumentDate CustSettlmtList DocumentDate Journal Entry Date
DocumentReferenceID CustSettlmtList DocumentReferenceID Reference
AssignmentReference CustSettlmtList AssignmentReference Assignment Reference
SettlmtApplSts CustSettlmtList SettlmtApplSts Appl. Status
SettlmtApplStsGrp CustSettlmtList SettlmtApplStsGrp Status Group
PricingProcedure CustSettlmtList PricingProcedure Procedure
BillToParty CustSettlmtList BillToParty Inv. Recipient
PayerParty CustSettlmtList PayerParty Payer
InvoicingParty R_CustSettlmtListItem InvoicingParty Supplier
PayeeParty R_CustSettlmtListItem PayeeParty Payee
SalesOrganization CustSettlmtList SalesOrganization Sales Organization
DistributionChannel CustSettlmtList DistributionChannel RefDistCh-Cust/Mat.
Division CustSettlmtList Division Internal Division ID
CompanyCode CustSettlmtList CompanyCode Receiver Company Code
CreatedByUser CustSettlmtList CreatedByUser User Name
CreationDate CustSettlmtList CreationDate Time Stamp
CreationTime CustSettlmtList CreationTime Time of Change
LastChangeDate CustSettlmtList LastChangeDate Time Stamp
CustSettlmtListCurrency CustSettlmtList CustSettlmtListCurrency Doc. Currency
ExchangeRate CustSettlmtList ExchangeRate Exchange rate
ExchangeRateType CustSettlmtList ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed CustSettlmtList ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate CustSettlmtList ExchangeRateDate Translatn Date
CustSettlmtListTotGrossAmount CustSettlmtList CustSettlmtListTotGrossAmount
CustSettlmtListTotalNetAmount CustSettlmtList CustSettlmtListTotalNetAmount
CustSettlmtListTotalTaxAmount CustSettlmtList CustSettlmtListTotalTaxAmount
PaymentTerms CustSettlmtList PaymentTerms Pyt Terms
CashDiscount1Days CustSettlmtList CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CustSettlmtList CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays CustSettlmtList NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CustSettlmtList CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CustSettlmtList CashDiscount2Percent Disc. Percent 2
PaymentMethod CustSettlmtList PaymentMethod Pymt Meth.
CustTotEligibleAmtForCshDisc CustSettlmtList CustTotEligibleAmtForCshDisc Cust Cash Disc Bas
CustSettlmtListIsReversed CustSettlmtList CustSettlmtListIsReversed
RvsdCustSettlmtList CustSettlmtList RvsdCustSettlmtList
AdditionalValueDays CustSettlmtList AdditionalValueDays Add. Value Days
FixedValueDate CustSettlmtList FixedValueDate Fixed Val. Date
TaxDepartureCountry CustSettlmtList TaxDepartureCountry Tx Dep Ctry/Reg
TaxDestinationCountry CustSettlmtList TaxDestinationCountry Tx Des Ctry/Reg
IsEUTriangularDeal CustSettlmtList IsEUTriangularDeal Is EU Triangular Deal
SettlmtCoCodeTaxCountry CustSettlmtList SettlmtCoCodeTaxCountry Tax Ctry/Reg. CoCode
VATRegistration CustSettlmtList VATRegistration VAT Registration No.
StateCentralBankPaymentReason CustSettlmtList StateCentralBankPaymentReason SCB Ind.
CreditControlArea CustSettlmtList CreditControlArea Credit Control Area
CustSettlmtListActivityReason CustSettlmtList CustSettlmtListActivityReason
PaymentReference CustSettlmtList PaymentReference Payment Reference
CustSettlmtListPaytCurrency CustSettlmtList CustSettlmtListPaytCurrency
CustSetlLstPaytCrcyExchRate CustSettlmtList CustSetlLstPaytCrcyExchRate
OneTimeCustomerAddressID CustSettlmtList OneTimeCustomerAddressID
IntrastatDeclnGdsFlwCat CustSettlmtList IntrastatDeclnGdsFlwCat Goods Flow
DocIntrastatRelevance CustSettlmtList DocIntrastatRelevance Intrastat Rel.
IncotermsVersion CustSettlmtList IncotermsVersion Inco. Version
IncotermsClassification CustSettlmtList IncotermsClassification Incoterms
IncotermsTransferLocation CustSettlmtList IncotermsTransferLocation Incoterms 2
IncotermsLocation1 CustSettlmtList IncotermsLocation1 Inco. Location1
IncotermsLocation2 CustSettlmtList IncotermsLocation2 Inco. Location2
SettlmtBusProcVar CustSettlmtList SettlmtBusProcVar Proc. Category
SettlmtBusProcCat CustSettlmtList SettlmtBusProcCat Use Case Type
SEPAMandate CustSettlmtList SEPAMandate SEPA Mandate
SupplyingCountry CustSettlmtList SupplyingCountry Supplying Ctry/Reg.
FiscalPeriod CustSettlmtList FiscalPeriod Tax period
SettlmtDate CustSettlmtList SettlmtDate Settlement Date
CustSettlmtListIncmpltnsRsn CustSettlmtList CustSettlmtListIncmpltnsRsn
RefSettlmtDoc R_CustSettlmtListItem RefSettlmtDoc
CustSettlmtListItemNetAmount R_CustSettlmtListItem CustSettlmtListItemNetAmount
CustSettlmtListItemTaxAmount R_CustSettlmtListItem CustSettlmtListItemTaxAmount
NonDeductibleInputTaxAmount R_CustSettlmtListItem NonDeductibleInputTaxAmount Non-deductible
SettlmtRemunerationNetAmt R_CustSettlmtListItem SettlmtRemunerationNetAmt
SettlmtRemunerationTaxAmt R_CustSettlmtListItem SettlmtRemunerationTaxAmt
CustSettlmtListItemIsReversed R_CustSettlmtListItem CustSettlmtListItemIsReversed
PrcDetnIsIncmplt R_CustSettlmtListItem PrcDetnIsIncmplt Price Determination Is Incomplete
_BillToParty CustSettlmtList _BillToParty
_BillToPartyCompany CustSettlmtList _BillToPartyCompany
_PayerParty CustSettlmtList _PayerParty
_PayerPartyCompany CustSettlmtList _PayerPartyCompany
_CustSettlmtListCurrency CustSettlmtList _CustSettlmtListCurrency
_CustSettlmtListPaytCurrency CustSettlmtList _CustSettlmtListPaytCurrency

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_CustSettlmtListDEX.
-- 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_CustSettlmtListDEX AS
SELECT
  CustSettlmtListItem.CustSettlmtList AS CustSettlmtList,
  CustSettlmtListItem.CustSettlmtListItem AS CustSettlmtListItem,
  CustSettlmtList.SettlmtDocType AS SettlmtDocType,
  CustSettlmtList.SettlmtDocCat AS SettlmtDocCat,
  CustSettlmtList.SettlmtProcessType AS SettlmtProcessType,
  CustSettlmtList.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  CustSettlmtList.PostingDate AS PostingDate,
  CustSettlmtList.CustSettlmtListAcctgTransfSts AS CustSettlmtListAcctgTransfSts,
  CustSettlmtList.DocumentDate AS DocumentDate,
  CustSettlmtList.DocumentReferenceID AS DocumentReferenceID,
  CustSettlmtList.AssignmentReference AS AssignmentReference,
  CustSettlmtList.SettlmtApplSts AS SettlmtApplSts,
  CustSettlmtList.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  CustSettlmtList.PricingProcedure AS PricingProcedure,
  CustSettlmtList.BillToParty AS BillToParty,
  CustSettlmtList.PayerParty AS PayerParty,
  CustSettlmtListItem.InvoicingParty AS InvoicingParty,
  CustSettlmtListItem.PayeeParty AS PayeeParty,
  CustSettlmtList.SalesOrganization AS SalesOrganization,
  CustSettlmtList.DistributionChannel AS DistributionChannel,
  CustSettlmtList.Division AS Division,
  CustSettlmtList.CompanyCode AS CompanyCode,
  CustSettlmtList.CreatedByUser AS CreatedByUser,
  CustSettlmtList.CreationDate AS CreationDate,
  CustSettlmtList.CreationTime AS CreationTime,
  CustSettlmtList.LastChangeDate AS LastChangeDate,
  CustSettlmtList.CustSettlmtListCurrency AS CustSettlmtListCurrency,
  CustSettlmtList.ExchangeRate AS ExchangeRate,
  CustSettlmtList.ExchangeRateType AS ExchangeRateType,
  CustSettlmtList.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  CustSettlmtList.ExchangeRateDate AS ExchangeRateDate,
  CustSettlmtList.CustSettlmtListTotGrossAmount AS CustSettlmtListTotGrossAmount,
  CustSettlmtList.CustSettlmtListTotalNetAmount AS CustSettlmtListTotalNetAmount,
  CustSettlmtList.CustSettlmtListTotalTaxAmount AS CustSettlmtListTotalTaxAmount,
  CustSettlmtList.PaymentTerms AS PaymentTerms,
  CustSettlmtList.CashDiscount1Days AS CashDiscount1Days,
  CustSettlmtList.CashDiscount2Days AS CashDiscount2Days,
  CustSettlmtList.NetPaymentDays AS NetPaymentDays,
  CustSettlmtList.CashDiscount1Percent AS CashDiscount1Percent,
  CustSettlmtList.CashDiscount2Percent AS CashDiscount2Percent,
  CustSettlmtList.PaymentMethod AS PaymentMethod,
  CustSettlmtList.CustTotEligibleAmtForCshDisc AS CustTotEligibleAmtForCshDisc,
  CustSettlmtList.CustSettlmtListIsReversed AS CustSettlmtListIsReversed,
  CustSettlmtList.RvsdCustSettlmtList AS RvsdCustSettlmtList,
  CustSettlmtList.AdditionalValueDays AS AdditionalValueDays,
  CustSettlmtList.FixedValueDate AS FixedValueDate,
  CustSettlmtList.TaxDepartureCountry AS TaxDepartureCountry,
  CustSettlmtList.TaxDestinationCountry AS TaxDestinationCountry,
  CustSettlmtList.IsEUTriangularDeal AS IsEUTriangularDeal,
  CustSettlmtList.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
  CustSettlmtList.VATRegistration AS VATRegistration,
  CustSettlmtList.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  CustSettlmtList.CreditControlArea AS CreditControlArea,
  CustSettlmtList.CustSettlmtListActivityReason AS CustSettlmtListActivityReason,
  CustSettlmtList.PaymentReference AS PaymentReference,
  CustSettlmtList.CustSettlmtListPaytCurrency AS CustSettlmtListPaytCurrency,
  CustSettlmtList.CustSetlLstPaytCrcyExchRate AS CustSetlLstPaytCrcyExchRate,
  CustSettlmtList.OneTimeCustomerAddressID AS OneTimeCustomerAddressID,
  CustSettlmtList.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  CustSettlmtList.DocIntrastatRelevance AS DocIntrastatRelevance,
  CustSettlmtList.IncotermsVersion AS IncotermsVersion,
  CustSettlmtList.IncotermsClassification AS IncotermsClassification,
  CustSettlmtList.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustSettlmtList.IncotermsLocation1 AS IncotermsLocation1,
  CustSettlmtList.IncotermsLocation2 AS IncotermsLocation2,
  CustSettlmtList.SettlmtBusProcVar AS SettlmtBusProcVar,
  CustSettlmtList.SettlmtBusProcCat AS SettlmtBusProcCat,
  CustSettlmtList.SEPAMandate AS SEPAMandate,
  CustSettlmtList.SupplyingCountry AS SupplyingCountry,
  CustSettlmtList.FiscalPeriod AS FiscalPeriod,
  CustSettlmtList.SettlmtDate AS SettlmtDate,
  CustSettlmtList.CustSettlmtListIncmpltnsRsn AS CustSettlmtListIncmpltnsRsn,
  CustSettlmtListItem.RefSettlmtDoc AS RefSettlmtDoc,
  CustSettlmtListItem.CustSettlmtListItemNetAmount AS CustSettlmtListItemNetAmount,
  CustSettlmtListItem.CustSettlmtListItemTaxAmount AS CustSettlmtListItemTaxAmount,
  CustSettlmtListItem.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  CustSettlmtListItem.SettlmtRemunerationNetAmt AS SettlmtRemunerationNetAmt,
  CustSettlmtListItem.SettlmtRemunerationTaxAmt AS SettlmtRemunerationTaxAmt,
  CustSettlmtListItem.CustSettlmtListItemIsReversed AS CustSettlmtListItemIsReversed,
  CustSettlmtListItem.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  CustSettlmtList._BillToParty AS _BillToParty,
  CustSettlmtList._BillToPartyCompany AS _BillToPartyCompany,
  CustSettlmtList._PayerParty AS _PayerParty,
  CustSettlmtList._PayerPartyCompany AS _PayerPartyCompany,
  CustSettlmtList._CustSettlmtListCurrency AS _CustSettlmtListCurrency,
  CustSettlmtList._CustSettlmtListPaytCurrency AS _CustSettlmtListPaytCurrency
FROM R_CustSettlmtListItem AS CustSettlmtListItem
;

Learn More