I_PURCHASEREQNADDRESS

CDS View
58 Fields 1 CDS Views

Purchase Requisition Address Basic View

I_PURCHASEREQNADDRESS is a CDS View in S/4HANA. Purchase Requisition Address Basic View. It contains 58 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurchaseReqnDeliveryAddress view from COMPOSITE Pur Reqn Delivery Address Basic View

Fields (58)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition PurchaseRequisition 1
KEY PurchaseRequisitionItem PurchaseRequisitionItem 1
_FormOfAddress _FormOfAddress 1
_Region _Region 1
AdditionalStreetPrefixName AdditionalStreetPrefixName 1
AdditionalStreetSuffixName AdditionalStreetSuffixName 1
AddressID AddressID 1
AddressTimeZone AddressTimeZone 1
AddressType AddressType 1
Building Building 1
BusinessPartnerName1 BusinessPartnerName1 1
BusinessPartnerName2 BusinessPartnerName2 1
BusinessPartnerName3 BusinessPartnerName3 1
BusinessPartnerName4 BusinessPartnerName4 1
CareOfName CareOfName 1
CityCode CityCode 1
CityName CityName 1
CitySearch CitySearch 1
CompanyPostalCode CompanyPostalCode 1
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 1
County County 1
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
District District 1
FaxNumber FaxNumber 1
Floor Floor 1
FormOfAddress FormOfAddress 1
FullName FullName 1
HomeCityName HomeCityName 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
ItemDeliveryAddressID ItemDeliveryAddressID 1
ManualDeliveryAddressID ManualDeliveryAddressID 1
Nation Nation 1
Person Person 1
PhoneNumber PhoneNumber 1
Plant Plant 1
PlantText PlantText 1
POBox POBox 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 1
RoomNumber RoomNumber 1
SearchTerm1 SearchTerm1 1
StorageLocation StorageLocation 1
StreetName StreetName 1
StreetPrefixName StreetPrefixName 1
StreetSearch StreetSearch 1
StreetSuffixName StreetSuffixName 1
TaxJurisdiction TaxJurisdiction 1
TransportZone TransportZone 1

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.

-- Purchase Requisition Address Basic View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEREQNADDRESS (
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    _FORMOFADDRESS,
    _REGION,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSID,
    ADDRESSTIMEZONE,
    ADDRESSTYPE,
    BUILDING,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    CAREOFNAME,
    CITYCODE,
    CITYNAME,
    CITYSEARCH,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    FAXNUMBER,
    FLOOR,
    FORMOFADDRESS,
    FULLNAME,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    ITEMDELIVERYADDRESSID,
    MANUALDELIVERYADDRESSID,
    NATION,
    PERSON,
    PHONENUMBER,
    PLANT,
    PLANTTEXT,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    ROOMNUMBER,
    SEARCHTERM1,
    STORAGELOCATION,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSEARCH,
    STREETSUFFIXNAME,
    TAXJURISDICTION,
    TRANSPORTZONE,
    PRIMARY KEY (PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More