MMSPQCEXRATE_D - Draft table for entity R_SPQtnItmCmmdtyExchangeRatTP
Draft table for entity R_SPQtnItmCmmdtyExchangeRatTP information is stored in SAP table MMSPQCEXRATE_D.
It is part of development package RAP_MM_PUR_SRCGPROJQTN in software component MM-PUR-SPQ. This development package consists of objects that can be grouped under "Sourcing Project Quotation".
It is part of development package RAP_MM_PUR_SRCGPROJQTN in software component MM-PUR-SPQ. This development package consists of objects that can be grouped under "Sourcing Project Quotation".
Fields for table MMSPQCEXRATE_D
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| CONDITIONRECORD | Number of the Condition Record | X | KNUMH | CHAR | 20 | |
| CONDITIONSEQUENTIALNUMBERSHORT | Sequential number of the condition | X | KOPOS | NUMC | 4 | |
| PRICINGCONDITIONTERM | CPE Term - Number in Formula | X | CPET_TERMNO | NUMC | 10 | |
| PRCGCNDNTRMEXCHRATEDATETIME | Exchange Rate Time Stamp | X | CPET_EXCHANGERATE_TIMESTAMP | DEC | 8 | |
| SOURCINGPROJECTQUOTATION | Supplier Quotation | VDM_SOURCINGPROJECTQUOTATION | CHAR | 20 | ||
| SOURCINGPROJECTQUOTATIONITEM | Supplier Quotation Item | VDM_SRCGPROJQTNITEM | NUMC | 10 | ||
| SRCGPROJQUOTATIONVERSION | Sourcing Project Quotation Version | VDM_SRCGPROJQTNVERSION | NUMC | 10 | ||
| SRCGPROJQTNITEMUUID | Supplier Quotation Item UUID | VDM_SRCGPROJQTNITEMUUID | RAW | 16 | ||
| SOURCINGPROJECTQUOTATIONUUID | Supplier Quotation UUID | VDM_SRCGPROJQUOTATIONUUID | RAW | 16 | ||
| CONDITIONVALIDITYENDDATE | Validity end date of the condition record | KODATBI | DATS | 16 | ||
| CONDITIONVALIDITYSTARTDATE | Validity start date of the condition record | KODATAB | DATS | 16 | ||
| PROCMTHUBPLANTUNIQUEID | Plant Unique ID | MMPUR_BE_PLANT_UNIQUE_ID | CHAR | 60 | ||
| CONDITIONTYPE | Condition Type | KSCHA | CHAR | 8 | ||
| CURRENCY | Condition Unit (Currency or Percentage) | KONWA | CUKY | 10 | ||
| CONDITIONRATEVALUE | Condition amount or percentage where no scale exists | KBETR_KOND | CURR | 6 | ||
| CONDITIONRATEVALUEUNIT | Condition Unit (Currency or Percentage) | KONWA | CUKY | 10 | ||
| CONDITIONCALCULATIONTYPESHORT | Calculation Type for Condition | KRECH | CHAR | 2 | ||
| CONDITIONQUANTITY | Condition Pricing Unit | KPEIN | DEC | 3 | ||
| CONDITIONQUANTITYUNIT | Condition Unit | KMEIN | UNIT | 6 | ||
| CONDITIONAPPLICATION | Application | KAPPL | CHAR | 4 | ||
| CONDITIONISDELETED | Deletion Indicator for Condition Record | LOEVM_KO | CHAR | 2 | ||
| DOCITEMCOMMODITYPRICINGUUID | Globally Unique Identifier | GUID | RAW | 16 | ||
| CNDNEXCHRATEPERDDETNRESULTUUID | CPE Term - GUID for Result of Period Determination | CPET_PERIODDTOUT_GUID | RAW | 16 | ||
| PRCGCONDITIONEXCHANGERATETYPE | Exchange Rate Type | KURST_CURR | CHAR | 8 | ||
| PRICINGCONDITIONSOURCECURRENCY | CPE - Currency to Be Converted During Conversion ('from') | CPET_CURRFROM | CUKY | 10 | ||
| PRICINGCONDITIONTARGETCURRENCY | CPE - Currency to Be Converted to During Conversion ('to') | CPET_CURRTO | CUKY | 10 | ||
| NUMBEROFSOURCECURRENCYUNITS | Ratio for the "from" currency units | FFACT_CURR | DEC | 5 | ||
| NUMBEROFTARGETCURRENCYUNITS | Ratio for the "to" currency units | TFACT_CURR | DEC | 5 | ||
| CNDNTRMEXCHRATESUBSTNDATETIME | Substitution Time Stamp | CPET_SUBSTITUTION_TIMESTAMP | DEC | 8 | ||
| CNDNTRMEXCHRATEISNONTRADINGDAY | CPE - Indicates a non-trading day | CPET_EXCHRATE_CLOSED_MARKET | CHAR | 2 | ||
| PRCGCNDNTRMEXCHRATEISMISSING | CPE - Indicates that the Exchange Rate is missing | CPET_EXCHRATE_MISSING | CHAR | 2 | ||
| CNDNTRMEXCHRATEISSUBSTITUTED | CPE - Indicates that the Exchange Rate is substituted | CPET_EXCHRATE_SUBSTITUTED | CHAR | 2 | ||
| PRCGCNDNTRMEXCHRATEISIGNORED | CPE - Indicates that the exchange rate is ignored | CPET_EXCHRATE_IGNORED | CHAR | 2 | ||
| PRCGCNDNTRMEXCHRATEFCSTSTATUS | Status of Quotation or Exchange Rate Forecast | CPET_FORECAST_STATUS | INT1 | 1 | ||
| PRICINGCONDITIONEXCHANGERATE | CPE - Exchange Rate Used for Currency Conversion | CPET_USEDEXCHRATE | DEC | 9 | ||
| PRCGCONDITIONSWAPEXCHANGERATE | Swap Exchange Rate | CMM_SWAP_RATE | DEC | 5 | ||
| PRCGCONDITIONSPOTEXCHANGERATE | Spot Exchange Rate | CMM_SPOT_RATE | DEC | 5 | ||
| .INCLUDE | %ADMIN | SYCH_BDL_DRAFT_ADMIN_INC | 0 | |||
| DRAFTENTITYCREATIONDATETIME | Draft Created At | SYCH_BDL_DRAFT_CREATED_AT | DEC | 11 | ||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed At | SYCH_BDL_DRAFT_LAST_CHANGED_AT | DEC | 11 | ||
| DRAFTADMINISTRATIVEDATAUUID | Draft Administration UUID | SYCH_BDL_DRAFT_ADMIN_UUID | RAW | 16 | ||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SYCH_BDL_DRAFT_OPERATION_CODE | CHAR | 2 | ||
| HASACTIVEENTITY | Draft Flag "Has Active Instance" | SYCH_BDL_DRAFT_HASACTIVE | CHAR | 2 | ||
| DRAFTFIELDCHANGES | Draft Field Changes as BLOB | SYCH_BDL_DRAFT_FIELD_CHANGES | RSTR | 8 |