P_UNREALIZEDCRCYDIFFFILTER

CDS View
55 Fields 1 CDS Views

Filter on Unrealized Currency Difference

P_UNREALIZEDCRCYDIFFFILTER is a CDS View in S/4HANA. Filter on Unrealized Currency Difference. It contains 55 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashFlowItem view_entity union_all COMPOSITE Cash Flow Items

Fields (55)

KeyField CDS FieldsUsed in Views
KEY CashFlow CashFlow 1
KEY CashFlowID CashFlowID 1
KEY OriginDocument OriginDocument 1
KEY OriginSystem OriginSystem 1
KEY OriginTransaction OriginTransaction 1
KEY OriginTransactionQualifier OriginTransactionQualifier 1
KEY ValidFrom ValidFrom 1
KEY ValidTo ValidTo 1
AccountingDocumentType AccountingDocumentType 1
AssetContract AssetContract 1
BankAccountInternalID BankAccountInternalID 1
BusinessArea BusinessArea 1
BusinessPartner BusinessPartner 1
CashFlowIsEndOfDayReconciled CashFlowIsEndOfDayReconciled 1
CashPlanningGroup CashPlanningGroup 1
CashReleaseStatus CashReleaseStatus 1
CashTransactionOwner CashTransactionOwner 1
CertaintyLevel CertaintyLevel 1
CompanyCode CompanyCode 1
CostCenter CostCenter 1
CreationDateTime CreationDateTime 1
Customer Customer 1
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
FinancialAccountType FinancialAccountType 1
FinancialInstrumentProductType FinancialInstrumentProductType 1
FinancialTransactionType FinancialTransactionType 1
FiscalYear FiscalYear 1
Fund Fund 1
GLAccount GLAccount 1
GrantID GrantID 1
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
IsValid IsValid 1
LastChangeDateTime LastChangeDateTime 1
LiquidityItem LiquidityItem 1
Material Material 1
MemoRecordExpirationDateTime MemoRecordExpirationDateTime 1
NetDueDate NetDueDate 1
PartnerCompany PartnerCompany 1
PaymentMethod PaymentMethod 1
PlanningLevel PlanningLevel 1
Portfolio Portfolio 1
PostingDate PostingDate 1
PostingFiscalPeriod PostingFiscalPeriod 1
ProfitCenter ProfitCenter 1
RelatedOriginApplication RelatedOriginApplication 1
RelatedOriginTransactionID RelatedOriginTransactionID 1
SecurityAccount SecurityAccount 1
SecurityClass SecurityClass 1
Segment Segment 1
SourceCompanyCode SourceCompanyCode 1
Supplier Supplier 1
TransactionCurrency TransactionCurrency 1
TransactionDate DocumentDate 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Filter on Unrealized Currency Difference
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_UNREALIZEDCRCYDIFFFILTER (
    CASHFLOW,
    CASHFLOWID,
    ORIGINDOCUMENT,
    ORIGINSYSTEM,
    ORIGINTRANSACTION,
    ORIGINTRANSACTIONQUALIFIER,
    VALIDFROM,
    VALIDTO,
    ACCOUNTINGDOCUMENTTYPE,
    ASSETCONTRACT,
    BANKACCOUNTINTERNALID,
    BUSINESSAREA,
    BUSINESSPARTNER,
    CASHFLOWISENDOFDAYRECONCILED,
    CASHPLANNINGGROUP,
    CASHRELEASESTATUS,
    CASHTRANSACTIONOWNER,
    CERTAINTYLEVEL,
    COMPANYCODE,
    COSTCENTER,
    CREATIONDATETIME,
    CUSTOMER,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALTRANSACTIONTYPE,
    FISCALYEAR,
    FUND,
    GLACCOUNT,
    GRANTID,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    ISVALID,
    LASTCHANGEDATETIME,
    LIQUIDITYITEM,
    MATERIAL,
    MEMORECORDEXPIRATIONDATETIME,
    NETDUEDATE,
    PARTNERCOMPANY,
    PAYMENTMETHOD,
    PLANNINGLEVEL,
    PORTFOLIO,
    POSTINGDATE,
    POSTINGFISCALPERIOD,
    PROFITCENTER,
    RELATEDORIGINAPPLICATION,
    RELATEDORIGINTRANSACTIONID,
    SECURITYACCOUNT,
    SECURITYCLASS,
    SEGMENT,
    SOURCECOMPANYCODE,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    TRANSACTIONDATE,
    PRIMARY KEY (CASHFLOW, CASHFLOWID, ORIGINDOCUMENT, ORIGINSYSTEM, ORIGINTRANSACTION, ORIGINTRANSACTIONQUALIFIER, VALIDFROM, VALIDTO)
);

Learn More