R_SettlmtDocListDEX

DDL: R_SETTLMTDOCLISTDEX Type: view_entity COMPOSITE Package: WZRE
109 Fields 1 Data Sources

Settlement Doc List Basic Extraction

R_SettlmtDocListDEX is a Composite CDS View that provides data about "Settlement Doc List Basic Extraction" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocListItem) and exposes 109 fields with key fields SettlmtDocList, SettlmtDocListItem. Part of development package WZRE.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocListItem SettlmtDocListItem from

Annotations (10)

NameValueLevelField
EndUserText.label Settlement Doc 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
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (109)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDocList R_SettlmtDocListItem SettlmtDocList
KEY SettlmtDocListItem R_SettlmtDocListItem SettlmtDocListItem
SettlmtDocType SettlmtDocList SettlmtDocType Settlement Document Type
SettlmtDocCat SettlmtDocList SettlmtDocCat Settlement Document Category
SettlmtProcessType SettlmtDocList SettlmtProcessType Settlement Process Type
SettlmtDocListCat SettlmtDocList SettlmtDocListCat
LogisticsDataEntryCat SettlmtDocList LogisticsDataEntryCat Entry Category
SettlmtDocListAcctgTransfSts SettlmtDocList SettlmtDocListAcctgTransfSts
PostingDate SettlmtDocList PostingDate Posting Date for GR
DocumentReferenceID SettlmtDocList DocumentReferenceID Reference
AssignmentReference SettlmtDocList AssignmentReference Assignment Reference
SettlmtApplSts SettlmtDocList SettlmtApplSts Appl. Status
SettlmtApplStsGrp SettlmtDocList SettlmtApplStsGrp Status Group
PricingProcedure SettlmtDocList PricingProcedure Procedure
InvoicingParty SettlmtDocList InvoicingParty Supplier
PayeeParty SettlmtDocList PayeeParty Payee
AlternativeInvoicingParty SettlmtDocList AlternativeInvoicingParty Alternative Supplier
BillToParty SettlmtDocList BillToParty Inv. Recipient
PayerParty SettlmtDocList PayerParty Payer
CompanyCode SettlmtDocList CompanyCode Receiver Company Code
PurchasingOrganization SettlmtDocList PurchasingOrganization Purchasing Organization
PurchasingGroup SettlmtDocList PurchasingGroup Purchasing Group
SalesOrganization SettlmtDocList SalesOrganization Sales Organization
DistributionChannel SettlmtDocList DistributionChannel RefDistCh-Cust/Mat.
Division SettlmtDocList Division Internal Division ID
CreatedByUser SettlmtDocList CreatedByUser User Name
CreationDate SettlmtDocList CreationDate Time Stamp
CreationTime SettlmtDocList CreationTime Time of Change
LastChangeDate SettlmtDocList LastChangeDate Time Stamp
SettlmtDocListCurrency SettlmtDocList SettlmtDocListCurrency Doc. Currency
ExchangeRate SettlmtDocList ExchangeRate Exchange rate
ExchangeRateType SettlmtDocList ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed SettlmtDocList ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate SettlmtDocList ExchangeRateDate Translatn Date
SettlmtDocListTotalGrossAmount SettlmtDocList SettlmtDocListTotalGrossAmount
SettlmtDocListTotalNetAmount SettlmtDocList SettlmtDocListTotalNetAmount
SettlmtDocListTotalTaxAmount SettlmtDocList SettlmtDocListTotalTaxAmount
PaymentTerms SettlmtDocList PaymentTerms Pyt Terms
CashDiscount1Days SettlmtDocList CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days SettlmtDocList CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays SettlmtDocList NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent SettlmtDocList CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent SettlmtDocList CashDiscount2Percent Disc. Percent 2
PaymentMethod SettlmtDocList PaymentMethod Pymt Meth.
EligibleAmountForCashDiscount SettlmtDocList EligibleAmountForCashDiscount
SettlmtDocListIsReversed SettlmtDocList SettlmtDocListIsReversed
RvsdSettlmtDocList SettlmtDocList RvsdSettlmtDocList
AdditionalValueDays SettlmtDocList AdditionalValueDays Add. Value Days
FixedValueDate SettlmtDocList FixedValueDate Fixed Val. Date
TaxDepartureCountry SettlmtDocList TaxDepartureCountry Tx Dep Ctry/Reg
TaxDestinationCountry SettlmtDocList TaxDestinationCountry Tx Des Ctry/Reg
IsEUTriangularDeal SettlmtDocList IsEUTriangularDeal Is EU Triangular Deal
SettlmtCoCodeTaxCountry SettlmtDocList SettlmtCoCodeTaxCountry Tax Ctry/Reg. CoCode
VATRegistration SettlmtDocList VATRegistration VAT Registration No.
SupplyingCountry SettlmtDocList SupplyingCountry Supplying Ctry/Reg.
StateCentralBankPaymentReason SettlmtDocList StateCentralBankPaymentReason SCB Ind.
CreditControlArea SettlmtDocList CreditControlArea Credit Control Area
SettlmtDocListActivityReason SettlmtDocList SettlmtDocListActivityReason
PaymentReference SettlmtDocList PaymentReference Payment Reference
SettlmtDocListPaymentCurrency SettlmtDocList SettlmtDocListPaymentCurrency
SettlmtDocListPaytCrcyExchRate SettlmtDocList SettlmtDocListPaytCrcyExchRate
OneTimeSettlmtPartAddrID SettlmtDocList OneTimeSettlmtPartAddrID
FiscalPeriod SettlmtDocList FiscalPeriod Tax period
SettlmtDate SettlmtDocList SettlmtDate Settlement Date
SettlmtDocListIncmpltnsRsn SettlmtDocList SettlmtDocListIncmpltnsRsn
DocIntrastatRelevance SettlmtDocList DocIntrastatRelevance Intrastat Rel.
IntrastatDeclnGdsFlwCat SettlmtDocList IntrastatDeclnGdsFlwCat Goods Flow
IncotermsVersion SettlmtDocList IncotermsVersion Inco. Version
IncotermsClassification SettlmtDocList IncotermsClassification Incoterms
IncotermsTransferLocation SettlmtDocList IncotermsTransferLocation Incoterms 2
IncotermsLocation1 SettlmtDocList IncotermsLocation1 Inco. Location1
IncotermsLocation2 SettlmtDocList IncotermsLocation2 Inco. Location2
SettlmtBusProcVar SettlmtDocList SettlmtBusProcVar Proc. Category
SettlmtBusProcCat SettlmtDocList SettlmtBusProcCat Use Case Type
SEPAMandate SettlmtDocList SEPAMandate SEPA Mandate
SettlmtDocListType SettlmtDocList SettlmtDocListType
SettlmtDocListItemNetAmount R_SettlmtDocListItem SettlmtDocListItemNetAmount
SettlmtDocListItemTaxAmount R_SettlmtDocListItem SettlmtDocListItemTaxAmount
NonDeductibleInputTaxAmount R_SettlmtDocListItem NonDeductibleInputTaxAmount Non-deductible
SettlmtRemunerationNetAmt R_SettlmtDocListItem SettlmtRemunerationNetAmt
SettlmtRemunerationTaxAmt R_SettlmtDocListItem SettlmtRemunerationTaxAmt
SettlmtDocListItemCat R_SettlmtDocListItem SettlmtDocListItemCat
RefSuplrBillgDoc R_SettlmtDocListItem RefSuplrBillgDoc
RefSettlmtDoc R_SettlmtDocListItem RefSettlmtDoc
RefCustSettlmtList R_SettlmtDocListItem RefCustSettlmtList
RefSuplrSettlmtList R_SettlmtDocListItem RefSuplrSettlmtList
RefSettlmtDocList R_SettlmtDocListItem RefSettlmtDocList
RefCustSettlmt R_SettlmtDocListItem RefCustSettlmt
RefExpnSettlmt R_SettlmtDocListItem RefExpnSettlmt
RefSuplrSettlmt R_SettlmtDocListItem RefSuplrSettlmt
SettlmtExtBillgDoc R_SettlmtDocListItem SettlmtExtBillgDoc
SettlmtExtAcctgDocCompanyCode R_SettlmtDocListItem SettlmtExtAcctgDocCompanyCode
SettlmtExtAcctgDoc R_SettlmtDocListItem SettlmtExtAcctgDoc
SettlmtExtAcctgDocFiscalYear R_SettlmtDocListItem SettlmtExtAcctgDocFiscalYear
SettlmtExtAcctgDocItem R_SettlmtDocListItem SettlmtExtAcctgDocItem
SettlmtDocListItemIsReversed R_SettlmtDocListItem SettlmtDocListItemIsReversed
PrcDetnIsIncmplt R_SettlmtDocListItem PrcDetnIsIncmplt Price Determination Is Incomplete
_BillToParty SettlmtDocList _BillToParty
_BillToPartyCompany SettlmtDocList _BillToPartyCompany
_InvoicingParty SettlmtDocList _InvoicingParty
_InvoicingPartyCompany SettlmtDocList _InvoicingPartyCompany
_AlternativeInvoicingParty SettlmtDocList _AlternativeInvoicingParty
_AltvInvoicingPartyCompany SettlmtDocList _AltvInvoicingPartyCompany
_PayeeParty SettlmtDocList _PayeeParty
_PayeePartyCompany SettlmtDocList _PayeePartyCompany
_PayerParty SettlmtDocList _PayerParty
_PayerPartyCompany SettlmtDocList _PayerPartyCompany
_SettlmtDocListCurrency SettlmtDocList _SettlmtDocListCurrency
_SettlmtDocListPaymentCurrency SettlmtDocList _SettlmtDocListPaymentCurrency

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_SettlmtDocListDEX.
-- 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_SettlmtDocListDEX AS
SELECT
  SettlmtDocListItem.SettlmtDocList AS SettlmtDocList,
  SettlmtDocListItem.SettlmtDocListItem AS SettlmtDocListItem,
  SettlmtDocList.SettlmtDocType AS SettlmtDocType,
  SettlmtDocList.SettlmtDocCat AS SettlmtDocCat,
  SettlmtDocList.SettlmtProcessType AS SettlmtProcessType,
  SettlmtDocList.SettlmtDocListCat AS SettlmtDocListCat,
  SettlmtDocList.LogisticsDataEntryCat AS LogisticsDataEntryCat,
  SettlmtDocList.SettlmtDocListAcctgTransfSts AS SettlmtDocListAcctgTransfSts,
  SettlmtDocList.PostingDate AS PostingDate,
  SettlmtDocList.DocumentReferenceID AS DocumentReferenceID,
  SettlmtDocList.AssignmentReference AS AssignmentReference,
  SettlmtDocList.SettlmtApplSts AS SettlmtApplSts,
  SettlmtDocList.SettlmtApplStsGrp AS SettlmtApplStsGrp,
  SettlmtDocList.PricingProcedure AS PricingProcedure,
  SettlmtDocList.InvoicingParty AS InvoicingParty,
  SettlmtDocList.PayeeParty AS PayeeParty,
  SettlmtDocList.AlternativeInvoicingParty AS AlternativeInvoicingParty,
  SettlmtDocList.BillToParty AS BillToParty,
  SettlmtDocList.PayerParty AS PayerParty,
  SettlmtDocList.CompanyCode AS CompanyCode,
  SettlmtDocList.PurchasingOrganization AS PurchasingOrganization,
  SettlmtDocList.PurchasingGroup AS PurchasingGroup,
  SettlmtDocList.SalesOrganization AS SalesOrganization,
  SettlmtDocList.DistributionChannel AS DistributionChannel,
  SettlmtDocList.Division AS Division,
  SettlmtDocList.CreatedByUser AS CreatedByUser,
  SettlmtDocList.CreationDate AS CreationDate,
  SettlmtDocList.CreationTime AS CreationTime,
  SettlmtDocList.LastChangeDate AS LastChangeDate,
  SettlmtDocList.SettlmtDocListCurrency AS SettlmtDocListCurrency,
  SettlmtDocList.ExchangeRate AS ExchangeRate,
  SettlmtDocList.ExchangeRateType AS ExchangeRateType,
  SettlmtDocList.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  SettlmtDocList.ExchangeRateDate AS ExchangeRateDate,
  SettlmtDocList.SettlmtDocListTotalGrossAmount AS SettlmtDocListTotalGrossAmount,
  SettlmtDocList.SettlmtDocListTotalNetAmount AS SettlmtDocListTotalNetAmount,
  SettlmtDocList.SettlmtDocListTotalTaxAmount AS SettlmtDocListTotalTaxAmount,
  SettlmtDocList.PaymentTerms AS PaymentTerms,
  SettlmtDocList.CashDiscount1Days AS CashDiscount1Days,
  SettlmtDocList.CashDiscount2Days AS CashDiscount2Days,
  SettlmtDocList.NetPaymentDays AS NetPaymentDays,
  SettlmtDocList.CashDiscount1Percent AS CashDiscount1Percent,
  SettlmtDocList.CashDiscount2Percent AS CashDiscount2Percent,
  SettlmtDocList.PaymentMethod AS PaymentMethod,
  SettlmtDocList.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
  SettlmtDocList.SettlmtDocListIsReversed AS SettlmtDocListIsReversed,
  SettlmtDocList.RvsdSettlmtDocList AS RvsdSettlmtDocList,
  SettlmtDocList.AdditionalValueDays AS AdditionalValueDays,
  SettlmtDocList.FixedValueDate AS FixedValueDate,
  SettlmtDocList.TaxDepartureCountry AS TaxDepartureCountry,
  SettlmtDocList.TaxDestinationCountry AS TaxDestinationCountry,
  SettlmtDocList.IsEUTriangularDeal AS IsEUTriangularDeal,
  SettlmtDocList.SettlmtCoCodeTaxCountry AS SettlmtCoCodeTaxCountry,
  SettlmtDocList.VATRegistration AS VATRegistration,
  SettlmtDocList.SupplyingCountry AS SupplyingCountry,
  SettlmtDocList.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  SettlmtDocList.CreditControlArea AS CreditControlArea,
  SettlmtDocList.SettlmtDocListActivityReason AS SettlmtDocListActivityReason,
  SettlmtDocList.PaymentReference AS PaymentReference,
  SettlmtDocList.SettlmtDocListPaymentCurrency AS SettlmtDocListPaymentCurrency,
  SettlmtDocList.SettlmtDocListPaytCrcyExchRate AS SettlmtDocListPaytCrcyExchRate,
  SettlmtDocList.OneTimeSettlmtPartAddrID AS OneTimeSettlmtPartAddrID,
  SettlmtDocList.FiscalPeriod AS FiscalPeriod,
  SettlmtDocList.SettlmtDate AS SettlmtDate,
  SettlmtDocList.SettlmtDocListIncmpltnsRsn AS SettlmtDocListIncmpltnsRsn,
  SettlmtDocList.DocIntrastatRelevance AS DocIntrastatRelevance,
  SettlmtDocList.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
  SettlmtDocList.IncotermsVersion AS IncotermsVersion,
  SettlmtDocList.IncotermsClassification AS IncotermsClassification,
  SettlmtDocList.IncotermsTransferLocation AS IncotermsTransferLocation,
  SettlmtDocList.IncotermsLocation1 AS IncotermsLocation1,
  SettlmtDocList.IncotermsLocation2 AS IncotermsLocation2,
  SettlmtDocList.SettlmtBusProcVar AS SettlmtBusProcVar,
  SettlmtDocList.SettlmtBusProcCat AS SettlmtBusProcCat,
  SettlmtDocList.SEPAMandate AS SEPAMandate,
  SettlmtDocList.SettlmtDocListType AS SettlmtDocListType,
  SettlmtDocListItem.SettlmtDocListItemNetAmount AS SettlmtDocListItemNetAmount,
  SettlmtDocListItem.SettlmtDocListItemTaxAmount AS SettlmtDocListItemTaxAmount,
  SettlmtDocListItem.NonDeductibleInputTaxAmount AS NonDeductibleInputTaxAmount,
  SettlmtDocListItem.SettlmtRemunerationNetAmt AS SettlmtRemunerationNetAmt,
  SettlmtDocListItem.SettlmtRemunerationTaxAmt AS SettlmtRemunerationTaxAmt,
  SettlmtDocListItem.SettlmtDocListItemCat AS SettlmtDocListItemCat,
  SettlmtDocListItem.RefSuplrBillgDoc AS RefSuplrBillgDoc,
  SettlmtDocListItem.RefSettlmtDoc AS RefSettlmtDoc,
  SettlmtDocListItem.RefCustSettlmtList AS RefCustSettlmtList,
  SettlmtDocListItem.RefSuplrSettlmtList AS RefSuplrSettlmtList,
  SettlmtDocListItem.RefSettlmtDocList AS RefSettlmtDocList,
  SettlmtDocListItem.RefCustSettlmt AS RefCustSettlmt,
  SettlmtDocListItem.RefExpnSettlmt AS RefExpnSettlmt,
  SettlmtDocListItem.RefSuplrSettlmt AS RefSuplrSettlmt,
  SettlmtDocListItem.SettlmtExtBillgDoc AS SettlmtExtBillgDoc,
  SettlmtDocListItem.SettlmtExtAcctgDocCompanyCode AS SettlmtExtAcctgDocCompanyCode,
  SettlmtDocListItem.SettlmtExtAcctgDoc AS SettlmtExtAcctgDoc,
  SettlmtDocListItem.SettlmtExtAcctgDocFiscalYear AS SettlmtExtAcctgDocFiscalYear,
  SettlmtDocListItem.SettlmtExtAcctgDocItem AS SettlmtExtAcctgDocItem,
  SettlmtDocListItem.SettlmtDocListItemIsReversed AS SettlmtDocListItemIsReversed,
  SettlmtDocListItem.PrcDetnIsIncmplt AS PrcDetnIsIncmplt,
  SettlmtDocList._BillToParty AS _BillToParty,
  SettlmtDocList._BillToPartyCompany AS _BillToPartyCompany,
  SettlmtDocList._InvoicingParty AS _InvoicingParty,
  SettlmtDocList._InvoicingPartyCompany AS _InvoicingPartyCompany,
  SettlmtDocList._AlternativeInvoicingParty AS _AlternativeInvoicingParty,
  SettlmtDocList._AltvInvoicingPartyCompany AS _AltvInvoicingPartyCompany,
  SettlmtDocList._PayeeParty AS _PayeeParty,
  SettlmtDocList._PayeePartyCompany AS _PayeePartyCompany,
  SettlmtDocList._PayerParty AS _PayerParty,
  SettlmtDocList._PayerPartyCompany AS _PayerPartyCompany,
  SettlmtDocList._SettlmtDocListCurrency AS _SettlmtDocListCurrency,
  SettlmtDocList._SettlmtDocListPaymentCurrency AS _SettlmtDocListPaymentCurrency
FROM R_SettlmtDocListItem AS SettlmtDocListItem
;

Learn More