VBAK
Sales Document: Header Data
VBAK is an SAP database table in S/4HANA. Sales Document: Header Data. It contains 301 fields. 79 CDS views read from this table.
CDS Views using this table (79)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /sapapo/v_tdl_sales_order | view | from | SAPAPO TDL: Sales Order | |
| arun_i_so_arun_check | view | from | Select SalesOrder Items for ARun Article | |
| arun_i_so_reqmt | view | from | Sales Order selection in Normal mode | |
| ARUN_I_SO_REQMT_PREV | view | from | Sales Order selection from Preview table | |
| Arun_Reqsrt_Sd | view | from | Requirement sorting - SD | |
| ARUN_SD_DB | view | from | Sales document data | |
| Arun_So_Reqmt | view | left_outer | Sales Order Requirement | |
| ARun_ValAddedSrvcSDItmBsc | view | from | ||
| ARun_ValAddedSrvcSDServices | view | inner | ||
| Atpc_Cds_Vbep | view | left_outer | CDS View on VBEP Table for ATP BOP | |
| E_SalesDocumentBasic | view_entity | from | EXTENSION | Extension view for VBAK |
| EWA_ALY_I_CRV | view | from | ||
| EWA_ALY_I_CRV | view | union | ||
| F3_Mmim_Sorder_Vh | view | from | Help-View Sales Order (VBAK) | |
| Fcdm_Keyfigures_Read_Custrq | view | from | Read Customer Requirements for Forecast Demand Keyfigures | |
| FINOC_RT_SOI_MONTHS | view | inner | Orgl Chg: Sales Doc Crte Dt Plus Months | |
| finoc_rule_soi_base | view | from | Orgl Change-Rule: Sales Order Item Base | |
| FINOC_RULE_SOX_BASE | view | from | Organizational Changes: Base Rle IC SOI | |
| fins_prctr_of_object_acdoca | view | left_outer | Derive PRCTR & PPRCTR for ACDOCA object | |
| fins_rev_rec_sd_status | view | inner | Status of sales order/return/contract items | |
| Fins_Trr_Acc_Ass_Obj_all | view | inner | Account Assignment Object | |
| Fins_Trr_Acc_Ass_Obj_prps | view | left_outer | Account Assignment Object | |
| FINS_TRR_ACC_ASS_OBJ_VBAK | view | inner | Account Assignment Object | |
| Fins_Trr_Acc_Ass_Obj_vbap | view | inner | Account Assignment Object | |
| I_ARunMntrItemSD | view | inner | BASIC | Basic View for Item data of SD document in ARun Monitor Runs |
| I_ARunOvwSDItem | view | inner | BASIC | Basic View for Sales Document Item |
| I_ARunPrioritySlsOrdBasic | view | inner | BASIC | Base View for ARun Priority in SOs |
| I_ARunSalesOrderItem | view | from | BASIC | ARun relevant Sales Document Item |
| I_DigitalVehSalesDocConfig | view_entity | inner | BASIC | Digital Vehicle SalesDoc Configuration |
| I_ExcessRqmtQtyFashionSlsContr | view | from | BASIC | Fashion Sales Contract Documents |
| I_NominationDocNumberVH | view | inner | BASIC | Nomination Document Number |
| I_RFM_SalesDocument | view | from | BASIC | Sales Document Basic |
| I_RO_SAFTOrderReference | view | inner | BASIC | RO SAFT Order Reference |
| I_SalesDocumentBasic | view | from | BASIC | Sales Document Basic |
| I_SlsOrdRelevanceForTranspMgmt | view | from | BASIC | Sales Order Relevance for Transport Management |
| I_SupDmndAllDocRetSlsOrd | view | from | BASIC | View for Return Sales Orders |
| I_SupDmndOvwItemSD | view | from | BASIC | Basic View for Sales Document Item |
| I_TripSalesContractVH | view | from | BASIC | Value Help for Sales Contract |
| Mbv_Ebew_Vbak | view | inner | Compatibility view for V_EBEW_VBAK view (ML integration) | |
| Mbv_V_Ebew_Vbak | view | inner | Compatibility view for V_EBEW_VBAK view (ML integration) | |
| P_CmmdtyPrcFixationExerciseSls | view | inner | BASIC | |
| P_CmmdtyPrcFixationExerSlsNew | view_entity | inner | COMPOSITE | |
| P_CmmdtyPrcFixationOptionSales | view | inner | BASIC | |
| P_CmmdtyPrcFixationOptnSlsNew | view_entity | inner | COMPOSITE | |
| P_CustomerOrder | view | inner | BASIC | |
| P_Fcdm_Keyf_Read_Custrq_Sls | view | from | BASIC | |
| P_HUPSchedgAgrmt | view_entity | inner | BASIC | Scheduling Agreement Item details 4 HUP |
| P_ONRVB | view | inner | BASIC | |
| P_PrcFixationOptionBsHndlgSls | view | inner | BASIC | |
| P_PrcFixationOptionCnvrsnSls | view | inner | BASIC | |
| P_PrcFixationOptnCnvrsnSlsNew | view_entity | inner | COMPOSITE | |
| P_PrcSttgMethExecutionAnalysis | view | left_outer | BASIC | |
| P_PrFixationOptnBsHndlgSlsNew | view_entity | inner | COMPOSITE | |
| P_Salesdcmnt | view | from | BASIC | |
| P_SupDmndAllDocSDRqmtType | view | from | BASIC | |
| P_SupDmndOvwSDDateBasic | view | from | BASIC | |
| P_Trrsochartbase | view | inner | COMPOSITE | |
| P_VarConfignSalesDocument | view | from | BASIC | |
| rfm_psst_so_redet | view | from | PSST - SO redetermination | |
| RFM_SalesDocumentItemBasic | view | from | ||
| rfm_scc_salesdata_basic_V | view | from | Salesdata basic view | |
| RFM_SD_SEASONS_BASIC_VIEW | view | from | RFM Sales Document Seasons Basic View | |
| SHSM_F4_POSNR_VBAP | view | from | CDS view replacing VBAP in F4_POSNR_VBAP | |
| SHSM_F4_VBAK | view | from | CDS view replacing VBAK in search help F4_VBAK | |
| SHSM_FSH_VA_SEA_F4 | view | from | CDS replacing replacing FSH_VA_SEA_F4 | |
| SHSM_SGT_VMVA | view | from | CDS view replacing VBAP in SGT_VMVA | |
| SHSM_VF_O | view | from | CDS view replacing SHVF_O | |
| SHSM_VMVAA | view | from | CDS view replacing M_VMVAA in search help VMVAA | |
| SHSM_VMVAB | view | from | CDS view replacing V_VMVAB in search help VMVAB | |
| SHSM_VMVAC | view | from | CDS View replacing V_VMVAC in search help VMVAC | |
| SHSM_VMVAD | view | from | CDS view replacing V_VMVAD in search help VMVAD | |
| SHSM_VMVAF | view | from | CDS View replacing V_VMVAF in search help VMVAF | |
| SHSM_VMVAH | view | from | CDS view replacing V_VMVAH in search help VMVAH | |
| SHSM_VMVAM | view | from | CDS view replacing V_VMVAM in search help VMVAM | |
| SHSM_WRF_SALES_MAT_CHAR | view | from | CDS replacing VBAP in WRF_SALES_MAT_CHAR | |
| V_DOC_CURR | view | inner | Document Currency | |
| v_vapma | view | from | ||
| V_VBUK_S4 | view | from | Vbuk Cds View | |
| VC_INTEGRATION_VBAK | view | from | Extraction for VBAK |
Fields (301)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | vbeln | vbeln_va | Sales Document | |||
| erdat | erdat | Created On | ||||
| erzet | erzet | Time | ||||
| ernam | ernam | Created By | ||||
| angdt | angdt_v | Valid From | ||||
| bnddt | bnddt | Valid To | ||||
| audat | audat | Document Date | ||||
| vbtyp | vbtypl | Document Cat. | ||||
| trvog | trvog | Transact.Group | ||||
| auart | auart | Sales Doc. Type | ||||
| augru | augru | Order Reason | ||||
| gwldt | gwldt | Warranty Start | ||||
| submi | submi_sd | Collective No. | ||||
| lifsk | lifsk | Delivery Block | ||||
| faksk | faksk | Billing Block | ||||
| netwr | netwr_ak | Net Value | ||||
| waerk | waerk | Doc. Currency | ||||
| vkorg | vkorg | Sales Org. | ||||
| vtweg | vtweg | Distr. Channel | ||||
| spart | spart | Division | ||||
| vkgrp | vkgrp | Sales Group | ||||
| vkbur | vkbur | Sales Office | ||||
| gsber | gsber | Business Area | ||||
| gskst | gskst | Business Area | ||||
| guebg | guebg | Valid From | ||||
| gueen | gueen | Valid To | ||||
| knumv | knumv | Doc. Condition | ||||
| vdatu | edatu_vbak | Reqd Deliv Date | ||||
| delivery_date_type_rule | sd_delivery_date_type_rule | Deliv Date Rule | ||||
| vprgr | prgrs_vbak | Prop.date type | ||||
| autlf | autlf | Complete Dlv. | ||||
| vbkla | vbkla | Original system | ||||
| vbklt | vbklt | Indicator | ||||
| kalsm | kalsmasd | Pric. Procedure | ||||
| vsbed | vsbed | Shipping Conditions | ||||
| fkara | fkara | Ord-Rel.Bill.Ty | ||||
| awahr | awahr_ak | Probability | ||||
| ktext | ktext_v | Description | ||||
| bstnk | bstnk | Cust. Reference | ||||
| bsark | bsark | Pur. Ord. Type | ||||
| bstdk | bstdk | Cust. Ref. Date | ||||
| bstzd | bstzd | Supplement | ||||
| ihrez | ihrez | Your Reference | ||||
| bname | bname_v | Name | ||||
| telf1 | telf1_vp | Telephone | ||||
| mahza | mahza | No.of Contacts | ||||
| mahdt | mahdt | Last Contact Dt | ||||
| kunnr | kunag | Sold-to Party | ||||
| kostl | kostl | Cost Center | ||||
| stafo | stafo | Update Group | ||||
| stwae | stwae | Stats. Currency | ||||
| aedat | aedat | Changed On | ||||
| kvgr1 | kvgr1 | Customer Grp 1 | ||||
| kvgr2 | kvgr2 | Customer Grp 2 | ||||
| kvgr3 | kvgr3 | Customer Grp 3 | ||||
| kvgr4 | kvgr4 | Customer Grp 4 | ||||
| kvgr5 | kvgr5 | Customer Grp 5 | ||||
| knuma | knuma | Agreement | ||||
| kokrs | kokrs | CO Area | ||||
| ps_psp_pnr | ps_psp_pnr | WBS Element | ||||
| kurst | kurst | Exch. Rate Type | ||||
| kkber | kkber | Cred.Contr.Area | ||||
| knkli | knkli | Credit Account | ||||
| grupp | grupp_cm | Cust.Cred.Group | ||||
| sbgrp | sbgrp_cm | Cred.Rep.Grp | ||||
| ctlpc | ctlpc_cm | Risk Category | ||||
| cmwae | waers_cm | Currency | ||||
| cmfre | cmfre | Release date | ||||
| cmnup | cmnup | Next Check | ||||
| cmngv | cmngv | Next date | ||||
| amtbl | amtbl_cm | Credit Value | ||||
| cm_last_check | sd_cm_last_check | Credit Chk Timestamp | ||||
| abrvw | abrvw | Usage | ||||
| abdis | abdis | MRP for DS type | ||||
| vgbel | vgbel | Reference Doc. | ||||
| objnr | objko | Object No. Hdr | ||||
| bukrs_vf | bukrs_vf | CCodeToBeBilled | ||||
| taxk1 | taxk1_ak | Alt.Tax Class. | ||||
| taxk2 | taxk2 | Tax Cls.2 Cust. | ||||
| taxk3 | taxk3 | Tax Cls.3 Cust. | ||||
| taxk4 | taxk4 | Tax Cls.4 Cust. | ||||
| taxk5 | taxk5 | Tax Cls.5 Cust. | ||||
| taxk6 | taxk6 | Tax Cls.6 Cust. | ||||
| taxk7 | taxk7 | Tax Cls.7 Cust. | ||||
| taxk8 | taxk8 | Tax Cls.8 Cust. | ||||
| taxk9 | taxk9 | Tax Cls.9 Cust. | ||||
| xblnr | xblnr_v1 | Reference | ||||
| zuonr | ordnr_v | Assignment | ||||
| vgtyp | vbtypl_v | Prec.Doc.Categ. | ||||
| kalsm_ch | kalsma_ch | Search Proced. | ||||
| agrzr | agrzr | Accrual period | ||||
| aufnr | aufnr | Order | ||||
| qmnum | qmnum | Notification | ||||
| vbeln_grp | vbeln_grp | Master Contract | ||||
| scheme_grp | scheme_grp | Ref.procedure | ||||
| abruf_part | abruf_part | Check partner | ||||
| abhod | abhod | Pick-Up Date | ||||
| abhov | abhoz | Pick-Up Time | ||||
| abhob | abhoz | Pick-Up Time | ||||
| rplnr | rplnr | Paym.Ca.Pl.No. | ||||
| vzeit | ezeit_vbak | Req. dely time | ||||
| stceg_l | land1tx | Tax Dest. Cty/R | ||||
| landtx | landtx | Tax Depar. C/R | ||||
| xegdr | xegdr | EU Triang. Deal | ||||
| enqueue_grp | enqueue_grp | Block master contr. until all lower level contracts updated | ||||
| dat_fzau | dat_fzau | CmlQtyDate | ||||
| fmbdat | mbdat | Mat.Avail.Date | ||||
| vsnmr_v | vsnmr_v | Version | ||||
| handle | tsegguid_vbak | Int.ID | ||||
| proli | adge_proli | DG Mgmt Profile | ||||
| cont_dg | adge_ncdg | Contains DG | ||||
| crm_guid | char70 | Char 70 | ||||
| upd_tmstmp | timestampl | Time Stamp | ||||
| msr_id | msr_process_id | Process ID No. | ||||
| tm_ctrl_key | tm_ctrl_key | Control Key | ||||
| oipbl | oif_pblnr | Location ID | ||||
| last_changed_by_user | last_changed_by_user | Last Changed By | ||||
| ext_bus_syst_id | sd_ext_bus_syst_id | Ext. Bus. Syst. ID | ||||
| ext_ref_doc_id | sd_ext_ref_doc_id | External Document ID | ||||
| ext_rev_tmstmp | ext_rev_tmstmp | External Revision | ||||
| apm_approval_status | sd_apm_approval_status | Approval Status | ||||
| apm_approval_reason | sd_apm_approval_reason | Apprvl Req. Rsn ID | ||||
| apm_rejection_reason | sd_apm_rejection_reason | Apprvl Req Rjcn Rsn | ||||
| solution_order_id | crms4_solo_object_id | Solution Order | ||||
| ext_comm_syst_type | tdd_comm_syst_type | Comm system Type | ||||
| retro_purchdoc_creation | edi_retro_purchdoc_creation | Purchasing Doc Retro | ||||
| crossitem_prc_date | crossitem_prc_date | CrossItemPricingDate | ||||
| _dataaging | data_temperature | Data Aging | ||||
| OIC_PBATCH | OIC_PBATCH | OIC_PBATCH | CHAR | 16 | ||
| VBAK | ABRVW | WAERK | WAERK | |||
| VBAK | ABRVW | WAERK | WAERK | |||
| VBAK | AUART | WAERK | WAERK | |||
| VBAK | AUART | WAERK | WAERK | |||
| VBAK | AUFNR | WAERK | WAERK | |||
| VBAK | AUFNR | WAERK | WAERK | |||
| VBAK | AUGRU | WAERK | WAERK | |||
| VBAK | AUGRU | WAERK | WAERK | |||
| VBAK | BPN | WAERK | WAERK | |||
| VBAK | BPN | WAERK | WAERK | |||
| VBAK | BSARK | WAERK | WAERK | |||
| VBAK | BSARK | WAERK | WAERK | |||
| VBAK | BUKRS_VF | WAERK | WAERK | |||
| VBAK | BUKRS_VF | WAERK | WAERK | |||
| VBAK | CMWAE | WAERK | WAERK | |||
| VBAK | CMWAE | WAERK | WAERK | |||
| VBAK | CTLPC | WAERK | WAERK | |||
| VBAK | CTLPC | WAERK | WAERK | |||
| VBAK | CTLPC | WAERK | WAERK | |||
| VBAK | FAKSK | WAERK | WAERK | |||
| VBAK | FAKSK | WAERK | WAERK | |||
| VBAK | FKARA | WAERK | WAERK | |||
| VBAK | FKARA | WAERK | WAERK | |||
| VBAK | GSBER | WAERK | WAERK | |||
| VBAK | GSBER | WAERK | WAERK | |||
| VBAK | GSKST | WAERK | WAERK | |||
| VBAK | GSKST | WAERK | WAERK | |||
| VBAK | HB_CONT_REASON | WAERK | WAERK | |||
| VBAK | HB_CONT_REASON | WAERK | WAERK | |||
| VBAK | HITYP_PR | WAERK | WAERK | |||
| VBAK | HITYP_PR | WAERK | WAERK | |||
| VBAK | KALSM | WAERK | WAERK | |||
| VBAK | KALSM | WAERK | WAERK | |||
| VBAK | KALSM | WAERK | WAERK | |||
| VBAK | KALSM | WAERK | WAERK | |||
| VBAK | KALSM_CH | WAERK | WAERK | |||
| VBAK | KALSM_CH | WAERK | WAERK | |||
| VBAK | KALSM_CH | WAERK | WAERK | |||
| VBAK | KALSM_CH | WAERK | WAERK | |||
| VBAK | KKBER | WAERK | WAERK | |||
| VBAK | KKBER | WAERK | WAERK | |||
| VBAK | KNKLI | WAERK | WAERK | |||
| VBAK | KNKLI | WAERK | WAERK | |||
| VBAK | KNUMA | WAERK | WAERK | |||
| VBAK | KNUMA | WAERK | WAERK | |||
| VBAK | KOKRS | WAERK | WAERK | |||
| VBAK | KOKRS | WAERK | WAERK | |||
| VBAK | KUNNR | WAERK | WAERK | |||
| VBAK | KUNNR | WAERK | WAERK | |||
| VBAK | KURST | WAERK | WAERK | |||
| VBAK | KURST | WAERK | WAERK | |||
| VBAK | KVGR1 | WAERK | WAERK | |||
| VBAK | KVGR1 | WAERK | WAERK | |||
| VBAK | KVGR2 | WAERK | WAERK | |||
| VBAK | KVGR2 | WAERK | WAERK | |||
| VBAK | KVGR3 | WAERK | WAERK | |||
| VBAK | KVGR3 | WAERK | WAERK | |||
| VBAK | KVGR4 | WAERK | WAERK | |||
| VBAK | KVGR4 | WAERK | WAERK | |||
| VBAK | KVGR5 | WAERK | WAERK | |||
| VBAK | KVGR5 | WAERK | WAERK | |||
| VBAK | LANDTX | WAERK | WAERK | |||
| VBAK | LANDTX | WAERK | WAERK | |||
| VBAK | LIFSK | WAERK | WAERK | |||
| VBAK | LIFSK | WAERK | WAERK | |||
| VBAK | MANDT | WAERK | WAERK | |||
| VBAK | MTLAUR | WAERK | WAERK | |||
| VBAK | MTLAUR | WAERK | WAERK | |||
| VBAK | OBJNR | WAERK | WAERK | |||
| VBAK | OBJNR | WAERK | WAERK | |||
| VBAK | OIC_DCITYC | WAERK | WAERK | |||
| VBAK | OIC_DCITYC | WAERK | WAERK | |||
| VBAK | OIC_DCITYC | WAERK | WAERK | |||
| VBAK | OIC_DCITYC | WAERK | WAERK | |||
| VBAK | OIC_DCOUNC | WAERK | WAERK | |||
| VBAK | OIC_DCOUNC | WAERK | WAERK | |||
| VBAK | OIC_DCOUNC | WAERK | WAERK | |||
| VBAK | OIC_DCOUNC | WAERK | WAERK | |||
| VBAK | OIC_DLAND1 | WAERK | WAERK | |||
| VBAK | OIC_DLAND1 | WAERK | WAERK | |||
| VBAK | OIC_DREGIO | WAERK | WAERK | |||
| VBAK | OIC_DREGIO | WAERK | WAERK | |||
| VBAK | OIC_DREGIO | WAERK | WAERK | |||
| VBAK | OIC_LIFNR | WAERK | WAERK | |||
| VBAK | OIC_LIFNR | WAERK | WAERK | |||
| VBAK | OIC_MOT | WAERK | WAERK | |||
| VBAK | OIC_MOT | WAERK | WAERK | |||
| VBAK | OIC_OCITYC | WAERK | WAERK | |||
| VBAK | OIC_OCITYC | WAERK | WAERK | |||
| VBAK | OIC_OCITYC | WAERK | WAERK | |||
| VBAK | OIC_OCITYC | WAERK | WAERK | |||
| VBAK | OIC_OCOUNC | WAERK | WAERK | |||
| VBAK | OIC_OCOUNC | WAERK | WAERK | |||
| VBAK | OIC_OCOUNC | WAERK | WAERK | |||
| VBAK | OIC_OCOUNC | WAERK | WAERK | |||
| VBAK | OIC_OLAND1 | WAERK | WAERK | |||
| VBAK | OIC_OLAND1 | WAERK | WAERK | |||
| VBAK | OIC_OREGIO | WAERK | WAERK | |||
| VBAK | OIC_OREGIO | WAERK | WAERK | |||
| VBAK | OIC_OREGIO | WAERK | WAERK | |||
| VBAK | OIDRC | WAERK | WAERK | |||
| VBAK | OIDRC | WAERK | WAERK | |||
| VBAK | OIEXGNUM | WAERK | WAERK | |||
| VBAK | OIEXGNUM | WAERK | WAERK | |||
| VBAK | OIEXGTYP | WAERK | WAERK | |||
| VBAK | OIEXGTYP | WAERK | WAERK | |||
| VBAK | OIINEX | WAERK | WAERK | |||
| VBAK | OIINEX | WAERK | WAERK | |||
| VBAK | OIPBL | WAERK | WAERK | |||
| VBAK | OIPBL | WAERK | WAERK | |||
| VBAK | OIU_CT_TYPE_CD | WAERK | WAERK | |||
| VBAK | OIU_GPLT_COMPANY | WAERK | WAERK | |||
| VBAK | OIU_GPLT_COMPANY | WAERK | WAERK | |||
| VBAK | OIU_GPLT_VNAME | WAERK | WAERK | |||
| VBAK | OIU_GPLT_VNAME | WAERK | WAERK | |||
| VBAK | OIU_GPLT_VNAME | WAERK | WAERK | |||
| VBAK | OIU_MMS_TYPE_CD | WAERK | WAERK | |||
| VBAK | OIU_MMS_TYPE_CD | WAERK | WAERK | |||
| VBAK | PHASE | WAERK | WAERK | |||
| VBAK | PHASE | WAERK | WAERK | |||
| VBAK | PHASE | WAERK | WAERK | |||
| VBAK | PHASE | WAERK | WAERK | |||
| VBAK | PROLI | WAERK | WAERK | |||
| VBAK | PROLI | WAERK | WAERK | |||
| VBAK | PS_PSP_PNR | WAERK | WAERK | |||
| VBAK | PS_PSP_PNR | WAERK | WAERK | |||
| VBAK | QMNUM | WAERK | WAERK | |||
| VBAK | QMNUM | WAERK | WAERK | |||
| VBAK | RPLNR | WAERK | WAERK | |||
| VBAK | RPLNR | WAERK | WAERK | |||
| VBAK | SBGRP | WAERK | WAERK | |||
| VBAK | SBGRP | WAERK | WAERK | |||
| VBAK | SBGRP | WAERK | WAERK | |||
| VBAK | SCHEME_GRP | WAERK | WAERK | |||
| VBAK | SCHEME_GRP | WAERK | WAERK | |||
| VBAK | SMENR | WAERK | WAERK | |||
| VBAK | SMENR | WAERK | WAERK | |||
| VBAK | SMENR | WAERK | WAERK | |||
| VBAK | SMENR | WAERK | WAERK | |||
| VBAK | SPART | WAERK | WAERK | |||
| VBAK | SPART | WAERK | WAERK | |||
| VBAK | SPART | WAERK | WAERK | |||
| VBAK | SPART | WAERK | WAERK | |||
| VBAK | STCEG_L | WAERK | WAERK | |||
| VBAK | STCEG_L | WAERK | WAERK | |||
| VBAK | STWAE | WAERK | WAERK | |||
| VBAK | STWAE | WAERK | WAERK | |||
| VBAK | SWENR | WAERK | WAERK | |||
| VBAK | SWENR | WAERK | WAERK | |||
| VBAK | SWENR | WAERK | WAERK | |||
| VBAK | VBELN | WAERK | WAERK | |||
| VBAK | VBELN | WAERK | WAERK | |||
| VBAK | VGBEL | WAERK | WAERK | |||
| VBAK | VGBEL | WAERK | WAERK | |||
| VBAK | VKBUR | WAERK | WAERK | |||
| VBAK | VKBUR | WAERK | WAERK | |||
| VBAK | VKBUR | WAERK | WAERK | |||
| VBAK | VKBUR | WAERK | WAERK | |||
| VBAK | VKBUR | WAERK | WAERK | |||
| VBAK | VKGRP | WAERK | WAERK | |||
| VBAK | VKGRP | WAERK | WAERK | |||
| VBAK | VKGRP | WAERK | WAERK | |||
| VBAK | VKORG | WAERK | WAERK | |||
| VBAK | VKORG | WAERK | WAERK | |||
| VBAK | VSBED | WAERK | WAERK | |||
| VBAK | VSBED | WAERK | WAERK | |||
| VBAK | VTWEG | WAERK | WAERK | |||
| VBAK | VTWEG | WAERK | WAERK | |||
| VBAK | VTWEG | WAERK | WAERK | |||
| VBAK | WAERK | WAERK | WAERK | |||
| VBAK | WAERK | WAERK | WAERK |
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: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBAK (
MANDT, -- Client [mandt]
VBELN, -- Sales Document [vbeln_va]
ERDAT, -- Created On [erdat]
ERZET, -- Time [erzet]
ERNAM, -- Created By [ernam]
ANGDT, -- Valid From [angdt_v]
BNDDT, -- Valid To [bnddt]
AUDAT, -- Document Date [audat]
VBTYP, -- Document Cat. [vbtypl]
TRVOG, -- Transact.Group [trvog]
AUART, -- Sales Doc. Type [auart]
AUGRU, -- Order Reason [augru]
GWLDT, -- Warranty Start [gwldt]
SUBMI, -- Collective No. [submi_sd]
LIFSK, -- Delivery Block [lifsk]
FAKSK, -- Billing Block [faksk]
NETWR, -- Net Value [netwr_ak]
WAERK, -- Doc. Currency [waerk]
VKORG, -- Sales Org. [vkorg]
VTWEG, -- Distr. Channel [vtweg]
SPART, -- Division [spart]
VKGRP, -- Sales Group [vkgrp]
VKBUR, -- Sales Office [vkbur]
GSBER, -- Business Area [gsber]
GSKST, -- Business Area [gskst]
GUEBG, -- Valid From [guebg]
GUEEN, -- Valid To [gueen]
KNUMV, -- Doc. Condition [knumv]
VDATU, -- Reqd Deliv Date [edatu_vbak]
DELIVERY_DATE_TYPE_RULE, -- Deliv Date Rule [sd_delivery_date_type_rule]
VPRGR, -- Prop.date type [prgrs_vbak]
AUTLF, -- Complete Dlv. [autlf]
VBKLA, -- Original system [vbkla]
VBKLT, -- Indicator [vbklt]
KALSM, -- Pric. Procedure [kalsmasd]
VSBED, -- Shipping Conditions [vsbed]
FKARA, -- Ord-Rel.Bill.Ty [fkara]
AWAHR, -- Probability [awahr_ak]
KTEXT, -- Description [ktext_v]
BSTNK, -- Cust. Reference [bstnk]
BSARK, -- Pur. Ord. Type [bsark]
BSTDK, -- Cust. Ref. Date [bstdk]
BSTZD, -- Supplement [bstzd]
IHREZ, -- Your Reference [ihrez]
BNAME, -- Name [bname_v]
TELF1, -- Telephone [telf1_vp]
MAHZA, -- No.of Contacts [mahza]
MAHDT, -- Last Contact Dt [mahdt]
KUNNR, -- Sold-to Party [kunag]
KOSTL, -- Cost Center [kostl]
STAFO, -- Update Group [stafo]
STWAE, -- Stats. Currency [stwae]
AEDAT, -- Changed On [aedat]
KVGR1, -- Customer Grp 1 [kvgr1]
KVGR2, -- Customer Grp 2 [kvgr2]
KVGR3, -- Customer Grp 3 [kvgr3]
KVGR4, -- Customer Grp 4 [kvgr4]
KVGR5, -- Customer Grp 5 [kvgr5]
KNUMA, -- Agreement [knuma]
KOKRS, -- CO Area [kokrs]
PS_PSP_PNR, -- WBS Element [ps_psp_pnr]
KURST, -- Exch. Rate Type [kurst]
KKBER, -- Cred.Contr.Area [kkber]
KNKLI, -- Credit Account [knkli]
GRUPP, -- Cust.Cred.Group [grupp_cm]
SBGRP, -- Cred.Rep.Grp [sbgrp_cm]
CTLPC, -- Risk Category [ctlpc_cm]
CMWAE, -- Currency [waers_cm]
CMFRE, -- Release date [cmfre]
CMNUP, -- Next Check [cmnup]
CMNGV, -- Next date [cmngv]
AMTBL, -- Credit Value [amtbl_cm]
CM_LAST_CHECK, -- Credit Chk Timestamp [sd_cm_last_check]
ABRVW, -- Usage [abrvw]
ABDIS, -- MRP for DS type [abdis]
VGBEL, -- Reference Doc. [vgbel]
OBJNR, -- Object No. Hdr [objko]
BUKRS_VF, -- CCodeToBeBilled [bukrs_vf]
TAXK1, -- Alt.Tax Class. [taxk1_ak]
TAXK2, -- Tax Cls.2 Cust. [taxk2]
TAXK3, -- Tax Cls.3 Cust. [taxk3]
TAXK4, -- Tax Cls.4 Cust. [taxk4]
TAXK5, -- Tax Cls.5 Cust. [taxk5]
TAXK6, -- Tax Cls.6 Cust. [taxk6]
TAXK7, -- Tax Cls.7 Cust. [taxk7]
TAXK8, -- Tax Cls.8 Cust. [taxk8]
TAXK9, -- Tax Cls.9 Cust. [taxk9]
XBLNR, -- Reference [xblnr_v1]
ZUONR, -- Assignment [ordnr_v]
VGTYP, -- Prec.Doc.Categ. [vbtypl_v]
KALSM_CH, -- Search Proced. [kalsma_ch]
AGRZR, -- Accrual period [agrzr]
AUFNR, -- Order [aufnr]
QMNUM, -- Notification [qmnum]
VBELN_GRP, -- Master Contract [vbeln_grp]
SCHEME_GRP, -- Ref.procedure [scheme_grp]
ABRUF_PART, -- Check partner [abruf_part]
ABHOD, -- Pick-Up Date [abhod]
ABHOV, -- Pick-Up Time [abhoz]
ABHOB, -- Pick-Up Time [abhoz]
RPLNR, -- Paym.Ca.Pl.No. [rplnr]
VZEIT, -- Req. dely time [ezeit_vbak]
STCEG_L, -- Tax Dest. Cty/R [land1tx]
LANDTX, -- Tax Depar. C/R [landtx]
XEGDR, -- EU Triang. Deal [xegdr]
ENQUEUE_GRP, -- Block master contr. until all lower level contracts updated [enqueue_grp]
DAT_FZAU, -- CmlQtyDate [dat_fzau]
FMBDAT, -- Mat.Avail.Date [mbdat]
VSNMR_V, -- Version [vsnmr_v]
HANDLE, -- Int.ID [tsegguid_vbak]
PROLI, -- DG Mgmt Profile [adge_proli]
CONT_DG, -- Contains DG [adge_ncdg]
CRM_GUID, -- Char 70 [char70]
UPD_TMSTMP, -- Time Stamp [timestampl]
MSR_ID, -- Process ID No. [msr_process_id]
TM_CTRL_KEY, -- Control Key [tm_ctrl_key]
OIPBL, -- Location ID [oif_pblnr]
LAST_CHANGED_BY_USER, -- Last Changed By [last_changed_by_user]
EXT_BUS_SYST_ID, -- Ext. Bus. Syst. ID [sd_ext_bus_syst_id]
EXT_REF_DOC_ID, -- External Document ID [sd_ext_ref_doc_id]
EXT_REV_TMSTMP, -- External Revision [ext_rev_tmstmp]
APM_APPROVAL_STATUS, -- Approval Status [sd_apm_approval_status]
APM_APPROVAL_REASON, -- Apprvl Req. Rsn ID [sd_apm_approval_reason]
APM_REJECTION_REASON, -- Apprvl Req Rjcn Rsn [sd_apm_rejection_reason]
SOLUTION_ORDER_ID, -- Solution Order [crms4_solo_object_id]
EXT_COMM_SYST_TYPE, -- Comm system Type [tdd_comm_syst_type]
RETRO_PURCHDOC_CREATION, -- Purchasing Doc Retro [edi_retro_purchdoc_creation]
CROSSITEM_PRC_DATE, -- CrossItemPricingDate [crossitem_prc_date]
_DATAAGING, -- Data Aging [data_temperature]
OIC_PBATCH CHAR(16), -- OIC_PBATCH
VBAK WAERK, -- ABRVW
VBAK WAERK, -- ABRVW
VBAK WAERK, -- AUART
VBAK WAERK, -- AUART
VBAK WAERK, -- AUFNR
VBAK WAERK, -- AUFNR
VBAK WAERK, -- AUGRU
VBAK WAERK, -- AUGRU
VBAK WAERK, -- BPN
VBAK WAERK, -- BPN
VBAK WAERK, -- BSARK
VBAK WAERK, -- BSARK
VBAK WAERK, -- BUKRS_VF
VBAK WAERK, -- BUKRS_VF
VBAK WAERK, -- CMWAE
VBAK WAERK, -- CMWAE
VBAK WAERK, -- CTLPC
VBAK WAERK, -- CTLPC
VBAK WAERK, -- CTLPC
VBAK WAERK, -- FAKSK
VBAK WAERK, -- FAKSK
VBAK WAERK, -- FKARA
VBAK WAERK, -- FKARA
VBAK WAERK, -- GSBER
VBAK WAERK, -- GSBER
VBAK WAERK, -- GSKST
VBAK WAERK, -- GSKST
VBAK WAERK, -- HB_CONT_REASON
VBAK WAERK, -- HB_CONT_REASON
VBAK WAERK, -- HITYP_PR
VBAK WAERK, -- HITYP_PR
VBAK WAERK, -- KALSM
VBAK WAERK, -- KALSM
VBAK WAERK, -- KALSM
VBAK WAERK, -- KALSM
VBAK WAERK, -- KALSM_CH
VBAK WAERK, -- KALSM_CH
VBAK WAERK, -- KALSM_CH
VBAK WAERK, -- KALSM_CH
VBAK WAERK, -- KKBER
VBAK WAERK, -- KKBER
VBAK WAERK, -- KNKLI
VBAK WAERK, -- KNKLI
VBAK WAERK, -- KNUMA
VBAK WAERK, -- KNUMA
VBAK WAERK, -- KOKRS
VBAK WAERK, -- KOKRS
VBAK WAERK, -- KUNNR
VBAK WAERK, -- KUNNR
VBAK WAERK, -- KURST
VBAK WAERK, -- KURST
VBAK WAERK, -- KVGR1
VBAK WAERK, -- KVGR1
VBAK WAERK, -- KVGR2
VBAK WAERK, -- KVGR2
VBAK WAERK, -- KVGR3
VBAK WAERK, -- KVGR3
VBAK WAERK, -- KVGR4
VBAK WAERK, -- KVGR4
VBAK WAERK, -- KVGR5
VBAK WAERK, -- KVGR5
VBAK WAERK, -- LANDTX
VBAK WAERK, -- LANDTX
VBAK WAERK, -- LIFSK
VBAK WAERK, -- LIFSK
VBAK WAERK, -- MANDT
VBAK WAERK, -- MTLAUR
VBAK WAERK, -- MTLAUR
VBAK WAERK, -- OBJNR
VBAK WAERK, -- OBJNR
VBAK WAERK, -- OIC_DCITYC
VBAK WAERK, -- OIC_DCITYC
VBAK WAERK, -- OIC_DCITYC
VBAK WAERK, -- OIC_DCITYC
VBAK WAERK, -- OIC_DCOUNC
VBAK WAERK, -- OIC_DCOUNC
VBAK WAERK, -- OIC_DCOUNC
VBAK WAERK, -- OIC_DCOUNC
VBAK WAERK, -- OIC_DLAND1
VBAK WAERK, -- OIC_DLAND1
VBAK WAERK, -- OIC_DREGIO
VBAK WAERK, -- OIC_DREGIO
VBAK WAERK, -- OIC_DREGIO
VBAK WAERK, -- OIC_LIFNR
VBAK WAERK, -- OIC_LIFNR
VBAK WAERK, -- OIC_MOT
VBAK WAERK, -- OIC_MOT
VBAK WAERK, -- OIC_OCITYC
VBAK WAERK, -- OIC_OCITYC
VBAK WAERK, -- OIC_OCITYC
VBAK WAERK, -- OIC_OCITYC
VBAK WAERK, -- OIC_OCOUNC
VBAK WAERK, -- OIC_OCOUNC
VBAK WAERK, -- OIC_OCOUNC
VBAK WAERK, -- OIC_OCOUNC
VBAK WAERK, -- OIC_OLAND1
VBAK WAERK, -- OIC_OLAND1
VBAK WAERK, -- OIC_OREGIO
VBAK WAERK, -- OIC_OREGIO
VBAK WAERK, -- OIC_OREGIO
VBAK WAERK, -- OIDRC
VBAK WAERK, -- OIDRC
VBAK WAERK, -- OIEXGNUM
VBAK WAERK, -- OIEXGNUM
VBAK WAERK, -- OIEXGTYP
VBAK WAERK, -- OIEXGTYP
VBAK WAERK, -- OIINEX
VBAK WAERK, -- OIINEX
VBAK WAERK, -- OIPBL
VBAK WAERK, -- OIPBL
VBAK WAERK, -- OIU_CT_TYPE_CD
VBAK WAERK, -- OIU_GPLT_COMPANY
VBAK WAERK, -- OIU_GPLT_COMPANY
VBAK WAERK, -- OIU_GPLT_VNAME
VBAK WAERK, -- OIU_GPLT_VNAME
VBAK WAERK, -- OIU_GPLT_VNAME
VBAK WAERK, -- OIU_MMS_TYPE_CD
VBAK WAERK, -- OIU_MMS_TYPE_CD
VBAK WAERK, -- PHASE
VBAK WAERK, -- PHASE
VBAK WAERK, -- PHASE
VBAK WAERK, -- PHASE
VBAK WAERK, -- PROLI
VBAK WAERK, -- PROLI
VBAK WAERK, -- PS_PSP_PNR
VBAK WAERK, -- PS_PSP_PNR
VBAK WAERK, -- QMNUM
VBAK WAERK, -- QMNUM
VBAK WAERK, -- RPLNR
VBAK WAERK, -- RPLNR
VBAK WAERK, -- SBGRP
VBAK WAERK, -- SBGRP
VBAK WAERK, -- SBGRP
VBAK WAERK, -- SCHEME_GRP
VBAK WAERK, -- SCHEME_GRP
VBAK WAERK, -- SMENR
VBAK WAERK, -- SMENR
VBAK WAERK, -- SMENR
VBAK WAERK, -- SMENR
VBAK WAERK, -- SPART
VBAK WAERK, -- SPART
VBAK WAERK, -- SPART
VBAK WAERK, -- SPART
VBAK WAERK, -- STCEG_L
VBAK WAERK, -- STCEG_L
VBAK WAERK, -- STWAE
VBAK WAERK, -- STWAE
VBAK WAERK, -- SWENR
VBAK WAERK, -- SWENR
VBAK WAERK, -- SWENR
VBAK WAERK, -- VBELN
VBAK WAERK, -- VBELN
VBAK WAERK, -- VGBEL
VBAK WAERK, -- VGBEL
VBAK WAERK, -- VKBUR
VBAK WAERK, -- VKBUR
VBAK WAERK, -- VKBUR
VBAK WAERK, -- VKBUR
VBAK WAERK, -- VKBUR
VBAK WAERK, -- VKGRP
VBAK WAERK, -- VKGRP
VBAK WAERK, -- VKGRP
VBAK WAERK, -- VKORG
VBAK WAERK, -- VKORG
VBAK WAERK, -- VSBED
VBAK WAERK, -- VSBED
VBAK WAERK, -- VTWEG
VBAK WAERK, -- VTWEG
VBAK WAERK, -- VTWEG
VBAK WAERK, -- WAERK
VBAK WAERK, -- WAERK
PRIMARY KEY (MANDT, VBELN)
);
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