VBAP
Sales Document: Item Data
VBAP is an SAP database table in S/4HANA. Sales Document: Item Data. It contains 519 fields. 85 CDS views read from this table.
CDS Views using this table (85)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Adk0_Dli_Wip_Detail_Vbl_View | view | inner | DLI WIP Detail View for SD Documents | |
| Arun_I_So_1 | view | from | SO Item level Data selection | |
| arun_i_so_arun_check | view | inner | Select SalesOrder Items for ARun Article | |
| arun_i_so_item | view | from | SO Item level Data selection | |
| Arun_Reqsrt_Sd | view | inner | Requirement sorting - SD | |
| ARUN_SD_DB | view | inner | Sales document data | |
| ARUN_SO_ITEM_QTY | view | from | Fetch Sup Assgmt status of a sales order | |
| Arun_So_Req1 | view | from | Sales Order Requirement - Initial join | |
| ARUN_SO_REQMT_SL | view | inner | SO selection at Date level | |
| ARun_ValAddedSrvcSDItmBsc | view | inner | P_ARunValAddedSrvcSDItmBsc | |
| Atpc_Cds_Vbep | view | left_outer | CDS View on VBEP Table for ATP BOP | |
| atpc_dvol_peak_creation_tstmp | view | from | Data Volume for Peaks with Creation Timestamp | |
| C_SchedProdnSalesDocumentVH | view | inner | CONSUMPTION | Sales Document |
| CTE_CDS_FIN_MON_SO | view | inner | CDS View for Monotoring SO exp to Concur | |
| E_SalesDocumentItemBasic | view_entity | from | EXTENSION | Extension view for VBAP |
| Fcdm_Keyfigures_Read_Custrq | view | inner | Read Cust Rqmt for Fcs Demand Keyfigures | |
| FINOC_MOCK_RT_SOI_FILL | view | inner | Orgl Change: Mock for FINOC_RT_SOI_FILL | |
| FINOC_RT_SOI_MONTHS | view | from | Orgl Chg: Sales Doc Crte Dt Plus Months | |
| finoc_vbap_incorrect_prctr | view_entity | inner | Sales Doc Items with Incorrect PrftCtr | |
| fins_prctr_of_object_acdoca | view | left_outer | Derive PRCTR & PPRCTR for ACDOCA object | |
| fins_rev_rec_alloc | view_entity | inner | Read data from FINS_TRR_ALLOC | |
| FINS_REV_REC_FLOWSOMD | view_entity | left_outer | Flow of documents, Object Summary | |
| fins_rev_rec_sd_status | view_entity | union_all | Status of sales order/return/contract items | |
| Fins_Trr_Acc_Ass_Obj_all | view_entity | union | Account Assignment Object | |
| Fins_Trr_Acc_Ass_Obj_prps | view_entity | left_outer | Account Assignment Object | |
| Fins_Trr_Acc_Ass_Obj_vbap | view_entity | from | Account Assignment Object | |
| FSH_DDL_TPO | view | left_outer | TPO Extract | |
| I_ARunMntrItemSD | view | from | BASIC | Basic View for Item data of SD document in ARun Monitor Runs |
| I_ARunOvwSDItem | view | from | BASIC | Basic View for Sales Document Item |
| I_ARunPrioritySlsOrdBasic | view | from | BASIC | Base View for ARun Priority in SOs |
| I_ARunSalesOrderItem | view | inner | BASIC | ARun relevant Sales Document Item |
| I_DigitalVehSalesDocConfig | view_entity | from | BASIC | Digital Vehicle SalesDoc Configuration |
| I_RFM_SalesDocumentItem | view | from | BASIC | Sales Document Item |
| I_RFM_SDItemWthParentAttrib | view | from | BASIC | Sales Document with Parent Attribute |
| I_RFM_SDItemWthProdAttrib | view | from | BASIC | Sales data with product attributes |
| I_SalesDocumentItem | view | from | BASIC | Sales Document Item |
| I_SalesDocumentItemBasic | view | from | BASIC | Sales Document Item Basic |
| I_SalesDocumentItemRqmtSgmt | view | from | BASIC | Sales Document Item Requirement Segment for VH |
| I_SupDmndAllDocRetSlsOrd | view | inner | BASIC | View for Return Sales Orders |
| I_SupDmndOvwItemSD | view | inner | BASIC | Basic View for Sales Document Item |
| P_CmmdtyPrcFixationExerciseSls | view | inner | BASIC | Basic View Price Fixation Exercises Sales |
| P_CmmdtyPrcFixationExerSlsNew | view_entity | inner | COMPOSITE | Private View Price Fixation Exercise (sCPE) Sales |
| P_CmmdtyPrcFixationOptionSales | view | inner | BASIC | Basic View Price Fixation Option Sales |
| P_CmmdtyPrcFixationOptnSlsNew | view_entity | inner | COMPOSITE | Private View Price Fixation Option (sCPE) Sales |
| P_Combapbilling | view | inner | BASIC | Billing as planned |
| P_Comfpbilling | view | left_outer | BASIC | Fixed Plan Billing |
| P_CustomerOrder | view | inner | BASIC | Customer and Order information |
| P_Fcdm_Keyf_Read_Custrq_Sls | view | inner | BASIC | Read Customer sales Forecast Demand Keyfigures |
| P_HUPSchedgAgrmt | view_entity | from | BASIC | Scheduling Agreement Item details 4 HUP |
| P_PrcFixationOptionBsHndlgSls | view | inner | BASIC | Basic View Price Fixation Option Basis Handling Sales |
| P_PrcFixationOptionCnvrsnSls | view | inner | BASIC | Basic View Price Fixation Option Conversion Sales |
| P_PrcFixationOptnCnvrsnSlsNew | view_entity | inner | COMPOSITE | Price Fixation Option Conversion (sCPE) Sales |
| P_PrcSttgMethExecutionAnalysis | view | left_outer | BASIC | Price Setting Method Execution Analysis |
| P_PrFixationOptnBsHndlgSlsNew | view_entity | inner | COMPOSITE | Price Fixation Option Basis Handling (sCPE) Sales |
| P_ProdAllocSalesOrderPartner | view | inner | COMPOSITE | Reads The Correct Partner for Sales Order Items |
| P_Ra_Objects | view | left_outer | BASIC | Objects of results analysis |
| P_RFM_MaSaDoSDVCMItm | view | from | BASIC | Sales Documents with VCM |
| P_SDM_SDSLS_VBAP_2 | view | from | BASIC | Inconsistent address_type data for contact person in VBPA |
| P_SDM_SDSLS_VBAP_3 | view | from | BASIC | Inconsistent address_type data for contact person in VBPA |
| P_SDM_SDSLS_VBAP_4 | view_entity | from | BASIC | SDM for field VBAP-ITEM_UUID |
| P_SupDmndAllDocSDRqmtType | view | inner | BASIC | View for Sales Document Requirement Type |
| P_SupDmndOvwSDDateBasic | view | inner | BASIC | SD Item For Supply Demand Overview |
| P_Trrsobase | view_entity | inner | COMPOSITE | Base View TRR for Sales Order |
| P_Trrsobaseplan | view_entity | from | COMPOSITE | Base view for plan data |
| P_Trrsochartbase | view_entity | inner | COMPOSITE | Base View TRR for SalOrd.Chart |
| P_VarConfignSalesDocumentItem | view | from | BASIC | Simulation - Sales Document Item private view |
| P_WhereUsdPrftCtrSlsDocItem | view_entity | from | BASIC | Simplified Sales Document Item |
| pp_mrp_read_mfg_order | view | inner | Read Manufacturing Order | |
| pp_mrp_read_mfg_order_comp | view | inner | Read Manufacturing Order Components | |
| pp_mrp_read_outbound_deliv | view | inner | Read Outbound Deliveries | |
| pp_mrp_read_planned_order_comp | view | inner | Read Planned Order Components | |
| pp_mrp_read_purchase_req | view | inner | Deprecated: Replaced by I_MRPPurchaseRequisition | |
| pp_mrp_read_sales_order | view | inner | Read Sales Order | |
| PRODCMPLNCLICRLVTSALESDOC | view | from | License Relevant Sales Document Items | |
| rfm_psst_assign | view | inner | PSST Assignment monitor view | |
| rfm_psst_so_redet | view | inner | PSST - SO redetermination | |
| RFM_SalesDocumentItemBasic | view | inner | RFM Cont | |
| rfm_scc_salesdata_basic_V | view | inner | Salesdata basic view | |
| rfm_scc_sd_season_assign | view | from | RFM Manage Season Completeness SD Assign | |
| RFM_SD_ITM_HDR_PATNR_BASIC | view | from | Salesdoc items mapped to HDR Partnr det | |
| RFM_SD_SEASONS_BASIC_VIEW | view | inner | RFM Sales Document Seasons Basic View | |
| SHSM_FSH_VA_SEA_F4 | view | inner | CDS replacing replacing FSH_VA_SEA_F4 | |
| V_Vbup_S4 | view | from | DDL for VBUP CDS view | |
| VC_INTEGRATION_VBAP | view | from | Extraction for VBAP | |
| vfco_dll_va88_l1 | view | inner | CDS-View for transaction VA88H - first step |
Fields (519)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | vbeln | vbeln_va | Sales Document | |||
| KEY | posnr | posnr_va | Item | |||
| item_uuid | sd_sls_item_uuid | |||||
| matnr | matnr | Material | ||||
| matwa | matwa | MaterialEntered | ||||
| pmatn | pmatn | Pr. Ref. Matl | ||||
| charg | charg_d | Batch | ||||
| matkl | matkl | Material Group | ||||
| arktx | arktx | Item Descr. | ||||
| pstyv | pstyv | Item Category | ||||
| posar | posar | Item Type | ||||
| process_code | tdd_item_process_code | Processing Code | ||||
| dwn_payt_procg_var | sdbil_dwn_payt_procg_var | |||||
| lfrel | lfrel_ap | Item Del.f.Dlv. | ||||
| fkrel | fkrel | Relev.for Bill. | ||||
| uepos | uepos | Higher-Lev.Item | ||||
| grpos | grpos | Altern. to Item | ||||
| abgru | abgru_va | RejectionReason | ||||
| prodh_univ_id_val_contr | prod_hier_id | Product Hierarchy | ||||
| prodh_univ_node_val_contr | prod_hier_node_value | Node | ||||
| prodh | prodh_d | Prod. Hierarchy | ||||
| zwert | dzwert | Target Value | ||||
| zmeng | dzmeng | Target Quantity | ||||
| zieme | dzieme | Target Qty UoM | ||||
| umziz | umziz | Convers.Factor | ||||
| umzin | umzin | Convers.Factor | ||||
| meins | meins | Base Unit | ||||
| substn_numerator | md_substn_numerator | Numerator for Conversion | ||||
| substn_denominator | md_substn_denominator | Denominator for Conversion | ||||
| smeng | smeng | Scale Quantity | ||||
| ablfz | ablfz | Rounding qty | ||||
| abdat | abdat | Recon.Date | ||||
| absfz | absfz | Absolute deviation | ||||
| posex | posex | PO Item | ||||
| kdmat | matnr_ku | Cust. Material | ||||
| kbver | kbver | % deviation | ||||
| kever | kever | Dev. days | ||||
| vkgru | vkgru | Class. of Items | ||||
| vkaus | abrvw | Usage | ||||
| grkor | grkor | Delivery Group | ||||
| fmeng | fmeng | Qty. is fixed | ||||
| uebtk | uebtk_v | Unlimited Tol. | ||||
| uebto | uebto | Overdeliv. Tol. | ||||
| untto | untto | Underdel. Tol. | ||||
| faksp | faksp_ap | Billing Block | ||||
| atpkz | atpkz | Replacemt Part | ||||
| rkfkf | rkfkf | Bill.meth.CO/PPC | ||||
| spart | spart | Division | ||||
| gsber | gsber | Business Area | ||||
| netwr | netwr_ap | Net Value | ||||
| waerk | waerk | Doc. Currency | ||||
| antlf | antlf | Max.Part.Deliv. | ||||
| kztlf | kztlf | Part.dlv./item | ||||
| resource_id | nsdm_resourcename_sid | Resource Name | ||||
| chspl | chspl | Batch split | ||||
| kwmeng | kwmeng | Order quantity | ||||
| lsmeng | lsmeng | Required DlvQty | ||||
| kbmeng | kbmeng | CumltvConfdQty | ||||
| klmeng | klmeng | CumltvConfdQty | ||||
| vrkme | vrkme | Sales Unit | ||||
| umvkz | umvkz | Numerator | ||||
| umvkn | umvkn | Denominat. | ||||
| brgew | brgew_ap | Gross Weight | ||||
| ntgew | ntgew_ap | Net Weight | ||||
| gewei | gewei | Unit of Weight | ||||
| volum | volum_ap | Volume | ||||
| voleh | voleh | Volume Unit | ||||
| vbelv | vbelv | Originating Doc | ||||
| posnv | posnv | Origin. Item | ||||
| vgbel | vgbel | Reference Doc. | ||||
| vgpos | vgpos | Reference Item | ||||
| voref | voref | Complete Refer. | ||||
| upflu | upflv | Update Doc.Flow | ||||
| erlre | erlre | Completion Rule | ||||
| lprio | lprio | Delivery Prior. | ||||
| werks | werks_ext | Plant | ||||
| lgort | lgort_d | Location | ||||
| vstel | vstel | Shipping Point | ||||
| route | route | Route | ||||
| stkey | stkey | BOM origin | ||||
| stdat | stdat | BOM Key Date | ||||
| stlnr | stnum | BOM | ||||
| stpos | stpos_vbap | BOM Item Number | ||||
| awahr | awahr | Order Probab. | ||||
| erdat | erdat | Created On | ||||
| ernam | ernam | Created By | ||||
| erzet | erzet | Time | ||||
| taxm1 | taxmt | Tax Classific. | ||||
| taxm2 | taxmt | Tax Classific. | ||||
| taxm3 | taxmt | Tax Classific. | ||||
| taxm4 | taxmt | Tax Classific. | ||||
| taxm5 | taxmt | Tax Classific. | ||||
| taxm6 | taxmt | Tax Classific. | ||||
| taxm7 | taxmt | Tax Classific. | ||||
| taxm8 | taxmt | Tax Classific. | ||||
| taxm9 | taxmt | Tax Classific. | ||||
| vbeaf | vbeaf | Fixed proc.time | ||||
| vbeav | vbeav | Var. proc. time | ||||
| vgref | vgref | Preced. with ref. | ||||
| netpr | netpr | Net Price | ||||
| kpein | kpein | Pricing Unit | ||||
| kmein | kmein | Unit of Measure | ||||
| shkzg | shkzg_va | Returns | ||||
| sktof | sktof | Cash Discount | ||||
| mtvfp | mtvfp | Avail. check | ||||
| sumbd | sumbd | Req'mt totals. | ||||
| kondm | kondm | Mat. Price Grp | ||||
| ktgrm | ktgrm | AcctAssmtGrpMat | ||||
| bonus | bonus | Vol. Rebate Grp | ||||
| provg | provg | Commission Grp | ||||
| eannr | eannr | EAN Number | ||||
| prsok | prsok | Pricing | ||||
| bwtar | bwtar_d | Valuation Type | ||||
| bwtex | bwtex | Separate val. | ||||
| xchpf | xchpf | Batch Mgmt Rqt | ||||
| xchar | xchar | Batches | ||||
| batch_billing_variant | sdbil_batch_billing_variant | BatchItmBillVar | ||||
| lfmng | minlf | Min. Dely Qty | ||||
| stafo | stafo | Update Group | ||||
| wavwr | wavwr | Cost | ||||
| kzwi1 | kzwi1 | Subtotal 1 | ||||
| kzwi2 | kzwi2 | Subtotal 2 | ||||
| kzwi3 | kzwi3 | Subtotal 3 | ||||
| kzwi4 | kzwi4 | Subtotal 4 | ||||
| kzwi5 | kzwi5 | Subtotal 5 | ||||
| kzwi6 | kzwi6 | Subtotal 6 | ||||
| stcur | stcur_ap | Exch.Rate stats | ||||
| aedat | aedat | Changed On | ||||
| ean11 | ean11 | EAN/UPC | ||||
| fixmg | fixmg | Fix Qty/Date | ||||
| prctr | prctr | Profit Center | ||||
| mvgr1 | mvgr1 | MaterialGroup 1 | ||||
| mvgr2 | mvgr2 | MaterialGroup 2 | ||||
| mvgr3 | mvgr3 | MaterialGroup 3 | ||||
| mvgr4 | mvgr4 | MaterialGroup 4 | ||||
| mvgr5 | mvgr5 | MaterialGroup 5 | ||||
| kmpmg | kmpmg | Quantity | ||||
| sugrd | sugrd | Reasn | ||||
| sobkz | sobkz | Special Stock | ||||
| vpzuo | vpzuo | Allocation Ind. | ||||
| bob_fg_id | tdd_bob_fg_id | FGID OmniChnl | ||||
| bob_promotion_id | tdd_bob_promotion_id | OmniChnl PromoID | ||||
| paobjnr | rkeobjnr | Profit. segment | ||||
| freeze_paobjnr | sd_freeze_paobjnr | Depdnt Profit. Sgmt | ||||
| ps_psp_pnr | ps_psp_pnr | WBS Element | ||||
| aufnr | aufnr | Order | ||||
| vpmat | vpmat | Plng material | ||||
| vpwrk | vpwrk | Planning Plant | ||||
| prbme | prbme | Prod. grp unit | ||||
| umref | umreff | Conversion | ||||
| knttp | knttp | Acct Assgmt Cat | ||||
| kzvbr | kzvbr | Consumption | ||||
| sernr | sernr | BOM expl.number | ||||
| objnr | objpo | ObjNo Item | ||||
| abgrs | abgr_schl | RA Key | ||||
| bedae | bedae | Reqmts type | ||||
| cmpre | cmpre | Credit Price | ||||
| cmtfg | cmtfg | Partial release | ||||
| cmpnt | cmpnt | Credit Active | ||||
| cmkua | cmkua | Exchange rate | ||||
| cuobj | cuobj_va | Configuration | ||||
| cuobj_ch | cuobj_ch | Int.object no. | ||||
| cepok | cepok | Expected price | ||||
| koupd | koupd | Condit. Update | ||||
| serail | serail | SerialNoProfile | ||||
| anzsn | anzsn | No.serial no. | ||||
| nachl | nachl | No GR posted | ||||
| magrv | magrv | Matl Grp Pckmat | ||||
| mprok | mprok | Manual Price | ||||
| vgtyp | vbtypl_v | Prec.Doc.Categ. | ||||
| prosa | prosa | MatDetermActive | ||||
| uepvw | uepvw | Usage HL Item | ||||
| kalnr | ck_kalnr | Cost EstimateNo | ||||
| klvar | ck_klvar | Costing Variant | ||||
| sposn | sposn | Item | ||||
| kowrr | kowrr | Stat. Value | ||||
| stadat | stadat | Statistics Date | ||||
| exart | exart | Bus.Trans.Type | ||||
| prefe | prefe | Cus. Preference | ||||
| knumh | knumh_ch | NoCondRec.Batch | ||||
| clint | clint | Int class no. | ||||
| chmvs | chmvs | Qty proposal | ||||
| stlty | stlty | BOM category | ||||
| stlkn | stlkn | Item node | ||||
| stpoz | cim_count | Counter | ||||
| stman | cuink | Inconsist. conf | ||||
| zschl_k | aufzschl | Overhead key | ||||
| kalsm_k | aufkalsm | Costing Sheet | ||||
| kalvar | ck_klvar | Costing Variant | ||||
| kosch | kosch | Prod.allocation | ||||
| upmat | upmat | Pr.Ref.Material | ||||
| ukonm | ukonm | MnItem MatPrcGr | ||||
| mfrgr | mfrgr | Mat.Freight Grp | ||||
| plavo | plavo | PlanDelSchedIns | ||||
| discontinue_by | tdd_discontinue_by | Discontinue Based On | ||||
| discontinued_date | discontinued_date | Discontinuation Date | ||||
| discontinued_time | discontinued_time | Discontinuation Time | ||||
| dscont_as_of_qty | tdd_dscont_as_of_qty | Dscontn Quantity | ||||
| dscont_fiscal_year | tdd_dscont_as_of_fy | Fiscal Year | ||||
| dscont_rmng_qty | tdd_dscont_rmng_qty | Remaining Quantity | ||||
| follow_up_item | follow_up_item | Follow-Up Item | ||||
| pick_hu_ind | tdd_pick_hu_ind | Apply HU Pick. Crit. | ||||
| kannr | kannr | Sequence Number | ||||
| cmpre_flt | cmpre_flt | Credit Price | ||||
| abfor | absform_cm | PaytGuarantForm | ||||
| abges | abges_cm | Guaranteed | ||||
| j_1bcfop | j_1bcfop | CFOP | ||||
| j_1btaxlw1 | j_1btaxlw1 | ICMS Law | ||||
| j_1btaxlw2 | j_1btaxlw2 | IPI Law | ||||
| j_1btxsdc | j_1btxsdc_ | Tax Code | ||||
| wktnr | wktnr | Value Contract No. | ||||
| wktps | wktps | Val. Cont.Item | ||||
| skopf | w_sortk | Module | ||||
| kzbws | kzbws | Valuation | ||||
| wgru1 | wgru_hie1 | MatGroup 1 | ||||
| wgru2 | wgru_hie2 | MatGroup 2 | ||||
| knuma_pi | knuma_pi | Promotion | ||||
| knuma_ag | knuma_ag | Sales Deal | ||||
| kzfme | kzfme | Leading UoM | ||||
| lstanr | lstanr | FreeGoods DelyContrl | ||||
| techs | techs | StandardVariant | ||||
| mwsbp | mwsbp | Tax Amount | ||||
| berid | berid | MRP Area | ||||
| pctrf | pctrf | Profit Ctr Bill | ||||
| logsys_ext | logsys | Logical system | ||||
| j_1btaxlw3 | j_1btaxlw3 | ISS Law | ||||
| j_1btaxlw4 | j_1btaxlw4 | COFINS Law | ||||
| j_1btaxlw5 | j_1btaxlw5 | PIS Law | ||||
| stockloc | stockloc | Location | ||||
| sloctype | sloctype | Location Type | ||||
| msr_ret_reason | msr_returns_reason | Return Reason | ||||
| msr_refund_code | msr_returns_refund_code | Refund Code | ||||
| msr_approv_block | msr_approval_block | Approval | ||||
| nrab_knumh | knumh | Cond.Record No. | ||||
| trmrisk_relevant | sls_trm_risk_relevancy | Risk Relevancy | ||||
| sgt_rcat | sgt_rcat | Req. Segment | ||||
| vbkd_posnr | posnr_va | Item | ||||
| veda_posnr | posnr_va | Item | ||||
| ext_ref_item_id | sd_ext_ref_item_id | External Item ID | ||||
| revacc_refid | revacc_refid | Rev.Acc. Ref ID | ||||
| revacc_reftype | revacc_reftype | Rev.Acc. Ref Type | ||||
| _dataaging | data_temperature | Data Aging | ||||
| cmtd_deliv_date | tdd_cmtd_deliv_date | Committed Deliv.Date | ||||
| cmtd_deliv_creadate | tdd_cmtd_deliv_creadate | Cmtd Deliv.Crtn Date | ||||
| cmtd_deliv_qty_su | tdd_cmtd_deliv_qty_su | Cmtd Delivery Qty | ||||
| delivery_date_type_rule | sd_delivery_date_type_rule | Deliv Date Rule | ||||
| reqqty_bu | tdd_reqqty_bu | Requ.SalesOrder Qty. | ||||
| handle | guid_32 | GUID 16 | ||||
| pbs_state | sd_pbs_state | PBS State | ||||
| ifrs15_relevance | ifrs15_relevance | IFRS 15 Relevant | ||||
| ifrs15_total_ssp | ifrs15_total_ssp | SSP | ||||
| revfp | revfp | AvailCheck rule | ||||
| capped_net_amount | capped_net_amount | Net Amount Cap | ||||
| capped_net_amount_alert_thld | capped_net_amount_alert_thld | Cap Notif. Threshold | ||||
| cats_overtime_category | cats_overtime_category | Overtime Category | ||||
| session_creation_date | session_creation_date | Session Created On | ||||
| session_creation_time | session_creation_time | Session Created At | ||||
| original_plant | original_plant | Original Plant | ||||
| atp_abc_substitution_status | atp_abc_substitution_status | Sub. Status | ||||
| transit_plant | transit_plant | Transit Plant | ||||
| sls_contr_auto_assignment | sls_contr_auto_assignment | |||||
| reason_code | sd_item_reason_code | Return/Change Reason | ||||
| TAX_SUBJECT_ST | J_1BTC_TAX_SUBJECT_ST | Possible values | J_1BTC_TAX_SUBJECT_ST | CHAR | 1 | |
| OIC_PBATCH | OIC_PBATCH | OIC_PBATCH | CHAR | 16 | ||
| OIU_MP_NO | CHAR | 20 | ||||
| OIU_WL_NO | CHAR | 15 | ||||
| OIU_WC_NO | CHAR | 5 | ||||
| VBAP | ABFOR | ZIEME | ZIEME | |||
| VBAP | ABFOR | ZIEME | ZIEME | |||
| VBAP | ABGRS | ZIEME | ZIEME | |||
| VBAP | ABGRS | ZIEME | ZIEME | |||
| VBAP | ABGRU | ZIEME | ZIEME | |||
| VBAP | ABGRU | ZIEME | ZIEME | |||
| VBAP | AUFNR | ZIEME | ZIEME | |||
| VBAP | AUFNR | ZIEME | ZIEME | |||
| VBAP | BEDAE | ZIEME | ZIEME | |||
| VBAP | BEDAE | ZIEME | ZIEME | |||
| VBAP | BONUS | ZIEME | ZIEME | |||
| VBAP | BONUS | ZIEME | ZIEME | |||
| VBAP | BPN | ZIEME | ZIEME | |||
| VBAP | BPN | ZIEME | ZIEME | |||
| VBAP | BWTAR | ZIEME | ZIEME | |||
| VBAP | BWTAR | ZIEME | ZIEME | |||
| VBAP | CHARG | ZIEME | ZIEME | |||
| VBAP | CHARG | ZIEME | ZIEME | |||
| VBAP | CHARG | ZIEME | ZIEME | |||
| VBAP | CHARG | ZIEME | ZIEME | |||
| VBAP | CLINT | ZIEME | ZIEME | |||
| VBAP | CLINT | ZIEME | ZIEME | |||
| VBAP | EXART | ZIEME | ZIEME | |||
| VBAP | EXART | ZIEME | ZIEME | |||
| VBAP | EXART | ZIEME | ZIEME | |||
| VBAP | FAKSP | ZIEME | ZIEME | |||
| VBAP | FAKSP | ZIEME | ZIEME | |||
| VBAP | FERC_IND | ZIEME | ZIEME | |||
| VBAP | FERC_IND | ZIEME | ZIEME | |||
| VBAP | GEWEI | ZIEME | ZIEME | |||
| VBAP | GEWEI | ZIEME | ZIEME | |||
| VBAP | GSBER | ZIEME | ZIEME | |||
| VBAP | GSBER | ZIEME | ZIEME | |||
| VBAP | J_1BCFOP | ZIEME | ZIEME | |||
| VBAP | J_1BCFOP | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW1 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW1 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW2 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW2 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW3 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW3 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW4 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW4 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW5 | ZIEME | ZIEME | |||
| VBAP | J_1BTAXLW5 | ZIEME | ZIEME | |||
| VBAP | J_1BTXSDC | ZIEME | ZIEME | |||
| VBAP | J_1BTXSDC | ZIEME | ZIEME | |||
| VBAP | KALSM_K | ZIEME | ZIEME | |||
| VBAP | KALSM_K | ZIEME | ZIEME | |||
| VBAP | KALSM_K | ZIEME | ZIEME | |||
| VBAP | KALSM_K | ZIEME | ZIEME | |||
| VBAP | KALVAR | ZIEME | ZIEME | |||
| VBAP | KALVAR | ZIEME | ZIEME | |||
| VBAP | KMEIN | ZIEME | ZIEME | |||
| VBAP | KMEIN | ZIEME | ZIEME | |||
| VBAP | KNTTP | ZIEME | ZIEME | |||
| VBAP | KNTTP | ZIEME | ZIEME | |||
| VBAP | KNUMA_AG | ZIEME | ZIEME | |||
| VBAP | KNUMA_AG | ZIEME | ZIEME | |||
| VBAP | KNUMA_PI | ZIEME | ZIEME | |||
| VBAP | KNUMA_PI | ZIEME | ZIEME | |||
| VBAP | KONDM | ZIEME | ZIEME | |||
| VBAP | KONDM | ZIEME | ZIEME | |||
| VBAP | KOSCH | ZIEME | ZIEME | |||
| VBAP | KOSCH | ZIEME | ZIEME | |||
| VBAP | KTGRM | ZIEME | ZIEME | |||
| VBAP | KTGRM | ZIEME | ZIEME | |||
| VBAP | LGORT | ZIEME | ZIEME | |||
| VBAP | LGORT | ZIEME | ZIEME | |||
| VBAP | LGORT | ZIEME | ZIEME | |||
| VBAP | LPRIO | ZIEME | ZIEME | |||
| VBAP | LPRIO | ZIEME | ZIEME | |||
| VBAP | MAGRV | ZIEME | ZIEME | |||
| VBAP | MAGRV | ZIEME | ZIEME | |||
| VBAP | MANDT | ZIEME | ZIEME | |||
| VBAP | MATKL | ZIEME | ZIEME | |||
| VBAP | MATKL | ZIEME | ZIEME | |||
| VBAP | MATNR | ZIEME | ZIEME | |||
| VBAP | MATNR | ZIEME | ZIEME | |||
| VBAP | MATWA | ZIEME | ZIEME | |||
| VBAP | MATWA | ZIEME | ZIEME | |||
| VBAP | MEINS | ZIEME | ZIEME | |||
| VBAP | MEINS | ZIEME | ZIEME | |||
| VBAP | MFRGR | ZIEME | ZIEME | |||
| VBAP | MFRGR | ZIEME | ZIEME | |||
| VBAP | MSR_REFUND_CODE | ZIEME | ZIEME | |||
| VBAP | MSR_REFUND_CODE | ZIEME | ZIEME | |||
| VBAP | MSR_RET_REASON | ZIEME | ZIEME | |||
| VBAP | MSR_RET_REASON | ZIEME | ZIEME | |||
| VBAP | MTVFP | ZIEME | ZIEME | |||
| VBAP | MTVFP | ZIEME | ZIEME | |||
| VBAP | MVGR1 | ZIEME | ZIEME | |||
| VBAP | MVGR1 | ZIEME | ZIEME | |||
| VBAP | MVGR2 | ZIEME | ZIEME | |||
| VBAP | MVGR2 | ZIEME | ZIEME | |||
| VBAP | MVGR3 | ZIEME | ZIEME | |||
| VBAP | MVGR3 | ZIEME | ZIEME | |||
| VBAP | MVGR4 | ZIEME | ZIEME | |||
| VBAP | MVGR4 | ZIEME | ZIEME | |||
| VBAP | MVGR5 | ZIEME | ZIEME | |||
| VBAP | MVGR5 | ZIEME | ZIEME | |||
| VBAP | OBJNR | ZIEME | ZIEME | |||
| VBAP | OBJNR | ZIEME | ZIEME | |||
| VBAP | OIBWTAR_EX | ZIEME | ZIEME | |||
| VBAP | OIBWTAR_EX | ZIEME | ZIEME | |||
| VBAP | OIBWTAR_IM | ZIEME | ZIEME | |||
| VBAP | OIBWTAR_IM | ZIEME | ZIEME | |||
| VBAP | OIC_DCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_DCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_DCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_DCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_DCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_DCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_DCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_DCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_DLAND1 | ZIEME | ZIEME | |||
| VBAP | OIC_DLAND1 | ZIEME | ZIEME | |||
| VBAP | OIC_DREGIO | ZIEME | ZIEME | |||
| VBAP | OIC_DREGIO | ZIEME | ZIEME | |||
| VBAP | OIC_DREGIO | ZIEME | ZIEME | |||
| VBAP | OIC_LIFNR | ZIEME | ZIEME | |||
| VBAP | OIC_LIFNR | ZIEME | ZIEME | |||
| VBAP | OIC_MOT | ZIEME | ZIEME | |||
| VBAP | OIC_MOT | ZIEME | ZIEME | |||
| VBAP | OIC_OCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_OCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_OCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_OCITYC | ZIEME | ZIEME | |||
| VBAP | OIC_OCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_OCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_OCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_OCOUNC | ZIEME | ZIEME | |||
| VBAP | OIC_OLAND1 | ZIEME | ZIEME | |||
| VBAP | OIC_OLAND1 | ZIEME | ZIEME | |||
| VBAP | OIC_OREGIO | ZIEME | ZIEME | |||
| VBAP | OIC_OREGIO | ZIEME | ZIEME | |||
| VBAP | OIC_OREGIO | ZIEME | ZIEME | |||
| VBAP | OIDRC | ZIEME | ZIEME | |||
| VBAP | OIDRC | ZIEME | ZIEME | |||
| VBAP | OIEXGTYP | ZIEME | ZIEME | |||
| VBAP | OIEXGTYP | ZIEME | ZIEME | |||
| VBAP | OIHANTYP | ZIEME | ZIEME | |||
| VBAP | OIHANTYP | ZIEME | ZIEME | |||
| VBAP | OIHANTYP_EX | ZIEME | ZIEME | |||
| VBAP | OIHANTYP_EX | ZIEME | ZIEME | |||
| VBAP | OIHANTYP_IM | ZIEME | ZIEME | |||
| VBAP | OIHANTYP_IM | ZIEME | ZIEME | |||
| VBAP | OIH_LCFOL | ZIEME | ZIEME | |||
| VBAP | OIH_LCFOL | ZIEME | ZIEME | |||
| VBAP | OIH_LCFOL | ZIEME | ZIEME | |||
| VBAP | OIH_LCFOL_EX | ZIEME | ZIEME | |||
| VBAP | OIH_LCFOL_EX | ZIEME | ZIEME | |||
| VBAP | OIH_LCFOL_EX | ZIEME | ZIEME | |||
| VBAP | OIH_LICTP | ZIEME | ZIEME | |||
| VBAP | OIH_LICTP | ZIEME | ZIEME | |||
| VBAP | OIH_LICTP_EX | ZIEME | ZIEME | |||
| VBAP | OIH_LICTP_EX | ZIEME | ZIEME | |||
| VBAP | OIINEX | ZIEME | ZIEME | |||
| VBAP | OIINEX | ZIEME | ZIEME | |||
| VBAP | OIINEX_EX | ZIEME | ZIEME | |||
| VBAP | OIINEX_EX | ZIEME | ZIEME | |||
| VBAP | OINETCYC | ZIEME | ZIEME | |||
| VBAP | OINETCYC | ZIEME | ZIEME | |||
| VBAP | OITAXFROM | ZIEME | ZIEME | |||
| VBAP | OITAXFROM | ZIEME | ZIEME | |||
| VBAP | OITAXFROM_EX | ZIEME | ZIEME | |||
| VBAP | OITAXFROM_EX | ZIEME | ZIEME | |||
| VBAP | OITAXFROM_IM | ZIEME | ZIEME | |||
| VBAP | OITAXFROM_IM | ZIEME | ZIEME | |||
| VBAP | OITAXGRP | ZIEME | ZIEME | |||
| VBAP | OITAXGRP | ZIEME | ZIEME | |||
| VBAP | OITAXGRP_EX | ZIEME | ZIEME | |||
| VBAP | OITAXGRP_EX | ZIEME | ZIEME | |||
| VBAP | OITAXGRP_IM | ZIEME | ZIEME | |||
| VBAP | OITAXGRP_IM | ZIEME | ZIEME | |||
| VBAP | OITAXTO | ZIEME | ZIEME | |||
| VBAP | OITAXTO | ZIEME | ZIEME | |||
| VBAP | OITAXTO_EX | ZIEME | ZIEME | |||
| VBAP | OITAXTO_EX | ZIEME | ZIEME | |||
| VBAP | OITAXTO_IM | ZIEME | ZIEME | |||
| VBAP | OITAXTO_IM | ZIEME | ZIEME | |||
| VBAP | PLAVO | ZIEME | ZIEME | |||
| VBAP | PLAVO | ZIEME | ZIEME | |||
| VBAP | PMATN | ZIEME | ZIEME | |||
| VBAP | PMATN | ZIEME | ZIEME | |||
| VBAP | POSNR | ZIEME | ZIEME | |||
| VBAP | POSNR | ZIEME | ZIEME | |||
| VBAP | POSNR | ZIEME | ZIEME | |||
| VBAP | POSNV | ZIEME | ZIEME | |||
| VBAP | POSNV | ZIEME | ZIEME | |||
| VBAP | POSNV | ZIEME | ZIEME | |||
| VBAP | PRBME | ZIEME | ZIEME | |||
| VBAP | PRBME | ZIEME | ZIEME | |||
| VBAP | PRODH | ZIEME | ZIEME | |||
| VBAP | PRODH | ZIEME | ZIEME | |||
| VBAP | PROVG | ZIEME | ZIEME | |||
| VBAP | PROVG | ZIEME | ZIEME | |||
| VBAP | PSTYV | ZIEME | ZIEME | |||
| VBAP | PSTYV | ZIEME | ZIEME | |||
| VBAP | PS_PSP_PNR | ZIEME | ZIEME | |||
| VBAP | PS_PSP_PNR | ZIEME | ZIEME | |||
| VBAP | ROUTE | ZIEME | ZIEME | |||
| VBAP | ROUTE | ZIEME | ZIEME | |||
| VBAP | SERAIL | ZIEME | ZIEME | |||
| VBAP | SERAIL | ZIEME | ZIEME | |||
| VBAP | SERNR | ZIEME | ZIEME | |||
| VBAP | SERNR | ZIEME | ZIEME | |||
| VBAP | SKOPF | ZIEME | ZIEME | |||
| VBAP | SKOPF | ZIEME | ZIEME | |||
| VBAP | SOBKZ | ZIEME | ZIEME | |||
| VBAP | SOBKZ | ZIEME | ZIEME | |||
| VBAP | SPART | ZIEME | ZIEME | |||
| VBAP | SPART | ZIEME | ZIEME | |||
| VBAP | SUGRD | ZIEME | ZIEME | |||
| VBAP | SUGRD | ZIEME | ZIEME | |||
| VBAP | UKONM | ZIEME | ZIEME | |||
| VBAP | UKONM | ZIEME | ZIEME | |||
| VBAP | UPMAT | ZIEME | ZIEME | |||
| VBAP | UPMAT | ZIEME | ZIEME | |||
| VBAP | VBELN | ZIEME | ZIEME | |||
| VBAP | VBELN | ZIEME | ZIEME | |||
| VBAP | VBELV | ZIEME | ZIEME | |||
| VBAP | VBELV | ZIEME | ZIEME | |||
| VBAP | VGBEL | ZIEME | ZIEME | |||
| VBAP | VGBEL | ZIEME | ZIEME | |||
| VBAP | VGPOS | ZIEME | ZIEME | |||
| VBAP | VGPOS | ZIEME | ZIEME | |||
| VBAP | VGPOS | ZIEME | ZIEME | |||
| VBAP | VKAUS | ZIEME | ZIEME | |||
| VBAP | VKAUS | ZIEME | ZIEME | |||
| VBAP | VKGRU | ZIEME | ZIEME | |||
| VBAP | VKGRU | ZIEME | ZIEME | |||
| VBAP | VOLEH | ZIEME | ZIEME | |||
| VBAP | VOLEH | ZIEME | ZIEME | |||
| VBAP | VPMAT | ZIEME | ZIEME | |||
| VBAP | VPMAT | ZIEME | ZIEME | |||
| VBAP | VPWRK | ZIEME | ZIEME | |||
| VBAP | VPWRK | ZIEME | ZIEME | |||
| VBAP | VRKME | ZIEME | ZIEME | |||
| VBAP | VRKME | ZIEME | ZIEME | |||
| VBAP | VSTEL | ZIEME | ZIEME | |||
| VBAP | VSTEL | ZIEME | ZIEME | |||
| VBAP | WAERK | ZIEME | ZIEME | |||
| VBAP | WAERK | ZIEME | ZIEME | |||
| VBAP | WKTNR | ZIEME | ZIEME | |||
| VBAP | WKTNR | ZIEME | ZIEME | |||
| VBAP | WKTPS | ZIEME | ZIEME | |||
| VBAP | WKTPS | ZIEME | ZIEME | |||
| VBAP | WKTPS | ZIEME | ZIEME | |||
| VBAP | ZIEME | ZIEME | ZIEME | |||
| VBAP | ZIEME | ZIEME | ZIEME |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Sales Document: Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBAP (
MANDT, -- Client [mandt]
VBELN, -- Sales Document [vbeln_va]
POSNR, -- Item [posnr_va]
ITEM_UUID, -- sd_sls_item_uuid
MATNR, -- Material [matnr]
MATWA, -- MaterialEntered [matwa]
PMATN, -- Pr. Ref. Matl [pmatn]
CHARG, -- Batch [charg_d]
MATKL, -- Material Group [matkl]
ARKTX, -- Item Descr. [arktx]
PSTYV, -- Item Category [pstyv]
POSAR, -- Item Type [posar]
PROCESS_CODE, -- Processing Code [tdd_item_process_code]
DWN_PAYT_PROCG_VAR, -- sdbil_dwn_payt_procg_var
LFREL, -- Item Del.f.Dlv. [lfrel_ap]
FKREL, -- Relev.for Bill. [fkrel]
UEPOS, -- Higher-Lev.Item [uepos]
GRPOS, -- Altern. to Item [grpos]
ABGRU, -- RejectionReason [abgru_va]
PRODH_UNIV_ID_VAL_CONTR, -- Product Hierarchy [prod_hier_id]
PRODH_UNIV_NODE_VAL_CONTR, -- Node [prod_hier_node_value]
PRODH, -- Prod. Hierarchy [prodh_d]
ZWERT, -- Target Value [dzwert]
ZMENG, -- Target Quantity [dzmeng]
ZIEME, -- Target Qty UoM [dzieme]
UMZIZ, -- Convers.Factor [umziz]
UMZIN, -- Convers.Factor [umzin]
MEINS, -- Base Unit [meins]
SUBSTN_NUMERATOR, -- Numerator for Conversion [md_substn_numerator]
SUBSTN_DENOMINATOR, -- Denominator for Conversion [md_substn_denominator]
SMENG, -- Scale Quantity [smeng]
ABLFZ, -- Rounding qty [ablfz]
ABDAT, -- Recon.Date [abdat]
ABSFZ, -- Absolute deviation [absfz]
POSEX, -- PO Item [posex]
KDMAT, -- Cust. Material [matnr_ku]
KBVER, -- % deviation [kbver]
KEVER, -- Dev. days [kever]
VKGRU, -- Class. of Items [vkgru]
VKAUS, -- Usage [abrvw]
GRKOR, -- Delivery Group [grkor]
FMENG, -- Qty. is fixed [fmeng]
UEBTK, -- Unlimited Tol. [uebtk_v]
UEBTO, -- Overdeliv. Tol. [uebto]
UNTTO, -- Underdel. Tol. [untto]
FAKSP, -- Billing Block [faksp_ap]
ATPKZ, -- Replacemt Part [atpkz]
RKFKF, -- Bill.meth.CO/PPC [rkfkf]
SPART, -- Division [spart]
GSBER, -- Business Area [gsber]
NETWR, -- Net Value [netwr_ap]
WAERK, -- Doc. Currency [waerk]
ANTLF, -- Max.Part.Deliv. [antlf]
KZTLF, -- Part.dlv./item [kztlf]
RESOURCE_ID, -- Resource Name [nsdm_resourcename_sid]
CHSPL, -- Batch split [chspl]
KWMENG, -- Order quantity [kwmeng]
LSMENG, -- Required DlvQty [lsmeng]
KBMENG, -- CumltvConfdQty [kbmeng]
KLMENG, -- CumltvConfdQty [klmeng]
VRKME, -- Sales Unit [vrkme]
UMVKZ, -- Numerator [umvkz]
UMVKN, -- Denominat. [umvkn]
BRGEW, -- Gross Weight [brgew_ap]
NTGEW, -- Net Weight [ntgew_ap]
GEWEI, -- Unit of Weight [gewei]
VOLUM, -- Volume [volum_ap]
VOLEH, -- Volume Unit [voleh]
VBELV, -- Originating Doc [vbelv]
POSNV, -- Origin. Item [posnv]
VGBEL, -- Reference Doc. [vgbel]
VGPOS, -- Reference Item [vgpos]
VOREF, -- Complete Refer. [voref]
UPFLU, -- Update Doc.Flow [upflv]
ERLRE, -- Completion Rule [erlre]
LPRIO, -- Delivery Prior. [lprio]
WERKS, -- Plant [werks_ext]
LGORT, -- Location [lgort_d]
VSTEL, -- Shipping Point [vstel]
ROUTE, -- Route [route]
STKEY, -- BOM origin [stkey]
STDAT, -- BOM Key Date [stdat]
STLNR, -- BOM [stnum]
STPOS, -- BOM Item Number [stpos_vbap]
AWAHR, -- Order Probab. [awahr]
ERDAT, -- Created On [erdat]
ERNAM, -- Created By [ernam]
ERZET, -- Time [erzet]
TAXM1, -- Tax Classific. [taxmt]
TAXM2, -- Tax Classific. [taxmt]
TAXM3, -- Tax Classific. [taxmt]
TAXM4, -- Tax Classific. [taxmt]
TAXM5, -- Tax Classific. [taxmt]
TAXM6, -- Tax Classific. [taxmt]
TAXM7, -- Tax Classific. [taxmt]
TAXM8, -- Tax Classific. [taxmt]
TAXM9, -- Tax Classific. [taxmt]
VBEAF, -- Fixed proc.time [vbeaf]
VBEAV, -- Var. proc. time [vbeav]
VGREF, -- Preced. with ref. [vgref]
NETPR, -- Net Price [netpr]
KPEIN, -- Pricing Unit [kpein]
KMEIN, -- Unit of Measure [kmein]
SHKZG, -- Returns [shkzg_va]
SKTOF, -- Cash Discount [sktof]
MTVFP, -- Avail. check [mtvfp]
SUMBD, -- Req'mt totals. [sumbd]
KONDM, -- Mat. Price Grp [kondm]
KTGRM, -- AcctAssmtGrpMat [ktgrm]
BONUS, -- Vol. Rebate Grp [bonus]
PROVG, -- Commission Grp [provg]
EANNR, -- EAN Number [eannr]
PRSOK, -- Pricing [prsok]
BWTAR, -- Valuation Type [bwtar_d]
BWTEX, -- Separate val. [bwtex]
XCHPF, -- Batch Mgmt Rqt [xchpf]
XCHAR, -- Batches [xchar]
BATCH_BILLING_VARIANT, -- BatchItmBillVar [sdbil_batch_billing_variant]
LFMNG, -- Min. Dely Qty [minlf]
STAFO, -- Update Group [stafo]
WAVWR, -- Cost [wavwr]
KZWI1, -- Subtotal 1 [kzwi1]
KZWI2, -- Subtotal 2 [kzwi2]
KZWI3, -- Subtotal 3 [kzwi3]
KZWI4, -- Subtotal 4 [kzwi4]
KZWI5, -- Subtotal 5 [kzwi5]
KZWI6, -- Subtotal 6 [kzwi6]
STCUR, -- Exch.Rate stats [stcur_ap]
AEDAT, -- Changed On [aedat]
EAN11, -- EAN/UPC [ean11]
FIXMG, -- Fix Qty/Date [fixmg]
PRCTR, -- Profit Center [prctr]
MVGR1, -- MaterialGroup 1 [mvgr1]
MVGR2, -- MaterialGroup 2 [mvgr2]
MVGR3, -- MaterialGroup 3 [mvgr3]
MVGR4, -- MaterialGroup 4 [mvgr4]
MVGR5, -- MaterialGroup 5 [mvgr5]
KMPMG, -- Quantity [kmpmg]
SUGRD, -- Reasn [sugrd]
SOBKZ, -- Special Stock [sobkz]
VPZUO, -- Allocation Ind. [vpzuo]
BOB_FG_ID, -- FGID OmniChnl [tdd_bob_fg_id]
BOB_PROMOTION_ID, -- OmniChnl PromoID [tdd_bob_promotion_id]
PAOBJNR, -- Profit. segment [rkeobjnr]
FREEZE_PAOBJNR, -- Depdnt Profit. Sgmt [sd_freeze_paobjnr]
PS_PSP_PNR, -- WBS Element [ps_psp_pnr]
AUFNR, -- Order [aufnr]
VPMAT, -- Plng material [vpmat]
VPWRK, -- Planning Plant [vpwrk]
PRBME, -- Prod. grp unit [prbme]
UMREF, -- Conversion [umreff]
KNTTP, -- Acct Assgmt Cat [knttp]
KZVBR, -- Consumption [kzvbr]
SERNR, -- BOM expl.number [sernr]
OBJNR, -- ObjNo Item [objpo]
ABGRS, -- RA Key [abgr_schl]
BEDAE, -- Reqmts type [bedae]
CMPRE, -- Credit Price [cmpre]
CMTFG, -- Partial release [cmtfg]
CMPNT, -- Credit Active [cmpnt]
CMKUA, -- Exchange rate [cmkua]
CUOBJ, -- Configuration [cuobj_va]
CUOBJ_CH, -- Int.object no. [cuobj_ch]
CEPOK, -- Expected price [cepok]
KOUPD, -- Condit. Update [koupd]
SERAIL, -- SerialNoProfile [serail]
ANZSN, -- No.serial no. [anzsn]
NACHL, -- No GR posted [nachl]
MAGRV, -- Matl Grp Pckmat [magrv]
MPROK, -- Manual Price [mprok]
VGTYP, -- Prec.Doc.Categ. [vbtypl_v]
PROSA, -- MatDetermActive [prosa]
UEPVW, -- Usage HL Item [uepvw]
KALNR, -- Cost EstimateNo [ck_kalnr]
KLVAR, -- Costing Variant [ck_klvar]
SPOSN, -- Item [sposn]
KOWRR, -- Stat. Value [kowrr]
STADAT, -- Statistics Date [stadat]
EXART, -- Bus.Trans.Type [exart]
PREFE, -- Cus. Preference [prefe]
KNUMH, -- NoCondRec.Batch [knumh_ch]
CLINT, -- Int class no. [clint]
CHMVS, -- Qty proposal [chmvs]
STLTY, -- BOM category [stlty]
STLKN, -- Item node [stlkn]
STPOZ, -- Counter [cim_count]
STMAN, -- Inconsist. conf [cuink]
ZSCHL_K, -- Overhead key [aufzschl]
KALSM_K, -- Costing Sheet [aufkalsm]
KALVAR, -- Costing Variant [ck_klvar]
KOSCH, -- Prod.allocation [kosch]
UPMAT, -- Pr.Ref.Material [upmat]
UKONM, -- MnItem MatPrcGr [ukonm]
MFRGR, -- Mat.Freight Grp [mfrgr]
PLAVO, -- PlanDelSchedIns [plavo]
DISCONTINUE_BY, -- Discontinue Based On [tdd_discontinue_by]
DISCONTINUED_DATE, -- Discontinuation Date [discontinued_date]
DISCONTINUED_TIME, -- Discontinuation Time [discontinued_time]
DSCONT_AS_OF_QTY, -- Dscontn Quantity [tdd_dscont_as_of_qty]
DSCONT_FISCAL_YEAR, -- Fiscal Year [tdd_dscont_as_of_fy]
DSCONT_RMNG_QTY, -- Remaining Quantity [tdd_dscont_rmng_qty]
FOLLOW_UP_ITEM, -- Follow-Up Item [follow_up_item]
PICK_HU_IND, -- Apply HU Pick. Crit. [tdd_pick_hu_ind]
KANNR, -- Sequence Number [kannr]
CMPRE_FLT, -- Credit Price [cmpre_flt]
ABFOR, -- PaytGuarantForm [absform_cm]
ABGES, -- Guaranteed [abges_cm]
J_1BCFOP, -- CFOP [j_1bcfop]
J_1BTAXLW1, -- ICMS Law [j_1btaxlw1]
J_1BTAXLW2, -- IPI Law [j_1btaxlw2]
J_1BTXSDC, -- Tax Code [j_1btxsdc_]
WKTNR, -- Value Contract No. [wktnr]
WKTPS, -- Val. Cont.Item [wktps]
SKOPF, -- Module [w_sortk]
KZBWS, -- Valuation [kzbws]
WGRU1, -- MatGroup 1 [wgru_hie1]
WGRU2, -- MatGroup 2 [wgru_hie2]
KNUMA_PI, -- Promotion [knuma_pi]
KNUMA_AG, -- Sales Deal [knuma_ag]
KZFME, -- Leading UoM [kzfme]
LSTANR, -- FreeGoods DelyContrl [lstanr]
TECHS, -- StandardVariant [techs]
MWSBP, -- Tax Amount [mwsbp]
BERID, -- MRP Area [berid]
PCTRF, -- Profit Ctr Bill [pctrf]
LOGSYS_EXT, -- Logical system [logsys]
J_1BTAXLW3, -- ISS Law [j_1btaxlw3]
J_1BTAXLW4, -- COFINS Law [j_1btaxlw4]
J_1BTAXLW5, -- PIS Law [j_1btaxlw5]
STOCKLOC, -- Location [stockloc]
SLOCTYPE, -- Location Type [sloctype]
MSR_RET_REASON, -- Return Reason [msr_returns_reason]
MSR_REFUND_CODE, -- Refund Code [msr_returns_refund_code]
MSR_APPROV_BLOCK, -- Approval [msr_approval_block]
NRAB_KNUMH, -- Cond.Record No. [knumh]
TRMRISK_RELEVANT, -- Risk Relevancy [sls_trm_risk_relevancy]
SGT_RCAT, -- Req. Segment [sgt_rcat]
VBKD_POSNR, -- Item [posnr_va]
VEDA_POSNR, -- Item [posnr_va]
EXT_REF_ITEM_ID, -- External Item ID [sd_ext_ref_item_id]
REVACC_REFID, -- Rev.Acc. Ref ID [revacc_refid]
REVACC_REFTYPE, -- Rev.Acc. Ref Type [revacc_reftype]
_DATAAGING, -- Data Aging [data_temperature]
CMTD_DELIV_DATE, -- Committed Deliv.Date [tdd_cmtd_deliv_date]
CMTD_DELIV_CREADATE, -- Cmtd Deliv.Crtn Date [tdd_cmtd_deliv_creadate]
CMTD_DELIV_QTY_SU, -- Cmtd Delivery Qty [tdd_cmtd_deliv_qty_su]
DELIVERY_DATE_TYPE_RULE, -- Deliv Date Rule [sd_delivery_date_type_rule]
REQQTY_BU, -- Requ.SalesOrder Qty. [tdd_reqqty_bu]
HANDLE, -- GUID 16 [guid_32]
PBS_STATE, -- PBS State [sd_pbs_state]
IFRS15_RELEVANCE, -- IFRS 15 Relevant [ifrs15_relevance]
IFRS15_TOTAL_SSP, -- SSP [ifrs15_total_ssp]
REVFP, -- AvailCheck rule [revfp]
CAPPED_NET_AMOUNT, -- Net Amount Cap [capped_net_amount]
CAPPED_NET_AMOUNT_ALERT_THLD, -- Cap Notif. Threshold [capped_net_amount_alert_thld]
CATS_OVERTIME_CATEGORY, -- Overtime Category [cats_overtime_category]
SESSION_CREATION_DATE, -- Session Created On [session_creation_date]
SESSION_CREATION_TIME, -- Session Created At [session_creation_time]
ORIGINAL_PLANT, -- Original Plant [original_plant]
ATP_ABC_SUBSTITUTION_STATUS, -- Sub. Status [atp_abc_substitution_status]
TRANSIT_PLANT, -- Transit Plant [transit_plant]
SLS_CONTR_AUTO_ASSIGNMENT, -- sls_contr_auto_assignment
REASON_CODE, -- Return/Change Reason [sd_item_reason_code]
TAX_SUBJECT_ST CHAR(1), -- Possible values [J_1BTC_TAX_SUBJECT_ST]
OIC_PBATCH CHAR(16), -- OIC_PBATCH
OIU_MP_NO CHAR(20),
OIU_WL_NO CHAR(15),
OIU_WC_NO CHAR(5),
VBAP ZIEME, -- ABFOR
VBAP ZIEME, -- ABFOR
VBAP ZIEME, -- ABGRS
VBAP ZIEME, -- ABGRS
VBAP ZIEME, -- ABGRU
VBAP ZIEME, -- ABGRU
VBAP ZIEME, -- AUFNR
VBAP ZIEME, -- AUFNR
VBAP ZIEME, -- BEDAE
VBAP ZIEME, -- BEDAE
VBAP ZIEME, -- BONUS
VBAP ZIEME, -- BONUS
VBAP ZIEME, -- BPN
VBAP ZIEME, -- BPN
VBAP ZIEME, -- BWTAR
VBAP ZIEME, -- BWTAR
VBAP ZIEME, -- CHARG
VBAP ZIEME, -- CHARG
VBAP ZIEME, -- CHARG
VBAP ZIEME, -- CHARG
VBAP ZIEME, -- CLINT
VBAP ZIEME, -- CLINT
VBAP ZIEME, -- EXART
VBAP ZIEME, -- EXART
VBAP ZIEME, -- EXART
VBAP ZIEME, -- FAKSP
VBAP ZIEME, -- FAKSP
VBAP ZIEME, -- FERC_IND
VBAP ZIEME, -- FERC_IND
VBAP ZIEME, -- GEWEI
VBAP ZIEME, -- GEWEI
VBAP ZIEME, -- GSBER
VBAP ZIEME, -- GSBER
VBAP ZIEME, -- J_1BCFOP
VBAP ZIEME, -- J_1BCFOP
VBAP ZIEME, -- J_1BTAXLW1
VBAP ZIEME, -- J_1BTAXLW1
VBAP ZIEME, -- J_1BTAXLW2
VBAP ZIEME, -- J_1BTAXLW2
VBAP ZIEME, -- J_1BTAXLW3
VBAP ZIEME, -- J_1BTAXLW3
VBAP ZIEME, -- J_1BTAXLW4
VBAP ZIEME, -- J_1BTAXLW4
VBAP ZIEME, -- J_1BTAXLW5
VBAP ZIEME, -- J_1BTAXLW5
VBAP ZIEME, -- J_1BTXSDC
VBAP ZIEME, -- J_1BTXSDC
VBAP ZIEME, -- KALSM_K
VBAP ZIEME, -- KALSM_K
VBAP ZIEME, -- KALSM_K
VBAP ZIEME, -- KALSM_K
VBAP ZIEME, -- KALVAR
VBAP ZIEME, -- KALVAR
VBAP ZIEME, -- KMEIN
VBAP ZIEME, -- KMEIN
VBAP ZIEME, -- KNTTP
VBAP ZIEME, -- KNTTP
VBAP ZIEME, -- KNUMA_AG
VBAP ZIEME, -- KNUMA_AG
VBAP ZIEME, -- KNUMA_PI
VBAP ZIEME, -- KNUMA_PI
VBAP ZIEME, -- KONDM
VBAP ZIEME, -- KONDM
VBAP ZIEME, -- KOSCH
VBAP ZIEME, -- KOSCH
VBAP ZIEME, -- KTGRM
VBAP ZIEME, -- KTGRM
VBAP ZIEME, -- LGORT
VBAP ZIEME, -- LGORT
VBAP ZIEME, -- LGORT
VBAP ZIEME, -- LPRIO
VBAP ZIEME, -- LPRIO
VBAP ZIEME, -- MAGRV
VBAP ZIEME, -- MAGRV
VBAP ZIEME, -- MANDT
VBAP ZIEME, -- MATKL
VBAP ZIEME, -- MATKL
VBAP ZIEME, -- MATNR
VBAP ZIEME, -- MATNR
VBAP ZIEME, -- MATWA
VBAP ZIEME, -- MATWA
VBAP ZIEME, -- MEINS
VBAP ZIEME, -- MEINS
VBAP ZIEME, -- MFRGR
VBAP ZIEME, -- MFRGR
VBAP ZIEME, -- MSR_REFUND_CODE
VBAP ZIEME, -- MSR_REFUND_CODE
VBAP ZIEME, -- MSR_RET_REASON
VBAP ZIEME, -- MSR_RET_REASON
VBAP ZIEME, -- MTVFP
VBAP ZIEME, -- MTVFP
VBAP ZIEME, -- MVGR1
VBAP ZIEME, -- MVGR1
VBAP ZIEME, -- MVGR2
VBAP ZIEME, -- MVGR2
VBAP ZIEME, -- MVGR3
VBAP ZIEME, -- MVGR3
VBAP ZIEME, -- MVGR4
VBAP ZIEME, -- MVGR4
VBAP ZIEME, -- MVGR5
VBAP ZIEME, -- MVGR5
VBAP ZIEME, -- OBJNR
VBAP ZIEME, -- OBJNR
VBAP ZIEME, -- OIBWTAR_EX
VBAP ZIEME, -- OIBWTAR_EX
VBAP ZIEME, -- OIBWTAR_IM
VBAP ZIEME, -- OIBWTAR_IM
VBAP ZIEME, -- OIC_DCITYC
VBAP ZIEME, -- OIC_DCITYC
VBAP ZIEME, -- OIC_DCITYC
VBAP ZIEME, -- OIC_DCITYC
VBAP ZIEME, -- OIC_DCOUNC
VBAP ZIEME, -- OIC_DCOUNC
VBAP ZIEME, -- OIC_DCOUNC
VBAP ZIEME, -- OIC_DCOUNC
VBAP ZIEME, -- OIC_DLAND1
VBAP ZIEME, -- OIC_DLAND1
VBAP ZIEME, -- OIC_DREGIO
VBAP ZIEME, -- OIC_DREGIO
VBAP ZIEME, -- OIC_DREGIO
VBAP ZIEME, -- OIC_LIFNR
VBAP ZIEME, -- OIC_LIFNR
VBAP ZIEME, -- OIC_MOT
VBAP ZIEME, -- OIC_MOT
VBAP ZIEME, -- OIC_OCITYC
VBAP ZIEME, -- OIC_OCITYC
VBAP ZIEME, -- OIC_OCITYC
VBAP ZIEME, -- OIC_OCITYC
VBAP ZIEME, -- OIC_OCOUNC
VBAP ZIEME, -- OIC_OCOUNC
VBAP ZIEME, -- OIC_OCOUNC
VBAP ZIEME, -- OIC_OCOUNC
VBAP ZIEME, -- OIC_OLAND1
VBAP ZIEME, -- OIC_OLAND1
VBAP ZIEME, -- OIC_OREGIO
VBAP ZIEME, -- OIC_OREGIO
VBAP ZIEME, -- OIC_OREGIO
VBAP ZIEME, -- OIDRC
VBAP ZIEME, -- OIDRC
VBAP ZIEME, -- OIEXGTYP
VBAP ZIEME, -- OIEXGTYP
VBAP ZIEME, -- OIHANTYP
VBAP ZIEME, -- OIHANTYP
VBAP ZIEME, -- OIHANTYP_EX
VBAP ZIEME, -- OIHANTYP_EX
VBAP ZIEME, -- OIHANTYP_IM
VBAP ZIEME, -- OIHANTYP_IM
VBAP ZIEME, -- OIH_LCFOL
VBAP ZIEME, -- OIH_LCFOL
VBAP ZIEME, -- OIH_LCFOL
VBAP ZIEME, -- OIH_LCFOL_EX
VBAP ZIEME, -- OIH_LCFOL_EX
VBAP ZIEME, -- OIH_LCFOL_EX
VBAP ZIEME, -- OIH_LICTP
VBAP ZIEME, -- OIH_LICTP
VBAP ZIEME, -- OIH_LICTP_EX
VBAP ZIEME, -- OIH_LICTP_EX
VBAP ZIEME, -- OIINEX
VBAP ZIEME, -- OIINEX
VBAP ZIEME, -- OIINEX_EX
VBAP ZIEME, -- OIINEX_EX
VBAP ZIEME, -- OINETCYC
VBAP ZIEME, -- OINETCYC
VBAP ZIEME, -- OITAXFROM
VBAP ZIEME, -- OITAXFROM
VBAP ZIEME, -- OITAXFROM_EX
VBAP ZIEME, -- OITAXFROM_EX
VBAP ZIEME, -- OITAXFROM_IM
VBAP ZIEME, -- OITAXFROM_IM
VBAP ZIEME, -- OITAXGRP
VBAP ZIEME, -- OITAXGRP
VBAP ZIEME, -- OITAXGRP_EX
VBAP ZIEME, -- OITAXGRP_EX
VBAP ZIEME, -- OITAXGRP_IM
VBAP ZIEME, -- OITAXGRP_IM
VBAP ZIEME, -- OITAXTO
VBAP ZIEME, -- OITAXTO
VBAP ZIEME, -- OITAXTO_EX
VBAP ZIEME, -- OITAXTO_EX
VBAP ZIEME, -- OITAXTO_IM
VBAP ZIEME, -- OITAXTO_IM
VBAP ZIEME, -- PLAVO
VBAP ZIEME, -- PLAVO
VBAP ZIEME, -- PMATN
VBAP ZIEME, -- PMATN
VBAP ZIEME, -- POSNR
VBAP ZIEME, -- POSNR
VBAP ZIEME, -- POSNR
VBAP ZIEME, -- POSNV
VBAP ZIEME, -- POSNV
VBAP ZIEME, -- POSNV
VBAP ZIEME, -- PRBME
VBAP ZIEME, -- PRBME
VBAP ZIEME, -- PRODH
VBAP ZIEME, -- PRODH
VBAP ZIEME, -- PROVG
VBAP ZIEME, -- PROVG
VBAP ZIEME, -- PSTYV
VBAP ZIEME, -- PSTYV
VBAP ZIEME, -- PS_PSP_PNR
VBAP ZIEME, -- PS_PSP_PNR
VBAP ZIEME, -- ROUTE
VBAP ZIEME, -- ROUTE
VBAP ZIEME, -- SERAIL
VBAP ZIEME, -- SERAIL
VBAP ZIEME, -- SERNR
VBAP ZIEME, -- SERNR
VBAP ZIEME, -- SKOPF
VBAP ZIEME, -- SKOPF
VBAP ZIEME, -- SOBKZ
VBAP ZIEME, -- SOBKZ
VBAP ZIEME, -- SPART
VBAP ZIEME, -- SPART
VBAP ZIEME, -- SUGRD
VBAP ZIEME, -- SUGRD
VBAP ZIEME, -- UKONM
VBAP ZIEME, -- UKONM
VBAP ZIEME, -- UPMAT
VBAP ZIEME, -- UPMAT
VBAP ZIEME, -- VBELN
VBAP ZIEME, -- VBELN
VBAP ZIEME, -- VBELV
VBAP ZIEME, -- VBELV
VBAP ZIEME, -- VGBEL
VBAP ZIEME, -- VGBEL
VBAP ZIEME, -- VGPOS
VBAP ZIEME, -- VGPOS
VBAP ZIEME, -- VGPOS
VBAP ZIEME, -- VKAUS
VBAP ZIEME, -- VKAUS
VBAP ZIEME, -- VKGRU
VBAP ZIEME, -- VKGRU
VBAP ZIEME, -- VOLEH
VBAP ZIEME, -- VOLEH
VBAP ZIEME, -- VPMAT
VBAP ZIEME, -- VPMAT
VBAP ZIEME, -- VPWRK
VBAP ZIEME, -- VPWRK
VBAP ZIEME, -- VRKME
VBAP ZIEME, -- VRKME
VBAP ZIEME, -- VSTEL
VBAP ZIEME, -- VSTEL
VBAP ZIEME, -- WAERK
VBAP ZIEME, -- WAERK
VBAP ZIEME, -- WKTNR
VBAP ZIEME, -- WKTNR
VBAP ZIEME, -- WKTPS
VBAP ZIEME, -- WKTPS
VBAP ZIEME, -- WKTPS
VBAP ZIEME, -- ZIEME
VBAP ZIEME, -- ZIEME
PRIMARY KEY (MANDT, VBELN, POSNR)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA