MSCA

Sales Orders on Hand with Supplier | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
CHARG FK Batch Number
LIFNR FK Account Number of Supplier
SOBKZ FK Special Stock Indicator
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
CALAB Valuated Unrestricted-Use Stock
CAINS Stock in Quality Inspection
CASPE Blocked Stock
CAVLA Valuated unrestricted-use stock in previous period
CAVIN Stock in Quality Inspection in Previous Period
CAVSP Blocked stock of previous period
Column Name Description
Column Name Description
CASPR Physical Inventory Blocking Indicator Show values
CARUE MxxxH rec. already exists for per. before last of Mxxx per. Show values
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
CAILL Physical inventory indicator for whse stock in current year INVKZ
CAILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
CAILS Physical inventory indicator for blocked stock INVKZ
CAVLL Physical inventory indicator for stock in previous year INVKZ
CAVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
CAVLS Phys. inventory indicator for blocked stock in prev. period INVKZ
CAFLL Physical inventory indicator for stock in following year INVKZ
CAFLQ Physical inventory indicator, quality insp.stck, follow.yr. INVKZ
CAFLS Phys. inventory ind. for blocked stock in following period INVKZ
CAJIN Fiscal year of current physical inventory indicator GJAHR
Master Data Relations Join Conditions
Batch
  • Material Number
  • Batch Number
  • Plant
  • MSCA.MANDT == MCHA.MANDT
  • MSCA.MATNR == MCHA.MATNR
  • MSCA.CHARG == MCHA.CHARG
  • MSCA.WERKS == MCHA.WERKS
Vendor
  • MSCA.MANDT == LFA1.MANDT
  • MSCA.LIFNR == LFA1.LIFNR
Client MSCA.MANDT == T000.MANDT
Material No.
  • Material Number
  • Client
  • MSCA.MATNR == MARA.MATNR
  • MSCA.MANDT == MARA.MANDT
Sonderbestandskennzeichen
  • MSCA.MANDT == T148.MANDT
  • MSCA.SOBKZ == T148.SOBKZ
Plant
  • MSCA.MANDT == T001W.MANDT
  • MSCA.WERKS == T001W.WERKS