CURRENTACTIVITY
CURRENTACTIVITY is an SAP database table in S/4HANA. It contains 35 fields.
Fields (35)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| BankGuaranteeNumber | BankGuaranteeNumber | 1 | |
| BankGuaranteeType | BankGuaranteeType | 1 | |
| CurrencyPair | CurrencyPair | 1 | |
| EffectiveInterestMethod | EffectiveInterestMethod | 1 | |
| EffectiveInterestRate | EffectiveInterestRate | 1 | |
| ExchangeRate | ExchangeRate | 1 | |
| FinancialInstrActivityCategory | FinancialInstrActivityCategory | 1 | |
| FinancialInstrContactPerson | FinancialInstrContactPerson | 1 | |
| FinInstrExternalReference | FinInstrExternalReference | 1 | |
| FinTransActyConclusionDate | FinTransActyConclusionDate | 1 | |
| FinTransActyConclusionTime | FinTransActyConclusionTime | 1 | |
| FinTransActyConclusionTimeZone | FinTransActyConclusionTimeZone | 1 | |
| FinTransExerciseDate | FinTransExerciseDate | 1 | |
| FinTransFixingDate | FinTransFixingDate | 1 | |
| FinTransNoticeDate | FinTransNoticeDate | 1 | |
| FinTransOrderValidityEndDate | FinTransOrderValidityEndDate | 1 | |
| FinTransRolloverDate | FinTransRolloverDate | 1 | |
| FinTransTermCategory | FinTransTermCategory | 1 | |
| FinTransTermStartEndInclusive | FinTransTermStartEndInclusive | 1 | |
| FollowingCurrency | FollowingCurrency | 1 | |
| ForeignExchangeFixingReference | ForeignExchangeFixingReference | 1 | |
| LeadingCurrency | LeadingCurrency | 1 | |
| LetterOfCredit | LetterOfCredit | 1 | |
| LiquidityEffectValue | LiquidityEffectValue | 1 | |
| SpotExchangeRate | SpotExchangeRate | 1 | |
| SwapExchangeRate | SwapExchangeRate | 1 | |
| TermEndDate | TermEndDate | 1 | |
| Trader | Trader | 1 | |
| TreasuryAdvisingBank | TreasuryAdvisingBank | 1 | |
| TreasuryApplicant | TreasuryApplicant | 1 | |
| TreasuryBeneficiary | TreasuryBeneficiary | 1 | |
| TreasuryIssuingBank | TreasuryIssuingBank | 1 | |
| TreasuryReversalReason | TreasuryReversalReason | 1 | |
| TrsyMnllyEnteredApplcntName | TrsyMnllyEnteredApplcntName | 1 | |
| TrsyMnllyEnteredBnfcyName | TrsyMnllyEnteredBnfcyName | 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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CURRENTACTIVITY (
BANKGUARANTEENUMBER,
BANKGUARANTEETYPE,
CURRENCYPAIR,
EFFECTIVEINTERESTMETHOD,
EFFECTIVEINTERESTRATE,
EXCHANGERATE,
FINANCIALINSTRACTIVITYCATEGORY,
FINANCIALINSTRCONTACTPERSON,
FININSTREXTERNALREFERENCE,
FINTRANSACTYCONCLUSIONDATE,
FINTRANSACTYCONCLUSIONTIME,
FINTRANSACTYCONCLUSIONTIMEZONE,
FINTRANSEXERCISEDATE,
FINTRANSFIXINGDATE,
FINTRANSNOTICEDATE,
FINTRANSORDERVALIDITYENDDATE,
FINTRANSROLLOVERDATE,
FINTRANSTERMCATEGORY,
FINTRANSTERMSTARTENDINCLUSIVE,
FOLLOWINGCURRENCY,
FOREIGNEXCHANGEFIXINGREFERENCE,
LEADINGCURRENCY,
LETTEROFCREDIT,
LIQUIDITYEFFECTVALUE,
SPOTEXCHANGERATE,
SWAPEXCHANGERATE,
TERMENDDATE,
TRADER,
TREASURYADVISINGBANK,
TREASURYAPPLICANT,
TREASURYBENEFICIARY,
TREASURYISSUINGBANK,
TREASURYREVERSALREASON,
TRSYMNLLYENTEREDAPPLCNTNAME,
TRSYMNLLYENTEREDBNFCYNAME
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA