C_OutgoingCheck

DDL: C_OUTGOINGCHECK SQL: COUTGOINGCHECK Type: view CONSUMPTION
47 Fields 1 Data Sources 2 Associations

CDS view Outgoing check consumption

C_OutgoingCheck is a Consumption CDS View that provides data about "CDS view Outgoing check consumption" in SAP S/4HANA. It reads from 1 data source (I_OutgoingCheck) and exposes 47 fields with key fields PaymentCompanyCode, HouseBank, HouseBankAccount, PaymentMethod, OutgoingCheque. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_OutgoingCheck I_OutgoingCheck from

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_HouseBankAccountText _HouseBankAccount _HouseBankAccount.CompanyCode = $projection.PaymentCompanyCode and _HouseBankAccount.HouseBank = $projection.HouseBank and _HouseBankAccount.HouseBankAccount = $projection.HouseBankAccount and _HouseBankAccount.Language = $parameters.P_Language
[0..1] E_Outgoingcheck _Extension $projection.PaymentCompanyCode = _Extension.PaymentCompanyCode and $projection.HouseBank = _Extension.HouseBank and $projection.HouseBankAccount = _Extension.HouseBankAccount and $projection.PaymentMethod = _Extension.PaymentMethod and $projection.OutgoingCheque = _Extension.OutgoingCheque

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName COUTGOINGCHECK view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS view Outgoing check consumption view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY PaymentCompanyCode PaymentCompanyCode
KEY HouseBank HouseBank House Bank
KEY HouseBankAccount HouseBankAccount House Bank Account
KEY PaymentMethod PaymentMethod Pymt Meth.
KEY OutgoingCheque OutgoingCheque
IsIntercompanyPayment IsIntercompanyPayment Intercompany Payment
ChequeIsManuallyIssued ChequeIsManuallyIssued
BankName BankName Bank Name
ChequebookFirstCheque ChequebookFirstCheque
PaymentDocument PaymentDocument Payment Document Number
ChequePaymentDate ChequePaymentDate
PaymentCurrency PaymentCurrency Payment Currency
PaidAmountInPaytCurrency PaidAmountInPaytCurrency Payment Amount
Supplier Supplier Supplier
PaymentDocPrintDate PaymentDocPrintDate
PaymentDocPrintTime PaymentDocPrintTime
ChequePrintDateTime ChequePrintDateTime
PaymentDocPrintedByUser PaymentDocPrintedByUser
ChequeEncashmentDate ChequeEncashmentDate
ChequeLastExtractDate ChequeLastExtractDate
ChequeLastExtractDateTime ChequeLastExtractDateTime
PayeeTitle PayeeTitle
PayeeName PayeeName
PayeeAdditionalName PayeeAdditionalName
PayeePostalCode PayeePostalCode
PayeeCityName PayeeCityName
PayeeStreet PayeeStreet
PayeePOBox PayeePOBox
PayeePOBoxPostalCode PayeePOBoxPostalCode
PayeePOBoxCityName PayeePOBoxCityName
Country Country Venue: Ctry/Reg
Region Region Venue Region
ChequeVoidReason ChequeVoidReason
ChequeVoidReasonTxt
ChequeVoidedDate ChequeVoidedDate
ChequeVoidedByUser ChequeVoidedByUser
ChequeIsCashed ChequeIsCashed
CashDiscountAmount CashDiscountAmount CD Amount
CompanyName CompanyCodeName Company Name
CountryName
FiscalYear FiscalYear G/L Fiscal Year
ChequeStatus ChequeStatus
ChequeIssuingType ChequeIssuingType
ChequeType ChequeType
VoidedChequeUsage VoidedChequeUsage
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
BankAccountName _HouseBankAccount HouseBankAccountDescription

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 C_OutgoingCheck.
-- 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.
-- SQL view name: COUTGOINGCHECK
-- Parameters: P_Language : sylangu

CREATE VIEW C_OutgoingCheck AS
SELECT
  PaymentCompanyCode,
  HouseBank,
  HouseBankAccount,
  PaymentMethod,
  OutgoingCheque,
  IsIntercompanyPayment,
  ChequeIsManuallyIssued,
  BankName,
  ChequebookFirstCheque,
  PaymentDocument,
  ChequePaymentDate,
  PaymentCurrency,
  PaidAmountInPaytCurrency,
  Supplier,
  PaymentDocPrintDate,
  PaymentDocPrintTime,
  ChequePrintDateTime,
  PaymentDocPrintedByUser,
  ChequeEncashmentDate,
  ChequeLastExtractDate,
  ChequeLastExtractDateTime,
  PayeeTitle,
  PayeeName,
  PayeeAdditionalName,
  PayeePostalCode,
  PayeeCityName,
  PayeeStreet,
  PayeePOBox,
  PayeePOBoxPostalCode,
  PayeePOBoxCityName,
  Country,
  Region,
  ChequeVoidReason,
  _VoidReason[1: Language = $parameters.P_Language].ChequeVoidReasonTxt AS ChequeVoidReasonTxt,
  ChequeVoidedDate,
  ChequeVoidedByUser,
  ChequeIsCashed,
  CashDiscountAmount,
  CompanyCodeName AS CompanyName,
  _Country._Text[1: Language = $parameters.P_Language].CountryName AS CountryName,
  FiscalYear,
  ChequeStatus,
  ChequeIssuingType,
  ChequeType,
  VoidedChequeUsage,
  CompanyCodeCountry,
  _HouseBankAccount.HouseBankAccountDescription AS BankAccountName
FROM I_OutgoingCheck
LEFT OUTER JOIN I_HouseBankAccountText AS _HouseBankAccount ON _HouseBankAccount.CompanyCode = PaymentCompanyCode AND _HouseBankAccount.HouseBank = HouseBank AND _HouseBankAccount.HouseBankAccount = HouseBankAccount AND _HouseBankAccount.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN E_Outgoingcheck AS _Extension ON PaymentCompanyCode = _Extension.PaymentCompanyCode AND HouseBank = _Extension.HouseBank AND HouseBankAccount = _Extension.HouseBankAccount AND PaymentMethod = _Extension.PaymentMethod AND OutgoingCheque = _Extension.OutgoingCheque  -- association [0..1]
;

Learn More