SAP table reference

VFKP

Shipment Costs: Item Data

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table VFKP.

SAP table VFKP has 3 primary key fields: MANDT,FKNUM,FKPOS.

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

VFKP fields.

64 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key FKNUM Shipment Cost NumberCHAR100 VFKK FKNUM
Key FKPOS Shipment costs itemNUMC60 FKPOS
FKPTY Item category shipment costsCHAR40 TVFT FKPTY
BUKRS Company CodeCHAR40 T001 BUKRS
NETWR Net value in currency of shipment cost itemCURR152 NETWR_P
MWSBP Tax amount in currency of shipment cost itemCURR132 MWSBP_P
WAERS Currency of the Shipment Cost ItemCUKY50 TCURC WAERS_P
MWSKZ Tax on sales/purchases codeCHAR20 T007A MWSKZ
PRSDT Pricing dateDATS80 PRSDT_P
BUDAT Settlement dateDATS80 BUDAT_P
EXTI1 External identification 1 ItemCHAR200 EXTI1_P
EXTI2 External identification 2 ItemCHAR200 EXTI2_P
TPLST Transportation planning pointCHAR40 TTDS TPLST
VSART Shipping type for shipment stageCHAR20 T173 VERSARTS
KALSM Pricing Procedure in PricingCHAR60 T683 KALSMASD
KNUMV Number of the Document ConditionCHAR100 KNUMV
WERKS PlantCHAR40 T001W WERKS_D
EKORG Purchasing organizationCHAR40 T024E EKORG
EKGRP Purchasing GroupCHAR30 T024 BKGRP
EBELN Purchasing Document NumberCHAR100 * EBELN
EBELP Item Number of Purchasing DocumentNUMC50 * EBELP
LBLNI Entry Sheet NumberCHAR100 * LBLNI
PARVW Partner FunctionCHAR20 TPAR PARVW
TDLNR Number of service agentCHAR100 LFA1 TDLNR_P
RECHS Invoicing party for shipment cost itemCHAR100 LFA1 RECHST
KURST Exchange Rate TypeCHAR40 TCURV KURST
KOSTY Cost type (shipment cost item)CHAR10 KOSTY
REFTY SD Document CategoryCHAR40 VBTYPL
REBEL Referenced documentCHAR100 REBEL
REPOS Referenced document itemNUMC60 REPOS_P
POSTX Description for referenceCHAR400 POSTX
KNTTP Account Assignment CategoryCHAR10 T163K KNTTP
BKLAS Valuation ClassCHAR40 T025 BWKLL
STBER Status of calculation (shipment costs item data)CHAR10 STBER_P
DTBER Date of calculationDATS80 DTBER
UZBER Time of calculationTIMS60 UZBER
STFRE Status of account determinationCHAR10 STFRE_P
DTFRE Date of account determinationDATS80 DTFRE
UZFRE Time of account assignmentTIMS60 UZFRE
STABR Status of transfer (shipment costs item data)CHAR10 STABR_P
DTABR Date of settlementDATS80 DTABR_T
UZABR Time of settlementTIMS60 UZABR
ERNAM Name of Person Responsible for Creating the ObjectCHAR120 ERNAM
ERDAT Date on which the record was createdDATS80 ERDAT
ERZET Entry timeTIMS60 ERZET
AENAM Name of Person Who Changed ObjectCHAR120 AENAM
AEDAT Last Changed OnDATS80 AEDAT
AEZET Time last change was madeTIMS60 AEZET
LOGSYS Logical systemCHAR100 TBDLS LOGSYS
KSTAU Cost distribution COCHAR10 KSTAU
TRFZNA Tariff zone of point of departureCHAR100 TVFTZ TRFZNA
TRFZNZ Tariff zone of point of destinationCHAR100 TVFTZ TRFZNZ
TXJCD Tax JurisdictionCHAR150 * TXJCD
BASWR Tax base amountCURR152 BASWR_P
SLAND1_A Tax country departureCHAR30 T005 SLAND1_A
SLAND1_Z Tax country destinationCHAR30 T005 SLAND1_Z
FKSTO Shipment cost item already cancelledCHAR10 FKSTO_P
KZWI1 Subtotal 1 from Pricing Procedure for Price ElementCURR132 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price ElementCURR132 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price ElementCURR132 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price ElementCURR132 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price ElementCURR132 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price ElementCURR132 KZWI6
/ Relationships

VFKP relationships.

38 relationships
TableFieldCheck tableDescriptionCheck field
VFKPBKLAST025Valuation ClassesMANDT
VFKPBKLAST025Valuation ClassesBKLAS
VFKPBUKRST001Company CodesBUKRS
VFKPEKGRPT024Purchasing GroupsEKGRP
VFKPEKORGT024EPurchasing OrganizationsEKORG
VFKPFKNUMVFKKShipment Costs: Header DataMANDT
VFKPFKNUMVFKKShipment Costs: Header DataFKNUM
VFKPFKPTYTVFTShipment Cost Item CategoriesMANDT
VFKPFKPTYTVFTShipment Cost Item CategoriesFKPTY
VFKPKALSMT683Pricing proceduresKAPPL
VFKPKALSMT683Pricing proceduresKALSM
VFKPKNTTPT163KAccount Assignment Categories in Purchasing DocumentMANDT
VFKPKNTTPT163KAccount Assignment Categories in Purchasing DocumentKNTTP
VFKPKURSTTCURVExchange rate types for currency translationMANDT
VFKPKURSTTCURVExchange rate types for currency translationKURST
VFKPLOGSYSTBDLSLogical systemLOGSYS
VFKPMANDTT000ClientsMANDT
VFKPMWSKZT007ATax KeysKALSM
VFKPMWSKZT007ATax KeysMWSKZ
VFKPPARVWTPARBusiness Partner: FunctionsPARVW
VFKPRECHSLFA1Supplier Master (General Section)MANDT
VFKPRECHSLFA1Supplier Master (General Section)LIFNR
VFKPSLAND1_AT005CountriesMANDT
VFKPSLAND1_AT005CountriesLAND1
VFKPSLAND1_ZT005CountriesMANDT
VFKPSLAND1_ZT005CountriesLAND1
VFKPTDLNRLFA1Supplier Master (General Section)MANDT
VFKPTDLNRLFA1Supplier Master (General Section)LIFNR
VFKPTPLSTTTDSOrganizational Unit: Transportation Scheduling PointTPLST
VFKPTRFZNATVFTZTariff Zones for Shipment CostsMANDT
VFKPTRFZNATVFTZTariff Zones for Shipment CostsTRFZN
VFKPTRFZNZTVFTZTariff Zones for Shipment CostsMANDT
VFKPTRFZNZTVFTZTariff Zones for Shipment CostsTRFZN
VFKPVSARTT173Routes: Mode of Transport for Each Shipping TypeMANDT
VFKPVSARTT173Routes: Mode of Transport for Each Shipping TypeVSART
VFKPWAERSTCURCCurrency CodesMANDT
VFKPWAERSTCURCCurrency CodesWAERS
VFKPWERKST001WPlants/BranchesWERKS
Back to SAP tables