MMSPQCNDNTERM_D - Draft table for entity R_SRCGPROJQTNITMCMMDTYTERMTP
Draft table for entity R_SRCGPROJQTNITMCMMDTYTERMTP information is stored in SAP table MMSPQCNDNTERM_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 MMSPQCNDNTERM_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 | CPET_TERMNO | NUMC | 10 | ||
DOCITEMCOMMODITYPRICINGUUID | CPE Caller - GUID of Document Item | CPET_DOCITEM_GUID | RAW | 16 | ||
CONDITIONTYPE | CPE: Condition Type for Commodity Pricing | CPET_COND_TYPE | CHAR | 8 | ||
PRICINGCONDITIONFORMULAKEY | CPE Formula - Key | CPET_FORMID | CHAR | 20 | ||
PRCGCONDITIONFORMULAINPUTUUID | CPE Formula - GUID of Changed Input for General Data | CPET_FORMINPUT_GUID | RAW | 16 | ||
ORIGINSYSTEM | CPE Formula - Original Logical System | CPET_FORMLOGSYS | CHAR | 20 | ||
PRCGCNDNFMLACOMMODITYQUANTITY | CPE Formula - Total Quantity of Commodity in Document Item | CPET_FORMCOMMQUAN | QUAN | 8 | ||
PRCGCNDNFMLACMMDTYQUANTITYUNIT | CPE Formula - Unit of Measure of Commodity Used in Formula | CPET_FORMCOMMUOM | UNIT | 6 | ||
PRCGCNDNFMLAEVALUATIONDATETIME | CPE Formula - Evaluation Date and Time | CPET_EVAL_TIMESTAMP_CDS | CHAR | 28 | ||
CNDNEXCHRATEPERDDETNRESULTUUID | CPE Term - GUID for Result of Period Determination | CPET_PERIODDTOUT_GUID | RAW | 16 | ||
PRCGCNDNTRMCONVERSIONINPUTUUID | CPE Term - GUID for Conversion Input | CPET_TERMCONVIN_GUID | RAW | 16 | ||
PRCGCNDNTERMCONVERSIONRSLTUUID | CPE Term - GUID for Conversion Result | CPET_TERMCONVOUT_GUID | RAW | 16 | ||
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 | ||
PRCGCNDNSOURCEQUANTITYUNIT | CPE - Unit of Measure to Be Converted During Conv. ('From') | CPET_UOMFROM | UNIT | 6 | ||
PRCGCNDNTARGETQUANTITYUNIT | CPE - Unit of Measure Converted to During Conversion | CPET_UOMTO | UNIT | 6 | ||
PRICINGCONDITIONCONVERSIONRULE | CPE - Conversion Rule | CPET_CONVERSIONRULE | CHAR | 20 | ||
PRCGCONDITIONFIXEDEXCHANGERATE | CPE Term - Fixed Exchange Rate for Currency Conversion | CPET_FIXEXCHRATE | DEC | 9 | ||
CNDNCNVRSNRULEVALDTYSTRTDTETME | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR | 28 | ||
CNDNTRMCNVRSNVALDTYSTRTDTETME | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR | 28 | ||
PRCGCONDITIONCONVERSIONPLACE | CPE - Conversion Place | CPET_CONVPLACE | NUMC | 8 | ||
PRCGCNDNGRPTRMVALDTYSTRTDTETME | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR | 28 | ||
PRICINGCONDITIONTERMKEY | CPE Term - Key | CPET_TERMID | CHAR | 20 | ||
PRCGCNDNTRMVALDTYSTARTDATETIME | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR | 28 | ||
PRCGCNDNFMLAEVALUATIONMODULE | CPE - Module of the Commodity Pricing Engine | CPET_MODULE | CHAR | 4 | ||
CNDNTRMCALCTYPEROUTINESUBMDL | CPE Log - Submodule | CPET_LOG_SUBMODULE | CHAR | 4 | ||
PRCGCNDNTERMCALCULATIONTYPE | CPE Term - Term Calculation Type | CPET_TERMTYPE | NUMC | 14 | ||
PRICINGCONDITIONTERMRULE | CPE Term - Term Rule | CPET_TERMRULE | CHAR | 20 | ||
CNDNTRMRULEVALDTYSTARTDATETIME | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR | 28 | ||
PRCGCNDNTERMCALCULATIONRULE | CPE Term - Calculation Rule | CPET_CALCRULE | CHAR | 20 | ||
CNDNCALCRULEVALDTYSTRTDATETIME | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR | 28 | ||
PRCGCNDNTERMQUOTATIONRULE | CPE Quotation Rule | CPET_QUOTATIONRULE | CHAR | 20 | ||
CNDNQTANRULEVALDTYSTRTDATETIME | CPE - 'Valid From' Time Stamp of Commodity Pricing Object | CPET_VALIDFROM_CDS | CHAR | 28 | ||
PRICINGCONDITIONTERMRATE | CPE Term - Rate | CPET_TERMRATE_CDS | DEC | 16 | ||
PRCGCONDITIONTERMRATECRCY | CPE Term - Currency | CPET_TERMCURR | CUKY | 10 | ||
PRCGCONDITIONTERMRATEQTY | CPE Term - Price Unit | CPET_TERMPRUN | DEC | 3 | ||
PRCGCONDITIONTERMRATEQTYUNIT | CPE Term - Unit of Measure | CPET_TERMUOM | UNIT | 6 | ||
PRCGCONDITIONTERMQUOTATIONRATE | CPE Price Quotation | CPET_PRICEQUOT_CDS | DEC | 16 | ||
PRCGCNDNTRMQTANRATECURRENCY | Quotation Currency | CPET_QUOTCURR | CUKY | 10 | ||
PRCGCNDNTRMQTANRATEQUANTITY | Price Unit of Quotation | CPET_QUOTPRUN | DEC | 3 | ||
PRCGCNDNTRMQTANRATEQTYUNIT | Unit of Measure of Quotation | CPET_QUOTUOM | UNIT | 6 | ||
PRCGCNDNTRMQTANPERDSTRTDTETIME | CPE Term - First Date and Time of Period Determined | CPET_FIRSTTIMESTAMP_CDS | CHAR | 28 | ||
PRCGCNDNTRMQTANPERDENDDATETIME | CPE Term - End Date and Time of Period Determined | CPET_LASTTIMESTAMP_CDS | CHAR | 28 | ||
PRCGCNDNTRMQTANPERDREFDATE | CPE Term - Calculated Reference Date | CPET_REFDATE | DATS | 16 | ||
PRCGCNDNTRMQTANPERDBASEDTETIME | CPE Term - Calculated Base Date and Time | CPET_BASETIMESTAMP_CDS | CHAR | 28 | ||
CNDNTRMEXCHRATEPERDSTRTDTETIME | CPE Term - First Date and Time of Period Determined | CPET_FIRSTTIMESTAMP_CDS | CHAR | 28 | ||
CNDNTRMEXCHRATEPERDENDDATETIME | CPE Term - End Date and Time of Period Determined | CPET_LASTTIMESTAMP_CDS | CHAR | 28 | ||
PRCGCNDNTRMEXCHRATEPERDREFDATE | CPE Term - Calculated Reference Date | CPET_REFDATE | DATS | 16 | ||
CNDNTRMEXCHRATEPERDBASEDTETIME | CPE Term - Calculated Base Date and Time | CPET_BASETIMESTAMP_CDS | CHAR | 28 | ||
PRCGCONDITIONTERMSURCHARGERATE | CPE Term - Total Surcharge for Commodity | CPET_SURCHARGERATE_CDS | DEC | 16 | ||
PRCGCNDNTRMSURCHARGERTECRCY | CPE Term - Currency of Absolute Surcharge | CPET_SURCHRATECURR | CUKY | 10 | ||
PRCGCNDNTRMSURCHARGERTEQTY | CPE Term - Price Unit of Absolute Surcharge | CPET_SURCHRATEPRUN | DEC | 3 | ||
PRCGCNDNTRMSURCHARGERTEQTYUNIT | CPE Term - Unit of Measure of Absolute Surcharge | CPET_SURCHRATEUOM | UNIT | 6 | ||
PRICINGCONDITIONTERMGROUP | CPE Term - Term Group | CPET_TERMGROUP | CHAR | 2 | ||
PRICINGCONDITIONTERMFIXEDRATE | CPE Term - Fixed Rate | CPET_FIXTERMRATE_CDS | DEC | 16 | ||
PRCGCONDITIONTERMFIXEDRATECRCY | CPE - Currency for Fixed Rate | CPET_FIXCURR | CUKY | 10 | ||
PRCGCONDITIONTERMFIXEDRATEQTY | CPE - Price Unit of Fixed Rate | CPET_FIXPRUN | DEC | 3 | ||
PRCGCNDNTERMFIXEDRATEQTYUNIT | CPE - Unit of Measure of Fixed Rate | CPET_FIXUOM | UNIT | 6 | ||
DERIVATIVECONTRSPECIFICATION | Derivative Contract Specification ID | TBA_DCSID | CHAR | 40 | ||
MARKETIDENTIFIERCODE | Market Identifier Code | TBA_MIC | CHAR | 8 | ||
TIMETOMATURITY | Time to Maturity | TBA_TENOR | CHAR | 20 | ||
QUOTATIONPRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 4 | ||
CONDITIONVALIDITYENDDATE | Validity end date of the condition record | KODATBI | DATS | 16 | ||
CONDITIONVALIDITYSTARTDATE | Validity start date of the condition record | KODATAB | DATS | 16 | ||
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 | ||
PROCMTHUBPLANTUNIQUEID | Plant Unique ID | MMPUR_BE_PLANT_UNIQUE_ID | CHAR | 60 | ||
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 | ||
.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 |