Fields (20)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | terminput_guid | ACMPrcgTermInputUUID | 1 |
| accgo_cdote_status | CmmdtyOrderRequestStatus | 1 | |
| accgo_prc_fix_status | ACMPrcgFixationStatus | 1 | |
| ACMTermCalcType | ACMTermCalcType | 1 | |
| basis_type | BasisType | 1 | |
| BasisType | BasisType | 1 | |
| dcsid | DerivativeContrSpecification | 1 | |
| DerivativeContrSpecification | DerivativeContrSpecification | 2 | |
| fixtermcurr | PrcgCndnFmlaFixedRateCurrency,PrcgConditionTermFixedRateCrcy | 4 | |
| FIXTERMPRUN | PrcgConditionTermFixedRateQty | 2 | |
| fixtermrate | ACMPrcgCndnTermInputPrice | 2 | |
| fixtermrate_df34 | PricingConditionTermFixedRate | 2 | |
| FIXTERMUOM | PrcgCndnTermFixedRateQtyUnit | 2 | |
| MarketIdentifierCode | ACMPricingMarketIdentifierCode,MarketIdentifierCode | 2 | |
| MaturityKeyDate | MaturityKeyDate | 2 | |
| mic | MarketIdentifierCode | 1 | |
| PrcgCndnTrmRateChangeDateTime | PrcgCndnTrmRateChangeDateTime | 1 | |
| PriceQuotationType | PriceQuotationType | 1 | |
| pricetype | QuotationPriceType | 1 | |
| PricingConditionQuotationKey | PricingConditionQuotationKey | 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 TERMINPUT (
TERMINPUT_GUID,
ACCGO_CDOTE_STATUS,
ACCGO_PRC_FIX_STATUS,
ACMTERMCALCTYPE,
BASIS_TYPE,
BASISTYPE,
DCSID,
DERIVATIVECONTRSPECIFICATION,
FIXTERMCURR,
FIXTERMPRUN,
FIXTERMRATE,
FIXTERMRATE_DF34,
FIXTERMUOM,
MARKETIDENTIFIERCODE,
MATURITYKEYDATE,
MIC,
PRCGCNDNTRMRATECHANGEDATETIME,
PRICEQUOTATIONTYPE,
PRICETYPE,
PRICINGCONDITIONQUOTATIONKEY,
PRIMARY KEY (TERMINPUT_GUID)
);
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