VBRP
Billing Document: Item Data
VBRP is an SAP database table in S/4HANA. Billing Document: Item Data. It contains 300 fields. 15 CDS views read from this table.
CDS Views using this table (15)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CustInvcItQty | view | from | Customer Invoice Item Quantity | |
| E_BillingDocumentItem | view | from | EXTENSION | Extension View for VBRP |
| FISTRPGSTR1ITEM | view | left_outer | ||
| I_BillingDocExtdItemBasic | view | from | BASIC | Billing Document Item Basic Extended |
| I_ComplaintBillingStatus | view_entity | from | BASIC | Complaint Billing Status |
| I_RO_SAFTOrderReference | view | from | BASIC | RO SAFT Order Reference |
| P_BillingDocumentItemBasic_1 | view_entity | from | BASIC | |
| P_BillingDocumentItemBasic_2 | view_entity | from | BASIC | |
| P_CancelledBillgDocDtaMigrtn | view_entity | from | BASIC | |
| P_MstrProjBillDocItem | view_entity | from | BASIC | |
| TMA_V_VBRK_VBRP_1 | view | inner | Business Volume from Billing Document | |
| v_sd_ci_item_party | view | from | ||
| V_WB2_VBRK_VBRP_1 | view | from | Business Volume from Billing Document | |
| V_Wb2_Vbrk_Vbrp_Tpm | view | from | CCS: Business Volume from Sales for TPM | |
| view_sdi_items_p | view | from | Item Related Data of a Billing Document |
Fields (300)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | vbeln | VBELN_VF | Billing Doc. | |||
| KEY | posnr | POSNR_VF | Item | |||
| uepos | UEPOS | Higher-Lev.Item | ||||
| fkimg | FKIMG | Invoiced Qty | ||||
| vrkme | VRKME | Sales Unit | ||||
| umvkz | UMVKZ | Numerator | ||||
| umvkn | UMVKN | Denominat. | ||||
| meins | MEINS | Base Unit | ||||
| smeng | SMENG | Scale Quantity | ||||
| fklmg | FKLMG | Bill.Qty in SKU | ||||
| lmeng | LMENG | Required Qty | ||||
| ntgew | NTGEW_15 | Net Weight | ||||
| brgew | BRGEW_15 | Gross Weight | ||||
| gewei | GEWEI | Unit of Weight | ||||
| volum | VOLUM_15 | Volume | ||||
| voleh | VOLEH | Volume Unit | ||||
| gsber | GSBER | Business Area | ||||
| prsdt | PRSDT | Pricing Date | ||||
| fbuda | FBUDA | Serv. Rend. Dte | ||||
| kursk | KURSK | Exchange Rate | ||||
| netwr | NETWR_FP | Net Value | ||||
| vbelv | VBELV | Originating Doc | ||||
| posnv | POSNV | Origin. Item | ||||
| vgbel | VGBEL | Reference Doc. | ||||
| vgpos | VGPOS | Reference Item | ||||
| vgtyp | VBTYPL_V | Prec.Doc.Categ. | ||||
| aubel | VBELN_VA | Sales Document | ||||
| aupos | POSNR_VA | Item | ||||
| auref | AUREF | SalesDocumentRefer | ||||
| matnr | MATNR | Material | ||||
| arktx | ARKTX | Item Descr. | ||||
| pmatn | PMATN | Pr. Ref. Matl | ||||
| charg | CHARG_D | Batch | ||||
| matkl | MATKL | Material Group | ||||
| pstyv | PSTYV | Item Category | ||||
| posar | POSAR | Item Type | ||||
| prodh | PRODH_D | Prod. Hierarchy | ||||
| vstel | VSTEL | Shipping Point | ||||
| atpkz | ATPKZ | Replacemt Part | ||||
| spart | SPART | Division | ||||
| pospa | POSPA | Partner Item | ||||
| werks | WERKS_D | Plant | ||||
| aland | ALAND | Dep. Ctry/Reg. | ||||
| wkreg | WKREG | Region-Dlv.Plnt | ||||
| wkcou | WKCOU | County-Dlv.Plnt | ||||
| wkcty | WKCTY | City-Dlv.Plant | ||||
| taxm1 | TAXM1 | Tax Class. Mat. | ||||
| taxm2 | TAXM2 | Tax Class.2 Mt. | ||||
| taxm3 | TAXM3 | Tax Class.3 Mt. | ||||
| taxm4 | TAXM4 | Tax Class.4 Mt. | ||||
| taxm5 | TAXM5 | Tax Class.5 Mt. | ||||
| taxm6 | TAXM6 | Tax Class6 Mat. | ||||
| taxm7 | TAXM7 | Tax Class7 Mat. | ||||
| taxm8 | TAXM8 | Tax Class8 Mat. | ||||
| taxm9 | TAXM9 | Tax Class9 Mat. | ||||
| kowrr | KOWRR | Stat. Value | ||||
| prsfd | PRSFD | Pricing Relev. | ||||
| sktof | SKTOF | Cash Discount | ||||
| skfbp | SKFBP | Csh.Disc.Bas | ||||
| kondm | KONDM | Mat. Price Grp | ||||
| ktgrm | KTGRM | AcctAssmtGrpMat | ||||
| kostl | KOSTL | Cost Center | ||||
| bonus | BONUS | Vol. Rebate Grp | ||||
| provg | PROVG | Commission Grp | ||||
| eannr | EANNR | EAN Number | ||||
| vkgrp | VKGRP | Sales Group | ||||
| vkbur | VKBUR | Sales Office | ||||
| spara | SPART_AK | Division | ||||
| shkzg | SHKZG_VF | Returns | ||||
| ernam | ERNAM | Created By | ||||
| erdat | ERDAT | Created On | ||||
| erzet | ERZET | Time | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| lgort | LGORT_D | Location | ||||
| 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 | ||||
| uvprs | UVPRS | Pricing | ||||
| uvall | UVALL | General | ||||
| ean11 | EAN11 | EAN/UPC | ||||
| prctr | PRCTR | Profit Center | ||||
| 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 | ||||
| mvgr1 | MVGR1 | MaterialGroup 1 | ||||
| mvgr2 | MVGR2 | MaterialGroup 2 | ||||
| mvgr3 | MVGR3 | MaterialGroup 3 | ||||
| mvgr4 | MVGR4 | MaterialGroup 4 | ||||
| mvgr5 | MVGR5 | MaterialGroup 5 | ||||
| matwa | MATWA | MaterialEntered | ||||
| bonba | BONBA | Rebate Basis | ||||
| kokrs | KOKRS | CO Area | ||||
| paobjnr | RKEOBJNR | Profit. segment | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| aufnr | AUFNR | Order | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| cmpre | CMPRE | Credit Price | ||||
| cmpnt | CMPNT | Credit Active | ||||
| cuobj | CUOBJ_VA | Configuration | ||||
| cuobj_ch | CUOBJ_CH | Int.object no. | ||||
| koupd | KOUPD | Condit. Update | ||||
| uecha | UECHA | HghLevItmBatch | ||||
| xchar | XCHAR | Batches | ||||
| batch_billing_variant | SDBIL_BATCH_BILLING_VARIANT | BatchItmBillVar | ||||
| abrvw | ABRVW | Usage | ||||
| sernr | SERNR | BOM expl.number | ||||
| bzirk_auft | BZIRK_AUFT | Sls Dist. Order | ||||
| kdgrp_auft | KDGRP_AUFT | CustGrpOrder | ||||
| konda_auft | KONDA_AUFT | PriceGroupOrder | ||||
| lland_auft | LLAND_AUFT | Dst.CtryRg.Ord. | ||||
| mprok | MPROK | Manual Price | ||||
| pltyp_auft | PLTYP_AUFT | Price List Ord. | ||||
| regio_auft | REGIO_AUFT | Region Order | ||||
| vkorg_auft | VKORG_AUFT | SOrg of Order | ||||
| vtweg_auft | VTWEG_AUFT | Dist. Chan. Or. | ||||
| abrbg | ABRBG | AcctSettleStart | ||||
| prosa | PROSA | MatDetermActive | ||||
| uepvw | UEPVW | Usage HL Item | ||||
| autyp | VBTYPL | Document Cat. | ||||
| stadat | STADAT | Statistics Date | ||||
| fplnr | FPLNR | Bill. Plan No. | ||||
| fpltr | FPLTR | Item | ||||
| aktnr | WAKTION | Promotion | ||||
| knuma_pi | KNUMA_PI | Promotion | ||||
| knuma_ag | KNUMA_AG | Sales Deal | ||||
| mwsbp | MWSBP | Tax Amount | ||||
| augru_auft | AUGRU | Order Reason | ||||
| fareg | FAREG | Billing Rule | ||||
| upmat | UPMAT | Pr.Ref.Material | ||||
| ukonm | UKONM | MnItem MatPrcGr | ||||
| cmpre_flt | CMPRE_FLT | Credit Price | ||||
| abfor | ABSFORM_CM | PaytGuarantForm | ||||
| abges | ABGES_CM | Guaranteed | ||||
| j_1arfz | J_1ARFZVAT | Reason for Zero VAT | ||||
| j_1aregio | REGIO | Region | ||||
| j_1agicd | J_1AGICD_D | Activity Code | ||||
| j_1adtyp | J_1ADTYP_D | Distr. Type | ||||
| j_1atxrel | J_1ATXREL_ | Tax Rel. Class. | ||||
| j_1bcfop | J_1BCFOP | CFOP | ||||
| j_1btaxlw1 | J_1BTAXLW1 | ICMS Law | ||||
| j_1btaxlw2 | J_1BTAXLW2 | IPI Law | ||||
| j_1btxsdc | J_1BTXSDC_ | Tax Code | ||||
| brtwr | BRTWR_FP | Gross Value | ||||
| wktnr | WKTNR | Value Contract No. | ||||
| wktps | WKTPS | Val. Cont.Item | ||||
| rplnr | RPLNR_AU | Paym.ca.pl.no. | ||||
| kursk_dat | WWERT_D | Translatn Date | ||||
| wgru1 | WGRU_HIE1 | MatGroup 1 | ||||
| wgru2 | WGRU_HIE2 | MatGroup 2 | ||||
| kdkg1 | KDKG1 | Condition grp 1 | ||||
| kdkg2 | KDKG2 | Condition grp 2 | ||||
| kdkg3 | KDKG3 | Condition grp 3 | ||||
| kdkg4 | KDKG4 | Condition grp 4 | ||||
| kdkg5 | KDKG5 | Condition grp 5 | ||||
| vkaus | ABRVW | Usage | ||||
| j_1aindxp | J_1AINDXP | Inflation index | ||||
| j_1aidatep | J_1AIDATES | Index base date | ||||
| kzfme | KZFME | Leading UoM | ||||
| mwskz | MWSKZ | Tax Code | ||||
| vertt | RANTYP | Contract Type | ||||
| vertn | RANL | Contract Number | ||||
| sgtxt | SGTXT | Text | ||||
| delco | DELCO | Delivery Time | ||||
| bemot | BEMOT | AcctIndicator | ||||
| rrrel | RR_RELTYP | Rev. Recognition | ||||
| wminr | WMINR | Catalog | ||||
| vgbel_ex | VGBEL | Reference Doc. | ||||
| vgpos_ex | VGPOS | Reference Item | ||||
| logsys | LOGSYS | Logical system | ||||
| vgtyp_ex | VGTYP_EX | Category | ||||
| j_1btaxlw3 | J_1BTAXLW3 | ISS Law | ||||
| j_1btaxlw4 | J_1BTAXLW4 | COFINS Law | ||||
| j_1btaxlw5 | J_1BTAXLW5 | PIS Law | ||||
| msr_id | MSR_PROCESS_ID | Process ID No. | ||||
| msr_refund_code | MSR_RETURNS_REFUND_CODE | Refund Code | ||||
| msr_ret_reason | MSR_RETURNS_REASON | Return Reason | ||||
| nrab_knumh | KNUMH | Cond.Record No. | ||||
| nrab_value | KWERT | Condition Value | ||||
| dispute_case | DISPUTE_CASE | Dispute Case | ||||
| fund_usage_item | FUND_USAGE_ITEM | Fund Usg Item | ||||
| farr_reltype | FARR_RELTYPE | Type | ||||
| claims_taxation | CLAIMS_TAXATION | Claims Taxat. | ||||
| kurrf_dat_orig | WWERT_D | Translatn Date | ||||
| sgt_rcat | SGT_RCAT | Req. Segment | ||||
| sgt_scat | SGT_SCAT | Stock Segment | ||||
| prefe | PREFE | Cus. Preference | ||||
| akkur | AKKUR | LettofCredRate | ||||
| waerk | WAERK | Doc. Currency | ||||
| draft | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| activedocument | VBELN | SD Document | ||||
| grwrt | GRWRT | Statist. Value | ||||
| fksaa | FKSAA | Ord.Rel.BillgSt | ||||
| absta | ABSTA_BDR | Rejection Status | ||||
| abgru | ABGRU_BDR | Rejection Reason | ||||
| mwsk1 | MWSKZ | Tax Code | ||||
| txdat_from | FOT_TXDAT_FROM | Tax Rate Valid-From | ||||
| pbd_id | PBD_ID | Prelimin. Bill. Doc. | ||||
| pbd_item_id | PBD_ITEM_ID | Prelimin. Doc. Item | ||||
| cats_overtime_category | CATS_OVERTIME_CATEGORY | Overtime Category | ||||
| contr_dp_settl | CONTR_DP_SETTL_VF | Settlem. DP Contract | ||||
| prodh_univ_sales_parnt_nodid | NODID | Node ID | ||||
| transit_plant | TRANSIT_PLANT | Transit Plant | ||||
| vcm_chain_category | VCM_CHAIN_CATEGORY | Value Chain Category | ||||
| vcm_chain_uuid | GUID_32 | GUID 16 | ||||
| reason_code | SD_ITEM_REASON_CODE | Return/Change Reason | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| spe_herkl | HERKL | C/R of Origin | ||||
| spe_herkr | HERKR | Reg. of Origin | ||||
| itm_comco | /SAPSLL/COMCO | Commodity Code | ||||
| vtkey | VTKEY_KK | Contract | ||||
| vtpos | VTPOS_KK | Contract Item | ||||
| srcdoc_process_type | SRCDOC_PROCESS_TYPE | Source Doc. Type | ||||
| t2ccode_crcy_conv_factor | FINS_T2CCODE_CRCY_CONV_FACTOR | Tax Amt Fctr in LC | ||||
| t2cntry_crcy_conv_factor | FINS_T2CNTRY_CRCY_CONV_FACTOR | Tax Amt Fctr in RC | ||||
| dummy_billgdocitem_incl_eew_ps | DUMMY | Dummy function in length 1 | ||||
| service_doc_type | FCO_SRVDOC_TYPE | Service Doc. Type | ||||
| service_doc_id | FCO_SRVDOC_ID | Service Document | ||||
| service_doc_item_id | FCO_SRVDOC_ITEM_ID | Service Doc. Item | ||||
| solution_order_id | CRMS4_SOLO_OBJECT_ID | Solution Order | ||||
| solution_order_item_id | CRMS4_SOLO_NUMBER_INT | Solution Order Item | ||||
| vbtyp_ana | VBTYPL | Document Cat. | ||||
| fkart_ana | FKART | Billing Type | ||||
| vkorg_ana | VKORG | Sales Org. | ||||
| vtweg_ana | VTWEG | Distr. Channel | ||||
| konda_ana | KONDA | CustPrice Group | ||||
| kdgrp_ana | KDGRP | Customer Group | ||||
| land1_ana | LLAND | Dest. Ctry/Reg | ||||
| regio_ana | REGIO | Region | ||||
| cityc_ana | CITYC | City Code | ||||
| bzirk_ana | BZIRK | Sales District | ||||
| gbstk_ana | GBSTK | Overall Status | ||||
| vf_status_ana | VF_STATUS | Status | ||||
| kunag_ana | KUNAG | Sold-to Party | ||||
| kunrg_ana | KUNRG | Payer | ||||
| fkdat_ana | FKDAT | Billing Date | ||||
| bukrs_ana | BUKRS | Company Code | ||||
| counc_ana | COUNC | County Code | ||||
| knuma_ana | KNUMA | Agreement | ||||
| fktyp_ana | FKTYP | BillingCategory | ||||
| knumv_ana | KNUMV | Doc. Condition | ||||
| sfakn_ana | SFAKN | Canceld Bill.Dc | ||||
| kunwe_ana | KUNWE | Ship-to Party | ||||
| kunre_ana | KUNRE | Bill-to Party | ||||
| perve_ana | SALES_EMPL | Sales Employee | ||||
| perzm_ana | RESP_EMPL | Employee Responsible | ||||
| glo_log_ref1_it | GLO_LOG_REF1_IT | Commodity Code for Poland | ||||
| txs_business_transaction | TXS_BUSINESS_TRANSACTION | Business Transaction | ||||
| txs_material_usage | TXS_MATERIAL_USAGE | Customer Usage | ||||
| txs_usage_purpose | TXS_USAGE_PURPOSE | Usage Purpose | ||||
| zapcgki | /ILE/TAPCGK | Annexing Package | ||||
| apcgk_extendi | /ILE/TAPCGK_EXT | Ann.Package Extend | ||||
| zabdati | /ILE/TABDAT | Annexing base date | ||||
| aufpl | CO_AUFPL | Plan No.f.Oper. | ||||
| aplzl | CIM_COUNT | Counter | ||||
| dpcnr | /SAPPCE/DPCNR | DP Chain Number | ||||
| dcpnr | /SAPPCE/DPCPNR | Transaction | ||||
| dpnrb | /SAPPCE/DPCPNRB | Doc. Seq. No. | ||||
| bosfar | BOSFAR | Billing rule | ||||
| dp_belnr | BELNR_D | Document Number | ||||
| dp_bukrs | BUKRS | Company Code | ||||
| dp_gjahr | GJAHR | Fiscal Year | ||||
| dp_buzei | BUZEI | Item | ||||
| packno | PACKNO | Package number | ||||
| perop_beg | FM_PEROP_SD_LOW | Per. of Perf. Start | ||||
| perop_end | FM_PEROP_SD_HIGH | Per. of Perf. End | ||||
| fmfgus_key | FMFG_US_KEY | US Govt | ||||
| fsh_season_year | FSH_SAISJ | Season Year | ||||
| fsh_season | FSH_SAISO | Season | ||||
| fsh_collection | FSH_COLLECTION | Collection | ||||
| fsh_theme | FSH_THEME | Theme | ||||
| fonds | BP_GEBER | Fund | ||||
| fistl | FISTL | Funds Center | ||||
| fkber | FKBER | Functional Area | ||||
| grant_nbr | GM_GRANT_NBR | Grant | ||||
| budget_pd | FM_BUDGET_PERIOD | Budget Period | ||||
| j_3gbelnri | J_3GBELNRI | Document number | ||||
| j_3gpmaufe | J_3GPMAUFE | PM order owner | ||||
| j_3gpmaufv | J_3GPMAUFV | PM order admin. | ||||
| j_3getypa | J_3GETYPA | Send. rcpt type | ||||
| j_3getype | J_3GETYPE | Recve rcpt type | ||||
| j_3gorgueb | J_3GORGUEB | All org. str. | ||||
| prs_work_period | PRS_WORK_PERIOD | Work Period | ||||
| pprctr | PPRCTR | Partner PC | ||||
| pargb | PARGB | Trdg Part.BA | ||||
| aufpl_oaa | CO_AUFPL | Plan No.f.Oper. | ||||
| aplzl_oaa | CIM_COUNT | Counter | ||||
| campaign | CGPL_GUID16_R3 | CGPL_GUID | ||||
| compreas | CMP_COMPREAS_COPY | Abbreviation | ||||
| wrf_charstc1 | WRF_CHARSTC1 | Characteristic 1 | ||||
| wrf_charstc2 | WRF_CHARSTC2 | Characteristic 2 | ||||
| wrf_charstc3 | WRF_CHARSTC3 | Characteristic 3 |
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.
-- Billing Document: Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBRP (
MANDT, -- Client [MANDT]
VBELN, -- Billing Doc. [VBELN_VF]
POSNR, -- Item [POSNR_VF]
UEPOS, -- Higher-Lev.Item [UEPOS]
FKIMG, -- Invoiced Qty [FKIMG]
VRKME, -- Sales Unit [VRKME]
UMVKZ, -- Numerator [UMVKZ]
UMVKN, -- Denominat. [UMVKN]
MEINS, -- Base Unit [MEINS]
SMENG, -- Scale Quantity [SMENG]
FKLMG, -- Bill.Qty in SKU [FKLMG]
LMENG, -- Required Qty [LMENG]
NTGEW, -- Net Weight [NTGEW_15]
BRGEW, -- Gross Weight [BRGEW_15]
GEWEI, -- Unit of Weight [GEWEI]
VOLUM, -- Volume [VOLUM_15]
VOLEH, -- Volume Unit [VOLEH]
GSBER, -- Business Area [GSBER]
PRSDT, -- Pricing Date [PRSDT]
FBUDA, -- Serv. Rend. Dte [FBUDA]
KURSK, -- Exchange Rate [KURSK]
NETWR, -- Net Value [NETWR_FP]
VBELV, -- Originating Doc [VBELV]
POSNV, -- Origin. Item [POSNV]
VGBEL, -- Reference Doc. [VGBEL]
VGPOS, -- Reference Item [VGPOS]
VGTYP, -- Prec.Doc.Categ. [VBTYPL_V]
AUBEL, -- Sales Document [VBELN_VA]
AUPOS, -- Item [POSNR_VA]
AUREF, -- SalesDocumentRefer [AUREF]
MATNR, -- Material [MATNR]
ARKTX, -- Item Descr. [ARKTX]
PMATN, -- Pr. Ref. Matl [PMATN]
CHARG, -- Batch [CHARG_D]
MATKL, -- Material Group [MATKL]
PSTYV, -- Item Category [PSTYV]
POSAR, -- Item Type [POSAR]
PRODH, -- Prod. Hierarchy [PRODH_D]
VSTEL, -- Shipping Point [VSTEL]
ATPKZ, -- Replacemt Part [ATPKZ]
SPART, -- Division [SPART]
POSPA, -- Partner Item [POSPA]
WERKS, -- Plant [WERKS_D]
ALAND, -- Dep. Ctry/Reg. [ALAND]
WKREG, -- Region-Dlv.Plnt [WKREG]
WKCOU, -- County-Dlv.Plnt [WKCOU]
WKCTY, -- City-Dlv.Plant [WKCTY]
TAXM1, -- Tax Class. Mat. [TAXM1]
TAXM2, -- Tax Class.2 Mt. [TAXM2]
TAXM3, -- Tax Class.3 Mt. [TAXM3]
TAXM4, -- Tax Class.4 Mt. [TAXM4]
TAXM5, -- Tax Class.5 Mt. [TAXM5]
TAXM6, -- Tax Class6 Mat. [TAXM6]
TAXM7, -- Tax Class7 Mat. [TAXM7]
TAXM8, -- Tax Class8 Mat. [TAXM8]
TAXM9, -- Tax Class9 Mat. [TAXM9]
KOWRR, -- Stat. Value [KOWRR]
PRSFD, -- Pricing Relev. [PRSFD]
SKTOF, -- Cash Discount [SKTOF]
SKFBP, -- Csh.Disc.Bas [SKFBP]
KONDM, -- Mat. Price Grp [KONDM]
KTGRM, -- AcctAssmtGrpMat [KTGRM]
KOSTL, -- Cost Center [KOSTL]
BONUS, -- Vol. Rebate Grp [BONUS]
PROVG, -- Commission Grp [PROVG]
EANNR, -- EAN Number [EANNR]
VKGRP, -- Sales Group [VKGRP]
VKBUR, -- Sales Office [VKBUR]
SPARA, -- Division [SPART_AK]
SHKZG, -- Returns [SHKZG_VF]
ERNAM, -- Created By [ERNAM]
ERDAT, -- Created On [ERDAT]
ERZET, -- Time [ERZET]
BWTAR, -- Valuation Type [BWTAR_D]
LGORT, -- Location [LGORT_D]
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]
UVPRS, -- Pricing [UVPRS]
UVALL, -- General [UVALL]
EAN11, -- EAN/UPC [EAN11]
PRCTR, -- Profit Center [PRCTR]
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]
MVGR1, -- MaterialGroup 1 [MVGR1]
MVGR2, -- MaterialGroup 2 [MVGR2]
MVGR3, -- MaterialGroup 3 [MVGR3]
MVGR4, -- MaterialGroup 4 [MVGR4]
MVGR5, -- MaterialGroup 5 [MVGR5]
MATWA, -- MaterialEntered [MATWA]
BONBA, -- Rebate Basis [BONBA]
KOKRS, -- CO Area [KOKRS]
PAOBJNR, -- Profit. segment [RKEOBJNR]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
AUFNR, -- Order [AUFNR]
TXJCD, -- Tax Jur. [TXJCD]
CMPRE, -- Credit Price [CMPRE]
CMPNT, -- Credit Active [CMPNT]
CUOBJ, -- Configuration [CUOBJ_VA]
CUOBJ_CH, -- Int.object no. [CUOBJ_CH]
KOUPD, -- Condit. Update [KOUPD]
UECHA, -- HghLevItmBatch [UECHA]
XCHAR, -- Batches [XCHAR]
BATCH_BILLING_VARIANT, -- BatchItmBillVar [SDBIL_BATCH_BILLING_VARIANT]
ABRVW, -- Usage [ABRVW]
SERNR, -- BOM expl.number [SERNR]
BZIRK_AUFT, -- Sls Dist. Order [BZIRK_AUFT]
KDGRP_AUFT, -- CustGrpOrder [KDGRP_AUFT]
KONDA_AUFT, -- PriceGroupOrder [KONDA_AUFT]
LLAND_AUFT, -- Dst.CtryRg.Ord. [LLAND_AUFT]
MPROK, -- Manual Price [MPROK]
PLTYP_AUFT, -- Price List Ord. [PLTYP_AUFT]
REGIO_AUFT, -- Region Order [REGIO_AUFT]
VKORG_AUFT, -- SOrg of Order [VKORG_AUFT]
VTWEG_AUFT, -- Dist. Chan. Or. [VTWEG_AUFT]
ABRBG, -- AcctSettleStart [ABRBG]
PROSA, -- MatDetermActive [PROSA]
UEPVW, -- Usage HL Item [UEPVW]
AUTYP, -- Document Cat. [VBTYPL]
STADAT, -- Statistics Date [STADAT]
FPLNR, -- Bill. Plan No. [FPLNR]
FPLTR, -- Item [FPLTR]
AKTNR, -- Promotion [WAKTION]
KNUMA_PI, -- Promotion [KNUMA_PI]
KNUMA_AG, -- Sales Deal [KNUMA_AG]
MWSBP, -- Tax Amount [MWSBP]
AUGRU_AUFT, -- Order Reason [AUGRU]
FAREG, -- Billing Rule [FAREG]
UPMAT, -- Pr.Ref.Material [UPMAT]
UKONM, -- MnItem MatPrcGr [UKONM]
CMPRE_FLT, -- Credit Price [CMPRE_FLT]
ABFOR, -- PaytGuarantForm [ABSFORM_CM]
ABGES, -- Guaranteed [ABGES_CM]
J_1ARFZ, -- Reason for Zero VAT [J_1ARFZVAT]
J_1AREGIO, -- Region [REGIO]
J_1AGICD, -- Activity Code [J_1AGICD_D]
J_1ADTYP, -- Distr. Type [J_1ADTYP_D]
J_1ATXREL, -- Tax Rel. Class. [J_1ATXREL_]
J_1BCFOP, -- CFOP [J_1BCFOP]
J_1BTAXLW1, -- ICMS Law [J_1BTAXLW1]
J_1BTAXLW2, -- IPI Law [J_1BTAXLW2]
J_1BTXSDC, -- Tax Code [J_1BTXSDC_]
BRTWR, -- Gross Value [BRTWR_FP]
WKTNR, -- Value Contract No. [WKTNR]
WKTPS, -- Val. Cont.Item [WKTPS]
RPLNR, -- Paym.ca.pl.no. [RPLNR_AU]
KURSK_DAT, -- Translatn Date [WWERT_D]
WGRU1, -- MatGroup 1 [WGRU_HIE1]
WGRU2, -- MatGroup 2 [WGRU_HIE2]
KDKG1, -- Condition grp 1 [KDKG1]
KDKG2, -- Condition grp 2 [KDKG2]
KDKG3, -- Condition grp 3 [KDKG3]
KDKG4, -- Condition grp 4 [KDKG4]
KDKG5, -- Condition grp 5 [KDKG5]
VKAUS, -- Usage [ABRVW]
J_1AINDXP, -- Inflation index [J_1AINDXP]
J_1AIDATEP, -- Index base date [J_1AIDATES]
KZFME, -- Leading UoM [KZFME]
MWSKZ, -- Tax Code [MWSKZ]
VERTT, -- Contract Type [RANTYP]
VERTN, -- Contract Number [RANL]
SGTXT, -- Text [SGTXT]
DELCO, -- Delivery Time [DELCO]
BEMOT, -- AcctIndicator [BEMOT]
RRREL, -- Rev. Recognition [RR_RELTYP]
WMINR, -- Catalog [WMINR]
VGBEL_EX, -- Reference Doc. [VGBEL]
VGPOS_EX, -- Reference Item [VGPOS]
LOGSYS, -- Logical system [LOGSYS]
VGTYP_EX, -- Category [VGTYP_EX]
J_1BTAXLW3, -- ISS Law [J_1BTAXLW3]
J_1BTAXLW4, -- COFINS Law [J_1BTAXLW4]
J_1BTAXLW5, -- PIS Law [J_1BTAXLW5]
MSR_ID, -- Process ID No. [MSR_PROCESS_ID]
MSR_REFUND_CODE, -- Refund Code [MSR_RETURNS_REFUND_CODE]
MSR_RET_REASON, -- Return Reason [MSR_RETURNS_REASON]
NRAB_KNUMH, -- Cond.Record No. [KNUMH]
NRAB_VALUE, -- Condition Value [KWERT]
DISPUTE_CASE, -- Dispute Case [DISPUTE_CASE]
FUND_USAGE_ITEM, -- Fund Usg Item [FUND_USAGE_ITEM]
FARR_RELTYPE, -- Type [FARR_RELTYPE]
CLAIMS_TAXATION, -- Claims Taxat. [CLAIMS_TAXATION]
KURRF_DAT_ORIG, -- Translatn Date [WWERT_D]
SGT_RCAT, -- Req. Segment [SGT_RCAT]
SGT_SCAT, -- Stock Segment [SGT_SCAT]
PREFE, -- Cus. Preference [PREFE]
AKKUR, -- LettofCredRate [AKKUR]
WAERK, -- Doc. Currency [WAERK]
DRAFT, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
ACTIVEDOCUMENT, -- SD Document [VBELN]
GRWRT, -- Statist. Value [GRWRT]
FKSAA, -- Ord.Rel.BillgSt [FKSAA]
ABSTA, -- Rejection Status [ABSTA_BDR]
ABGRU, -- Rejection Reason [ABGRU_BDR]
MWSK1, -- Tax Code [MWSKZ]
TXDAT_FROM, -- Tax Rate Valid-From [FOT_TXDAT_FROM]
PBD_ID, -- Prelimin. Bill. Doc. [PBD_ID]
PBD_ITEM_ID, -- Prelimin. Doc. Item [PBD_ITEM_ID]
CATS_OVERTIME_CATEGORY, -- Overtime Category [CATS_OVERTIME_CATEGORY]
CONTR_DP_SETTL, -- Settlem. DP Contract [CONTR_DP_SETTL_VF]
PRODH_UNIV_SALES_PARNT_NODID, -- Node ID [NODID]
TRANSIT_PLANT, -- Transit Plant [TRANSIT_PLANT]
VCM_CHAIN_CATEGORY, -- Value Chain Category [VCM_CHAIN_CATEGORY]
VCM_CHAIN_UUID, -- GUID 16 [GUID_32]
REASON_CODE, -- Return/Change Reason [SD_ITEM_REASON_CODE]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
SPE_HERKL, -- C/R of Origin [HERKL]
SPE_HERKR, -- Reg. of Origin [HERKR]
ITM_COMCO, -- Commodity Code [/SAPSLL/COMCO]
VTKEY, -- Contract [VTKEY_KK]
VTPOS, -- Contract Item [VTPOS_KK]
SRCDOC_PROCESS_TYPE, -- Source Doc. Type [SRCDOC_PROCESS_TYPE]
T2CCODE_CRCY_CONV_FACTOR, -- Tax Amt Fctr in LC [FINS_T2CCODE_CRCY_CONV_FACTOR]
T2CNTRY_CRCY_CONV_FACTOR, -- Tax Amt Fctr in RC [FINS_T2CNTRY_CRCY_CONV_FACTOR]
DUMMY_BILLGDOCITEM_INCL_EEW_PS, -- Dummy function in length 1 [DUMMY]
SERVICE_DOC_TYPE, -- Service Doc. Type [FCO_SRVDOC_TYPE]
SERVICE_DOC_ID, -- Service Document [FCO_SRVDOC_ID]
SERVICE_DOC_ITEM_ID, -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
SOLUTION_ORDER_ID, -- Solution Order [CRMS4_SOLO_OBJECT_ID]
SOLUTION_ORDER_ITEM_ID, -- Solution Order Item [CRMS4_SOLO_NUMBER_INT]
VBTYP_ANA, -- Document Cat. [VBTYPL]
FKART_ANA, -- Billing Type [FKART]
VKORG_ANA, -- Sales Org. [VKORG]
VTWEG_ANA, -- Distr. Channel [VTWEG]
KONDA_ANA, -- CustPrice Group [KONDA]
KDGRP_ANA, -- Customer Group [KDGRP]
LAND1_ANA, -- Dest. Ctry/Reg [LLAND]
REGIO_ANA, -- Region [REGIO]
CITYC_ANA, -- City Code [CITYC]
BZIRK_ANA, -- Sales District [BZIRK]
GBSTK_ANA, -- Overall Status [GBSTK]
VF_STATUS_ANA, -- Status [VF_STATUS]
KUNAG_ANA, -- Sold-to Party [KUNAG]
KUNRG_ANA, -- Payer [KUNRG]
FKDAT_ANA, -- Billing Date [FKDAT]
BUKRS_ANA, -- Company Code [BUKRS]
COUNC_ANA, -- County Code [COUNC]
KNUMA_ANA, -- Agreement [KNUMA]
FKTYP_ANA, -- BillingCategory [FKTYP]
KNUMV_ANA, -- Doc. Condition [KNUMV]
SFAKN_ANA, -- Canceld Bill.Dc [SFAKN]
KUNWE_ANA, -- Ship-to Party [KUNWE]
KUNRE_ANA, -- Bill-to Party [KUNRE]
PERVE_ANA, -- Sales Employee [SALES_EMPL]
PERZM_ANA, -- Employee Responsible [RESP_EMPL]
GLO_LOG_REF1_IT, -- Commodity Code for Poland [GLO_LOG_REF1_IT]
TXS_BUSINESS_TRANSACTION, -- Business Transaction [TXS_BUSINESS_TRANSACTION]
TXS_MATERIAL_USAGE, -- Customer Usage [TXS_MATERIAL_USAGE]
TXS_USAGE_PURPOSE, -- Usage Purpose [TXS_USAGE_PURPOSE]
ZAPCGKI, -- Annexing Package [/ILE/TAPCGK]
APCGK_EXTENDI, -- Ann.Package Extend [/ILE/TAPCGK_EXT]
ZABDATI, -- Annexing base date [/ILE/TABDAT]
AUFPL, -- Plan No.f.Oper. [CO_AUFPL]
APLZL, -- Counter [CIM_COUNT]
DPCNR, -- DP Chain Number [/SAPPCE/DPCNR]
DCPNR, -- Transaction [/SAPPCE/DPCPNR]
DPNRB, -- Doc. Seq. No. [/SAPPCE/DPCPNRB]
BOSFAR, -- Billing rule [BOSFAR]
DP_BELNR, -- Document Number [BELNR_D]
DP_BUKRS, -- Company Code [BUKRS]
DP_GJAHR, -- Fiscal Year [GJAHR]
DP_BUZEI, -- Item [BUZEI]
PACKNO, -- Package number [PACKNO]
PEROP_BEG, -- Per. of Perf. Start [FM_PEROP_SD_LOW]
PEROP_END, -- Per. of Perf. End [FM_PEROP_SD_HIGH]
FMFGUS_KEY, -- US Govt [FMFG_US_KEY]
FSH_SEASON_YEAR, -- Season Year [FSH_SAISJ]
FSH_SEASON, -- Season [FSH_SAISO]
FSH_COLLECTION, -- Collection [FSH_COLLECTION]
FSH_THEME, -- Theme [FSH_THEME]
FONDS, -- Fund [BP_GEBER]
FISTL, -- Funds Center [FISTL]
FKBER, -- Functional Area [FKBER]
GRANT_NBR, -- Grant [GM_GRANT_NBR]
BUDGET_PD, -- Budget Period [FM_BUDGET_PERIOD]
J_3GBELNRI, -- Document number [J_3GBELNRI]
J_3GPMAUFE, -- PM order owner [J_3GPMAUFE]
J_3GPMAUFV, -- PM order admin. [J_3GPMAUFV]
J_3GETYPA, -- Send. rcpt type [J_3GETYPA]
J_3GETYPE, -- Recve rcpt type [J_3GETYPE]
J_3GORGUEB, -- All org. str. [J_3GORGUEB]
PRS_WORK_PERIOD, -- Work Period [PRS_WORK_PERIOD]
PPRCTR, -- Partner PC [PPRCTR]
PARGB, -- Trdg Part.BA [PARGB]
AUFPL_OAA, -- Plan No.f.Oper. [CO_AUFPL]
APLZL_OAA, -- Counter [CIM_COUNT]
CAMPAIGN, -- CGPL_GUID [CGPL_GUID16_R3]
COMPREAS, -- Abbreviation [CMP_COMPREAS_COPY]
WRF_CHARSTC1, -- Characteristic 1 [WRF_CHARSTC1]
WRF_CHARSTC2, -- Characteristic 2 [WRF_CHARSTC2]
WRF_CHARSTC3, -- Characteristic 3 [WRF_CHARSTC3]
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