VSAFPO_CN SAP (Version: Order items in PP orders) Table details
Dictionary Type: Table
Description: Version: Order items in PP orders
Description: Version: Order items in PP orders
Table field list including key, data, relationships and ABAP select examples
VSAFPO_CN is a standard SAP Table which is used to store Version: Order items in PP orders data and is available within R/3 SAP systems depending on the version and release level.
The VSAFPO_CN table consists of various fields, each holding specific information or linking keys about Version: Order items in PP orders data available in SAP. These include VSNMR (Number or description of a version), AUFNR (Order Number), POSNR (Order Item Number), PSOBS (Special procurement type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VSAFPO_CN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VSNMR | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | VSAUFK_CN | ALPHA | AUFNR | ANR | |
POSNR | Order Item Number | CO_POSNR | NUMC | 4 | CO_POSNR | ||||
PSOBS | Special procurement type | SOBES | CHAR | 1 | SOBES | ||||
QUNUM | Number of Quota Arrangement | QUNUM | CHAR | 10 | ALPHA | QUNUM | |||
QUPOS | Quota Arrangement Item | QUPOS | NUMC | 3 | NUM03 | ||||
PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | NUMC | 8 | VSPRPS_CN | KONPR | PS_POSNR | ||
PLNUM | Planned order number | PLNUM | CHAR | 10 | Assigned to domain | ALPHA | PLNUM | PAF | |
STRMP | Start date of the planned order | CO_STRMP | DATS | 8 | DATUM | ||||
ETRMP | Opening date of the planned order | CO_ETRMP | DATS | 8 | DATUM | ||||
KDAUF | Sales order number | CO_KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Sales order item | CO_KDPOS | NUMC | 6 | Assigned to domain | POSNR | AUP | ||
KDEIN | Delivery Schedule for Sales Order | KDEIN | NUMC | 4 | NUM04 | ||||
BESKZ | Procurement Type | BESKZ | CHAR | 1 | BESKZ | MBS | |||
PSAMG | Scrap quantity in item | CO_PSAMG | QUAN | 13(3) | MENG13 | ||||
PSMNG | Order item quantity | CO_PSMNG | QUAN | 13(3) | MENG13 | ||||
WEMNG | Quantity of goods received for the order item | CO_WEMNG | QUAN | 13(3) | MENG13 | ||||
IAMNG | Expected surplus/deficit for goods receipt | CO_IAMNG | QUAN | 13(3) | MENG13V | ||||
AMEIN | Unit of measure for in-house production | CO_AUFME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MEINS | Base Unit of Measure | LAGME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MATNR | Material Number for Order | CO_MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
PAMNG | Fixed quantity of scrap from production | AVMNG | QUAN | 13(3) | MENG13 | ||||
PGMNG | Total planned order quantity | GSMNG | QUAN | 13(3) | MENG13 | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
TPAUF | Indicator: Partial conversion | TPAUF | CHAR | 1 | CHAR1 | TPA | |||
LTRMI | Actual delivery/finish date | CO_LTRMI | DATS | 8 | DATUM | ||||
LTRMP | Delivery date from planned order | CO_LTRMP | DATS | 8 | DATUM | ||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | Assigned to domain | CK_KALNR | KNR | ||
UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
INSMK | Stock Type | INSMK | CHAR | 1 | INSMK | ||||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | T149C | BWTTY | |||
PWERK | Planning plant for the order | CO_PWERK | CHAR | 4 | T001W | WERKS | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
WEBAZ | Goods receipt processing time in days | PLWEZ | DEC | 3 | DEC3 | ||||
ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
SAFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | SA_AUFNR | ||
VERID | Production Version | VERID | CHAR | 4 | Assigned to domain | VERID | VER | ||
SERNR | BOM explosion number | SERNR | CHAR | 8 | SNUM | SERNR | |||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
DWERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
DAUTY | Order category | AUFTYP | NUMC | 2 | AUFTYP | ||||
DAUAT | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
DGLTP | Basic finish date | CO_GLTRP | DATS | 8 | DATUM | ||||
DGLTS | Scheduled finish | CO_GLTRS | DATS | 8 | DATUM | ||||
DFREI | Indicator: Order released/partially released (for MRP) | CO_FREI | CHAR | 1 | CHAR1 | ||||
DNREL | Indicator: Order item not relevant for MRP | CO_DNREL | CHAR | 1 | CHAR1 | ||||
VERTO | MRP Distribution Key | SA_VERTL | CHAR | 4 | T437V | SA_VERTL | |||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
WEWRT | Value of goods received in local currency | WEWRT | CURR | 13(2) | WERT7 | ||||
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | XFELD | ||||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
WEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | WEMPF | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCHA | CHARG | CHA | ||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
WEAED | Indicator: Goods receipt indicator can be changed | CO_WEAE | CHAR | 1 | XFELD | ||||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
KBNKZ | Kanban Indicator | KBNKZ | CHAR | 1 | KBNKZ | ||||
ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | MDNUM | ||||
ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | RSPOS | ||||
KRSNR | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
KRSPS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
KCKEY | Cost collector key | CCKEY | CHAR | 23 | CCKEY | ||||
RTP01 | Cost collector for repetitive manufacturing | RTP01 | CHAR | 1 | XFELD | ||||
RTP02 | Cost collector for KANBAN | RTP02 | CHAR | 1 | XFELD | ||||
RTP03 | Cost collector for valuated sales order stock | RTP03 | CHAR | 1 | XFELD | ||||
RTP04 | Cost collector for external PPC | RTP04 | CHAR | 1 | XFELD | ||||
KSVON | Cost collector valid from | KSVON | DATS | 8 | DATUM | ||||
KSBIS | Cost collector valid to | KSBIS | DATS | 8 | DATUM | ||||
OBJNP | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
NDISR | Ind.: Material in order item is not relevant for MRP | CO_NDISR | CHAR | 1 | CHAR1 | ||||
VFMNG | Committed quantity for order acc. to ATP check components | CO_VFMNG | QUAN | 13(3) | MENG13 | ||||
GSBTR | Overall commitment date | CO_GSBTR | DATS | 8 | DATUM | ||||
KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1 | KZAVC | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
XLOEK | Deletion flag | AUFLOEKZ | CHAR | 1 | XFELD | ||||
SERNP | Serial Number Profile | SERAIL | CHAR | 4 | T377P | SERAIL | |||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | INT4 | ||||
OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | OCM_OBJ_TYPE | ||||
CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 | OCM_CH_PROC | ||||
FXPRU | Fixed-Price Co-Product | CK_FIXPRKU | CHAR | 1 | XFELD | ||||
CUOBJ_ROOT | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
BERID | MRP Area | BERID | CHAR | 10 | Assigned to domain | BERID | BERID | ||
TECHS_COPY | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
.INCLU--AP | 0 | ||||||||
KUNNR2 | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
.INCLU--AP | 0 | ||||||||
MILL_OC_AUFNR_U | Number of original order | MILL_OC_AUFNR_U | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ||
MILL_OC_RUMNG | Confirmed Quantity for Item | MILL_OC_RUMNG | QUAN | 13(3) | MENG13 | ||||
MILL_OC_SORT | Item Sequence | MILL_OC_SORT | NUMC | 8 | CIM_COUNT |
Key field | Non-key field |
How do I retrieve data from SAP table VSAFPO_CN using ABAP code
The following ABAP code Example will allow you to do a basic selection on VSAFPO_CN to SELECT all data from the tableDATA: WA_VSAFPO_CN TYPE VSAFPO_CN.
SELECT SINGLE *
FROM VSAFPO_CN
INTO CORRESPONDING FIELDS OF WA_VSAFPO_CN
WHERE...
How to access SAP table VSAFPO_CN
Within an ECC or HANA version of SAP you can also view further information about VSAFPO_CN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects