SAP VSAFPO_CN Version: Order items in PP orders Table

Overview

VSAFPO_CN is a standard SAP S/4HANA table that stores Version: Order items in PP orders data. There are total 100 fields in the VSAFPO_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VSAFPO_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).

In addition, following links provide an overview of foreign key relationships, if any, that link VSAFPO_CN to other SAP tables and standard CDS views available based on VSAFPO_CN table in S/4HANA 2020.

Techincal Settings of VSAFPO_CN

Below are technical details of the table VSAFPO_CN

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VSAFPO_CN Fields

The following table gives you an overview of the fields available in VSAFPO_CN

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
VSNMRNumber or description of a versionVSNMRCHAR12
AUFNROrder NumberAUFNRVSAUFK_CNCHAR12
POSNROrder item numberCO_POSNRNUMC4
PSOBSSpecial procurement typeSOBESCHAR1
QUNUMNumber of quota arrangementQUNUMCHAR10
QUPOSQuota arrangement itemQUPOSNUMC3
PROJNWork breakdown structure element (WBS element)PS_PSP_ELEVSPRPS_CNNUMC8
PLNUMPlanned OrderPLNUMCHAR10
STRMPPlanned Order Planned Start DateCO_STRMPDATS8
ETRMPOpening Date of the Planned OrderCO_ETRMPDATS8
KDAUFSales OrderCO_KDAUFCHAR10
KDPOSSales Order ItemCO_KDPOSVBAPNUMC6
KDEINDelivery schedule for sales orderKDEINNUMC4
BESKZProcurement TypeBESKZCHAR1
PSAMGOrder Item Planned Scrap QuantityCO_PSAMGQUAN13
PSMNGOrder Item Planned Total QuantityCO_PSMNGQUAN13
WEMNGQuantity of Goods Received for the Order ItemCO_WEMNGQUAN13
IAMNGExpected Surplus/Deficit For Goods ReceiptCO_IAMNGQUAN13
AMEINUnit of measure for in-house productionCO_AUFMET006UNIT3
MEINSBase Unit of MeasureLAGMET006UNIT3
MATNRMaterial Number for OrderCO_MATNRMARACHAR40
PAMNGPlanned Scrap QuantityAVMNGQUAN13
PGMNGPlanned Total Order QuantityGSMNGQUAN13
KNTTPAccount Assignment CategoryKNTTPT163KCHAR1
TPAUFIndicator: Partial ConversionTPAUFCHAR1
LTRMIActual Delivery/Finish DateCO_LTRMIDATS8
LTRMPDelivery Date From Planned OrderCO_LTRMPDATS8
KALNRCost Estimate Number for Cost Est. w/o Qty StructureCK_KALNR*NUMC12
UEBTOOverdelivery ToleranceUEBTODEC3
UEBTKUnlimited Overdelivery AllowedUEBTKCHAR1
UNTTOUnderdelivery ToleranceUNTTODEC3
INSMKStock TypeINSMKCHAR1
WEPOSGoods Receipt IndicatorWEPOSCHAR1
BWTARValuation TypeBWTAR_DT149DCHAR10
BWTTYValuation CategoryBWTTY_DT149CCHAR1
PWERKPlanning Plant for an OrderCO_PWERKT001WCHAR4
LGORTStorage locationLGORT_DT001LCHAR4
UMREZNumerator for Conversion to Base Units of MeasureUMREZDEC5
UMRENDenominator for conversion to base units of measureUMRENDEC5
WEBAZGoods Receipt Processing Duration in DaysPLWEZDEC3
SAFNRRun schedule header numberSA_AUFNR*CHAR12
VERIDProduction VersionVERID*CHAR4
SERNRBOM explosion numberSERNRSNUMCHAR8
TECHSParameter Variant/Standard VariantTECHSCHAR12
DWERKPlantWERKS_DT001WCHAR4
DAUTYOrder categoryAUFTYPNUMC2
DAUATOrder TypeAUFARTT003OCHAR4
DGLTPBasic finish dateCO_GLTRPDATS8
DGLTSScheduled finishCO_GLTRSDATS8
DFREIIndicator: Order released/partially released (for MRP)CO_FREICHAR1
DNRELIndicator: Order Item is not Relevant for MRPCO_DNRELCHAR1
VERTOMRP Distribution KeySA_VERTLT437VCHAR4
SOBKZSpecial Stock IndicatorSOBKZT148CHAR1
KZVBRConsumption postingKZVBRCHAR1
WEWRTValue of goods received in local currencyWEWRTCURR13
WEUNBGoods Receipt Non-ValuatedWEUNBCHAR1
ABLADUnloading PointABLADCHAR25
WEMPFGoods RecipientWEMPFCHAR12
CHARGBatch NumberCHARG_DMCHACHAR10
GSBERBusiness AreaGSBERTGSBCHAR4
WEAEDIndicator: Goods receipt indicator can be changedCO_WEAECHAR1
CUOBJConfiguration (internal object number)CUOBJNUMC18
KBNKZKanban IndicatorKBNKZCHAR1
ARSNRSettlement reservation numberARSNRNUMC10
ARSPSItem number of the settlement reservationARSPSNUMC4
KRSNRNumber of reservation/dependent requirementsRSNUM*NUMC10
KRSPSItem Number of Reservation / Dependent RequirementsRSPOSNUMC4
KCKEYCost Collector KeyCCKEYCHAR23
RTP01Cost collector for repetitive manufacturingRTP01CHAR1
RTP02Cost collector for KANBANRTP02CHAR1
RTP03Cost collector for valuated sales order stockRTP03CHAR1
RTP04Cost collector for external PPCRTP04CHAR1
KSVONCost collector valid fromKSVONDATS8
KSBISCost collector valid toKSBISDATS8
OBJNPObject numberJ_OBJNR*CHAR22
NDISRInd.: Material in order item is not relevant for MRPCO_NDISRCHAR1
VFMNGCommitted quantity for order acc. to ATP check componentsCO_VFMNGQUAN13
GSBTRTotal Commitment DateCO_GSBTRDATS8
KZAVCIndicator for type of availability checkKZAVCCHAR1
KZBWSValuation of Special StockKZBWSCHAR1
XLOEKDeletion FlagAUFLOEKZCHAR1
SERNPSerial Number ProfileSERAILT377PCHAR4
ANZSNNumber of serial numbersANZSNINT410
OBJTYPEChange indicatorOCM_OBJ_TYPECHAR1
CH_PROCProcess that has lead to the change of an objectOCM_CH_PROCCHAR1
FXPRUFixed-Price Co-ProductCK_FIXPRKUCHAR1
CUOBJ_ROOTConfiguration (internal object number)CUOBJNUMC18
BERIDMRP AreaBERID*CHAR10
TECHS_COPYParameter Variant/Standard VariantTECHSCHAR12
SGT_SCATStock SegmentSGT_SCATCHAR40
KUNNR2Customer NumberKUNNRCHAR10
FSH_SEASON_YEARSeason YearFSH_SAISJCHAR4
FSH_SEASONSeasonFSH_SAISOCHAR10
FSH_COLLECTIONFashion CollectionFSH_COLLECTION*CHAR10
FSH_THEMEFashion ThemeFSH_THEMECHAR10
FSH_SALLOC_QTYAllocated Stock QuantityFSH_SALLOC_QTYQUAN13
MILL_OC_AUFNR_UNumber of original orderMILL_OC_AUFNR_U*CHAR12
MILL_OC_RUMNGConfirmed Quantity for ItemMILL_OC_RUMNGQUAN13
MILL_OC_SORTItem SequenceMILL_OC_SORTNUMC8

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VSAFPO_CN

Table NameFieldCardinalityCheck Table
VSAFPO_CNAMEINC: CNT006
VSAFPO_CNAUFNR1: 1VSAUFK_CN
VSAFPO_CNBWTARC: CNT149D
VSAFPO_CNBWTTYC: CNT149C
VSAFPO_CNCHARGC: CNMCHA
VSAFPO_CNDAUAT1: CNT003O
VSAFPO_CNDWERK1: CNT001W
VSAFPO_CNGSBERC: CNTGSB
VSAFPO_CNKALNRC: CN*
VSAFPO_CNKDAUF1: CN*
VSAFPO_CNKDPOS:VBAP
VSAFPO_CNKNTTP1: CNT163K
VSAFPO_CNLGORTC: CNT001L
VSAFPO_CNMANDT1: CNT000
VSAFPO_CNMATNR1: CNMARA
VSAFPO_CNMEINS1: CNT006
VSAFPO_CNPLNUM1: CN*
VSAFPO_CNPROJN1: CNVSPRPS_CN
VSAFPO_CNPWERKC: CNT001W
VSAFPO_CNSAFNRC: CN*
VSAFPO_CNSERNP:T377P
VSAFPO_CNSERNR:SNUM
VSAFPO_CNSOBKZC: CNT148
VSAFPO_CNVERIDC: CN*
VSAFPO_CNVERTOC: CNT437V

Other References