SDPRCG_CNDNR_D - I_SLSPRICINGCONDITIONRECORDTP I_SLSPRICINGCONDITIONRECORDTP

I_SLSPRICINGCONDITIONRECORDTP I_SLSPRICINGCONDITIONRECORDTP information is stored in SAP table SDPRCG_CNDNR_D.
It is part of development package VDM_SD_MD_CM in software component SD-MD-CM. This development package consists of objects that can be grouped under "VDM SD Conditions".

Fields for table SDPRCG_CNDNR_D

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
CONDITIONRECORDUUID	UUID serving as key (parent key, root key)	X	/BOBF/UUID	RAW	16
CONDITIONRECORD	Number of the Condition Record		KNUMH	CHAR	20
CONDITIONSEQUENTIALNUMBER	Sequential number of the condition		KOPOS	NUMC	4
CONDITIONVALIDITYENDDATE	Validity end date of the condition record		KODATBI	DATS	16
CONDITIONVALIDITYSTARTDATE	Validity start date of the condition record		KODATAB	DATS	16
CONDITIONTABLE	Condition Table		KOTABNR_CHAR	CHAR	6
CONDITIONAPPLICATION	Application		KAPPL	CHAR	4
CONDITIONTYPE	Condition Type		KSCHA	CHAR	8
CONDITIONTYPENAME	Description		VTXTM	CHAR	60
CREATEDBYUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
CREATIONDATE	Date on which the record was created		ERDAT	DATS	16
CONDITIONTEXTID	Number of texts		KNUMT	CHAR	20
PRICINGSCALETYPE	Scale Type		STFKZ	CHAR	2
PRICINGSCALEBASIS	Scale Base Type		KZBZG	CHAR	2
CONDITIONSCALEQUANTITY	Condition Scale Quantity		KSTBM	QUAN	8
CONDITIONSCALEQUANTITYUNIT	Condition Scale Unit of Measure		KONMS	UNIT	6
CONDITIONSCALEAMOUNT	Scale Value		KSTBW	CURR	8
CONDITIONSCALEAMOUNTCURRENCY	Scale Currency		KONWS	CUKY	10
CONDITIONCALCULATIONTYPE	Calculation Type for Condition		KRECH	CHAR	2
CONDITIONCALCULATIONTYPENAME	Description of a Condition Calculation Type		PRCT_CALCULATION_TYPE_DESCR	CHAR	60
CONDITIONRATEVALUE	Condition amount or percentage where no scale exists		KBETR_KOND	CURR	6
CONDITIONRATEVALUEUNIT	Condition Unit (Currency or Percentage)		KONWA	CUKY	10
CONDITIONQUANTITY	Condition Pricing Unit		KPEIN	DEC	3
CONDITIONQUANTITYUNIT	Condition Unit		KMEIN	UNIT	6
CONDITIONTOBASEQTYNMRTR	Numerator for converting condition units to base units		KUMZA	DEC	3
CONDITIONTOBASEQTYDNMNTR	Denominator for converting condition units to base units		KUMNE	DEC	3
BASEUNIT	Base Unit of Measure		MEINS	UNIT	6
CONDITIONLOWERLIMIT	Lower limit of the condition rate/amount		MXWRT	CURR	6
CONDITIONUPPERLIMIT	Upper limit for the condition rate		GKWRT	CURR	6
CONDITIONALTERNATIVECURRENCY	Condition Currency (for Cumulation Fields)		KWAEH	CUKY	10
CONDITIONEXCLUSION	Condition exclusion indicator		KZNEP	CHAR	2
CONDITIONISDELETED	Deletion Indicator for Condition Record		LOEVM_KO	CHAR	2
ADDITIONALVALUEDAYS	Additional Value Days		VALTG	NUMC	4
FIXEDVALUEDATE	Fixed Value Date		VALDT	DATS	16
PAYMENTTERMS	Terms of payment key		DZTERM	CHAR	8
PAYMENTTERMSNAME	Description of terms of payment		DZTERM_BEZ	CHAR	60
CNDNMAXNUMBEROFSALESORDERS	Maximum number of sales orders per condition record		ANZAUF	NUMC	4
MINIMUMCONDITIONBASISVALUE	Minimum condition base value		MIKBAS	QUAN	8
MAXIMUMCONDITIONBASISVALUE	Maximum condition base value		MXKBAS	QUAN	8
MAXIMUMCONDITIONAMOUNT	Maximum condition value		KOMXWRT	CURR	7
INCREMENTALSCALE	Number of incremental scale		KLF_STG	NUMC	8
PRICINGSCALELINE	Scale number for pricing		KLF_KAL	NUMC	8
CONDITIONRELEASESTATUS	Release Status		KFRST	CHAR	2
CONDITIONRELEASESTATUSTEXT	Explanatory Short Text		DDTEXT	CHAR	120
DEPARTURECOUNTRY	Departure Country/Region (from which the goods are sent)		ALAND	CHAR	6
DEPARTURECOUNTRYNAME	Country/Region Name		LANDX50	CHAR	100
SALESDOCUMENT	Sales Document		VBELN_VA	CHAR	20
SALESDOCUMENTITEM	Sales Document Item		POSNR_VA	NUMC	12
SALESDOCUMENTITEMTEXT	Short text for sales order item		ARKTX	CHAR	80
BILLABLECONTROL	Accounting Indicator		BEMOT	CHAR	4
BILLABLECONTROLNAME	Accounting Indicator Description		BEMOT_TXT	CHAR	50
INDUSTRY	Industry key		BRSCH	CHAR	8
INDUSTRYKEYTEXT	Description of the Industry Key		TEXT1_016T	CHAR	40
CITYCODE	City Code		CITYC	CHAR	8
CITYCODENAME	Description		BEZEI20	CHAR	40
CONDITIONCONTRACT	Condition Contract		WCB_COCO_NUM	CHAR	20
COUNTY	County Code		COUNC	CHAR	6
COUNTYNAME	Description		BEZEI20	CHAR	40
TECHNICALOBJECTTYPE	Type of Technical Object		EQART	CHAR	20
TECHNICALOBJECTTYPEDESC	Text for Object Type		EARTX	CHAR	40
EQUIPMENT	Equipment Number		EQUNR	CHAR	36
EQUIPMENTNAME	Description of technical object		KTX01	CHAR	80
CUSTOMERHIERARCHY	Customer		KUNNR_KH	CHAR	20
INCOTERMSCLASSIFICATION	Incoterms (Part 1)		INCO1	CHAR	6
INCOTERMSCLASSIFICATIONNAME	Description		BEZEI30	CHAR	60
INCOTERMSTRANSFERLOCATION	Incoterms (Part 2)		INCO2	CHAR	56
ACCOUNTTAXTYPE	Tax type		J_1AFITP_D	CHAR	4
CUSTOMERGROUP	Customer Group		KDGRP	CHAR	4
CUSTOMERGROUPNAME	Name		VTXTK	CHAR	40
CUSTOMERPRICEGROUP	Customer Price Group		KONDA_V	CHAR	4
CUSTOMERPRICEGROUPNAME	Description		BEZEI20	CHAR	40
MATERIALPRICINGGROUP	Material Price Group		KONDM_V	CHAR	4
MATERIALPRICINGGROUPNAME	Description		BEZEI20	CHAR	40
SOLDTOPARTY	Sold-to Party		KUNAG	CHAR	20
SOLDTOPARTYNAME	Name of Customer		MD_CUSTOMER_NAME	CHAR	160
CUSTOMER	Customer number		KUNNR_V	CHAR	20
CUSTOMERNAME	Name of Customer		MD_CUSTOMER_NAME	CHAR	160
PAYERPARTY	Payer		KUNRG	CHAR	20
PAYERPARTYNAME	Name of Customer		MD_CUSTOMER_NAME	CHAR	160
SHIPTOPARTY	Ship-to Party		KUNWE	CHAR	20
SHIPTOPARTYNAME	Name of Customer		MD_CUSTOMER_NAME	CHAR	160
SUPPLIER	Vendor's account number		ELIFN	CHAR	20
SUPPLIERNAME	Name of Supplier		MD_SUPPLIER_NAME	CHAR	160
DESTINATIONCOUNTRY	Destination Country/Region		LLAND	CHAR	6
DESTINATIONCOUNTRYNAME	Country/Region Name		LANDX50	CHAR	100
MATERIALGROUP	Material Group		MATKL	CHAR	18
MATERIALGROUPNAME	Material Group Description		WGBEZ	CHAR	40
RETURNSREFUNDEXTENT	Returns Refund Code		MSR_RETURNS_REFUND_CODE	CHAR	6
RETURNSREFUNDEXTENTDESC	Refund Code Description		MSR_REFUND_CODE_TEXT	CHAR	120
ADDITIONALMATERIALGROUP1	Material Group 1		MVGR1	CHAR	6
ADDITIONALMATERIALGROUP1NAME	Description		BEZEI40	CHAR	80
ADDITIONALMATERIALGROUP2	Material Group 2		MVGR2	CHAR	6
ADDITIONALMATERIALGROUP2NAME	Description		BEZEI40	CHAR	80
ADDITIONALMATERIALGROUP3	Material Group 3		MVGR3	CHAR	6
ADDITIONALMATERIALGROUP3NAME	Description		BEZEI40	CHAR	80
ADDITIONALMATERIALGROUP4	Material Group 4		MVGR4	CHAR	6
ADDITIONALMATERIALGROUP4NAME	Description		BEZEI40	CHAR	80
ADDITIONALMATERIALGROUP5	Material Group 5		MVGR5	CHAR	6
ADDITIONALMATERIALGROUP5NAME	Description		BEZEI40	CHAR	80
PERSONNEL	Personnel Number		PERNR_D	NUMC	16
PERSONFULLNAME	Full Name		BU_NAME1TX	CHAR	160
PRICELISTTYPE	Price List Type		PLTYP	CHAR	4
PRICELISTTYPENAME	Text (20 Characters)		TEXT20	CHAR	40
POSTALCODE	Postal Code		PSTLZ	CHAR	20
REGION	Region (State, Province, County)		REGIO	CHAR	6
REGIONNAME	Description		BEZEI20	CHAR	40
ENGAGEMENTPROJECTSERVICEORG	Service Organization		/CPD/PWS_WS_ORG_UNIT_ID	CHAR	10
ENGMTPROJECTSERVICEORGNAME	Description of Organization Unit ID		/CPD/PWS_WS_ORG_UNIT_ID_DESC	CHAR	80
REQUIREMENTSEGMENT	Requirement Segment		SGT_RCAT	CHAR	80
STOCKSEGMENT	Stock Segment		SGT_SCAT	CHAR	80
DIVISION	Division		SPART	CHAR	4
DIVISIONNAME	Division Description		DIVISIONNAME	CHAR	40
COMMODITYCODE	Commodity Code		STAWN	CHAR	34
COMMODITYCODETEXT	Description		BEZEI40	CHAR	80
PRODUCTHIERARCHYNODE	Product Hierarchy Node		VKON_PROD_HIER_NODE_VALUE	CHAR	48
PRODUCTHIERARCHYNODETEXT	Product Hierarchy Node Value Text		PROD_HIER_NODE_VALUE_TEXT	CHAR	80
CONSUMPTIONTAXCTRLCODE	Control code for consumption taxes in foreign trade		STEUC	CHAR	32
BRSPCFCTAXBASEPERCENTAGECODE	Tax Base in Percentage		TAXBS	NUMC	2
BRSPCFCTXGRPDYNTAXEXCEPTIONS	Tax Group for Dynamic Tax Exceptions		J_1BTXGRP	NUMC	4
CUSTOMERTAXCLASSIFICATION1	Tax Classification 1 for Customer		TAXK1	CHAR	2
CUSTOMERTAXCLASSIFICATION2	Tax Classification 2 for Customer		TAXK2	CHAR	2
CUSTOMERTAXCLASSIFICATION3	Tax Classification 3 for Customer		TAXK3	CHAR	2
CUSTOMERTAXCLASSIFICATION4	Tax Classification 4 for Customer		TAXK4	CHAR	2
PRODUCTTAXCLASSIFICATION1	Tax classification material		TAXM1	CHAR	2
PRODUCTTAXCLASSIFICATION2	Tax Classification 2 for Material		TAXM2	CHAR	2
PRODUCTTAXCLASSIFICATION3	Tax Classification 3 for Material		TAXM3	CHAR	2
PRODUCTTAXCLASSIFICATION4	Tax Classification 4 for Material		TAXM4	CHAR	2
TRADINGCONTRACT	Trading Contract		TKONN	CHAR	20
TRADINGCONTRACTITEM	Item Number of Trading Contract		TPOSN	NUMC	12
TAXJURISDICTION	Tax Jurisdiction		TXJCD	CHAR	30
TAXJURISDICTIONNAME	Description		TEXT1_TXJT	CHAR	100
BRSPCFCTAXDEPARTUREREGION	Ship from location (tax region)		J_1BTXSHPF	CHAR	6
BRSPCFCTAXDESTINATIONREGION	Ship to location (tax region)		J_1BTXSHPT	CHAR	6
MAINITEMMATERIALPRICINGGROUP	Material pricing group of main item		UKONM	CHAR	4
MAINITMMATLPRICINGGROUPNAME	Description		BEZEI20	CHAR	40
MAINITEMPRICINGREFMATERIAL	Pricing reference material of main item		UPMAT	CHAR	80
MAINITEMPRICINGREFMATERIALNAME	Material Description		MAKTX	CHAR	80
VARIANTCONDITION	Variant Condition Key		VARCOND	CHAR	52
VARIANTCONDITIONNAME	Variant Condition Key		VARCOND	CHAR	52
VALUEADDEDSERVICECHARGECODE	VAS Charge Codes		FSH_VAS_CHRG_CODE	CHAR	6
SDDOCUMENT	Sales and Distribution Document Number		VBELN	CHAR	20
REFERENCESDDOCUMENT	Document number of the reference document		VGBEL	CHAR	20
REFERENCESDDOCUMENTITEM	Item number of the reference item		VGPOS	NUMC	12
SALESOFFICE	Sales office		VKBUR	CHAR	8
SALESOFFICENAME	Description		BEZEI20	CHAR	40
SALESGROUP	Sales group		VKGRP	CHAR	6
SALESGROUPNAME	Description		BEZEI20	CHAR	40
SALESORDERSALESORGANIZATION	Sales organization of sales order		VKORG_AUFT	CHAR	8
SLSORDERSALESORGANIZATIONNAME	Name		VTXTK	CHAR	40
ORDERQUANTITYUNIT	Sales unit		VRKME	UNIT	6
ORDERQUANTITYUNITNAME	Unit of Measurement Text (Maximum 30 Characters)		MSEHL	CHAR	60
SALESORGANIZATION	Sales Organization		VKORG	CHAR	8
SALESORGANIZATIONNAME	Description		VTEXT	CHAR	40
DISTRIBUTIONCHANNEL	Distribution Channel		VTWEG	CHAR	4
DISTRIBUTIONCHANNELNAME	Description		VTEXT	CHAR	40
MATERIAL	Material Number		MATNR	CHAR	80
MATERIALNAME	Material Description		MAKTX	CHAR	80
TRANSACTIONCURRENCY	SD Document Currency		WAERK	CUKY	10
TRANSACTIONCURRENCYNAME	Long Text		LTEXT	CHAR	80
WBSELEMENTINTERNALID	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
WBSDESCRIPTION	PS: Short description (1st text line)		PS_POST1	CHAR	80
WORKPACKAGE	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
WORKPACKAGENAME	PS: Short description (1st text line)		PS_POST1	CHAR	80
PLANT	Plant		WERKS_D	CHAR	8
PLANTNAME	Name		NAME1	CHAR	60
PLANTREGION	Region in which plant is located		WKREG	CHAR	6
PLANTREGIONNAME	Description		BEZEI20	CHAR	40
WORKITEM	Work Item ID		/CPD/PFP_WORKITEM_ID	CHAR	20
WORKITEMNAME	Work Item Name		/CPD/PFP_WORKITEM_NAME	CHAR	80
CONDITIONPROCESSINGSTATUS	Processing status for conditions		KBSTAT	CHAR	4
PRICINGDATE	Condition Pricing Date		KDATU	DATS	16
CONDITIONISEXCLUSIVE	Indicator condition exclusive		KEXCL	CHAR	2
CONDITIONSCALEBASISVALUE	Condition Scale Base Value		KSTAF	NUMC	14
TAXCODE	Tax on sales/purchases code		MWSKZ	CHAR	4
ENGAGEMENTPROJECT	Commercial Project ID		/CPD/MP_ID	CHAR	80
ENGAGEMENTPROJECTNAME	Customer Project Name		/CPD/SHORT_TEXT	CHAR	80
CONFIGURATIONNUMBER	Configuration (internal object number)		CUOBJ	NUMC	36
BR_NFDOCUMENTTYPE	Document type		J_1BDOCTYP	CHAR	2
BRSPCFCFREEDEFINEDFIELD1	Dynamic Key Field 1		J_1BDYNKEY1	CHAR	80
BRSPCFCFREEDEFINEDFIELD2	Dynamic Key Field 2		J_1BDYNKEY2	CHAR	80
BRSPCFCFREEDEFINEDFIELD3	Dynamic Key Field 3		J_1BDYNKEY3	CHAR	80
INTERNATIONALARTICLENUMBER	International Article Number (EAN/UPC)		EAN11	CHAR	36
TXRLVNCECLASSFCTNFORARGENTINA	Tax relevant classification		J_1ATXREL_	CHAR	20
BR_TAXCODE	SD tax code		J_1BTXSDC_	CHAR	4
LOCALSALESTAXAPPLICABILITYCODE	LST CST applicability code		J_1ISTCODE	CHAR	6
SERVICEDOCUMENT	Transaction ID		CRMT_OBJECT_ID_DB	CHAR	20
SERVICEDOCUMENTITEM	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
TIMESHEETOVERTIMECATEGORY	Overtime Category		CATS_OVERTIME_CATEGORY	CHAR	8
TIMESHEETOVERTIMECATEGORYTEXT	Overtime Category Description		CATS_SSC_OVERTIMECATTEXT	CHAR	100
SALESSDDOCUMENTCATEGORY	SD Document Category		VBTYPL	CHAR	8
SDDOCUMENTCATEGORYNAME	Short Text for Fixed Values		VAL_TEXT	CHAR	120
RETURNREASON	Return Reason		MSR_RETURNS_REASON	CHAR	6
CUSTOMERCONDITIONGROUP	Customer Attribute for Condition Groups		KDKGR	CHAR	4
SHIPPINGTYPE	Shipping Type		VERSART	CHAR	4
SHIPPINGTYPENAME	Shipping Type Description		VERSARTBEZ	CHAR	40
SUBSCRIPTIONCONTRACTDURATION	Numerical Value of Duration		CRMT_PROV_DURATION	NUMC	26
SUBSCRPNCONTRDURATIONUNIT	IS-T: Unit of Duration for a Telco Contract		CRMT_PROV_DURATION_UNIT	CHAR	24
SUBSCRIPTIONCONTRACTLOCKREASON	Lock Reason		IST_LOCK_REASON	CHAR	16
VALIDONDATE	Valid On		DATAM	DATS	16
ACCESSNUMBEROFACCESSSEQUENCE	Access sequence - Access number		KOLNR	NUMC	6
ETAG	Character field of length 40		CHAR40	CHAR	80
CONDITIONRECORDISEDITABLE	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
CONDITIONRECORDISDRAFT	Boolean Variable (X = True, - = False, Space = Unknown)		BOOLEAN	CHAR	2
STATUS	Single-Character Flag		CHAR1	CHAR	2
SALESPRICEAPPROVALREQUEST	Sales Price Approval Request		SALESPRICEAPPROVALREQUEST	CHAR	20
CONDITIONCHANGEREASON	Reason for Changing Condition Record		CNDN_CHGREASON	CHAR	6
CONDITIONCHANGEREASONTEXT	Text field		TEXT	CHAR	58
CONDITIONTEXT	Description		BEZEI40	CHAR	80
ACTIVEUUID	UUID serving as key (parent key, root key)		/BOBF/UUID	RAW	16
HASACTIVEENTITY	Draft - Indicator - Has active document		SDRAFT_HAS_ACTIVE	CHAR	2
.INCLUDE				SDRAFT_WRITE_DRAFT_ADMIN	0
DRAFTENTITYCREATIONDATETIME	Draft Created On		SDRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On		SDRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document		SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft - Consistency Status		SDRAFT_CONSISTENCY_STATUS	CHAR	2
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SDRAFT_OPERATION_CODE	CHAR	2
.INCLUDE				SDPRCOMHEAD_INCL_EEW_PS	0
DUMMY_PRCOMHEAD_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				SDPRCOMITEM_INCL_EEW_PS	0
DUMMY_PRCOMITEM_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2
.INCLU--AP				OIU_PRICING	0
PRACONTRACT	Contract Number		OIU_CT_NO	CHAR	20	*
WELL	Well ID number		OIU_WL_NO	CHAR	30
WELLCOMPLETION	Well Completion Number		OIU_WC_NO	CHAR	10
MEASUREMENTPOINT	Measurement point number		OIU_MP_NO	CHAR	40