CRMD_SALES

Business Transaction - Sales Set | #transactional | Component: Business Transactions
Column Name Description
CLIENT Client
GUID GUID of a CRM Order Object
Column Name Description
Column Name Description
Column Name Description
PO_DATE_SOLD Reference Document Date
PO_DATE_SHIP Ship-To Party's Reference Document Date
NFE_REF_DATE null
Column Name Description
PROBABILITY Order Probability Show values
DATE_QTY_FIXED Fixed Date and Quantity Show values
ROUNDING Round Requirement Quantity Show values
PAR_ATP_SSTOCK Parameter-Dependent ATP Safety Stock Show values
CONF_RULE Confirmation Rule Show values
REASSIGN_ABILITY Reassignment of Order Confirmations Show values
ABNORMAL_DEMAND Abnormal Demand Show values
Column Name Description Domain name
PO_NUMBER_UC Sold-to Party's External Reference No. (in Capital Letters) CHAR35
REGION Region (State, Province, County) REGIO
INDUSTRY Industry Sector BRSCH
PCAT_HDR_GUID null
PCAT_VRT_GUID null
PCAT_CTY_GUID null
PO_NUMBER_SOLD Sold-To Party's External Reference Number TEXT35
YOUR_REF_SOLD Sold-to Party Reference TEXT12
PO_NUMBER_SHIP Ship-To Party's External Reference Number TEXT35
YOUR_REF_SHIP Ship-To Party Reference TEXT12
SUBMISSION Collective Number for Quotations TEXT10
REQ_DLV_DATE Requested Delivery Date Header BCOS_TSTMP
REQ_TIMEZONE Time Zone Requested Delivery Date Header TZNZONE
RULE_REQ_DATE Rule Reqested Delivery Date Header TIMERULEID
MAX_LOC Maximum Number of Locations
REQ_SOLUTION Complaint Requested Solution CRMS4_REQ_SOLUTION
ISSUE_CAUSED_BY Complaint Issue Caused By CRMS4_COMP_ISS_CAU
COMPLAINT_IMPACT Complaint Impact CRMS4_COMP_IMPACT
COMPLAINT_REASON Complaint Reason CRMS4_COMP_REASON
CUST_PROFILE null
SALES_DUMMY Dummy function in length 1 DUMMY
NFE_REF_NUM Text (length 35) TEXT35
Master Data Relations Join Conditions
Customer Group 1
  • CRMD_SALES.CLIENT == TVV1.MANDT
  • CRMD_SALES.CUST_GROUP1 == TVV1.KVGR1
Customer Group 2
  • CRMD_SALES.CLIENT == TVV2.MANDT
  • CRMD_SALES.CUST_GROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • CRMD_SALES.CUST_GROUP3 == TVV3.KVGR3
  • CRMD_SALES.CLIENT == TVV3.MANDT
Customer Group 4
  • CRMD_SALES.CLIENT == TVV4.MANDT
  • CRMD_SALES.CUST_GROUP4 == TVV4.KVGR4
Customer Group 5
  • Customer Group 5
  • Client
  • CRMD_SALES.CUST_GROUP5 == TVV5.KVGR5
  • CRMD_SALES.CLIENT == TVV5.MANDT
Cancellation Reason Code
  • Cancellation Reason Code
  • Client
Rule Criterion 2
Rule Criterion 1
Usage Indicator
  • Usage Indicator
  • Client
  • CRMD_SALES.USAGE_TYPE == TVLV.ABRVW
  • CRMD_SALES.CLIENT == TVLV.MANDT