What is R_SettlmtDocDraft in SAP S/4HANA?

R_SettlmtDocDraft is a basic CDS view in SAP S/4HANA. Settlement Document - Draft It contains 146 fields.

Which tables does R_SettlmtDocDraft read from?

R_SettlmtDocDraft reads data from: wlf_d_sdoc_d.

What VDM layer is R_SettlmtDocDraft?

R_SettlmtDocDraft is classified as a Basic (interface) view providing a 1:1 representation of a database table.

R_SettlmtDocDraft

DDL: R_SETTLMTDOCDRAFT Type: view_entity BASIC

146 Fields 1 Data Sources 15 Associations

Settlement Document - Draft

R_SettlmtDocDraft is a Basic CDS View that provides data about "Settlement Document - Draft" in SAP S/4HANA. It reads from 1 data source (wlf_d_sdoc_d) and exposes 146 fields with key fields SettlmtDoc, DraftUUID. It has 15 associations to related views.

Data Sources (1)

Source	Alias	Join Type
wlf_d_sdoc_d	SettlementDocument	from

Associations (15)

Cardinality	Target	Alias	Condition
[0..1]	I_CustomerCompany	_BillToPartyCompany	`$projection.BillToParty = _BillToPartyCompany.Customer and $projection.CustSettlmtCompanyCode = _BillToPartyCompany.CompanyCode`
[0..1]	I_Customer	_BillToParty	`$projection.BillToParty = _BillToParty.Customer`
[0..1]	I_CustomerCompany	_PayerPartyCompany	`$projection.PayerParty = _PayerPartyCompany.Customer and $projection.CustSettlmtCompanyCode = _PayerPartyCompany.CompanyCode`
[0..1]	I_Customer	_PayerParty	`$projection.PayerParty = _PayerParty.Customer`
[0..1]	I_SupplierCompany	_AltvInvoicingPartyCompany	`$projection.AlternativeInvoicingParty = _AltvInvoicingPartyCompany.Supplier and $projection.SuplrSettlmtCompanyCode = _AltvInvoicingPartyCompany.CompanyCode`
[0..1]	I_SupplierCompany	_InvoicingPartyCompany	`$projection.InvoicingParty = _InvoicingPartyCompany.Supplier and $projection.SuplrSettlmtCompanyCode = _InvoicingPartyCompany.CompanyCode`
[0..1]	I_SupplierCompany	_PayeePartyCompany	`$projection.PayeeParty = _PayeePartyCompany.Supplier and $projection.SuplrSettlmtCompanyCode = _PayeePartyCompany.CompanyCode`
[0..1]	I_Supplier	_PayeeParty	`$projection.PayeeParty = _PayeeParty.Supplier`
[0..1]	I_Supplier	_InvoicingParty	`$projection.InvoicingParty = _InvoicingParty.Supplier`
[0..1]	I_Supplier	_AlternativeInvoicingParty	`$projection.AlternativeInvoicingParty = _AlternativeInvoicingParty.Supplier`
[1..1]	E_SettlmtDocDraft	_Extension	`$projection.SettlmtDoc = _Extension.SettlmtDoc and $projection.DraftUUID = _Extension.DraftUUID`
[0..*]	R_SettlmtDocItemDraft	_SettlmtDocItem
[0..*]	R_SettlmtDocCustPrcgElmntDraft	_CustomerPricingElement
[0..*]	R_SettlmtDocSuplrPrcgElmntD	_SupplierPricingElement
[0..*]	R_SettlmtDocPartnerDraft	_SettlmtDocPartner

Annotations (7)

Name	Value	Level
EndUserText.label	Settlement Document - Draft	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (146)

Key	Field	Source Field	Description
KEY	SettlmtDoc	settlmtdoc	Settlement Doc.
KEY	DraftUUID	draftuuid	UUID
	SettlmtDocType	settlmtdoctype	Settlement Document Type
	SettlmtDocCat	settlmtdoccat	Settlement Document Category
	SettlmtProcessType	settlmtprocesstype	Settlement Process Type
	SettlmtProcessCat	settlmtprocesscat	Settlement Process Category
	LogisticsDataEntryCat	logisticsdataentrycat	Entry Category
	SettlmtCat	settlmtcat	Settl. Category
	SupplierPricingProcedure	supplierpricingprocedure	SuplrPrcgProc.
	CustomerPricingProcedure	customerpricingprocedure	CustPrcgProc.
	PostingDate	postingdate	Posting Date for GR
	SettlmtMgmtAcctgTransfSts	settlmtmgmtacctgtransfsts	Posting Status
	InvoicingParty	invoicingparty	Supplier
	PayeeParty	payeeparty	Payee
	BillToParty	billtoparty	Inv. Recipient
	PayerParty	payerparty	Payer
	PurchasingOrganization	purchasingorganization	Purchasing Organization
	PurchasingGroup	purchasinggroup	Purchasing Group
	SalesOrganization	salesorganization	Sales Organization
	DistributionChannel	distributionchannel	RefDistCh-Cust/Mat.
	Division	division	Internal Division ID
	SuplrSettlmtCompanyCode	suplrsettlmtcompanycode	Suppl. Company Code
	CustSettlmtCompanyCode	custsettlmtcompanycode	Cust. Company Code
	CreatedByUser	createdbyuser	User Name
	CreationDate	creationdate	Time Stamp
	CreationTime	creationtime	Time of Change
	LastChangeDate	lastchangedate	Time Stamp
	DocumentDate	documentdate	Journal Entry Date
	DocumentReferenceID	documentreferenceid	Reference
	AssignmentReference	assignmentreference	Assignment Reference
	SettlmtDocCurrency	settlmtdoccurrency	Doc. Currency
	ExchangeRate	exchangerate	Exchange rate
	ExchangeRateIsFixed	exchangerateisfixed	Fixed Exch.Rate
	ExchangeRateDate	exchangeratedate	Translatn Date
	SupplierTotalGrossAmount	suppliertotalgrossamount	Supplier Total Gross Amount
	SupplierTotalNetAmount	suppliertotalnetamount	Supplier Total Net Amount
	SupplierTotalTaxAmount	suppliertotaltaxamount	Supplier Total Tax Amount
	CustomerTotalGrossAmount	customertotalgrossamount	Customer Total Gross Amount
	CustomerTotalNetAmount	customertotalnetamount	Extracted Net Value
	CustomerTotalTaxAmount	customertotaltaxamount	Customer Total Tax Amount
	SupplierPaymentTerms	supplierpaymentterms	Supplier Payment Terms
	SupplierCashDiscount1Days	suppliercashdiscount1days	Supplier First Payment in Days
	SupplierCashDiscount2Days	suppliercashdiscount2days	Supplier Second Payment in Days
	SupplierNetPaymentDays	suppliernetpaymentdays	Supplier Cash Discount Days
	SupplierCashDiscount1Percent	suppliercashdiscount1percent	Supplier Discount for 1st Payment in %
	SupplierCashDiscount2Percent	suppliercashdiscount2percent	Supplier Discount for 2nd Payment in %
	SupplierPaymentMethod	supplierpaymentmethod	Supplier Payment Method
	CustomerPaymentTerms	customerpaymentterms	Pyt Terms
	CustomerCashDiscount1Days	customercashdiscount1days	Customer 1st Payment in Days
	CustomerCashDiscount2Days	customercashdiscount2days	Customer 2nd Payment in Days
	CustomerNetPaymentDays	customernetpaymentdays	Customer Cash Discount Days
	CustomerCashDiscount1Percent	customercashdiscount1percent	Customer Discount for 1st Payment in %
	CustomerCashDiscount2Percent	customercashdiscount2percent	Customer Discount for 2nd Payment in %
	CustomerPaymentMethod	customerpaymentmethod	Cust Pmt Method
	SuplrTotEligibleAmtForCshDisc	suplrtoteligibleamtforcshdisc	Suplr Cash Disc Bas
	CustTotEligibleAmtForCshDisc	custtoteligibleamtforcshdisc	Cust Cash Disc Bas
	SettlmtDocIsCanceled	settlmtdociscanceled	Doc. Reversed
	CanceledSettlmtDoc	canceledsettlmtdoc	Reversed Document
	SupplierPricingDocument	supplierpricingdocument	Supplier Document Condition
	CustomerPricingDocument	customerpricingdocument	Customer Document Condition
	SupplierAdditionalValueDays	supplieradditionalvaluedays	Supplier Additional Value Days
	SupplierFixedValueDate	supplierfixedvaluedate	Supplier Fixed Value Date
	CustomerAdditionalValueDays	customeradditionalvaluedays	Customer Additional Value Days
	CustomerFixedValueDate	customerfixedvaluedate	Customer Fixed Value Date
	SupplyingCountry	supplyingcountry	Supplying Ctry/Reg.
	StateCentralBankPaymentReason	statecentralbankpaymentreason	SCB Ind.
	CreditControlArea	creditcontrolarea	Credit Control Area
	SettlmtDocActivityReason	settlmtdocactivityreason	Header Document Creation Activity Reason
	PaymentReference	paymentreference	Payment Reference
	SupplierPaymentCurrency	supplierpaymentcurrency	Payt Currency
	SupplierPaytCurrencyExchRate	supplierpaytcurrencyexchrate	Supp. Payt Currency Exch. Rate
	CustomerPaymentCurrency	customerpaymentcurrency	Payt Currency
	CustomerPaytCurrencyExchRate	customerpaytcurrencyexchrate	Cust. Payt Currency Exch. Rate
	SettlmtApplSts	settlmtapplsts	Appl. Status
	ExchangeRateType	exchangeratetype	Exch. Rate Type
	SalesOffice	salesoffice	Sales Office
	SalesGroup	salesgroup	Sales Group
	SettlmtReltdRefDocCat	settlmtreltdrefdoccat	Contract Cat.
	SettlmtReltdRefDoc	settlmtreltdrefdoc	Contract
	SettlmtReltdCndnContr	settlmtreltdcndncontr	Related Condition Contract
	SettlmtDocSmmrznCat	settlmtdocsmmrzncat	Summarization
	CreditControlAreaCurrency	creditcontrolareacurrency	Credit Control Area Currency
	ReleasedCreditAmount	releasedcreditamount	Credit Value
	SettlmtClassificationCat	settlmtclassificationcat	Classification Cat.
	SettlmtPartnerCat	settlmtpartnercat	Settlmt Part Cat
	SupplierSettlmtStatus	suppliersettlmtstatus	Settl. Status Supp.
	CustomerSettlmtStatus	customersettlmtstatus	Settl. Status Cust.
	SupplierSettlmtDocCat	suppliersettlmtdoccat	Doc. Type - Suppl.
	CustomerSettlmtDocCat	customersettlmtdoccat	Settlmt Doc Type
	SupplierSettlmtBlkgReason	suppliersettlmtblkgreason	Supplier Settlement Blocking Reason
	CustomerSettlmtBlkgReason	customersettlmtblkgreason	Customer Settlement Blocking Reason
	FiscalPeriod	fiscalperiod	Tax period
	CndnContrType	cndncontrtype	Contract Type
	CndnContrProcessCategory	cndncontrprocesscategory	Process Category
	SettlmtDateCat	settlmtdatecat	Settlement Date Type
	ActualSettlmtDate	actualsettlmtdate	Actual Settl. Date
	SettlmtDateSequentialID	settlmtdatesequentialid	Settlement Date ID
	SettlmtDocIncmpltnsRsn	settlmtdocincmpltnsrsn	Incomplete Rsn
	AlternativeInvoicingParty	alternativeinvoicingparty	Alternative Supplier
	CombinedSettlmtPostgSts	combinedsettlmtpostgsts	Posting Status 2
	DocIntrastatRelevance	docintrastatrelevance	Intrastat Rel.
	TaxDepartureCountry	taxdeparturecountry	Tx Dep Ctry/Reg
	TaxDestinationCountry	taxdestinationcountry	Tx Des Ctry/Reg
	IsEUTriangularDeal	iseutriangulardeal	Is EU Triangular Deal
	SupplierVATRegistration	suppliervatregistration	VAT Registration No.
	CustomerVATRegistration	customervatregistration	VAT Registration No.
	IntrastatDeclnGdsFlwCat	intrastatdeclngdsflwcat	Goods Flow
	SettlmtDate	settlmtdate	Settlement Date
	SettlmtBusProcVar	settlmtbusprocvar	Proc. Category
	SettlmtDocCollSts	settlmtdoccollsts	Collective Settlement Status
	SettlmtDocIsCollvDoc	settlmtdociscollvdoc	Document is Collective Document
	CollSettlmtBlkgReason	collsettlmtblkgreason	Collective Settlement Blocking Reason
	SuplrSettlmtCoCodeTaxCountry	suplrsettlmtcocodetaxcountry	Tax Ctry/Reg. CoCode
	CustSettlmtCoCodeTaxCountry	custsettlmtcocodetaxcountry	Tax Country/Region Company Code Customer
	SettlmtBusProcCat	settlmtbusproccat	Use Case Type
	PostingPartnerCat	postingpartnercat	Posting Partner
	SettlmtPeriodStartDate	settlmtperiodstartdate	Start Date of Period
	SettlmtPeriodEndDate	settlmtperiodenddate	End Date of Period
	SettlmtApplStsGrp	settlmtapplstsgrp	Status Group
	JournalEntryCreationDate	journalentrycreationdate	Journal Entry Creation Date
	JournalEntryCreationTime	journalentrycreationtime	Journal Entry Creation Time
	ContractAccount	contractaccount	Contract Acct
	ApplElmntBehaviorGrp	applelmntbehaviorgrp	Element Behavior Group
	SettlmtHasDvtgCndnContrData	settlmthasdvtgcndncontrdata	Dev. Settl Data Item
	SettlmtDocAuthznCat	settlmtdocauthzncat	Authorization Cat.
	SettlmtDocChangeState	settlmtdocchangestate	Change State
	DraftEntityCreationDateTime	draftentitycreationdatetime	Draft Created On
	DraftEntityLastChangeDateTime	draftentitylastchangedatetime	Draft Last Changed On
	DraftAdministrativeDataUUID	draftadministrativedatauuid	UUID
	DraftEntityOperationCode	draftentityoperationcode	Draft - Operation Code
	HasActiveEntity	hasactiveentity	TRUE
	DraftFieldChanges	draftfieldchanges	Field Changes
	_SettlmtDocItem	_SettlmtDocItem
	_CustomerPricingElement	_CustomerPricingElement
	_SupplierPricingElement	_SupplierPricingElement
	_SettlmtDocPartner	_SettlmtDocPartner
	_BillToPartyCompany	_BillToPartyCompany
	_BillToParty	_BillToParty
	_PayerPartyCompany	_PayerPartyCompany
	_PayerParty	_PayerParty
	_AltvInvoicingPartyCompany	_AltvInvoicingPartyCompany
	_InvoicingPartyCompany	_InvoicingPartyCompany
	_PayeePartyCompany	_PayeePartyCompany
	_PayeeParty	_PayeeParty
	_InvoicingParty	_InvoicingParty
	_AlternativeInvoicingParty	_AlternativeInvoicingParty

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_SettlmtDocDraft.
-- 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_SettlmtDocDraft AS
SELECT
  SettlmtDoc,
  DraftUUID,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtProcessCat,
  LogisticsDataEntryCat,
  SettlmtCat,
  SupplierPricingProcedure,
  CustomerPricingProcedure,
  PostingDate,
  SettlmtMgmtAcctgTransfSts,
  InvoicingParty,
  PayeeParty,
  BillToParty,
  PayerParty,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SuplrSettlmtCompanyCode,
  CustSettlmtCompanyCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtDocCurrency,
  ExchangeRate,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  SupplierTotalGrossAmount,
  SupplierTotalNetAmount,
  SupplierTotalTaxAmount,
  CustomerTotalGrossAmount,
  CustomerTotalNetAmount,
  CustomerTotalTaxAmount,
  SupplierPaymentTerms,
  SupplierCashDiscount1Days,
  SupplierCashDiscount2Days,
  SupplierNetPaymentDays,
  SupplierCashDiscount1Percent,
  SupplierCashDiscount2Percent,
  SupplierPaymentMethod,
  CustomerPaymentTerms,
  CustomerCashDiscount1Days,
  CustomerCashDiscount2Days,
  CustomerNetPaymentDays,
  CustomerCashDiscount1Percent,
  CustomerCashDiscount2Percent,
  CustomerPaymentMethod,
  SuplrTotEligibleAmtForCshDisc,
  CustTotEligibleAmtForCshDisc,
  SettlmtDocIsCanceled,
  CanceledSettlmtDoc,
  SupplierPricingDocument,
  CustomerPricingDocument,
  SupplierAdditionalValueDays,
  SupplierFixedValueDate,
  CustomerAdditionalValueDays,
  CustomerFixedValueDate,
  SupplyingCountry,
  StateCentralBankPaymentReason,
  CreditControlArea,
  SettlmtDocActivityReason,
  PaymentReference,
  SupplierPaymentCurrency,
  SupplierPaytCurrencyExchRate,
  CustomerPaymentCurrency,
  CustomerPaytCurrencyExchRate,
  SettlmtApplSts,
  ExchangeRateType,
  SalesOffice,
  SalesGroup,
  SettlmtReltdRefDocCat,
  SettlmtReltdRefDoc,
  SettlmtReltdCndnContr,
  SettlmtDocSmmrznCat,
  CreditControlAreaCurrency,
  ReleasedCreditAmount,
  SettlmtClassificationCat,
  SettlmtPartnerCat,
  SupplierSettlmtStatus,
  CustomerSettlmtStatus,
  SupplierSettlmtDocCat,
  CustomerSettlmtDocCat,
  SupplierSettlmtBlkgReason,
  CustomerSettlmtBlkgReason,
  FiscalPeriod,
  CndnContrType,
  CndnContrProcessCategory,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  SettlmtDocIncmpltnsRsn,
  AlternativeInvoicingParty,
  CombinedSettlmtPostgSts,
  DocIntrastatRelevance,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SupplierVATRegistration,
  CustomerVATRegistration,
  IntrastatDeclnGdsFlwCat,
  SettlmtDate,
  SettlmtBusProcVar,
  SettlmtDocCollSts,
  SettlmtDocIsCollvDoc,
  CollSettlmtBlkgReason,
  SuplrSettlmtCoCodeTaxCountry,
  CustSettlmtCoCodeTaxCountry,
  SettlmtBusProcCat,
  PostingPartnerCat,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  SettlmtApplStsGrp,
  JournalEntryCreationDate,
  JournalEntryCreationTime,
  ContractAccount,
  ApplElmntBehaviorGrp,
  SettlmtHasDvtgCndnContrData,
  SettlmtDocAuthznCat,
  SettlmtDocChangeState,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM wlf_d_sdoc_d AS SettlementDocument
LEFT OUTER JOIN I_CustomerCompany AS _BillToPartyCompany ON BillToParty = _BillToPartyCompany.Customer AND CustSettlmtCompanyCode = _BillToPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _PayerPartyCompany ON PayerParty = _PayerPartyCompany.Customer AND CustSettlmtCompanyCode = _PayerPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _AltvInvoicingPartyCompany ON AlternativeInvoicingParty = _AltvInvoicingPartyCompany.Supplier AND SuplrSettlmtCompanyCode = _AltvInvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _InvoicingPartyCompany ON InvoicingParty = _InvoicingPartyCompany.Supplier AND SuplrSettlmtCompanyCode = _InvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _PayeePartyCompany ON PayeeParty = _PayeePartyCompany.Supplier AND SuplrSettlmtCompanyCode = _PayeePartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PayeeParty ON PayeeParty = _PayeeParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _AlternativeInvoicingParty ON AlternativeInvoicingParty = _AlternativeInvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN E_SettlmtDocDraft AS _Extension ON SettlmtDoc = _Extension.SettlmtDoc AND DraftUUID = _Extension.DraftUUID  -- association [1..1]
LEFT OUTER JOIN R_SettlmtDocItemDraft AS _SettlmtDocItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocCustPrcgElmntDraft AS _CustomerPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocSuplrPrcgElmntD AS _SupplierPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocPartnerDraft AS _SettlmtDocPartner ON /* condition not available in parsed metadata */  -- association [0..*]
;

Depth:

R_SettlmtDocDraft view_entity

wlf_d_sdoc_d