R_SettlmtDocTP
Settlement Document - TP
R_SettlmtDocTP is a Transactional CDS View that provides data about "Settlement Document - TP" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDoc) and exposes 205 fields with key field SettlmtDoc. It has 7 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_SettlmtDoc | SettlmtDoc | from |
Associations (7)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_SettlmtDocPartner | _Partner | $projection.SettlmtDoc = _Partner.SettlmtDoc |
| [0..1] | R_OutputRequestTP | _OutputRequest | _OutputRequest.OutputControlApplicationObject = $projection.SettlmtDoc and _OutputRequest.OutputControlApplObjectType = 'SETTLEMENT_DOCUMENT' |
| [1..1] | E_SettlmtMgmtDoc | _Extension | $projection.SettlmtDoc = _Extension.SettlmtMgmtDoc |
| [0..*] | R_SettlmtDocItemTP | _SettlmtDocItem | |
| [0..*] | R_SettlmtDocCustPrcgElmntTP | _CustomerPricingElement | |
| [0..*] | R_SettlmtDocSuplrPrcgElmntTP | _SupplierPricingElement | |
| [0..*] | R_SettlmtDocPartnerTP | _SettlmtDocPartner | |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Settlement Document - TP | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.representativeKey | SettlmtDoc | view | |
| ObjectModel.sapObjectNodeType.name | SettlementDocument | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Analytics.technicalName | RWLFSDOCTP | view |
Fields (205)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SettlmtDoc | R_SettlmtDoc | SettlmtDoc | Settlement Doc. |
| SettlmtDocType | R_SettlmtDoc | SettlmtDocType | Settlement Document Type | |
| SettlmtDocCat | R_SettlmtDoc | SettlmtDocCat | Settlement Document Category | |
| SettlmtProcessType | R_SettlmtDoc | SettlmtProcessType | Settlement Process Type | |
| SettlmtProcessCat | R_SettlmtDoc | SettlmtProcessCat | Settlement Process Category | |
| LogisticsDataEntryCat | R_SettlmtDoc | LogisticsDataEntryCat | Entry Category | |
| SettlmtCat | R_SettlmtDoc | SettlmtCat | Settl. Category | |
| SupplierPricingProcedure | R_SettlmtDoc | SupplierPricingProcedure | SuplrPrcgProc. | |
| CustomerPricingProcedure | R_SettlmtDoc | CustomerPricingProcedure | CustPrcgProc. | |
| PostingDate | R_SettlmtDoc | PostingDate | Posting Date for GR | |
| SettlmtMgmtAcctgTransfSts | R_SettlmtDoc | SettlmtMgmtAcctgTransfSts | Posting Status | |
| InvoicingParty | R_SettlmtDoc | InvoicingParty | Supplier | |
| PayeeParty | R_SettlmtDoc | PayeeParty | Payee | |
| BillToParty | R_SettlmtDoc | BillToParty | Inv. Recipient | |
| PayerParty | R_SettlmtDoc | PayerParty | Payer | |
| PurchasingOrganization | R_SettlmtDoc | PurchasingOrganization | Purchasing Organization | |
| PurchasingGroup | R_SettlmtDoc | PurchasingGroup | Purchasing Group | |
| SalesOrganization | R_SettlmtDoc | SalesOrganization | Sales Organization | |
| DistributionChannel | R_SettlmtDoc | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | R_SettlmtDoc | Division | Internal Division ID | |
| SuplrSettlmtCompanyCode | R_SettlmtDoc | SuplrSettlmtCompanyCode | Suppl. Company Code | |
| CustSettlmtCompanyCode | R_SettlmtDoc | CustSettlmtCompanyCode | Cust. Company Code | |
| CreatedByUser | R_SettlmtDoc | CreatedByUser | User Name | |
| CreationDate | R_SettlmtDoc | CreationDate | Time Stamp | |
| CreationTime | R_SettlmtDoc | CreationTime | Time of Change | |
| LastChangeDate | R_SettlmtDoc | LastChangeDate | Time Stamp | |
| DocumentDate | R_SettlmtDoc | DocumentDate | Journal Entry Date | |
| DocumentReferenceID | R_SettlmtDoc | DocumentReferenceID | Reference | |
| AssignmentReference | R_SettlmtDoc | AssignmentReference | Assignment Reference | |
| SettlmtDocCurrency | R_SettlmtDoc | SettlmtDocCurrency | Doc. Currency | |
| ExchangeRate | R_SettlmtDoc | ExchangeRate | Exchange rate | |
| ExchangeRateIsFixed | R_SettlmtDoc | ExchangeRateIsFixed | Fixed Exch.Rate | |
| ExchangeRateDate | R_SettlmtDoc | ExchangeRateDate | Translatn Date | |
| SupplierTotalGrossAmount | R_SettlmtDoc | SupplierTotalGrossAmount | Supplier Total Gross Amount | |
| SupplierTotalNetAmount | R_SettlmtDoc | SupplierTotalNetAmount | Supplier Total Net Amount | |
| SupplierTotalTaxAmount | R_SettlmtDoc | SupplierTotalTaxAmount | Supplier Total Tax Amount | |
| CustomerTotalGrossAmount | R_SettlmtDoc | CustomerTotalGrossAmount | Customer Total Gross Amount | |
| CustomerTotalNetAmount | R_SettlmtDoc | CustomerTotalNetAmount | Extracted Net Value | |
| CustomerTotalTaxAmount | R_SettlmtDoc | CustomerTotalTaxAmount | Customer Total Tax Amount | |
| SupplierPaymentTerms | R_SettlmtDoc | SupplierPaymentTerms | Supplier Payment Terms | |
| SupplierCashDiscount1Days | R_SettlmtDoc | SupplierCashDiscount1Days | Supplier First Payment in Days | |
| SupplierCashDiscount2Days | R_SettlmtDoc | SupplierCashDiscount2Days | Supplier Second Payment in Days | |
| SupplierNetPaymentDays | R_SettlmtDoc | SupplierNetPaymentDays | Supplier Cash Discount Days | |
| SupplierCashDiscount1Percent | R_SettlmtDoc | SupplierCashDiscount1Percent | Supplier Discount for 1st Payment in % | |
| SupplierCashDiscount2Percent | R_SettlmtDoc | SupplierCashDiscount2Percent | Supplier Discount for 2nd Payment in % | |
| SupplierPaymentMethod | R_SettlmtDoc | SupplierPaymentMethod | Supplier Payment Method | |
| CustomerPaymentTerms | R_SettlmtDoc | CustomerPaymentTerms | Pyt Terms | |
| CustomerCashDiscount1Days | R_SettlmtDoc | CustomerCashDiscount1Days | Customer 1st Payment in Days | |
| CustomerCashDiscount2Days | R_SettlmtDoc | CustomerCashDiscount2Days | Customer 2nd Payment in Days | |
| CustomerNetPaymentDays | R_SettlmtDoc | CustomerNetPaymentDays | Customer Cash Discount Days | |
| CustomerCashDiscount1Percent | R_SettlmtDoc | CustomerCashDiscount1Percent | Customer Discount for 1st Payment in % | |
| CustomerCashDiscount2Percent | R_SettlmtDoc | CustomerCashDiscount2Percent | Customer Discount for 2nd Payment in % | |
| CustomerPaymentMethod | R_SettlmtDoc | CustomerPaymentMethod | Cust Pmt Method | |
| SuplrTotEligibleAmtForCshDisc | R_SettlmtDoc | SuplrTotEligibleAmtForCshDisc | Suplr Cash Disc Bas | |
| CustTotEligibleAmtForCshDisc | R_SettlmtDoc | CustTotEligibleAmtForCshDisc | Cust Cash Disc Bas | |
| SettlmtDocIsCanceled | R_SettlmtDoc | SettlmtDocIsCanceled | Doc. Reversed | |
| CanceledSettlmtDoc | R_SettlmtDoc | CanceledSettlmtDoc | Reversed Document | |
| SupplierPricingDocument | R_SettlmtDoc | SupplierPricingDocument | Supplier Document Condition | |
| CustomerPricingDocument | R_SettlmtDoc | CustomerPricingDocument | Customer Document Condition | |
| SupplierAdditionalValueDays | R_SettlmtDoc | SupplierAdditionalValueDays | Supplier Additional Value Days | |
| SupplierFixedValueDate | R_SettlmtDoc | SupplierFixedValueDate | Supplier Fixed Value Date | |
| CustomerAdditionalValueDays | R_SettlmtDoc | CustomerAdditionalValueDays | Customer Additional Value Days | |
| CustomerFixedValueDate | R_SettlmtDoc | CustomerFixedValueDate | Customer Fixed Value Date | |
| SupplyingCountry | R_SettlmtDoc | SupplyingCountry | Supplying Ctry/Reg. | |
| StateCentralBankPaymentReason | R_SettlmtDoc | StateCentralBankPaymentReason | SCB Ind. | |
| CreditControlArea | R_SettlmtDoc | CreditControlArea | Credit Control Area | |
| SettlmtDocActivityReason | R_SettlmtDoc | SettlmtDocActivityReason | Header Document Creation Activity Reason | |
| PaymentReference | R_SettlmtDoc | PaymentReference | Payment Reference | |
| SupplierPaymentCurrency | R_SettlmtDoc | SupplierPaymentCurrency | Payt Currency | |
| SupplierPaytCurrencyExchRate | R_SettlmtDoc | SupplierPaytCurrencyExchRate | Supp. Payt Currency Exch. Rate | |
| CustomerPaymentCurrency | R_SettlmtDoc | CustomerPaymentCurrency | Payt Currency | |
| CustomerPaytCurrencyExchRate | R_SettlmtDoc | CustomerPaytCurrencyExchRate | Cust. Payt Currency Exch. Rate | |
| SettlmtApplSts | R_SettlmtDoc | SettlmtApplSts | Appl. Status | |
| ExchangeRateType | R_SettlmtDoc | ExchangeRateType | Exch. Rate Type | |
| SalesOffice | R_SettlmtDoc | SalesOffice | Sales Office | |
| SalesGroup | R_SettlmtDoc | SalesGroup | Sales Group | |
| SettlmtReltdRefDocCat | SettlmtReltdRefDocCat | Contract Cat. | ||
| SettlmtReltdRefDoc | SettlmtReltdRefDoc | Contract | ||
| SettlmtReltdCndnContr | R_SettlmtDoc | SettlmtReltdCndnContr | Related Condition Contract | |
| SettlmtDocSmmrznCat | R_SettlmtDoc | SettlmtDocSmmrznCat | Summarization | |
| CreditControlAreaCurrency | R_SettlmtDoc | CreditControlAreaCurrency | Credit Control Area Currency | |
| ReleasedCreditAmount | R_SettlmtDoc | ReleasedCreditAmount | Credit Value | |
| SettlmtClassificationCat | R_SettlmtDoc | SettlmtClassificationCat | Classification Cat. | |
| SettlmtPartnerCat | R_SettlmtDoc | SettlmtPartnerCat | Settlmt Part Cat | |
| SupplierSettlmtStatus | R_SettlmtDoc | SupplierSettlmtStatus | Settl. Status Supp. | |
| CustomerSettlmtStatus | R_SettlmtDoc | CustomerSettlmtStatus | Settl. Status Cust. | |
| SupplierSettlmtDocCat | R_SettlmtDoc | SupplierSettlmtDocCat | Doc. Type - Suppl. | |
| CustomerSettlmtDocCat | R_SettlmtDoc | CustomerSettlmtDocCat | Settlmt Doc Type | |
| SupplierSettlmtBlkgReason | R_SettlmtDoc | SupplierSettlmtBlkgReason | Supplier Settlement Blocking Reason | |
| CustomerSettlmtBlkgReason | R_SettlmtDoc | CustomerSettlmtBlkgReason | Customer Settlement Blocking Reason | |
| FiscalPeriod | R_SettlmtDoc | FiscalPeriod | Tax period | |
| CndnContrType | R_SettlmtDoc | CndnContrType | Contract Type | |
| CndnContrProcessCategory | R_SettlmtDoc | CndnContrProcessCategory | Process Category | |
| SettlmtDateCat | R_SettlmtDoc | SettlmtDateCat | Settlement Date Type | |
| ActualSettlmtDate | R_SettlmtDoc | ActualSettlmtDate | Actual Settl. Date | |
| SettlmtDateSequentialID | R_SettlmtDoc | SettlmtDateSequentialID | Settlement Date ID | |
| SettlmtDocIncmpltnsRsn | R_SettlmtDoc | SettlmtDocIncmpltnsRsn | Incomplete Rsn | |
| AlternativeInvoicingParty | R_SettlmtDoc | AlternativeInvoicingParty | Alternative Supplier | |
| CombinedSettlmtPostgSts | R_SettlmtDoc | CombinedSettlmtPostgSts | Posting Status 2 | |
| DocIntrastatRelevance | R_SettlmtDoc | DocIntrastatRelevance | Intrastat Rel. | |
| TaxDepartureCountry | R_SettlmtDoc | TaxDepartureCountry | Tx Dep Ctry/Reg | |
| TaxDestinationCountry | R_SettlmtDoc | TaxDestinationCountry | Tx Des Ctry/Reg | |
| IsEUTriangularDeal | R_SettlmtDoc | IsEUTriangularDeal | Is EU Triangular Deal | |
| SupplierVATRegistration | R_SettlmtDoc | SupplierVATRegistration | VAT Registration No. | |
| CustomerVATRegistration | R_SettlmtDoc | CustomerVATRegistration | VAT Registration No. | |
| IntrastatDeclnGdsFlwCat | R_SettlmtDoc | IntrastatDeclnGdsFlwCat | Goods Flow | |
| SettlmtDate | R_SettlmtDoc | SettlmtDate | Settlement Date | |
| SettlmtBusProcVar | R_SettlmtDoc | SettlmtBusProcVar | Proc. Category | |
| SettlmtDocCollSts | R_SettlmtDoc | SettlmtDocCollSts | Collective Settlement Status | |
| SettlmtDocIsCollvDoc | R_SettlmtDoc | SettlmtDocIsCollvDoc | Document is Collective Document | |
| CollSettlmtBlkgReason | R_SettlmtDoc | CollSettlmtBlkgReason | Collective Settlement Blocking Reason | |
| SuplrSettlmtCoCodeTaxCountry | R_SettlmtDoc | SuplrSettlmtCoCodeTaxCountry | Tax Ctry/Reg. CoCode | |
| CustSettlmtCoCodeTaxCountry | R_SettlmtDoc | CustSettlmtCoCodeTaxCountry | Tax Country/Region Company Code Customer | |
| SettlmtBusProcCat | R_SettlmtDoc | SettlmtBusProcCat | Use Case Type | |
| PostingPartnerCat | R_SettlmtDoc | PostingPartnerCat | Posting Partner | |
| SettlmtPeriodStartDate | R_SettlmtDoc | SettlmtPeriodStartDate | Start Date of Period | |
| SettlmtPeriodEndDate | R_SettlmtDoc | SettlmtPeriodEndDate | End Date of Period | |
| SettlmtApplStsGrp | R_SettlmtDoc | 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 | R_SettlmtDoc | SettlmtDocChangeState | Change State | |
| _OutputRequest | _OutputRequest | |||
| _SettlmtDocItem | _SettlmtDocItem | |||
| _Partner | _Partner | |||
| _SettlmtDocPartner | _SettlmtDocPartner | |||
| _BankData | _BankData | |||
| _SupplierPricingElement | _SupplierPricingElement | |||
| _CustomerPricingElement | _CustomerPricingElement | |||
| _SettlmtDocType | _SettlmtDocType | |||
| _SettlmtDocCat | _SettlmtDocCat | |||
| _SettlmtProcessType | _SettlmtProcessType | |||
| _SettlmtProcessCat | _SettlmtProcessCat | |||
| _LogisticsDataEntryCat | _LogisticsDataEntryCat | |||
| _SettlmtCat | _SettlmtCat | |||
| _SettlmtMgmtAcctgTransfSts | _SettlmtMgmtAcctgTransfSts | |||
| _InvoicingParty | _InvoicingParty | |||
| _PayeeParty | _PayeeParty | |||
| _BillToParty | _BillToParty | |||
| _PayerParty | _PayerParty | |||
| _PurchasingOrganization | _PurchasingOrganization | |||
| _PurchasingGroup | _PurchasingGroup | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _Division | _Division | |||
| _SuplrSettlmtCompanyCode | _SuplrSettlmtCompanyCode | |||
| _CustSettlmtCompanyCode | _CustSettlmtCompanyCode | |||
| _CreatedByUser | _CreatedByUser | |||
| _SettlmtDocCurrency | _SettlmtDocCurrency | |||
| _SupplierPaymentTerms | _SupplierPaymentTerms | |||
| _CustomerPaymentTerms | _CustomerPaymentTerms | |||
| _CanceledSettlmtDoc | _CanceledSettlmtDoc | |||
| _SupplyingCountry | _SupplyingCountry | |||
| _CreditControlArea | _CreditControlArea | |||
| _SettlmtDocActivityReason | _SettlmtDocActivityReason | |||
| _SupplierPaymentCurrency | _SupplierPaymentCurrency | |||
| _CustomerPaymentCurrency | _CustomerPaymentCurrency | |||
| _SettlmtApplSts | _SettlmtApplSts | |||
| _SettlmtApplStsGrp | _SettlmtApplStsGrp | |||
| _SettlmtApplStsGrpStsAssgmt | _SettlmtApplStsGrpStsAssgmt | |||
| _ExchangeRateType | _ExchangeRateType | |||
| _SalesOffice | _SalesOffice | |||
| _SalesGroup | _SalesGroup | |||
| _SettlmtDocSmmrznCat | _SettlmtDocSmmrznCat | |||
| _CreditControlAreaCurrency | _CreditControlAreaCurrency | |||
| _SettlmtClassificationCat | _SettlmtClassificationCat | |||
| _SettlmtPartnerCat | _SettlmtPartnerCat | |||
| _SupplierSettlmtStatus | _SupplierSettlmtStatus | |||
| _CustomerSettlmtStatus | _CustomerSettlmtStatus | |||
| _SupplierSettlmtDocCat | _SupplierSettlmtDocCat | |||
| _CustomerSettlmtDocCat | _CustomerSettlmtDocCat | |||
| _SupplierSettlmtBlkgReason | _SupplierSettlmtBlkgReason | |||
| _CustomerSettlmtBlkgReason | _CustomerSettlmtBlkgReason | |||
| _SettlmtReltdCndnContr | _SettlmtReltdCndnContr | |||
| _CndnContrType | _CndnContrType | |||
| _SettlmtDateCat | _SettlmtDateCat | |||
| _SettlmtDocIncmpltnsRsn | _SettlmtDocIncmpltnsRsn | |||
| _AlternativeInvoicingParty | _AlternativeInvoicingParty | |||
| _CombinedSettlmtPostgSts | _CombinedSettlmtPostgSts | |||
| _DocIntrastatRelevance | _DocIntrastatRelevance | |||
| _TaxDepartureCountry | _TaxDepartureCountry | |||
| _TaxDestinationCountry | _TaxDestinationCountry | |||
| _IntrastatDeclnGdsFlwCat | _IntrastatDeclnGdsFlwCat | |||
| _SettlmtBusProcVar | _SettlmtBusProcVar | |||
| _SettlmtDocCollSts | _SettlmtDocCollSts | |||
| _SettlmtDocIsCollvDoc | _SettlmtDocIsCollvDoc | |||
| _CollSettlmtBlkgReason | _CollSettlmtBlkgReason | |||
| _SuplrSettlmtCoCodeTaxCountry | _SuplrSettlmtCoCodeTaxCountry | |||
| _CustSettlmtCoCodeTaxCountry | _CustSettlmtCoCodeTaxCountry | |||
| _SettlmtBusProcCat | _SettlmtBusProcCat | |||
| _PostingPartnerCat | _PostingPartnerCat | |||
| _InvoicingPartyCompany | _InvoicingPartyCompany | |||
| _PayeePartyCompany | _PayeePartyCompany | |||
| _AltvInvoicingPartyCompany | _AltvInvoicingPartyCompany | |||
| _BillToPartyCompany | _BillToPartyCompany | |||
| _PayerPartyCompany | _PayerPartyCompany | |||
| _SalesArea | _SalesArea | |||
| _CndnContrProcessCategory | _CndnContrProcessCategory | |||
| _CreditControlAreaText | _CreditControlAreaText | |||
| _SettlmtDocAuthznCat | _SettlmtDocAuthznCat | |||
| _FsclCalDateForSuplrCoCode | _FsclCalDateForSuplrCoCode | |||
| _FsclCalDateForCustCoCode | _FsclCalDateForCustCoCode |
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_SettlmtDocTP.
-- 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_SettlmtDocTP AS
SELECT
SettlmtDoc.SettlmtDoc AS SettlmtDoc,
SettlmtDoc.SettlmtDocType AS SettlmtDocType,
SettlmtDoc.SettlmtDocCat AS SettlmtDocCat,
SettlmtDoc.SettlmtProcessType AS SettlmtProcessType,
SettlmtDoc.SettlmtProcessCat AS SettlmtProcessCat,
SettlmtDoc.LogisticsDataEntryCat AS LogisticsDataEntryCat,
SettlmtDoc.SettlmtCat AS SettlmtCat,
SettlmtDoc.SupplierPricingProcedure AS SupplierPricingProcedure,
SettlmtDoc.CustomerPricingProcedure AS CustomerPricingProcedure,
SettlmtDoc.PostingDate AS PostingDate,
SettlmtDoc.SettlmtMgmtAcctgTransfSts AS SettlmtMgmtAcctgTransfSts,
SettlmtDoc.InvoicingParty AS InvoicingParty,
SettlmtDoc.PayeeParty AS PayeeParty,
SettlmtDoc.BillToParty AS BillToParty,
SettlmtDoc.PayerParty AS PayerParty,
SettlmtDoc.PurchasingOrganization AS PurchasingOrganization,
SettlmtDoc.PurchasingGroup AS PurchasingGroup,
SettlmtDoc.SalesOrganization AS SalesOrganization,
SettlmtDoc.DistributionChannel AS DistributionChannel,
SettlmtDoc.Division AS Division,
SettlmtDoc.SuplrSettlmtCompanyCode AS SuplrSettlmtCompanyCode,
SettlmtDoc.CustSettlmtCompanyCode AS CustSettlmtCompanyCode,
SettlmtDoc.CreatedByUser AS CreatedByUser,
SettlmtDoc.CreationDate AS CreationDate,
SettlmtDoc.CreationTime AS CreationTime,
SettlmtDoc.LastChangeDate AS LastChangeDate,
SettlmtDoc.DocumentDate AS DocumentDate,
SettlmtDoc.DocumentReferenceID AS DocumentReferenceID,
SettlmtDoc.AssignmentReference AS AssignmentReference,
SettlmtDoc.SettlmtDocCurrency AS SettlmtDocCurrency,
SettlmtDoc.ExchangeRate AS ExchangeRate,
SettlmtDoc.ExchangeRateIsFixed AS ExchangeRateIsFixed,
SettlmtDoc.ExchangeRateDate AS ExchangeRateDate,
SettlmtDoc.SupplierTotalGrossAmount AS SupplierTotalGrossAmount,
SettlmtDoc.SupplierTotalNetAmount AS SupplierTotalNetAmount,
SettlmtDoc.SupplierTotalTaxAmount AS SupplierTotalTaxAmount,
SettlmtDoc.CustomerTotalGrossAmount AS CustomerTotalGrossAmount,
SettlmtDoc.CustomerTotalNetAmount AS CustomerTotalNetAmount,
SettlmtDoc.CustomerTotalTaxAmount AS CustomerTotalTaxAmount,
SettlmtDoc.SupplierPaymentTerms AS SupplierPaymentTerms,
SettlmtDoc.SupplierCashDiscount1Days AS SupplierCashDiscount1Days,
SettlmtDoc.SupplierCashDiscount2Days AS SupplierCashDiscount2Days,
SettlmtDoc.SupplierNetPaymentDays AS SupplierNetPaymentDays,
SettlmtDoc.SupplierCashDiscount1Percent AS SupplierCashDiscount1Percent,
SettlmtDoc.SupplierCashDiscount2Percent AS SupplierCashDiscount2Percent,
SettlmtDoc.SupplierPaymentMethod AS SupplierPaymentMethod,
SettlmtDoc.CustomerPaymentTerms AS CustomerPaymentTerms,
SettlmtDoc.CustomerCashDiscount1Days AS CustomerCashDiscount1Days,
SettlmtDoc.CustomerCashDiscount2Days AS CustomerCashDiscount2Days,
SettlmtDoc.CustomerNetPaymentDays AS CustomerNetPaymentDays,
SettlmtDoc.CustomerCashDiscount1Percent AS CustomerCashDiscount1Percent,
SettlmtDoc.CustomerCashDiscount2Percent AS CustomerCashDiscount2Percent,
SettlmtDoc.CustomerPaymentMethod AS CustomerPaymentMethod,
SettlmtDoc.SuplrTotEligibleAmtForCshDisc AS SuplrTotEligibleAmtForCshDisc,
SettlmtDoc.CustTotEligibleAmtForCshDisc AS CustTotEligibleAmtForCshDisc,
SettlmtDoc.SettlmtDocIsCanceled AS SettlmtDocIsCanceled,
SettlmtDoc.CanceledSettlmtDoc AS CanceledSettlmtDoc,
SettlmtDoc.SupplierPricingDocument AS SupplierPricingDocument,
SettlmtDoc.CustomerPricingDocument AS CustomerPricingDocument,
SettlmtDoc.SupplierAdditionalValueDays AS SupplierAdditionalValueDays,
SettlmtDoc.SupplierFixedValueDate AS SupplierFixedValueDate,
SettlmtDoc.CustomerAdditionalValueDays AS CustomerAdditionalValueDays,
SettlmtDoc.CustomerFixedValueDate AS CustomerFixedValueDate,
SettlmtDoc.SupplyingCountry AS SupplyingCountry,
SettlmtDoc.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
SettlmtDoc.CreditControlArea AS CreditControlArea,
SettlmtDoc.SettlmtDocActivityReason AS SettlmtDocActivityReason,
SettlmtDoc.PaymentReference AS PaymentReference,
SettlmtDoc.SupplierPaymentCurrency AS SupplierPaymentCurrency,
SettlmtDoc.SupplierPaytCurrencyExchRate AS SupplierPaytCurrencyExchRate,
SettlmtDoc.CustomerPaymentCurrency AS CustomerPaymentCurrency,
SettlmtDoc.CustomerPaytCurrencyExchRate AS CustomerPaytCurrencyExchRate,
SettlmtDoc.SettlmtApplSts AS SettlmtApplSts,
SettlmtDoc.ExchangeRateType AS ExchangeRateType,
SettlmtDoc.SalesOffice AS SalesOffice,
SettlmtDoc.SalesGroup AS SalesGroup,
SettlmtReltdRefDocCat,
SettlmtReltdRefDoc,
SettlmtDoc.SettlmtReltdCndnContr AS SettlmtReltdCndnContr,
SettlmtDoc.SettlmtDocSmmrznCat AS SettlmtDocSmmrznCat,
SettlmtDoc.CreditControlAreaCurrency AS CreditControlAreaCurrency,
SettlmtDoc.ReleasedCreditAmount AS ReleasedCreditAmount,
SettlmtDoc.SettlmtClassificationCat AS SettlmtClassificationCat,
SettlmtDoc.SettlmtPartnerCat AS SettlmtPartnerCat,
SettlmtDoc.SupplierSettlmtStatus AS SupplierSettlmtStatus,
SettlmtDoc.CustomerSettlmtStatus AS CustomerSettlmtStatus,
SettlmtDoc.SupplierSettlmtDocCat AS SupplierSettlmtDocCat,
SettlmtDoc.CustomerSettlmtDocCat AS CustomerSettlmtDocCat,
SettlmtDoc.SupplierSettlmtBlkgReason AS SupplierSettlmtBlkgReason,
SettlmtDoc.CustomerSettlmtBlkgReason AS CustomerSettlmtBlkgReason,
SettlmtDoc.FiscalPeriod AS FiscalPeriod,
SettlmtDoc.CndnContrType AS CndnContrType,
SettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
SettlmtDoc.SettlmtDateCat AS SettlmtDateCat,
SettlmtDoc.ActualSettlmtDate AS ActualSettlmtDate,
SettlmtDoc.SettlmtDateSequentialID AS SettlmtDateSequentialID,
SettlmtDoc.SettlmtDocIncmpltnsRsn AS SettlmtDocIncmpltnsRsn,
SettlmtDoc.AlternativeInvoicingParty AS AlternativeInvoicingParty,
SettlmtDoc.CombinedSettlmtPostgSts AS CombinedSettlmtPostgSts,
SettlmtDoc.DocIntrastatRelevance AS DocIntrastatRelevance,
SettlmtDoc.TaxDepartureCountry AS TaxDepartureCountry,
SettlmtDoc.TaxDestinationCountry AS TaxDestinationCountry,
SettlmtDoc.IsEUTriangularDeal AS IsEUTriangularDeal,
SettlmtDoc.SupplierVATRegistration AS SupplierVATRegistration,
SettlmtDoc.CustomerVATRegistration AS CustomerVATRegistration,
SettlmtDoc.IntrastatDeclnGdsFlwCat AS IntrastatDeclnGdsFlwCat,
SettlmtDoc.SettlmtDate AS SettlmtDate,
SettlmtDoc.SettlmtBusProcVar AS SettlmtBusProcVar,
SettlmtDoc.SettlmtDocCollSts AS SettlmtDocCollSts,
SettlmtDoc.SettlmtDocIsCollvDoc AS SettlmtDocIsCollvDoc,
SettlmtDoc.CollSettlmtBlkgReason AS CollSettlmtBlkgReason,
SettlmtDoc.SuplrSettlmtCoCodeTaxCountry AS SuplrSettlmtCoCodeTaxCountry,
SettlmtDoc.CustSettlmtCoCodeTaxCountry AS CustSettlmtCoCodeTaxCountry,
SettlmtDoc.SettlmtBusProcCat AS SettlmtBusProcCat,
SettlmtDoc.PostingPartnerCat AS PostingPartnerCat,
SettlmtDoc.SettlmtPeriodStartDate AS SettlmtPeriodStartDate,
SettlmtDoc.SettlmtPeriodEndDate AS SettlmtPeriodEndDate,
SettlmtDoc.SettlmtApplStsGrp AS SettlmtApplStsGrp,
JournalEntryCreationDate,
JournalEntryCreationTime,
ContractAccount,
ApplElmntBehaviorGrp,
SettlmtHasDvtgCndnContrData,
SettlmtDocAuthznCat,
SettlmtDoc.SettlmtDocChangeState AS SettlmtDocChangeState
FROM R_SettlmtDoc AS SettlmtDoc
LEFT OUTER JOIN R_SettlmtDocPartner AS _Partner ON SettlmtDoc = _Partner.SettlmtDoc -- association [0..*]
LEFT OUTER JOIN R_OutputRequestTP AS _OutputRequest ON _OutputRequest.OutputControlApplicationObject = SettlmtDoc AND _OutputRequest.OutputControlApplObjectType = 'SETTLEMENT_DOCUMENT' -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SettlmtDoc = _Extension.SettlmtMgmtDoc -- association [1..1]
LEFT OUTER JOIN R_SettlmtDocItemTP AS _SettlmtDocItem ON /* condition not available in parsed metadata */ -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocCustPrcgElmntTP AS _CustomerPricingElement ON /* condition not available in parsed metadata */ -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocSuplrPrcgElmntTP AS _SupplierPricingElement ON /* condition not available in parsed metadata */ -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocPartnerTP AS _SettlmtDocPartner ON /* condition not available in parsed metadata */ -- association [0..*]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA